javascript - Using php fetched value in google charts -
it's first time working google charts. i'm using php/mysql query out results, , store them in div. utilize document.getelementbyid('field).value it's value , utilize in chart.
but somehow, doesn't seems working. might problem ? output blank , displays nothing. suggestions welcome.
php part
include 'dbconnector.php'; include 'class/class.user.php'; $user = new user(); seek { $s = $conn->query("select * messagequeue indexid=1"); $s->setfetchmode(pdo::fetch_obj); $row = $s->fetch(); $s->closecursor(); } catch(pdoexception $e) { echo $e->getmessage(); } ?> html part
<html> <head> <script type="text/javascript" src="https://www.google.com/jsapi"></script> <script type="text/javascript"> var read = document.getelementbyid('read').value; var unsub = document.getelementbyid('unsubscribed').value; google.load("visualization", "1", {packages:["corechart"]}); google.setonloadcallback(drawchart); function drawchart() { var info = google.visualization.arraytodatatable([ ['task', 'hours per day'], ['read', read], ['unsubscribed', unsub] ]); var options = { title: 'my daily activities', is3d: true, }; var chart = new google.visualization.piechart(document.getelementbyid('piechart_3d')); chart.draw(data, options); } </script> </head> <body> <div id="piechart_3d" style="width: 900px; height: 500px;"></div> <input type="hidden" name="read" id="read" value="<?php echo $row->read; ?>"> <input type="hidden" name="unsubscribed" id="unsubscribed" value="<?php echo $row->unsubscribed; ?>"> </body> </html>
if getting proper values $row->read & $row->unsubscribed html set js code @ end of body tag this. work.
<html> <body> <div id="piechart_3d" style="width: 900px; height: 500px;"></div> <input type="hidden" name="read" id="read" value="<?php echo "100" ?>"> <input type="hidden" name="unsubscribed" id="unsubscribed" value="<?php echo "200"; ?>"> </body> <script type="text/javascript" src="https://www.google.com/jsapi"></script> <script type="text/javascript"> var read = document.getelementbyid('read').value; var unsub = document.getelementbyid('unsubscribed').value; google.load("visualization", "1", {packages:["corechart"]}); google.setonloadcallback(drawchart); function drawchart() { var info = google.visualization.arraytodatatable([ ['task', 'hours per day'], ['read', read], ['unsubscribed', unsub] ]); var options = { title: 'my daily activities', is3d: true, }; var chart = new google.visualization.piechart(document.getelementbyid('piechart_3d')); chart.draw(data, options); } </script> </html> javascript php mysql google-visualization
No comments:
Post a Comment