[visualization-api] Timeline Google Charts mysql

fanny André Wed, 20 Apr 2016 00:13:30 -0700

Bonjour,

Voila j'essai de mettre en place la Timeline Google Charts avec mes données 
en BDD.
Ce sont des dates de prise de médicament à afficher... Début et fin de prise
J'ai lu la doc de Google mais je n'arrive toujours pas a afficher mon 
graph....


Est ce que quelqu'un pourrait m'aider ??!
Merci :)
Voila ce que j'ai dans mon fichier :

Code : Tout sélectionner 
<http://forum.phpfrance.com/php-debutant/timeline-google-charts-mysql-t275977.html#>
<script type="text/javascript" src="../js/jquery1.11.3.js"></script>
<script src="https://www.google.com/jsapi"; type="text/javascript"></script>
<script type="text/javascript" src=
"https://www.gstatic.com/charts/loader.js";></script>
</head>
<body>
<?php
include_once("../inc/connexion.php");
   $query = $mysqli -> query("SELECT * FROM medicament
   INNER JOIN compte
   ON medicament.cp_id = compte.cp_id
   WHERE compte.cp_id = $id_cp 
   ");
   $results = array();   
   while($rows = $query -> fetch_array()){
   $results[] = $rows;
   $chart = array();
   foreach($results as $result) 
   {
   $chart[] = array($result['med_nom'], (int)$result['debut_prise'],(int)
$result['fin_prise']);
   }
   $chart = json_encode($chart);
   }   
   echo $chart;
?>

<div id="timeline" style="height: 180px;"></div>

<script type="text/javascript" src=
"https://www.gstatic.com/charts/loader.js";></script>
    <script type="text/javascript">
      google.charts.load('current', {'packages':['timeline']});
      google.charts.setOnLoadCallback(drawChart);
      function drawChart() {
        var container = document.getElementById('timeline');
        var chart = new google.visualization.Timeline(container);
        var dataTable = new google.visualization.DataTable();

        dataTable.addColumn({ type: 'string', id: 'med_nom' });
        dataTable.addColumn({ type: 'date', id: 'debut_prise' });
        dataTable.addColumn({ type: 'date', id: 'fin_prise' });
        dataTable.addRows([$chart]);

        chart.draw(dataTable);
      }
    </script>

-- 
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-visualization-api/640f9cb3-bed0-4f88-85d3-64df4df1ca96%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[visualization-api] Timeline Google Charts mysql

Reply via email to