javascript - PHP Chart Js Load Mysql and Interface -

-

this source viewgraph.php

        <?php                $datesgraph = array();             $moneyss = array();             $sql = "select right(datetransaksi,2) dates, sum(allmoney ) money view_resume_transaksi                      datetransaksi between '20160401' , '20160420' group datetransaksi order datetransaksi asc" ;                $hasil=sqlsrv_query($conn, $sql) or die($sql . "<br>" .print_r( sqlsrv_errors(), true)) ;                 while($row = sqlsrv_fetch_array($hasil)){                                         $moneyss[$row[0]] = (int)$row[1];                                          $datesgraph[]=$row['tgl'];                                          $moneyss[]=$row['money'];                                      }  ?>  <script>     var randomscalingfactor = function(){ return math.round(math.random()*100)};     var linechartdata = {          labels : <?=json_encode($datesgraph);?>,         datasets : [             {                 label: "my second dataset",                 fillcolor : "rgba(151,187,205,0.2)",                 strokecolor : "rgba(151,187,205,1)",                 pointcolor : "rgba(151,187,205,1)",                 pointstrokecolor : "#fff",                 pointhighlightfill : "#fff",                 pointhighlightstroke : "rgba(151,187,205,1)",             data : <?=json_encode($moneyss);?>             }         ]     }     window.onload = function(){     showgrafik(); }  function showgrafik(){     var ctx = document.getelementbyid("canvas").getcontext("2d");         window.myline = new chart(ctx).line(linechartdata, {             responsive: true         }); }

and have in bottom

<td>    <label align="left">choose date</label>    <input type='text' id='date1_g' name='date1_g' size='12' value="<?php echo date('d-m-y');?> ">until <input type='text' id='date2_g' name='date2_g' size='12' value="<?php echo date('d-m-y');?> ">   </td>  <div style="width:80%"><canvas id="canvas" height="450" width="600"></canvas> </div>

this succesfully load data mysql... don't know, if user change date , date mysql , view graph. mean if proses > choose date -> send data using ajax -> viewing graph. proses > load .php -> viewing graph (because sql using not parameters interface).

please me, want display graph using ajax... thank's attention.

make function in javascript accept datefromand dateto parameters call in sql query in php via ajax. this..

var path_to_php_file = 'getdate.php';    function loadchartbydate(datefrom,dateto){     $.ajax(){       url: path_to_php_file,       type: 'post',       datatype: 'json',       data: {'datefrom': datefrom, 'dateto': dateto},       success: function(data){         //display data in chart         //add under success callback function         var randomscalingfactor = function(){ return                               math.round(math.random()*100)};         var linechartdata = {          labels : <?=json_encode($datesgraph);?>,            datasets : [               {                  label: "my second dataset",                  fillcolor : "rgba(151,187,205,0.2)",                  strokecolor : "rgba(151,187,205,1)",                  pointcolor : "rgba(151,187,205,1)",                  pointstrokecolor : "#fff",                  pointhighlightfill : "#fff",                  pointhighlightstroke : "rgba(151,187,205,1)",                   data : <?=json_encode($moneyss);?>               }             ]           }        window.onload = function(){               var ctx = document.getelementbyid("canvas").getcontext("2d");               window.myline = new chart(ctx).line(linechartdata, {                              responsive: true               });        }        },       error: function(err){         console.log(err.responsetext);         }     }  }

Comments

Post a Comment

Popular posts from this blog

html - Styling progress bar with inline style -

-
i trying set progress bar color red using inline style. need in way because have access <body> part of document. style need apply: progress { color: red } progress::-moz-progress-bar { background: red;} progress::-webkit-progress-value { background: red; } progress[aria-valuenow]:before { background: red; } i tried <progress style="background: red;"> incorrect effect, progress bar color turns blue red background. guide right direction desired style? thank in advance. here live example: https://jsfiddle.net/z36d3f6l/
Read more

java - Oracle Sql developer error: could not install some modules -

-
i have downloaded fresh copy of sqldeveloper ( sqldeveloper-4.1.3.20.78-no-jre ) oracle website. when unzip , lauch gui, keep getting following error message: warning - not install modules: dynamic module config - no module providing capability org.netbeans.netbinox found. my system: windows 7 32 bit hp probook. jdk 1.6 , 1.7, 1.8 available in java/jdk subdirectory. netbeans 8.0.2 installed finally got way out after dirty hours. extracted sqldeveloper zip in nested directory. i.e: e://a/b/c/sqldeveloper. starting sqldeveloper gui above directory threw erros. solution: go in c:\users**username**\appdata\roaming : delete sql developer , sqldeveloper folders extract sql developer zip in new non nested directory. i.e: e:// start , should work now reference: https://community.oracle.com/thread/3870680?start=0&tstart=0
Read more

How to use autoclose brackets in Jupyter notebook? -

-
this may sound silly question, how make use of autoclose brackets in jupyter notebook? example, when type print( jupyter notebook auto-closes brakets print() and places cursor inside. type argument, say print(1 + 1) now cursor between second 1 , right bracket ) . key navigate right of ) ? of course can press end or → or ) achieve this, not seem save time, purpose of brackets autoclose suppose? thanks in advance.
Read more