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
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<?php
// on se connecte à MySQL
$db = mysql_connect('localhost', '4sx', 'xxxxx');
// on sélectionne la base
mysql_select_db('4sx',$db);
?>
<table width="125" border="2" cellpadding="0" cellspacing="0">
<tr bgcolor="#0099FF">
<td width="23" bgcolor="#0099FF" class=tabhead><br>
<b><?php echo 'Numéro'; ?></b></td>
<td width="25" bgcolor="#0099FF" class=tabhead><br>
<b><?php echo 'DEPT'; ?></b></td>
<td width="26" bgcolor="#0099FF" class=tabhead><br>
<b><?php echo 'Technicien'; ?></b></td>
<td width="351" bgcolor="#0099FF" class=tabhead><br>
<b><?php echo 'Messages'; ?></b></td>
</tr>
<?php
mysql_query("INSERT INTO paca_badge (numero,departement,commentaire)");
$result = mysql_query("SELECT numero,departement,commentaire FROM paca_badge ORDER BY departement");
while ($row = mysql_fetch_array($result)) {
echo "<tr valign='middle'>";
echo "<td class='tabval'><b>".$row['numero']."</b> </td>";
echo "<td class='tabval'>".$row['departement']." </td>";
echo "<td class='tabval'>".$sql = 'INSERT INTO paca_badge_prod VALUES("", "'.mysql_escape_string($_POST['auteur']).'", "'.date("Y-m-d H:i:s").'", "'.mysql_escape_string($_POST['message']).'")';
if(!empty($_POST['auteur'])){
mysql_query($sql) or die('Erreur SQL !'.$sql.'<br />'.mysql_error());
}
echo "<form action='index.php' method='post'>";
echo "<SELECT NAME='auteur' onChange='FocusObjet()'>";
$req = mysql_query("SELECT auteur FROM paca_utilisateur ORDER BY auteur");
while($donnee = mysql_fetch_array($req))
echo "<OPTION VALUE='$donnee[auteur]'>$donnee[auteur] </option>";
echo "</select>";
echo "<textarea name='message' cols='31' rows='2'></textarea>";
echo "<input name='go' type='submit' value='Valider'>";
echo "</form>";
echo "</td>";
echo "<td class='tabval'>".$sql = 'SELECT auteur, date_signature, message FROM paca_badge_prod ORDER BY date_signature DESC';
$req = mysql_query($sql) or die('Erreur SQL !<br />'.$sql.'<br />'.mysql_error());
$nb_signature = mysql_num_rows($req);
if ($nb_signature == 0) {
echo 'Aucun mouvement.';
}
else {
while ($data = mysql_fetch_array($req)) {
sscanf($data['date_signature'], "%4s-%2s-%2s %2s:%2s:%2s", $annee, $mois, $jour, $heure, $minute, $seconde);
echo '<a href=mailto:' , htmlentities(trim($data['email'])) , '>' , htmlentities(trim($data['auteur'])) , '</a>';
echo ' le ' , $jour , '/' , $mois , '/' , $annee , ' à ' , $heure , ':' , $minute , '<br />';
echo nl2br(htmlentities(trim($data['message'])));
echo '<br /><br />';
}
}
// on libère l'espace mémoire alloué pour cette requête
mysql_free_result ($req);
echo "</td>";
echo "</tr>";
}
// on ferme la connexion à mysql
mysql_close();
?>
</table>
</body>
</html> |
Partager