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
|
<html>
<head>
<title>Evolution of the capor's characteristics </title>
<center><font color="#FF0033" size="6"><b> Captors of JUROGAM </b></font></center>
</head>
<?php
$connect= mysql_connect("localhost","root","")
or die("Impossible de se connecter");
$db_selected=mysql_select_db('stage',$connect);
//echo 'Connecte a la base de donnée stage <br />';
if(!$db_selected){
die('Impossible de sélectionner la BD:' . mysql_error());
}
?>
<form method="post" action="">
<p>
Date debut
<br />
<input type="text" name="date_d" size="8" />
<br />
Date fin :
<br />
<input type="text" name="date_f" size="8">
<br />
Capteur debut
<br />
<input type="text" name="capteur_d" size="3" />
<br />
Capteur fin :
<br />
<input type="text" name="capteur_f" size="3">
<br />
</p>
<input type="submit" name="Submit" value="Envoyer">
</form>
<html><body>
<?php
$heure=' 00:00:00';
$date_d=$_POST['date_d'].$heure;
$date_f=$_POST['date_f'].$heure;
$capteur_d=$_POST['capteur_d'];
$capteur_f=$_POST['capteur_f'];
echo '<p>Date debut: ' . $date_d . '</p>';
echo '<p>Date fin : ' . $date_f . '</p>';
echo '<p>Capteur debut: ' . $capteur_d . '</p>';
echo '<p>Capteur fin: ' . $capteur_f . '</p>';
?>
</body></html>
<?php
$requete = "SELECT voltage
FROM testtable_data
WHERE '$date_d'<=datetime AND datetime<='$date_f'
'$capteur_d'<=id_captor AND id_captor<='$capteur_f'
";
$pg_result = mysql_query($requete);
while ($resultat = mysql_fetch_row($pg_result)) {
echo '<option value="'.$resultat[0].'">'.$resultat[0];
}
?>
<?php
//Partie graph
include ("C:\wamp\www\Stage_pageweb\jpgraph-2.3\src\jpgraph.php");
include ("C:\wamp\www\Stage_pageweb\jpgraph-2.3\src\jpgraph_line.php");
include ("C:\wamp\www\Stage_pageweb\jpgraph-2.3\src\jpgraph_bar.php");
$month=array(
"Jan","Feb","Mar","Apr","Maj","Jun","Jul","Aug","Sep","Okt","Nov","Dec");
... Suite de l'ex donné par jpgraph |
Partager