Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I think you are mixing server and client code here, You PHP code will <strong>only be executed once on the server, while the page is fetched.</strong></p> <pre><code>window.setInterval(function( displaygraph(); }, 60000); </code></pre> <p>Cannot update data, it will only re-execute displaygraph(), but the data inside this method is not updated from server, but the data that was fetched during page load will be used, you will need to use AJAX, and make an ajax request to get updated data and then use it to redraw the chart with newly fetched data. Try debugging you javascript using <a href="http://getfirebug.com/" rel="nofollow">Firebug</a>.<br> As for the first load issue, you can easily do it with an if statement inside display graph.</p> <pre><code>if(chart) chart.destroy(); </code></pre> <p>To sum it up,</p> <p>charting.js</p> <pre><code>var chart; function displaygraph() { $.getJSON("getjson.php", function(json) { if(chart) chart.destroy(); //get data from json, and use in chart chart = new Highcharts.Chart({....}); }); setInterval(displaygraph, 60000); </code></pre> <p>getjson.php</p> <pre><code>&lt;?php $data = ... echo json_encode($data); ?&gt; </code></pre> <p>More on $.getJSON @ <a href="http://api.jquery.com/jQuery.getJSON/" rel="nofollow">http://api.jquery.com/jQuery.getJSON/</a> , $.ajax @ <a href="http://api.jquery.com/jQuery.ajax/" rel="nofollow">http://api.jquery.com/jQuery.ajax/</a> json-encoding in php @ <a href="http://php.net/manual/en/function.json-encode.php" rel="nofollow">http://php.net/manual/en/function.json-encode.php</a></p>
    singulars
    1. This table or related slice is empty.
    1. POAuto Refreshing Highcharts with PHP/JS
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USJugal Thakkar
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POAuto Refreshing Highcharts with PHP/JS
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThanks. Thats definately starting to point me in the right direction, i'm a beginner when it comes to Javascript. Would the $.getJSON work if I kept it all in one file still and just called the whole file? Atm the php and echo's out the necessary JS in loops, so would be difficult to separate this. Basically, what i think i need is a Jquery function that can call the PHP file every few minutes and at the same time, destory the previous graph, or even just only reload the stuff thats changed, think thats chart.reload().
      singulars
      1. PO
      1. USSeán McCabe
    2. COWould this be heading in the right direction? '<script> $(function() { $(document).ready(function(){ var refreshId = setInterval(function(){ $.get("api_dashchart.php?uID=<?php echo $userInfo_ID; ?>"); }, 1000); }); }); </script>'
      singulars
      1. PO
      1. USSeán McCabe
    3. COSince the only part in your chart that changes is the data, so ideally you should only ask ajax to return only the new data for you. But you can also ask for the entire chartingOptions from server @ every poll is you wish to <?php // Everything existing stays in php $chartingOptions =... echo json_encode($chartingOptions); ?> // This is all you will need in js var chart; $(function(){ setInterval(function(){ $.getJSON("getjson.php", function(chartingOptions) { if(chart) chart.destroy(); //get data from json, and use in chart chart = new Highcharts.Chart(chartingOptions); } },1000); }
      singulars
      1. PO
      1. USJugal Thakkar
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload