PHP From string to two variables

Question

In my db there is a table that have some values like this[string]

I need to change this values in

100%
50%
50%
10%

How can i do this using only PHP/mysql code?

EDIT:this is the code:

foreach ($html->find('div.stat') as $status_raw){
    $status = $tag_pic_raw->src;
    $status = mysql_real_escape_string($status);
    $data->query("INSERT IGNORE INTO `tb` (`value`) VALUES ('".$status."')");
}

I have used a DOM inspector to get info from another site

can you show the database/php code that you have already written ? — Maximus2012
– Maximus2012, Commented Sep 11, 2013 at 15:43
@Zenmaru don't forget to reward the users that have helped you with your question and select one of the answer as the right answer, see here how. — Prix
– Prix, Commented Sep 11, 2013 at 15:58
@Fred-ii- rather than asking for a verdict I believe the above is easier for new members. — Prix
– Prix, Commented Sep 11, 2013 at 15:59
@Prix I take it you don't know me very well ;-) I like to add a bit of "off the wall" or "slapstick" humour as it were. ;-) — Funk Forty Niner
– Funk Forty Niner, Commented Sep 11, 2013 at 16:01

Bad Wolf · Accepted Answer · 2013-09-11 15:47:09Z

4

Used explode() combined with some math.

$str = '40/80';
$vals = explode('/', $str);
$percent = (($vals[0] / $vals[1]) * 100).'%';
echo $percent;

edited Sep 11, 2013 at 15:47

answered Sep 11, 2013 at 15:45

Bad Wolf

8,3495 gold badges36 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

XaxD · Accepted Answer · 2013-09-11 15:45:28Z

2

use explode() to divide up the values and then math them.

foreach($array as $val) // assuming all the (##/##) values are in an array
{
    $mathProblem = explode("/", $val);
    echo (intval($mathProblem[0]) / intval($mathProblem[1]) * 100)."%<br />";
}

answered Sep 11, 2013 at 15:45

XaxD

1,55815 silver badges30 bronze badges

2 Comments

Logan Murphy Over a year ago

another possibility is using list($num, $den) = explode("/", $val); which gives you two nice variables you can work with instead of indices

XaxD Over a year ago

hadn't thought of that. clever way to make the code more aesthetically-pleasing/human-readable.

Albzi · Accepted Answer · 2013-09-11 15:50:54Z

0

You can set up a function similar to this:

function math($one)
    {
        $new = explode("/", $one);
        $math = $new[0] / $new[1];
        $answer = $math * 100;
        return $answer."%";
    }

Then every time you need to query something, you can do it simply by doing this:

foreach ($results as $r)
{
    echo math($r);
}

This just makes it (I think) tidier and easier to read.

answered Sep 11, 2013 at 15:50

Albzi

15.6k6 gold badges49 silver badges67 bronze badges

Comments

Charaf JRA · Accepted Answer · 2013-09-11 16:00:48Z

0

Use explode() :Returns an array of strings, each of which is a substring of string formed by splitting it on boundaries formed by the string delimiter( / in this case).

$arr=array('80/100','50/100','40/80');
foreach($arr as $str){
 $values = explode('/',$str);
 echo ((int)$values[0]/(int)$values[1])*100.'%<br/>';
}

edited Sep 11, 2013 at 16:00

answered Sep 11, 2013 at 15:48

Charaf JRA

8,3551 gold badge36 silver badges44 bronze badges

Collectives™ on Stack Overflow

PHP From string to two variables

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related