Voila la page d'envoi :
<?php
include ('connexion.inc');
session_start();
if(!isset($_SESSION['login']) && !isset($_SESSION['pass'])) {
echo 'Vous n\'êtes pas autoris´ à acceder à cette zone';
exit;
}
$demandeur = $_SESSION['login'];
$date = $_POST['date'];
$heure = $_POST['heure'];
$description = $_POST['descrip'];
$urgence = $_POST['urgence'];
if (empty($description))
{
echo 'Des champs n\'ont pas été remplis.';
exit();
}
else
{
$sql = "INSERT INTO intervention (num_interv, date_demande, heure_demande, description, num_user, num_urg, num_tech)
VALUES ('', '$date', '$heure', '$description', '$demandeur', '$urgence', '')";
$sql_exe = mysql_query($sql) or die('Erreur : ' . mysql_error());
}
header("Location: accueil.php");
?><?php
$slogin = $_SESSION['login'];
$date = date("d-m-Y");
$heure = date("H:i");
$sql = "SELECT S.num_service, S.nom_service, T.num_tech, T.nom_tech, T.prenom_tech, U.num_urg, U.nom_urg, US.num_user, US.nom_user, US.prenom_user, US.login_user, US.pass_user, US.num_user
FROM service S, technicien T, urgence U, users US
Where S.num_service = US.num_service
AND US.login_user = '".$slogin."'";
$sql_exe = mysql_query($sql) or die('Erreur : ' . mysql_error());
while ($Tab = mysql_fetch_array($sql_exe))
{
?>
<br>
<form action="envoi_demande.php" method="post">
<table>
<tr>
<td width="220"><span class="intitule_lig">Demandeur : </span></td>
<td> <input name="demandeur" type="text" size="31" readonly="enable" value="<?php echo $_SESSION['login'] ?>"></td>
</tr>
</table>
<table>
<tr>
<td width="220"><span class="intitule_lig">Date de la demande : </span></td>
<td> <input name="date" type="text" size="31" readonly="enable" value="<?php echo $date ?>"></td>
</tr>
</table>
<table>
<tr>
<td width="220"><span class="intitule_lig">Heure de la demande : </span></td>
<td> <input name="heure" type="text" size="31" readonly="enable" value="<?php echo $heure ?>"></td>
</tr>
</table>
<table>
<tr>
<td width="220"><span class="intitule_lig">Service : </span></td>
<?
$sql = "Select * From service order by nom_service";
$sql_exe = mysql_query($sql) or die('Erreur : ' . mysql_error());{
?>
<td> <input name="service" type="hidden" size="31" readonly="enable" value="<?php echo $Tab["num_service"] ?>"><?php echo $Tab["nom_service"] ?></td>
<? } ?>
</tr>
</table>
<table>
<tr>
<td width="216"><span class="intitule_lig">Urgence : </span></td>
<?
$sql = "Select * From urgence order by nom_urg";
$sql_exe = mysql_query($sql) or die('Erreur : ' . mysql_error());
?>
<td>
<?
$ld = "<SELECT NAME='urgence'>";
$ld .= "<OPTION VALUE=0>Choisir niveau de l'urgence</OPTION>";
while ( $row = mysql_fetch_array( $sql_exe)) {
$numurg = $row["num_urg"];
$nomurg = $row["nom_urg"];
$ld .= "<OPTION VALUE='$numurg'>$nomurg</OPTION>";
}
$ld .= "</SELECT>";
echo $ld
?>
</td>
</tr>
</table>
<table>
<tr>
<td><span class="intitule_lig">Description de la demande : </span></td>
</tr>
</table>
<table>
<tr>
<td><textarea name="descrip" cols="80" rows="10"></textarea></td>
</tr>
</table>
<br>
<table width="650" border="0" cellpadding="0">
<tr>
<td align="right"><input name="envoi" type="submit" value="Envoyer" /></td>
<td align="left"><input name="reset" type="reset" value="Annuler" /></td>
</tr>
</table>
</form>
<?php } ?>