Assuming that your dates are in the form "year-month-day", this is how you
would transform the dates properly:
while($r = mysql_fetch_assoc($query)) {
$temp = array();
$dateArray = explode('-', $r['date']);
$year = $dateArray[0];
$month = $dateArray[1] - 1; // subtract 1 from the month to convert to
javascript date format
$day = $dateArray[2];
$temp[] = array('v' => "Date($year, $month, $day)");
$temp[] = array('v' => (int) $r['value']);
$rows[] = array('c' => $temp);
}
On Tuesday, August 6, 2013 3:59:41 AM UTC-4, mizzle lee wrote:
>
> im new to learning google visualization API, i facing a problem when i wan
> to create a timeline and get the data from mysql.
> below is the source code:
>
> *json1.php*
>
> <?php
> $host="localhost";
> $user="root";
> $password="";
> $koneksi=mysql_connect($host,$user,$password) or die("Cannot Connect The
> Database");
> mysql_select_db("chart");
>
> $query = mysql_query('SELECT * FROM chart');
> $table = array();
> $table['cols'] = array(
>
> array('label' => 'Date', 'type' => 'datetime'),
> array('label' => 'November', 'type' => 'number'),
> );
> $rows = array();
> while($r = mysql_fetch_assoc($query)) {
> $temp = array();
>
> $temp[] = array('v' => $r['date']);
> $temp[] = array('v' => (int) $r['value']);
> $rows[] = array('c' => $temp);
> }
>
> $table['rows'] = $rows;
> $jsonTable = json_encode($table);
>
> echo $jsonTable;
> ?>
>
> *new3.php*
> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "
> http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";>
> <html xmlns="http://www.w3.org/1999/xhtml";>
> <head>
> <meta http-equiv="content-type" content="text/html; charset=utf-8" />
> <title>Google Visualization API Sample</title>
> <script type="text/javascript" src="http://www.google.com/jsapi
> "></script>
> <script type="text/javascript">
> google.load('visualization', '1', {packages: ['annotatedtimeline']});
> google.setOnLoadCallback(drawVisualization);
> function drawVisualization() {
> var json = $.ajax({
> url: 'json1.php',
> dataType: 'json',
> async: false
> }).responseText;
>
> var data = new google.visualization.DataTable(json);
> var options = {
> title: 'Chart 2013',
> };
>
> var chart = new google.visualization.AnnotatedTimeLine(
> document.getElementById('chart'));
> chart.draw(data, {'displayAnnotations': true});
> }
>
> </script>
> </head>
> <body style="font-family: Arial;border: 0 none;">
> <div id="chart" style="width: 800px; height: 300px;"></div>
> </body>
>
> ********
> i found out that the date format of the json is
> "rows":[{"c":[{"v":"2013-08-06"},{"v":20}]}
> but the google API is using js format, is it i need to change the date
> format?
> and how? really no idea.
>
--
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.
