1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107
| <?php
//Démarrage des sessions
session_start ();
//Affichage des erreurs PHP
error_reporting(E_ALL);
ini_set('display-errors','on');
// REQUIRE
require_once ('connexion.php');
//Récupération des variables AVANT de les utiliser
$mes_opcion = !empty($_POST['mes']) ? $_POST['mes'] : (!empty($_SESSION['mes']) ? $_SESSION['mes'] : NULL);
$_SESSION['mes'] = $mes_opcion ;
print_r(array_values($mes_opcion));
//Traitement
$sql = 'SELECT fecha, lluvia FROM meteo WHERE MONTH(fecha) = ? ';
$datas = array($mes_opcion[0]);
try{
$req = $connexion->prepare($sql);
$req->execute($datas);
$row = $req->fetchAll(PDO::FETCH_ASSOC); //on stocke les données dans un ARRAY
}catch(Exception $e){
echo "Erreur ! ".$e->getMessage();
}
$datos_lluvia = array();
if(!empty($row)){
//On parcours l'array
foreach($row as $R) {
$datos_lluvia[] = (float)$R['lluvia'];
}
}else{
echo " La requête n'a pas retournée de données.... ";
}
print_r(array_values($datos_lluvia)); // renvoi Array ( [0] => 10 [1] => 40 [2] => 5 [3] => 5 [4] => 20 [5] => 91 )
echo "<pre>datos_lluvia :<br>";
print_r($datos_lluvia); // renvoi datos_lluvia :
Array
(
[0] => 10
[1] => 40
[2] => 5
[3] => 5
[4] => 20
[5] => 91
)
echo " en Json => " . json_encode($datos_lluvia); //renvoi en Json => [10,40,5,5,20,91]
echo "</pre>";
$req->closeCursor();
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js" > </script>
<!-- Load the AJAX API -->
<script type="text/javascript" src="https://www.google.com/jsapi" > </script>
<script type="text/javascript"
src="https://www.google.com/jsapi?autoload={
'modules':[{
'name':'visualization',
'version':'1',
'packages':['corechart']
}]
}"></script>
<script type="text/javascript">
var cargaDatos = <?php echo json_encode($datos_lluvia); ?>;
console.log(cargaDatos);
console.log( " cargaDatos : " );
google.setOnLoadCallback(drawChart);
function drawChart() {
var datosFinales = google.visualization.arrayToDataTable(cargaDatos);
var options = {
title: 'Precipitacion',
curveType: 'function',
legend: { position: 'bottom' }
};
var chart = new google.visualization.LineChart(document.getElementById('curve_chart'));
chart.draw(datosFinales, options);
}
</script>
</head>
<body>
<div id="curve_chart" style="width: 900px; height: 500px"></div>
</body>
</html> |
Partager