Untitled

<?php
include('./connect.php');
$link=Connection();

// $db = mysql_connect($db_host, $db_user, $db_password);
//mysql_select_db("test_arduino");

$query = "SELECT timeStamp, temperature, humidity FROM test_arduino.tempLog WHERE timestamp >= DATE_SUB(CURRENT_DATE, INTERVAL 1 WEEK)";
echo  $query;
echo  "<br>";
// The Chart table contains two fields: weekly_task and percentage
// This example will display a pie chart. If you need other charts such as a Bar chart, you will need to modify the code a little to make it work with bar chart and other charts
// $sth = mysql_query("SELECT timeStamp, temperature, humidity FROM test_arduino.tempLog WHERE timestamp >= DATE_SUB(CURRENT_DATE, INTERVAL 1 WEEK)");


$sth = mysql_query($query , $link);
echo "<br>";
echo $sth;

$data = array (
      'cols' => array(
        array('id' => 'timestamp', 'label' => 'time', 'type' => 'datetime'),
        array('id' => 'temperature', 'label' => 'Temp F', 'type' => 'number'),
        array('id' => 'humidity', 'label' => 'Humidity', 'type' => 'number'),
                array('id' => 'temperature', 'label' => 'Temp C', 'type' => 'number')
    ),
    'rows' => array()
);
echo "<br>";
echo $data;

$rows = array();

while ($res = mysql_fetch_assoc($sth)) {
    // assumes dates are patterned 'yyyy-MM-dd hh:mm:ss'
    preg_match('/(d{4})-(d{2})-(d{2})s(d{2}):(d{2}):(d{2})/', $res['timestamp'], $match);
    $year = (int) $match[1];
    $month = (int) $match[2] - 1; // convert to zero-index to match javascript's dates
        $day = (int) $match[3];
    $hours = (int) $match[4];
    $minutes = (int) $match[5];
    $seconds = (int) $match[6];
    array_push($data['rows'], array('c' => array(
       array('v' => 'Date(' . date('Y,n,d,H,i,s', strtotime($res['timestamp'])).')'),
    array('v' => floatval($res['temperature'])),
    array('v' => floatval($res['humidity'])),
        array('v' => floatval($res['temperature']))
    )));
}

echo "<h2>JSON Table</h2>";
echo $jsonTable;
// mysql_close($link);
?>

<html>
  <head>

    <!--Load the Ajax API-->
 <script type="text/javascript" src="https://www.google.com/jsapi"></script>
    <script type="text/javascript">

    // Load the Visualization API and the piechart package.
    google.load('visualization', '1.1', {'packages':['annotationchart']});;

    // Set a callback to run when the Google Visualization API is loaded.
    google.setOnLoadCallback(drawChart);

    function drawChart() {

      // Create our data table out of JSON data loaded from server.
      var bar_chart_data = new google.visualization.DataTable(<?php echo json_encode($data); ?>);;

      var options = {
                'title':'Sensor 1 reading.',
                           'width':800,
                           'height':300,  legend: { position: 'bottom' },};

      // Instantiate and draw our chart, passing in some options.
      // Do not forget to check your div ID
      var chart = new google.visualization.AnnotationChart(document.getElementById('chart_div'));
        chart.draw(bar_chart_data, options);


    }


    </script>
  </head>

  <body>


    <!--<script>setInterval(function(){location.reload();}, 80000)</script>-->
    <div id="chart_div"></div>
        <br />


  </body>
</html>

<?php

        function Connection(){
                $server="localhost";
                $user="root";
                $pass="mysql";
                $db="test_arduino";

                $connection = mysql_connect($server, $user, $pass);

                if (!$connection) {
                die('MySQL ERROR: ' . mysql_error());
                }

                mysql_select_db($db) or die( 'MySQL ERROR: '. mysql_error() );

                return $connection;
        }
?>