Renaming array keys

Posted on 16th Feb 2014 07:03 pm by admin

The issue: renaming array keys inside a foreach loop.

I'm trying to build a pie chart image with the Google Chart API using information from a database. (I'm going to change the type of data I talk about because it is extremely sensitive. Just wanted to share that so you didn't think my example was completely weird or stupid even.)

After running my SELECT statement, I have a 2-column dataset with multiple rows. I am currently grabbing the data in this way:
<?php
$total = 0;
while ($r = mysql_fetch_array($result))
{
$info[$r['month']] = $r['days'];
$total += $r['days'];
}
?>
$info is an array with each key being the name of the month and the value being how many days are in that month. $total is the sum of each days.

To supply the dataset inside the image src, I provide a comma separated list. To supply the labels for each dataset, I provide a list separated by pipes.

The problem that I am having is that I would like each label to be the month as well as a percentage number of the total in parenthesis next to the month name.

I am building the URL perfectly fine using JUST the month name like this:
<?php
echo '<p>';
echo '<img src="http://chart.apis.google.com/chart?cht=p&chd=t:';
echo implode(',',array_values($info));
echo '&chs=250x100&chl=';
echo implode('|',array_keys($info));
echo '" alt="" />';
echo '</p>';
?>(I broke up each line for readability.)

How I am trying to include the percentage in the label is be redefining the key BEFORE I add in the array keys to the URL. Trying by this method:
<?php
foreach ($info as $key => $value)
{
$key = $key . (number_format($value/$total,0)) . '%';
}
?>

Expected outcome:
The labels on the image would read something to the tune of -- June (8.2%)

Actual outcome:
Nothing. Well, not nothing. Just the month is coming out. The key names are not being edited.

Thanks for reading this far. I appreciate the help

Your Answer:

Login to answer

Other forums

Ignore html and bbcode?
I've created a function to limit the amount of text according to the amount of words.

However

Beginner question regarding Array's
Hi everyone, the page im working on has an array of variable at the top...

Code: $define_li

Extracting Long text from message class with parameters
Hi,

I would like to extract the long text from a message class. However, the long text ha

reading partial code from external site
Hi,

I am trying to write a script for my website to get an article from an external website.

unserialize help, getting errors
hi all ,
I got a form with 6 fields (2 input and 4 select box), when the page loads one block is

Save file by click
Hello.
I'm not understand how to save file from page. I'd like make link to file with save abil

problem when runing a funciton
I am trying to connect to database using a funciton in a functions.php

<?php
funct

this code is not working????
it says this error.. Warning: Division by zero in ..

the variables are correct, so why is th

Word filter problem
Hello,

im trying to make a filter for words inputted in to my website but i want to store the

quick question
Hi ..

i have a question
how do i set a var so it displays via an echo
Code: $logo = '&a