The problem is on this line:
$output['rows'] = array('c' => array(
you are missing a pair of square brackets after the $output['rows']:
$output['rows'][] = array('c' => array(
and I see another issue you should clean up: you need to rename the $table
variable to $output (or change the $output's to $table, it doesn't matter
which):
$output['cols'] = array(
array('label'=> 'date', type=> 'datetime'),
array('label'=> 'actual', type=> 'number')
);
On Tuesday, November 26, 2013 8:48:26 PM UTC-5, [email protected] wrote:
>
> I changed.
>
> $sqlresult1=mysql_query($sqlquery1);
> $rows = mysql_num_rows($sqlresult1);
> $output=array();
> $table['cols']=array(
> array('label'=> 'date', type=>'datetime'),
> array('label'=>'actual', type=>'number')
> );
>
> while($rows>0){
> $row = mysql_fetch_row($sqlresult1);
> $dateTimeArray = explode(' ', $row[0]);
> $dateArray = explode('-', $dateTimeArray[0]);
> $year = (int) $dateArray[0];
> $month = (int) $dateArray[1]; // subtract 1 to convert to javascript's
> 0-indexed months
> $day = (int) $dateArray[2];
>
> $timeArray = explode(':', $dateTimeArray[1]);
> $hours = (int) $timeArray[0];
> $minutes = (int) $timeArray[1];
> $seconds = (int) $timeArray[2];
>
> $output['rows'] = array('c' => array(
> array('v' => "Date($year, $month, $day, $hours, $minutes,
> $seconds)"),
> array('v' => (float) $row[1])
> ));
> $rows--;
> }
>
> But it is showing only the last row data in mysql database. Why is that?
>
> {"rows":{"c":[{"v":"Date(2013, 11, 22, 3, 46,
> 3)"},{"v":4.4}]}}
>
> On Wednesday, November 27, 2013 6:55:39 AM UTC+5:30, asgallant wrote:
>>
>> Sorry, I left out the $'s that should be before dateArray and timeArray:
>>
>> $year = (int) $dateArray[0];
>> $month = (int) $dateArray[1] - 1; // subtract 1 to convert to
>> javascript's 0-indexed months
>> $day = (int) $dateArray[2];
>>
>> $timeArray = explode(':', $dateTimeArray[1]);
>> $hours = (int) $timeArray[0];
>> $minutes = (int) $timeArray[1];
>> $seconds = (int) $timeArray[2];
>>
>> On Tuesday, November 26, 2013 8:16:13 PM UTC-5, [email protected] wrote:
>>>
>>> The code i modified.
>>>
>>> <?php
>>>
>>> mysql_connect('host','user,'pw');
>>> mysql_select_db('DB');
>>>
>>> $sqlquery1="SELECT * FROM TABLE";
>>>
>>> $sqlresult1=mysql_query($sqlquery1);
>>> $rows = mysql_num_rows($sqlresult1);
>>> $output=array();
>>> $table['cols']=array(
>>> array('label'=> 'date', type=>'datetime'),
>>> array('label'=>'actual', type=>'number')
>>> );
>>>
>>> while($rows>0){
>>> $row = mysql_fetch_row($sqlresult1);
>>> $dateTimeArray = explode(' ', $row[0]);
>>> $dateArray = explode('-', $dateTimeArray[0]);
>>> $year = (int) dateArray[0];
>>> $month = (int) dateArray[1] - 1; // subtract 1 to convert to
>>> javascript's 0-indexed months
>>> $day = (int) dateArray[2];
>>>
>>> $timeArray = explode(':', $dateTimeArray[1]);
>>> $hours = (int) timeArray[0];
>>> $minutes = (int) timeArray[1];
>>> $seconds = (int) timeArray[2];
>>>
>>> $output['rows'][] = array('c' => array(
>>> array('v' => "Date($year, $month, $day, $hours, $minutes,
>>> $seconds)"),
>>> array('v' => (float) $row[1])
>>> ));
>>> $rows--;
>>> }
>>>
>>>
>>> echo json_encode($output);
>>> ?>
>>> But this gives me the error,
>>> *Parse error*: syntax error, unexpected '[' in
>>> */home/a9956835/public_html/Test/json.php* on line *20*
>>>
>>>
>>> On Wednesday, November 27, 2013 2:03:14 AM UTC+5:30, asgallant wrote:
>>>>
>>>> You have to parse the date output from the server into the correct
>>>> format for use in the Visualization API. Also, your rows are not
>>>> correctly
>>>> formated. Try this:
>>>>
>>>> while($rows>0){
>>>> $row = mysql_fetch_row($sqlresult1);
>>>> $dateTimeArray = explode(' ', $row[0]);
>>>> $dateArray = explode('-', $dateTimeArray[0]);
>>>> $year = (int) dateArray[0];
>>>> $month = (int) dateArray[1] - 1; // subtract 1 to convert to
>>>> javascript's 0-indexed months
>>>> $day = (int) dateArray[2];
>>>>
>>>> $timeArray = explode(':', $dateTimeArray[1]);
>>>> $hours = (int) timeArray[0];
>>>> $minutes = (int) timeArray[1];
>>>> $seconds = (int) timeArray[2];
>>>>
>>>> $output['rows'][] = array('c' => array(
>>>> array('v' => "Date($year, $month, $day, $hours, $minutes,
>>>> $seconds)"),
>>>> array('v' => (float) $row[1])
>>>> ));
>>>> $rows--;
>>>> }
>>>>
>>>> On Tuesday, November 26, 2013 2:44:35 PM UTC-5, [email protected]:
>>>>>
>>>>>
>>>>> <https://lh4.googleusercontent.com/-wAcgAdSwIiU/UpT4Dbu2VbI/AAAAAAAAAAM/2F2jX881p5M/s1600/Untitled.jpg>
>>>>> I want to get data from mysql database and make an Annotated Time
>>>>> Line graph. I attached a view of my database above. I used 2 pages, one
>>>>> for
>>>>> get data from database and other for drawing chart.
>>>>> Following is the page get the data from database.
>>>>>
>>>>> <?php
>>>>>
>>>>> mysql_connect('host','user,'pw');
>>>>> mysql_select_db('DB');
>>>>>
>>>>> $sqlquery1="SELECT * FROM TABLE";
>>>>>
>>>>> $sqlresult1=mysql_query($sqlquery1);
>>>>> $rows = mysql_num_rows($sqlresult1);
>>>>> $output=array();
>>>>> $table['cols']=array(
>>>>> array('label'=> 'date', type=>'datetime'),
>>>>> array('label'=>'actual', type=>'number')
>>>>> );
>>>>>
>>>>> while($rows>0){
>>>>> $row = mysql_fetch_row($sqlresult1);
>>>>> $output['rows'][] = array("{$row[0]}", $row[1]);
>>>>> $rows--;
>>>>> }
>>>>>
>>>>>
>>>>> echo json_encode($output);
>>>>> ?>
>>>>>
>>>>> Output is like this.
>>>>>
>>>>> <https://lh3.googleusercontent.com/-ZMCAK4wfxvo/UpT5Kosod1I/AAAAAAAAAAY/QPuqBXgNNkU/s1600/Untitled1.jpg>
>>>>>
>>>>> Page 2 which will draw the chart code is bellow.
>>>>>
>>>>> <html>
>>>>> <head>
>>>>> <title>My realtime chart</title>
>>>>> <script type="text/javascript" src="https://www.google.com/jsapi
>>>>> "></script>
>>>>> <script type="text/javascript" src="
>>>>> http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js
>>>>> "></script>
>>>>> <script type="text/javascript">
>>>>> google.load('visualization', '1',
>>>>> {'packages':['annotatedtimeline']});
>>>>> google.setOnLoadCallback(drawChart);
>>>>> function drawChart() {
>>>>>
>>>>> // Create the data table.
>>>>> var jsonData = $.ajax({
>>>>> url:'json.php',
>>>>> dataType:'json',
>>>>> async:false
>>>>> }).responseText;
>>>>>
>>>>> var data=new google.visualization.DataTable(jsonData);
>>>>> //var view=new google.visualization.DataView(data);
>>>>> // Set chart options
>>>>> var options = {'title':'Water level change',
>>>>> 'width':600 ,
>>>>> 'height':550};
>>>>>
>>>>> // Instantiate and draw our chart, passing in some options.
>>>>> var chart = new
>>>>> google.visualization.LineChart(document.getElementById('chart_product_history'));
>>>>> chart.draw(data, options);
>>>>> }
>>>>> </script>
>>>>> </head>
>>>>> <body>
>>>>> <div id='chart_product_history' style="width: 500px; height:
>>>>> 500px;"></div>
>>>>> </body>
>>>>> </html>
>>>>>
>>>>> But nothing displays.
>>>>> I am a beginner in coding and please help.
>>>>> Thanks
>>>>>
>>>>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/groups/opt_out.
