Voilà mon code, merci aux courageux qui liront ces lignes :
//Ajouter une demande :
<form name="insertion" action="insertion.php" method="POST">
<table width="400" border="0">
<tr>
<td width="79"> </td>
<td width="76"> </td>
<td >N°de ticket :</td>
<td align="right"><?php
$date = date("d-m-Y");
echo ("$date");
?></td>
<td align="left"><input name="numero" type="text" size="2" /></td>
</tr>
<tr>
<td>Problème :</td>
<td width="76"><?php include('connection.php'); ?>
<select name='probleme' ><option value='<?php $row["id_probleme"]; ?>'></option>
<?php
$query = "SELECT probleme FROM problemes";
$result = mysql_query ($query) or die ("La requête SQL a échoué !");
while (list($probleme) = mysql_fetch_row($result))
{
print "<option value='$probleme'>$probleme</option>\n";
}
?>
</select>
<?php
mysql_free_result($result);
?> </td>
<td width="68"></td>
<td width="70"></td>
<td width="40"></td>
</tr>
<tr>
<td>Demandeur : </td>
<td><?php include('connection.php'); ?>
<select name='demandeur' ><option value='<?php $row["id_demandeurs"]; ?>'></option>
<?php
$query = "SELECT demandeur FROM demandeurs";
$result = mysql_query ($query) or die ("La requête SQL a échoué !");
while (list($demandeur) = mysql_fetch_row($result))
{
print "<option value='$demandeur'>$demandeur</option>\n";
}
?>
</select>
<?php
mysql_free_result($result);
?> </td>
<td>Client :</td>
<td><?php include('connection.php'); ?>
<select name='client' ><option value='<?php $row["id_clients"]; ?>'></option>
<?php
$query = "SELECT client FROM clients";
$result = mysql_query ($query) or die ("La requête SQL a échoué !");
while (list($client) = mysql_fetch_row($result))
{
print "<option value='$client'>$client</option>\n";
}
?>
</select>
<?php
mysql_free_result($result);
?> </td>
<td> </td>
<td width="41"> </td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Description :</td>
<td colspan="5"><input name="description" type="text" size="40"></td>
</tr>
<tr>
<td>Description : </td>
<td colspan="5" rowspan="2"><textarea name="description_long" cols="35" rows="10"></textarea></td>
</tr>
<tr>
<td height="114"> </td>
</tr>
<tr>
</tr>
<tr>
<td>Date de fin :</td>
<td>Priorité :</td>
<td>Impact</td>
<td>Heure :</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><input name="date_fin" type="text" size="10"></td>
<td><?php include('connection.php'); ?>
<select name='priorite' ><option value='<?php $row["id_priorites"]; ?>'></option>
<?php
$query = "SELECT priorite FROM priorites";
$result = mysql_query ($query) or die ("La requête SQL a échoué !");
while (list($priorite) = mysql_fetch_row($result))
{
print "<option value='$priorite'>$priorite</option>\n";
}
?>
</select>
<?php
mysql_free_result($result);
?></td>
<td><?php include('connection.php'); ?>
<select name='impact' ><option value='<?php $row["id_impacts"]; ?>'></option>
<?php
$query = "SELECT impact FROM impacts";
$result = mysql_query ($query) or die ("La requête SQL a échoué !");
while (list($impact) = mysql_fetch_row($result))
{
print "<option value='$impact'>$impact</option>\n";
}
?>
</select>
<?php
mysql_free_result($result);
?> </td>
<td><input name="heure" type="text" size="10"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Assigné à :</td>
<td><?php include('connection.php'); ?>
<select name='assigne' ><option value='<?php $row["id_assignes"]; ?>'></option>
<?php
$query = "SELECT assigne FROM assignes";
$result = mysql_query ($query) or die ("La requête SQL a échoué !");
while (list($assigne) = mysql_fetch_row($result))
{
print "<option value='$assigne'>$assigne</option>\n";
}
?>
</select>
<?php
mysql_free_result($result);
?></td>
<td>Logger : </td>
<td><?php include('connection.php'); ?>
<select name='logger' ><option value='<?php $row["id_loggers"]; ?>'></option>
<?php
$query = "SELECT logger FROM loggers";
$result = mysql_query ($query) or die ("La requête SQL a échoué !");
while (list($logger) = mysql_fetch_row($result))
{
print "<option value='$logger'>$logger</option>\n";
}
?>
</select>
<?php
mysql_free_result($result);
?></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" value="insérer"></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="6"><div align="center"><a href="modifier_ticket.php" target="_self">Modifier</a> - <a href="supprimer_ticket.php" target="_self">Supprimer</a> - <a href="ajout_ticket.php" target="_self">Insérer</a> </div></td>
</tr>
</table>
</form>
//Script insertion :
<?php
//connection au serveur:
$cnx = mysql_connect( "localhost", "root","" ) ;
//sélection de la base de données:
$db = mysql_select_db( "helpdesk" ) ;
//récupération des valeurs des champs:
//$date = = addslashes($_POST["date"] );
//numero ticket:
$numero = addslashes($_POST["numero"]) ;
//le probleme:
$probleme = addslashes($_POST["probleme"]) ;
//demandeur:
$demandeur = addslashes($_POST["demandeur"] );
//client:
$description = addslashes($_POST["description"]) ;
//client:
$description_long = addslashes($_POST["description_long"]) ;
//client:
$date_fin = addslashes($_POST["date_fin"]) ;
//client:
$priorite = addslashes($_POST["priorite"]) ;
//client:
$impact = addslashes($_POST["impact"]) ;
//client:
$heure = addslashes($_POST["heure"]) ;
//client:
$assigne = addslashes($_POST["assigne"]) ;
//client:
$logger = addslashes($_POST["logger"]) ;
//création de la requête SQL:
$sql = "INSERT INTO demandes (date,numero, probleme, demandeur, description, description_long, date_fin, priorite, impact, heure, assigne, logger)
VALUES ('$date','$numero', '$probleme', '$demandeur', '$description', '$description_long', '$date_fin', '$priorite', '$impact', '$heure', '$assigne', '$logger') " ;
//exécution de la requête SQL:
$requete = mysql_query($sql, $cnx) or die( mysql_error() ) ;
//affichage des résultats, pour savoir si l'insertion a marchée:
if($requete)
{
echo("L'insertion a été correctement effectuée") ;
}
else
{
echo("L'insertion a échouée") ;
}
?>
//Script affiche les records pour modification :
<?php
//connection au serveur:
$cnx = mysql_connect( "localhost", "root", "" ) ;
//sélection de la base de données:
$db = mysql_select_db( "helpdesk" ) ;
//requête SQL:
$sql = "SELECT * FROM demandes ORDER BY id_demande" ;
//exécution de la requête:
$requete = mysql_query( $sql, $cnx ) ;
echo("<table width='300' border='0'>");
//affichage des données:
while( $result = mysql_fetch_object( $requete ) )
{
echo("
<tr>
<td>".$result->numero."</td>
<td>".$result->demandeur."</td>
<td>".$result->client."</td>
<td>".$result->description."</td>
<td>".$result->assigne."</td>
<td>".$result->logger."</td>
<td><a href=\"modification.php?id_demande=".$result->id_demande."\">modifier</a><br></td>
</tr>
");
echo("</table>");}
?>
//script d'affichage pour modif :
<?php
$cnx = mysql_connect( "localhost", "root", "" ) ;
$db = mysql_select_db( "helpdesk" ) ;
$id = $_GET["id_demande"] ;
//requête SQL:
$sql = "SELECT * FROM demandes WHERE id_demande = ".$id ;
//exécution de la requête:
$requete = mysql_query( $sql, $cnx ) ;
//affichage des données:
if( $result = mysql_fetch_object( $requete ) )
{
?>
<form name="insertion" action="insertion.php" method="POST">
<table width="400" border="0">
<tr>
<td width="79"> </td>
<td width="76"> </td>
<td >N°de ticket :</td>
<td align="right"><?php
$date = date("d-m-Y");
echo ("$date");
?></td>
<td align="left"><input name="numero" type="text" value="<?php echo($result->numero) ;?>" size="2" /></td>
</tr>
<tr>
<td>Problème :</td>
<td width="76"><?php include('connection.php'); ?>
<select name='probleme' ><option value='<?php echo($result->probleme) ;?>'></option>
<?php
$query = "SELECT probleme FROM problemes";
$result = mysql_query ($query) or die ("La requête SQL a échoué !");
while (list($probleme) = mysql_fetch_row($result))
{
print "<option value='$probleme'>$probleme</option>\n";
}
?>
</select>
<?php
mysql_free_result($result);
?> </td>
<td width="68"></td>
<td width="70"></td>
<td width="40"></td>
</tr>
<tr>
<td>Demandeur : </td>
<td><?php include('connection.php'); ?>
<select name='demandeur' ><option value='<?php echo($result->demandeur) ;?>'></option>
<?php
$query = "SELECT demandeur FROM demandeurs";
$result = mysql_query ($query) or die ("La requête SQL a échoué !");
while (list($demandeur) = mysql_fetch_row($result))
{
print "<option value='$demandeur'>$demandeur</option>\n";
}
?>
</select>
<?php
mysql_free_result($result);
?> </td>
<td>Client :</td>
<td><?php include('connection.php'); ?>
<select name='client' ><option value='<?php $row["id_clients"]; ?>'></option>
<?php
$query = "SELECT client FROM clients";
$result = mysql_query ($query) or die ("La requête SQL a échoué !");
while (list($client) = mysql_fetch_row($result))
{
print "<option value='$client'>$client</option>\n";
}
?>
</select>
<?php
mysql_free_result($result);
?> </td>
<td> </td>
<td width="41"> </td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Description :</td>
<td colspan="5"><input name="description" type="text" value="<?php echo($result->description) ;?>" size="40"></td>
</tr>
<tr>
<td>Description : </td>
<td colspan="5" rowspan="2"><textarea name="description_long" cols="35" rows="10" value="<?php echo($result->description_long) ;?>"></textarea></td>
</tr>
<tr>
<td height="114"> </td>
</tr>
<tr>
</tr>
<tr>
<td>Date de fin :</td>
<td>Priorité :</td>
<td>Impact</td>
<td>Heure :</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><input name="date_fin" type="text" size="10" value="<?php echo($result->date_fin) ;?>"></td>
<td><?php include('connection.php'); ?>
<select name='priorite' ><option value='<?php $row["id_priorites"]; ?>'></option>
<?php
$query = "SELECT priorite FROM priorites";
$result = mysql_query ($query) or die ("La requête SQL a échoué !");
while (list($priorite) = mysql_fetch_row($result))
{
print "<option value='$priorite'>$priorite</option>\n";
}
?>
</select>
<?php
mysql_free_result($result);
?></td>
<td><?php include('connection.php'); ?>
<select name='impact' ><option value='<?php $row["id_impacts"]; ?>'></option>
<?php
$query = "SELECT impact FROM impacts";
$result = mysql_query ($query) or die ("La requête SQL a échoué !");
while (list($impact) = mysql_fetch_row($result))
{
print "<option value='$impact'>$impact</option>\n";
}
?>
</select>
<?php
mysql_free_result($result);
?> </td>
<td><input name="heure" type="text" size="10" value="<?php echo($result->heure) ;?>"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Assigné à :</td>
<td><?php include('connection.php'); ?>
<select name='assigne' ><option value='<?php $row["id_assignes"]; ?>'></option>
<?php
$query = "SELECT assigne FROM assignes";
$result = mysql_query ($query) or die ("La requête SQL a échoué !");
while (list($assigne) = mysql_fetch_row($result))
{
print "<option value='$assigne'>$assigne</option>\n";
}
?>
</select>
<?php
mysql_free_result($result);
?></td>
<td>Logger : </td>
<td><?php include('connection.php'); ?>
<select name='logger' ><option value='<?php $row["id_loggers"]; ?>'></option>
<?php
$query = "SELECT logger FROM loggers";
$result = mysql_query ($query) or die ("La requête SQL a échoué !");
while (list($logger) = mysql_fetch_row($result))
{
print "<option value='$logger'>$logger</option>\n";
}
?>
</select>
<?php
mysql_free_result($result);
?></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" value="insérer"></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
</table>
</form>
<?php
}//fin if
?>
Bàv,
Burnside.
..:: Enjoy living in hell ::..
