assign php while array result to a variable number of variables

Question

I use this code to echo values from an array generated from a mysql query

while($row = mysql_fetch_array($result)) {

            echo $row[0]; 
            echo ' ';
            echo $row[1];
            echo "%  ";
            echo "<br>";
    }

to produce a result like:

CC 77.6% 
CT 21.9% 
TT 0.5%

Which is fine.

I would like to have the 3 pairs of values available to use in a bootstrap progress bar div so that I may represent the information in a more visual manner.

How can assign the values from the array into variables?

EDIT

Sample result set

Array ( 
[0] => AA 
[alleles] => AA 
[1] => 6 
[total] => 6 
[2] => 25.00 
[percentage] => 25.00 ) 

Array ( 
[0] => AG 
[alleles] => AG 
[1] => 11 
[total] => 11 
[2] => 45.83 
[percentage] => 45.83 ) 

Array ( 
[0] => GG 
[alleles] => GG 
[1] => 7 
[total] => 7 
[2] => 29.17 
[percentage] => 29.17 )

is the result of your query a single row ? or you need to aggregate data in any way? — darioguarascio
– darioguarascio, Commented Mar 28, 2015 at 7:34
Array ( [0] => AA [alleles] => AA [1] => 6 [total] => 6 [2] => 25.00 [percentage] => 25.00 ) Array ( [0] => AG [alleles] => AG [1] => 11 [total] => 11 [2] => 45.83 [percentage] => 45.83 ) Array ( [0] => GG [alleles] => GG [1] => 7 [total] => 7 [2] => 29.17 [percentage] => 29.17 ) — gungu
– gungu, Commented Mar 28, 2015 at 7:36

hamed · Accepted Answer · 2015-03-28 07:41:33Z

1

Try this:

$values = array();
while($row = mysql_fetch_array($result))
{
   array_push($values, array($row[0], $row[1]))
}

Now $values is an array of values. For example $values[0][0] is equal to "CC", $values[0][1] is equal to "77.6" and etc;

answered Mar 28, 2015 at 7:41

hamed

8,04517 gold badges66 silver badges119 bronze badges

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

Comments

darioguarascio · Accepted Answer · 2015-03-28 07:43:55Z

0

In your case, assuming alleles is unique, you can buffer your results and create an key-value array:

$results = array(); 
while($row = mysql_fetch_array($result)) {
    $results[ $row['alleles'] ] = array(
        'total' => $row['total'],
        'percentage' => $row['percentage']
    ); }

after that, you can access your data in the following way:

$results['AA']['total']

and to display all of them:

foreach ($results as $k => $data) {
    printf("%s: %s%%<br/>\n", $k, $data['percentage']);
}

answered Mar 28, 2015 at 7:43

darioguarascio

1,09711 silver badges15 bronze badges

Comments

Nana Partykar · Accepted Answer · 2015-03-28 07:48:12Z

0

First of all, use two div. first for name of that progress bar. Other one for value. This is the code dude.. use this..

answered Mar 28, 2015 at 7:48

Nana Partykar

10.5k10 gold badges50 silver badges79 bronze badges

Collectives™ on Stack Overflow

assign php while array result to a variable number of variables

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related