Help! on Annotation Chart creation from Mysql DB and PHP page
Romain Bernard
Hi Everyone,
First of all, I'd like to thank you all for being so helpful!
Here is my concern. I'm trying to build an PHP page that render a Annotation chart from a query done on a Mysql DB.
I tried many examples found in the forums to make an annotation chart working, but I miserably fail to have it working...
I always get this error, and even if mysql_num_rows() is deprecated, I cannot find a way to have it replaced
Warning: mysql_num_rows() expects parameter 1 to be resource, object given in /Applications/XAMPP/xamppfiles/htdocs/server1/Result_console4.php on line 11
Is anyone able to provide me some help ?
Thanks a lot!
Romain
Here is the entire code of my php page.
<?php
//DB connection parameters
require_once("mysql_connect.php");
$result = mysqli_query($con,"select date,value1,value2 from DATABASE");
if ($result !== false) {
$num=mysql_num_rows($result);
$i=0;
echo"";
$output = Array();
while ($i < $num) {
$DateTimeArray=explode(' ', mysql_result($result,$i,"date"));
$MYvalue1=mysql_result($result,$i,"value1");
$MYvalue2=mysql_result($result,$i,"value2");
$dateArray = explode('-', $DateTimeArray[0]);
$year = $dateArray[0];
$month = $dateArray[1] - 1; // adjust for javascript's 0-indexed months
$day = $dateArray[2];
$timeArray = explode(':', $DateTimeArray[1]);
$hours = $timeArray[0];
$minutes = $timeArray[1];
$seconds = $timeArray[2];
$output[] = "[new Date($year, $month, $day, $hours, $minutes, $seconds), $MYvalue1, $MYvalue2]";
$i++;
}
}
?>
<html>
<head>
</head>
<script type='text/javascript' src='http://www.google.com/jsapi'></script>
<script type='text/javascript'>
google.load('visualization', '1.1', {'packages':['annotationchart']});
google.setOnLoadCallback(drawChart);
function drawChart() {
var data = new google.visualization.DataTable();
data.addColumn('datetime', 'Date');
data.addColumn('number', 'value1');
data.addColumn('number', 'value2');
data.addRows([ <?php echo implode(',', $output); ?>]);
var chart = new google.visualization.AnnotationChart(document.getElementById('chart_div'));
var options = {
displayAnnotations: true,
};
chart.draw(data, options);
}
</script>
<body>
Graph should be here.
<div id='chart_div' style='width: 900px; height: 500px;'></div>
</body>
</html>
<?php
//DB connection parameters
require_once("mysql_connect.php");
$result = mysqli_query($con,"select date,value1,value2 from DATABASE");
if ($result !== false) {
$num=mysql_num_rows($result);
$i=0;
echo"";
$output = Array();
while ($i < $num) {
$DateTimeArray=explode(' ', mysql_result($result,$i,"date"));
$MYvalue1=mysql_result($result,$i,"value1");
$MYvalue2=mysql_result($result,$i,"value2");
$dateArray = explode('-', $DateTimeArray[0]);
$year = $dateArray[0];
$month = $dateArray[1] - 1; // adjust for javascript's 0-indexed months
$day = $dateArray[2];
$timeArray = explode(':', $DateTimeArray[1]);
$hours = $timeArray[0];
$minutes = $timeArray[1];
$seconds = $timeArray[2];
$output[] = "[new Date($year, $month, $day, $hours, $minutes, $seconds), $MYvalue1, $MYvalue2]";
$i++;
}
}
?>
<html>
<head>
</head>
<script type='text/javascript' src='http://www.google.com/jsapi'></script>
<script type='text/javascript'>
google.load('visualization', '1.1', {'packages':['annotationchart']});
google.setOnLoadCallback(drawChart);
function drawChart() {
var data = new google.visualization.DataTable();
data.addColumn('datetime', 'Date');
data.addColumn('number', 'value1');
data.addColumn('number', 'value2');
data.addRows([ <?php echo implode(',', $output); ?>]);
var chart = new google.visualization.AnnotationChart(document.getElementById('chart_div'));
var options = {
displayAnnotations: true,
};
chart.draw(data, options);
}
</script>
<body>
Graph should be here.
<div id='chart_div' style='width: 900px; height: 500px;'></div>
</body>
</html>
Andrew Gallant
Romain Bernard
Kasper Derkinderen
Op donderdag 24 juli 2014 14:52:12 UTC+2 schreef Romain Bernard: