<?php
  $dbuser="temperature";
  $dbname="temperature";
  $tablename="temp";
  $dbpass="temperaturepass";
  $dbserver="localhost";

  // Make a MySQL Connection
  $con = new mysqli($dbserver, $dbuser, $dbpass) or die(mysql_error());

  // Create a Query
  $sql_query = "SELECT * FROM (SELECT * FROM $dbname.$tablename ORDER BY ID DESC)sub ORDER BY ID ASC;";

  // Execute query
  $result = $con->query($sql_query);

  // Create an array table to store the results
  $table = array();
  $table['cols'] = array(
    array('label' => 'Time & Date', 'type' => 'string'),
    array('label' => 'Humidity', 'type' => 'number'),
    array('label' => 'Temperature', 'type' => 'number'),
    array('label' => 'Dewpoint', 'type' => 'number')
  );

  // Store results into an array
  $rows = array();
  while($row = $result->fetch_assoc()) {
    $temp = array();
    // $temp[] = array('v' => (string) "$row['Date'] $row['Time']");
    // $temp[] = array('v' => (string) $row['Time']);
    $temp[] = array('v' => (string) $row['Date']);
    $temp[] = array('v' => (float) $row['Humidity']);
    $temp[] = array('v' => (float) $row['Temperature']);
    $temp[] = array('v' => (float) $row['Dewpoint']);
    $rows[] = array('c' => $temp);
  }

  // Format and print data
  $table['rows'] = $rows;
  $jsonTable = json_encode($table);
  echo $jsonTable;

?>