PHP : Getting each value from the array and calculate

Question

I have these values in the array=Array ( [0] => 3 [1] => 2 [2] => 10 [3] => 5 )

How do i get each value separately from the array and perform the below calculation?

$j=$q*100/$ytot;

And this is what i've tried so far, which isnt giving the correct value :

$resul=mysql_query("select * from post_bet where bet_id = '$id'")or die(mysql_error());
if(mysql_num_rows($resul)>0)
{
    while($row=mysql_fetch_assoc($resul))
    {
        $y_uid=$row['yes_userid'];          
        $y_uamt=$row['yes_useramount'];
        $n_uid=$row['no_userid'];
        $n_uamt=$row['no_useramount'];
        $ytot=$row['yes_total'];
        $ntot=$row['no_total'];
        $hhh=explode(',',$row['yes_useramount']);
        $q = print_r($hhh);
        echo $j=$q*100/$ytot;
    }
}

what do you want here ? Do you want to perform the operation for each array values or you want to append the operation to a single variable $j — Jenz
– Jenz, Commented Apr 8, 2014 at 6:21
Yessir! i do want to calculate each value. Ignore my mistakes please. — MetaldroiD
– MetaldroiD, Commented Apr 8, 2014 at 6:22
You need to specify what you mean with the calculation. What are $j, $q, and $ytot? — Niels Abildgaard
– Niels Abildgaard, Commented Apr 8, 2014 at 6:23
As far as I can tell from your code you are fetching an associative array from MySQL database that looks nothing like the array you describe in your question. This is unclear. Please clear it up. — Niels Abildgaard
– Niels Abildgaard, Commented Apr 8, 2014 at 6:24
how u can do like that? $hhh can only store 1 value and you should place exploit outside the while loop. you did wrong. — user3454436
– user3454436, Commented Apr 8, 2014 at 6:24

sunny · Accepted Answer · 2014-04-08 06:32:48Z

1

Try this-

$resul=mysql_query("select * from post_bet where bet_id = '$id'")or die(mysql_error());
if(mysql_num_rows($resul)>0)
{
    while($row=mysql_fetch_assoc($resul))
    {
        $y_uid=$row['yes_userid'];          
        $y_uamt=$row['yes_useramount'];
        $n_uid=$row['no_userid'];
        $n_uamt=$row['no_useramount'];
        $ytot=$row['yes_total'];
        $ntot=$row['no_total'];
        $hhh=explode(',',$row['yes_useramount']);

    }


foreach($hhh as $val)
{
        echo $j=$val*100/$ytot;
}
}

answered Apr 8, 2014 at 6:32

sunny

1,1668 silver badges15 bronze badges

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

1 Comment

MetaldroiD Over a year ago

Works like a charm. This is what i wanted. THANKS! \m/

Ja͢ck · Accepted Answer · 2014-04-08 06:36:23Z

1

A simple foreach should do the trick:

foreach (explode(',', $row['yes_useramount']) as $q) {
    echo $q * 100 / $ytot;
}

answered Apr 8, 2014 at 6:36

Ja͢ck

174k39 gold badges269 silver badges316 bronze badges

Comments

Jenz · Accepted Answer · 2014-04-08 09:35:14Z

1

You can process an array in PHP using foreach like shown below:

foreach (($hhh) as $v => $k)
{
echo $k*100/$ytot;
}

Here,

$hhh=explode(',',$row['yes_useramount']);

So $hhh will return an array of values from $row['yes_useramount'] which was imploded with ,.

edited Apr 8, 2014 at 9:35

answered Apr 8, 2014 at 7:17

Jenz

8,3718 gold badges50 silver badges83 bronze badges

1 Comment

MetaldroiD Over a year ago

Cool. But how do i get each value of the array after a , ? implode doesn't seem to work here.

user3454436 · Accepted Answer · 2014-04-08 06:29:32Z

0

try this code in your script. If there having error please tell me here.

$resul=mysql_query("select * from post_bet where bet_id = '$id'")or die(mysql_error());
if(mysql_num_rows($resul)>0)
{
 while($row=mysql_fetch_assoc($resul))
{
 $y_uid=$row['yes_userid'];         
 $y_uamt[]=$row['yes_useramount'];
 $n_uid=$row['no_userid'];
 $n_uamt=$row['no_useramount'];
 $ytot=$row['yes_total'];
 $ntot=$row['no_total'];
}

for($i = 0; $i<count($y_uamt);$i++){

$sum_uamt = $sum_uamt + int($y_uamt[$i]);
}

echo $j = $sum_uamt * 100 / $ytot;

answered Apr 8, 2014 at 6:29

user3454436

2311 gold badge4 silver badges15 bronze badges

2 Comments

MetaldroiD Over a year ago

echo isn't returning any values.

user3454436 Over a year ago

u try echo $y_aumt inside while loop.

Collectives™ on Stack Overflow

PHP : Getting each value from the array and calculate

4 Answers 4

1 Comment

Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related