php - MySQLi json encoded data parsed into Google Chart -

-

i can't figure out correct way move mysqli data correct json echo google chart code.

i query data , echo out results in json.

$query = mysqli_query($con,"select count(e.song_id)  song_count, c.show_id, e.show_id, date_format(c.show_date, '%y') s_year tbl_song_shows e, tbl_shows c e.song_id='{$sid}' , c.show_id = e.show_id group s_year order s_year desc");   //show stats graph//  $table = array(); $table['cols'] = array(     /* define datatable columns here      * each column gets own array      * syntax of arrays is:      * label => column label      * type => data type of column (string, number, date, datetime, boolean)      */     // assumed first column "string" type     // , second column "number" type     // can change them if not     array('id' => 'year','label' => 's_year', 'type' => 'string'),     array('id' => 'value','label' => 'song_count', 'type' => 'number')  );  $rows = array(); while($r = mysqli_fetch_array($query, mysql_assoc)){ $temp = array();     // each column needs have data inserted via $temp array     $temp[] = array('v' =>  $r['s_year']);     $temp[] = array('v' =>  (int) $r['song_count']);      // insert temp array $rows     $rows[] = array('c' => $temp); }  // populate table rows of data $table['rows'] = $rows;  // encode table json $jsontable = json_encode($table);  // set header; first 2 prevent ie caching queries header('cache-control: no-cache, must-revalidate'); header('content-type: application/json');  // return json data echo $jsontable;

this returns: {"cols":[{"id":"year","label":"s_year","type":"string"},{"id":"value","label":"song_count","type":"number"}],"rows":[{"c":[{"v":"2013"},{"v":5}]},{"c":[{"v":"2012"},{"v":1}]},{"c":[{"v":"2005"},{"v":1}]},{"c":[{"v":"2003"},{"v":1}]}]}

if paste google chart chart works fine. don't want hardcode data in there want send echoed data javascript google chart.

  <script type="text/javascript" src="https://www.google.com/jsapi"></script>     <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>     <script type="text/javascript">      // load visualization api , piechart package.     google.load('visualization', '1', {'packages':['corechart']});      // set callback run when google visualization api loaded.     google.setonloadcallback(drawchart);      function drawchart() {     var jsondata = {"cols":[{"id":"year","label":"s_year","type":"string"},{"id":"value","label":"song_count","type":"number"}],"rows":[{"c":[{"v":"2013"},{"v":5}]},{"c":[{"v":"2012"},{"v":1}]},{"c":[{"v":"2005"},{"v":1}]},{"c":[{"v":"2003"},{"v":1}]}]}          // create our data table out of json data loaded server.      var data = new google.visualization.datatable(jsondata);         var options = {            title: 'yearly song counts',          chartarea:{left:40, width:850, height:250},     legend: {position: 'none'}, colors:['#94b599'], haxis: {gridlines:{count:6}}         };       // instantiate , draw our chart, passing in options.       // not forget check div id       var chart = new google.visualization.barchart(document.getelementbyid('chart_div'));       chart.draw(data, options);     }     </script>

shouldnt able like:

var jsondata = $jsontable

can me figure out?

i have previous question: mysql find previous date song played hasn't been answered, if can me answer either of these i'd appreciative. thank you.

you close. need echo variable inside php context (<?php ... ?>)

var jsondata = <?php echo $jsontable;  ?>

Comments

Post a Comment

Popular posts from this blog

Line ending issue with Mercurial or Visual Studio -

-
i seem have strange issue caused either visual studio or mercurial. localised single project, i'm guessing in project configuration causing issue. at difficult specify point, when perform action in visual studio, update every line ending in given file, means when @ file in sourcetree, every line has changed. i can replicate using nuget add package dependency; packages.config entirely replaced. if commit changes, including line endings, later same issue occur. workaround have shelve changes , reapply them, whereupon lines written correctly. i'm not sure application blame here. did make mistake of allowing sourcetree change mercurial configuration, issue have fixed, i'm not sure if has persisted. i thought might issue mercurial.ini files or hgrcs don't seem contain untoward. here's mercurial.ini [ui] username = .... [auth] bb.prefix = https://bitbucket.org/ bb.username = .... bb.password = .... [extensions] mq = rebase = [web] allow_push = * push_s...
Read more

java - Jtable duplicate Rows -

-
Image
when add new rows in jtable duplicate rows many times this method update jtable public final void tableaucomande(){ ((defaulttablemodel)tabcommande.getmodel()).getdatavector().clear(); session s=hibernateutil.getsessionfactory().opensession(); criteria cr1= s.createcriteria(commande.class); list <commande> lcs=cr1.list() ; criteria cr2= s.createcriteria(lignecommande.class); list <lignecommande> lck=cr2.list() ; if(lcs.size()!=0 && lck.size()!=0) { (commande lc:lcs) { for(lignecommande lig:lck){ ((defaulttablemodel)tabcommande.getmodel()).addrow(new object[]{ lc.getid_cmd(),lc.getnumcmd(),lc.getdate_cmd(),lc.getclient().getnomprenom(), lig.getproduit().getlib_prd(),lig.getquantite(),lig.getproduit().getid_prd() }); } } // tabcommande.setrowselectioninterval(tabcommande.getrowcount()-1,tabcommande.getrowcount()-1); } } this code add add data rows displaye...
Read more

java - Run a .jar on Heroku -

-
i trying run .jar file on heroku, , can't find instructions anywhere on how this. have read wants me compile uploading heroku. possible, , if is, how this? if helps, trying run minecraft craftbukkit server, , don't have pom.xml file yet. you didn't provide details i'll try give , people reaches question way it. first of all, create heroku account , create heroku application (assumed have done that). second, need generate application jar , upload heroku. so, open terminal , install heroku cli (assuming unix terminal): $ sudo npm install -g heroku-cli you need have npm , nodejs installed, can check link: https://www.digitalocean.com/community/tutorials/how-to-install-node-js-on-ubuntu-16-04 once done that, can use npm update node version acceptable heroku-cli: $ sudo npm install -g n $ sudo n 7.10.0 and run: $ sudo npm install -g heroku-cli in order deploy jars, need install deploy plugin: $ sudo heroku plugins:install heroku-cli-deploy ...
Read more