Skip to content

Instantly share code, notes, and snippets.

@dmsherazi

dmsherazi/php

Created March 31, 2014 10:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dmsherazi/9889728 to your computer and use it in GitHub Desktop.
Save dmsherazi/9889728 to your computer and use it in GitHub Desktop.
Download ZIP
php code
Raw
php
<html>
<head>
<title>Power comparator</title>
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load("visualization", "1", {packages:["corechart"]});
google.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable([
['Time', 'Voltage_Main', 'Voltage_Solar'],
<?php
$init = mysqli_init();
$option = mysqli_options($init, MYSQLI_READ_DEFAULT_FILE, "/etc/my.cnf");
mysqli_real_connect($init, "localhost", "bone", "bone", "CTDB", 0, NULL, 0);
//$con = mysqli_connect("localhost", "bone", "bone", "CTDB");
$query = "SELECT * FROM VTable";
$result = mysqli_query($init, $query);
//mysqli_close($con);
while ($row = mysqli_fetch_array($result))
{
$time = $row['MeasTime'];
$vnorm = $row['vnorm'];
$vslr = $row['vslr'];
echo "['$time', $vnorm, $vslr],";
}
mysqli_close($init);
?>
]);
var options = {
title: 'Measured voltage',
// hAxis: { title: 'time' }
vAxis: { title: 'Volts' }
};
var chart = new google.visualization.LineChart(document.getElementById('chart_div'));
chart.draw(data, options);
}
</script>
</head>
<body>
<div id="chart_div" style="width: 900px; height: 500px;"></div>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment