Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Jul 15th, 2012  |  syntax: None  |  size: 1.62 KB  |  hits: 21  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. High chart date time conversion showing wrong values
  2. <?php
  3.     define('DB_HOST', '*******');
  4.     define('DB_USER', 'user1');
  5.     define('DB_PASSWORD', 'test1');
  6.     define('DB_DATABASE', 'db1');
  7.  
  8.  $dbcnx = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
  9.  mysql_select_db('db1');
  10.  
  11. $sql = "select unix_timestamp(datetime1) as datetime1, value1 from data";
  12. $result = mysql_query($sql,$dbcnx);
  13. $data = array();
  14. while ($row = mysql_fetch_array($result)) {
  15.    //extract $row;
  16.    //$datetime1 = $row['dateTime1']*1000;
  17.    $datetime = $row['datetime1']*1000;
  18.    //echo $datetime;
  19.    echo $row['value1'];
  20.    $val  = $row['value1'];
  21.    // convert from Unix timestamp to JavaScript time
  22.    $data[] = "[$datetime, $val]";
  23. }
  24. ?>
  25. <html>
  26.     <head>
  27.         <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  28.         <title>Highcharts Example</title>
  29.  
  30.         <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
  31.         <script type="text/javascript">
  32. $(function () {
  33.     $(document).ready(function() {
  34.       //alert("TS");
  35.       var chart = new Highcharts.Chart({
  36.       chart: {
  37.          renderTo: 'container',
  38.                 type: 'line',
  39.                 marginRight: 130,
  40.                 marginBottom: 25
  41.  
  42.       },
  43.  
  44.       series:
  45.         [{
  46.          data: [<?php echo join($data, ',') ?>]
  47.       }],
  48.       xAxis: { type: 'datetime'}
  49.  
  50.    });
  51.   });
  52.  
  53. });
  54.         </script>
  55.     </head>
  56.     <body>
  57. <script src="js/highcharts.js"></script>
  58. <script src="js/modules/exporting.js"></script>
  59.  
  60. <div id="container" style="min-width: 400px; height: 400px; margin: 0 auto"></div>
  61.  
  62.     </body>
  63. </html>