<?php
include 'config.php';


if (!($conn = mysql_connect($databasehost, $databaseUser, $databasePassword))) {
    error_log("Could not connect to database");
    die();
}

if (!mysql_select_db($database, $conn)) {
    error_log("Error " . mysql_errno() . " : " . mysql_error());
    die();
}

   $queryString = "SELECT * from temp_log; ";
?>
<html>
<head>
<script type="text/javascript"  src="dygraph-combined-dev.js">
</script>
</head>
<body>
<div id="graphdiv"></div>
<script type="text/javascript">
  g = new Dygraph(

    // containing div
    document.getElementById("graphdiv"),

    // CSV or path to a CSV file.
    "Date,Temperature\n" +
 <?php
  $result = mysql_query($queryString, $conn);
            if (!$result) {
                error_log('Query failed: ' . mysql_error()." at line ".__LINE__);
                die();
            }
            
   $rows = array();
   $num_rows = mysql_num_rows($result);
   $idx=0;
   while ($r = mysql_fetch_assoc($result)) 
    {
       $row_string = '"'.$r['entry_time_stamp'].','.$r['esp_data'].'\\n"';
       
       $idx++;
       if ($idx != $num_rows)
           $row_string = $row_string.' +';
       echo $row_string;
    }
 ?>
    
    
  //  "Date,Temperature\n" +
   // "2008-05-07,75\n" +
   // "2008-05-08,70\n" +
   // "2008-05-09,80\n"

 ,{showRangeSelector: true,interactionModel: Dygraph.Interaction.defaultModel, width:900, height:700 } );
</script>
</body>
</html>
