//création de la requête SQL: $sql = "INSERT INTO demande (id ,utilisateur , type , date, etat , delai) VALUES ( '', '$utilisateur', '$type','$date','$etat', '$delai') " ; Echo " Variables passees en POST : <br>"; Print_r($_POST); Echo " Requête : <br>"; Print_r($sql); //exécution de la requête SQL: $requete = mysql_query($sql, $cnx) ;
delai] => [date_] =>
//date: (isset($_POST["date"] ))? $date=$_POST["date"] : $date="ERROR" ; /* C'est la syntaxe d'un IF Mavariable est initialisée...alors... sinon.. Tu peux remplacer ERROR par n'importe quelle valeur par défaut qui t'interesse... Ou même mettre à la place un ECHO */ (isset($_POST["date"] ))? $date=$_POST["date"] : Echo "ERROR" ;
<form name="form1" method="post" action="demande.php"> // ICI TES CHAMPS DATE,TYPE,ETAT,UTILISATEUR etc... </form>
p><div align="center"><strong>NOUVELLE DEMANDE</strong></div></p>
<table width="812" height="144" align="center" >
<form name="form1" method="post" action="demande.php">
<tr>
<td width="106"><strong> Utilisateur:</strong> </td>
<td width="362"><select name="utilisateur" style="width:230px">
<option value="user001">KEBE YACOUBA</option>
<option value="user002">TOURE SARAN</option>
<option value="user003">N'GUESSAN BERNISE</option>
<option value="user004">BERTE MARIE ANTOINETTE</option>
<option value="user005">Mme GANON</option>
<option value="user006">LOU VIVIANE</option>
<option value="user007">BROU YAO PAUL</option>
<option value="user008">KASSI DAMO</option>
<option value="user009">TRAORE FATOUMATA</option>
<option value="user010">THIAM KADIATOU</option>
<option value="user011">DICKO ALY</option>
<option value="user012">ABOUGNAN ESTHER</option>
<option value="user013">CAMARA BANGALI</option>
<option value="user014">ABBE N'CHO</option>
<option value="user015">LEVRY TOUSSAINT</option>
<option value="user016">KOUADIO JOSEPH</option>
<option value="user017">TROBIA HELENE</option>
<option value="usr018">KOUASSI PARFAIT</option>
<option value="user019">KOUAKOU HERMANN</option>
<option value="usr020">KONE MAMADOU</option>
<option value="user021">NIAMIEN YAO THEODORE</option>
<option value="user022">BIDI SANDRA</option>
<option value="user023">CARLTON COULIBALY</option>
<option value="usr024">GBIZIE NICOLAS</option>
</select>
</td>
</tr>
<tr>
<td><strong> Type : </strong> </td>
<td><select name="type" style=" width:150px;">
<option value="Travaux">Travaux </option>
<option value="Assistance"> Assistance </option>
<option value="Fourniture"> Fourniture </option>
<option value="Formation">Formation </option>
</select>
<td width="74" align="right"><strong> Delai :</strong> </td>
<td width="250"><input type="text" name="delai" maxlength="65" style="width:250px;" /></td>
</tr>
<tr>
<td><strong> Date : </strong> </td>
<td><input type="hidden" name="date" maxlength="65" style="width:180px;" /></td>
</tr>
<tr>
<td><strong> Etat: </strong> </td>
<td><input type="checkbox" name="etat" value="URGENCE"
checked = "checked" />
URGENCE
<input type="checkbox" name="etat" value="A PREVOIR" />
A PREVOIR
<input type="checkbox" name="etat" value="EN ATTENTE" />
EN ATTENTE</td>
</tr>
<tr>
<td colspan="2"><div align="center">
<input name="submit" type="submit" value="Envoyer" />
<input name="reset" type="reset" value="Annuler" />
</div></td>
</tr>
</form>
</table>
</body>
<tr>
<td><strong> Date : </strong> </td>
<td><input type="hidden" name="date" maxlength="65" style="width:180px;" /></td>
</tr>
<tr>
<td><strong> Etat: </strong> </td>
<td><input type="checkbox" name="etat" value="URGENCE"
checked = "checked" />
URGENCE
<input type="checkbox" name="etat" value="A PREVOIR" />
A PREVOIR
<input type="checkbox" name="etat" value="EN ATTENTE" />
EN ATTENTE</td>
</tr>