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 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161
| <?php
function ligneParDefaut($donnees)
{
$ligne = '';
if (isset($_POST['donnees']))
{
if ($_POST['donnees'] == $donnees)
{
$ligne='selected="selected"';
}
}
return $ligne;
}
?>
<head>
<title>Consultation des donnees de production</title>
<link rel="stylesheet" type="text/css" href="format.css">
<center><table>
<tr bgcolor="#f4fbfd" border="#f4fbfd">
<th width=33% height=80><center><img src="images/vihiers.jpg" width=536 height=160 style="border-color:#15735B" border = 3></center></th>
</table></center>
</head>
<br>
<hr width = 80%>
<b><center><h1>CONSULTATION DES DONNEES</h1></center></b>
<hr width = 80%>
<br>
<br>
<center>
<FORM method="post">
Les donnees de production de la ligne :<BR><BR>
<SELECT name="donnees">
<OPTION value="Toutes les lignes de fabrication" <?php echo ligneParDefaut('Toutes les lignes de fabrication'); ?>>Toutes les lignes de fabrication</OPTION>
<OPTION value="Kidiboo" <?php echo ligneParDefaut('Kidiboo'); ?>>Kidiboo (1)</OPTION>
<OPTION value="St Moret" <?php echo ligneParDefaut('St Moret'); ?>>St Moret (2)</OPTION>
<OPTION value="Tartare" <?php echo ligneParDefaut('Tartare'); ?>>Tartare (3)</OPTION>
<OPTION value="Petit Louis" <?php echo ligneParDefaut('Petit Louis'); ?>>Petit Louis (4)</OPTION>
<OPTION value="Cric Crac" <?php echo ligneParDefaut('Cric Crac'); ?>>Cric Crac (5)</OPTION>
</SELECT>
<br><br><center><INPUT TYPE=SUBMIT VALUE="Valider"></center>
</FORM>
</center>
<?php
if (isset($_POST['donnees']))
{
$host = "ma_machine" ;
$user = "mon_user" ;
$passwd = "mon_passwd" ;
$bdd = "ma_bdd" ;
mysql_connect($host , $user , $passwd) or die("Erreur de connexion au serveur");
mysql_select_db($bdd) or die("Erreur de connexion a la base de donnees");
switch($donnees){
case "Toutes les lignes de fabrication" :
$query_ligne = "SELECT idLibelle_Ligne_Fabrication,nom FROM Libelle_Ligne_Fabrication";
$result = mysql_query($query_ligne);
echo '<center><table width=80% border=#000000 CELLSPACING=0>';
echo '<th width="50%">N° Ligne Fabrication</th><th width="50%">Nom de la ligne</th>';
while($tableau = mysql_fetch_row($result)){
$ID_libelle_ligne = $tableau[0];
$Nom_ligne = $tableau[1];
echo "<tr><td><center>$ID_libelle_ligne</center></td><td><center>$Nom_ligne</center></td></tr>";
}
echo '</table></center>';
break ;
case "Kidiboo" :
$query_kidiboo = "SELECT `idLigne_Fabrication` , `idLibelle_data` , `date` , `valeur` FROM `Data_journee` WHERE `idLigne_Fabrication` = 1 ORDER BY `idLibelle_data` ASC LIMIT 0, 300" AND "SELECT `nom_libelle` FROM `Libelle_data` " ;
$result = mysql_query($query_kidiboo);
echo '<center><table width=80% border=#000000 CELLSPACING=0>';
echo '<th width=20%>N° Ligne Fabrication</th><th width=20%>N° de la donnée</th><th width=20%>Nom de la donnée</th><th width=20%>Date</th><th width=20%>Valeur</th>';
while($row = mysql_fetch_row($result)){
$idLigne_Fabrication = $row[0];
$idLibelle_data = $row[1];
$date = $row[2];
$valeur = $row[3];
$Libelle_data = $row[4];
echo "<tr><td><center>$idLigne_Fabrication</center></td><td><center>$idLibelle_data</center></td><td><center>$Libelle_data</center></td><td><center>$date</center></td><td><center>$valeur</center></td></tr>";
}
echo '</table></center>';
break ;
case "St Moret" :
$query_st_moret = "SELECT `idLigne_Fabrication` , `idLibelle_data` , `date` , `valeur` FROM `Data_journee` WHERE `idLigne_Fabrication` = 2 ORDER BY `idLibelle_data` ASC LIMIT 0, 300 ";
$result = mysql_query($query_st_moret);
echo '<center><table width=80% border=#000000 CELLSPACING=0>';
echo '<th width=25%>N° Ligne Fabrication</th><th width=25%>N° de la donnée</th><th width=25%>Date</th><th width=25%>Valeur</th>';
while($row = mysql_fetch_row($result)){
$idLigne_Fabrication = $row[0];
$idLibelle_data = $row[1];
$date = $row[2];
$valeur = $row[3];
echo "<tr><td><center>$idLigne_Fabrication</center></td><td><center>$idLibelle_data</center></td><td><center>$date</center></td><td><center>$valeur</center></td></tr>";
}
echo '</table></center>';
break ;
case "Cric Crac" :
$query_cric_crac = "SELECT `idLigne_Fabrication` , `idLibelle_data` , `date` , `valeur` FROM `Data_journee` WHERE `idLigne_Fabrication` = 5 ORDER BY `idLibelle_data` ASC LIMIT 0, 300 ";
$result = mysql_query($query_cric_crac);
echo '<center><table width=80% border=#000000 CELLSPACING=0>';
echo '<th width=25%>N° Ligne Fabrication</th><th width=25%>N° de la donnée</th><th width=25%>Date</th><th width=25%>Valeur</th>';
while($row = mysql_fetch_row($result)){
$idLigne_Fabrication = $row[0];
$idLibelle_data = $row[1];
$date = $row[2];
$valeur = $row[3];
echo "<tr><td><center>$idLigne_Fabrication</center></td><td><center>$idLibelle_data</center></td><td><center>$date</center></td><td><center>$valeur</center></td></tr>";
}
echo '</table></center>';
break ;
case "Tartare" :
$query_tartare = "SELECT `idLigne_Fabrication` , `idLibelle_data` , `date` , `valeur` FROM `Data_journee` WHERE `idLigne_Fabrication` = 3 ORDER BY `idLibelle_data` ASC LIMIT 0, 300 ";
$result = mysql_query($query_tartare);
echo '<center><table width=80% border=#000000 CELLSPACING=0>';
echo '<th width=25%>N° Ligne Fabrication</th><th width=25%>N° de la donnée</th><th width=25%>Date</th><th width=25%>Valeur</th>';
while($row = mysql_fetch_row($result)){
$idLigne_Fabrication = $row[0];
$idLibelle_data = $row[1];
$date = $row[2];
$valeur = $row[3];
echo "<tr><td><center>$idLigne_Fabrication</center></td><td><center>$idLibelle_data</center></td><td><center>$date</center></td><td><center>$valeur</center></td></tr>";
}
echo '</table></center>';
break ;
case "Petit Louis" :
$query_petit_louis = "SELECT `idLigne_Fabrication` , `idLibelle_data` , `date` , `valeur` FROM `Data_journee` WHERE `idLigne_Fabrication` = 4 ORDER BY `idLibelle_data` ASC LIMIT 0, 300 ";
$result = mysql_query($query_petit_louis);
echo '<center><table width=80% border=#000000 CELLSPACING=0>';
echo '<th width=25%>N° Ligne Fabrication</th><th width=25%>N° de la donnée</th><th width=25%>Date</th><th width=25%>Valeur</th>';
while($row = mysql_fetch_row($result)){
$idLigne_Fabrication = $row[0];
$idLibelle_data = $row[1];
$date = $row[2];
$valeur = $row[3];
echo "<tr><td><center>$idLigne_Fabrication</center></td><td><center>$idLibelle_data</center></td><td><center>$date</center></td><td><center>$valeur</center></td></tr>";
}
echo '</table></center>';
break ;
}
mysql_close();
}
?>
<br>
<br> |
Partager