Adding items to a multi-dimensional array during query while loop

Question

I have a query returning data that looks like this:

Status         Total
Success        234
Failed         20
Missing        12

I want to add this to an array which can then be used to populate a google pie chart.

the array would look like this:

array backup = array("Success" => 234),
                    ("Failed" => 20),
                    ("Missing" => 12);

How would I add these item dynamically at each row in a query?

Just what are you trying to do? Also, the second code block does not contain valid php, further obfuscating what you want done... I really can't make out what you are trying here... — Jasper
– Jasper, Commented Aug 25, 2010 at 16:24

NullUserException · Accepted Answer · 2010-08-25 16:31:07Z

2

$result = mysql_query(...);
$backup = array();

while ($r = mysql_fetch_assoc($result)) {
    $backup[$r['Status']] = $r['Total'];
}

Here's how you can make the Google Charts API call:

$values = implode(',', array_values($backup));
$labels = implode('|', array_keys($backup));

$img = "http://chart.apis.google.com/chart?cht=p3&chd=t:{$values}&chl={$labels}&chs=250x100";
echo "<img src='{$img}' alt='Chart'>";

edited Aug 25, 2010 at 16:31

answered Aug 25, 2010 at 16:23

NullUserException

85.8k31 gold badges212 silver badges239 bronze badges

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

2 Comments

iamjonesy Over a year ago

Wow thank you so much! everything there is exactly what I needed! I never new you could use array in the charts API. thanks a bunch NullUserException!

NullUserException Over a year ago

@Jonesy You are welcome, but those aren't arrays. implode() returns a string.

Felix Kling · Accepted Answer · 2010-08-25 16:25:25Z

1

Assuming this is your query:

SELECT status, total FROM table

Then you can do:

$data = array();

while(($row = mysql_fetch_assoc($result))) {
    $data[$row['status']] = $row['total'];
}

If this is not what you mean, please clarify your question and/or provide the code you already have.

answered Aug 25, 2010 at 16:25

Felix Kling

820k181 gold badges1.1k silver badges1.2k bronze badges

Comments

user280725 · Accepted Answer · 2010-08-25 16:23:03Z

0

I think we need a bunch more information, but in the mean time look at array_merge()

http://www.php.net/manual/en/function.array-merge.php

answered Aug 25, 2010 at 16:23

user280725

2931 gold badge2 silver badges7 bronze badges

Collectives™ on Stack Overflow

Adding items to a multi-dimensional array during query while loop

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related