google charts api - pie chart is not displaying

Question

I am trying to create a piechart dynamically by using Google Chart api. i am taking values from the database. I am not getting how exactly this can be done.

$resultViewed = $this->model_report_product->getMostViewed(); $stringResult ="var data= google.visualization.arrayToDataTable([ ['Product', 'Views'],"; foreach($resultViewed as $results) { $stringResult = $stringResult . "['".$results['name']."',".$results['quantity']."],"; break; } $stringResult .= "]);"; $this->data['Viewed'] = $stringResult;

When i run this, it gives Chart heading but pie chart is not displayed but it says No Data.

Please don't use mysql_* functions in new code. They were removed from PHP 7.0.0 in 2015. Instead, use prepared statements via PDO or MySQLi. See Why shouldn't I use mysql_* functions in PHP? for more information. — PeeHaa
– PeeHaa, Commented Jul 12, 2012 at 7:41

John Moses · Accepted Answer · 2012-07-12 04:57:26Z

1

You can't pass a variable in memory between php to html. You have to print it out to pass it to html. So where you have:

return $stringResult;

you should print it out like:

print $stringResult;

answered Jul 12, 2012 at 4:57

John Moses

1,2381 gold badge12 silver badges18 bronze badges

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

4 Comments

Prasanna Hegde Over a year ago

But its giving me no data. can i use php script to get the data from database within javascript like this?

Prasanna Hegde Over a year ago

Hi, I have edited the code. Actually i am getting the 1st row of data in my array, rest am not getting. Not getting whats the problem in the loop. Please look at my code which i have edited and help me in this. please please

John Moses Over a year ago

The for loop is only looping through once and then hitting that break command. Remove the break command.

Prasanna Hegde Over a year ago

Ya. sorry. But even after removing the break its the same problem. Just to test i had put the break but even then it displays only one data.

Collectives™ on Stack Overflow

google charts api - pie chart is not displaying

1 Answer 1

4 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Related