Creating data for jqPlot using PHP

Question

I am using http://www.jqplot.com/tests/pie-donut-charts.php which needs to have data given to it in the following format:

//JavaScript
var data = [
  ['Heavy Industry', 12],['Retail', 9], ['Light Industry', 14],
  ['Out of home', 16],['Commuting', 7], ['Orientation', 9]
];

The data is generated serverside with PHP. I am manually creating the string as follows:

//PHP
$string.='["'.$row['name'].'",'.$row['count'].'],';

I would rather just create an array, and use json_encode() or something similar to create the data. Any suggestions how I would do so?

It didn't work. I think because it would encode it as an object with {} — user1032531
– user1032531, Commented Aug 22, 2012 at 15:41

Waleed Khan · Accepted Answer · 2012-08-22 15:42:48Z

1

$array = array(
    array(
        "Heavy Industry",
        12
    ),
    array(
        "Retail",
        9
    )
);
$json = json_encode($array);
var_dump($json); // "[["Heavy Industry",12],["Retail",9]]"

answered Aug 22, 2012 at 15:42

Waleed Khan

11.5k7 gold badges41 silver badges70 bronze badges

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

4 Comments

user1032531 Over a year ago

Thanks Arxanas. Maybe it does work :). Let me check it out and make sure.

user1032531 Over a year ago

I get different results: echo manual created string ["Heavy Industry",44],["Retail",24] echo print_r($array,1) Array ( [Heavy Industry] => 44 [Retail] => 24 ) echo var_dump($array) array(7) { ["Heavy Industry"]=> string(2) "44" ["Retail"]=> string(2) "24" }

user1032531 Over a year ago

But when I run your exact script, I get correct results. Let me investigate. Thanks

user1032531 Over a year ago

Opps, I was doing $array=array("Heavy Industry"=>12, "Retail"=>9); Thanks for your help!

Collectives™ on Stack Overflow

Creating data for jqPlot using PHP

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related