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
| <?php
$jour=date("Y-m-d");
if(isset($_POST['counteram'])) $counteram=$_POST['counteram'];
else $counteram="0";
if(isset($_POST['jamam'])) $jamam=$_POST['jamam'];
else $jamam="0";
if(isset($_POST['counterpm'])) $counterpm=$_POST['counterpm'];
else $counterpm="0";
if(isset($_POST['jampm'])) $jampm=$_POST['jampm'];
else $jampm="0";
$db = mysql_connect('127.0.0.1', 'root','PASSWORD') or die('Erreur de connexion '.mysql_error());
mysql_select_db('info_printer',$db) or die('Erreur de selection '.mysql_error());
$query = "SELECT * FROM `count`";
$result = mysql_query($query, $db) or die($query . " - " . mysql_error());
$tab = mysql_fetch_array($result);
if ($tab['day']='$jour') {
$sql1 = "update `count` set `countpm`=1500 where `day`='$jour'";
mysql_query($sql1) or die('Erreur SQL !'.$sql1.'<br>'.mysql_error());
}
else{
$sql2 = "INSERT INTO `count` VALUES ('null','$jour','$counteram','$counterpm','$jamam','$jampm')";
echo "ok";
mysql_query($sql2) or die('Erreur SQL !'.$sql2.'<br>'.mysql_error());
}
echo"<table border=\"1\">";
echo "<tr>";
echo "<td width=200 bgcolor=#87AFC7><center><b>Jour </b></center></td>\n";
echo "<td width=200 bgcolor=#87AFC7><center><b>Compteur matin </b></center></td>\n";
echo "<td width=200 bgcolor=#87AFC7><center><b>Compteur apres-midi</b></center></td>\n";
echo "<td width=200 bgcolor=#87AFC7><center><b>Bourrages matin</b></center></td>\n";
echo "<td width=200 bgcolor=#87AFC7><center><b>Bourrages apres-midi</b></center></td>\n";
echo "<td width=200 bgcolor=#87AFC7><center><b>total</b></center></td>\n";
echo "</tr>";
echo "<tbody>";
echo"<TR>";
$total=$tab['countpm']-$tab['countam'];
echo "<TD>";echo $tab['day'];echo"</TD>\n";
echo "<TD>";echo $tab['countam'];echo"</TD>\n";
echo "<TD>";echo $tab['countpm'];echo"</TD>\n";
echo "<TD>";echo $tab['jamam'];echo"</TD>\n";
echo "<TD>";echo $tab['jampm'];echo"</TD>\n";
echo "<TD>";echo $total;echo"</TD>\n";
}
echo"</TR>";
echo"</tbody></table>";
mysql_close();
?> |
Partager