Comme je t'es dit , j'ai fait un test pour savoir si c'est un ajout ou une modif?
Je te file le code source des 2 pages.J'espère que ca pourra t'aider à mieux comprendre mon bordèle!!!
Ajout_micro.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=ISO-8859-1" http-equiv="content-type">
<link rel="stylesheet" media="screen" type="text/css"
title="repertoire"
href="http://localhost/intranet/css/formulaire2.css">
</head>
<body>
<? $chemin="http://localhost/intranet/"?>
<? mysql_connect("localhost","root","");
mysql_selectdb("intranet");
if (isset($_GET['modif_micro']))
{
$dspmic=mysql_query('SELECT * FROM parc_micro WHERE id='.$_GET['modif_micro']);
$donnees=mysql_fetch_array($dspmic);
$Nom=$donnees['Nom'];
$User=$donnees['User'];
$Etat=$donnees['Etat'];
$Service=$donnees['Service'];
$Bureau=$donnees['Bureau'];
$P_D_S=$donnees['P_D_S'];
$mP=$donnees['mP'];
$id_micro=$donnees['id'];
}
else
{
$Nom='';
$User='';
$Etat='';
$Service='';
$Bureau='';
$P_D_S='';
$mP='';
$id_micro=0;
}
function choixParDefaut($Service) {
$par_defaut ='';
if (isset($_POST['Service']))
{
if ($_POST['Service'] == $Service)
{
$par_defaut='selected="selected"';
}
}
return $par_defaut;
}
?>
<form Method="post" action="http://localhost/intranet/micro/modif_micro.php">
<table>
<tr>
<td>
<fieldset>
<legend>Identification</legend>
<label>Nom micro : <input type="text" name="Nom" value="<?echo $Nom;?>"/></label><br/>
<label>User : <input type="text" name="User" value="<?echo $User;?>"/></label><br/>
<label>N° de Série : <input type="text" name="Serie" value="<?echo $Serie;?>"/></label><br/>
</fieldset>
</td>
<td>
<fieldset>
<legend>Situation Géographique</legend>
<select name="Service">
<option
value="direction_generale" <?php echo
choixParDefaut('direction_generale'); ?>>Direction
Générale</option>
<option
value="direction_commerciale" <?php echo
choixParDefaut('direction_commerciale'); ?>>Direction commerciale
</option>
<option
value="direction_technique" <?php echo
choixParDefaut('direction_technique'); ?>>Direction technique
</option>
<option
value="equipe_systeme" <?php echo choixParDefaut('equipe_systeme');
?>> Equipe système </option>
<option
value="production_kheops" selected="selected"<?//php echo
choixParDefaut('production_kheops'); ?>>Production
Kheops</option>
<option
value="production_amasis_court_terme" <?php echo
choixParDefaut('production_amasis_court_terme'); ?>>Production
Amasis court-terme</option>
<option
value="production_amasis_long_terme" <?php echo
choixParDefaut('production_amasis_long_terme'); ?>>Production
Amasis long-terme </option>
<option
value="production_canopes" <?php echo
choixParDefaut('production_canopes'); ?>>Production Canopes
</option>
<option
value="production_ramses" <?php echo
choixParDefaut('production_ramses'); ?>>Production Ramses
</option>
<option
value="service_commercial" <?php echo
choixParDefaut('service_commercial'); ?>>Service
Commercial</option>
<option value="secretaire"
<?php echo choixParDefaut('secretaire'); ?>>Secrétariat
</option>
</select>
<label>Bureau : <input type="text" name="Bureau" value="<?echo $Bureau;?>"/></label><br/>
</fieldset>
</td>
</tr>
<tr>
<td>
<fieldset>
<legend>Type d'equipement<legend>
<label>pds :<input type="text" name="P_D_S" value="<?echo $P_D_S;?>"/></label><br/>
</fieldset>
</td>
</tr>
<tr>
<td>
<fieldset>
<legend>Puissance</legend>
<label>Processeur : <input type="text" name="mP" value="<?echo $mP;?>"/></label><br/>
</fieldset>
</td>
<td>
<fieldset>
<legend>Etat</legend>
<label>etat :<input type="text" name="Etat" value="<?echo $Etat;?>"/></label><br/>
</fieldset>
</td>
</tr>
<tr>
<input type="hidden" name="id_micro" value="<? echo $id_micro;?>"/>
<input type="submit" value="Ajouter"/>
</table>
</form>
<p><? echo '<a href='.$chemin.'micro/parc.php>';?>Revenir au parc</a></p>
</body>
</html>
Modif_micro.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=ISO-8859-1" http-equiv="content-type">
</head>
<body>
<? $chemin="http://localhost/intranet/"?>
<?
mysql_connect("localhost", "root", "");
mysql_select_db("intranet");
if (isset($_POST['Nom']) and isset($_POST['User']) and
isset($_POST['Etat']) and isset($_POST['Service']) and
isset($_POST['Bureau']) and isset($_POST['P_D_S']) and
isset($_POST['mP']) )
{
if ($_POST['id_micro']== 0)
{
mysql_query("INSERT into parc_micro
values('".$_POST['Nom']."','".$_POST['User']."','".$_POST['Etat']."','".$_POST['Service']."','".$_POST['Bureau']."','".$_POST['P_D_S']."','".$_POST['mP']."','')");
}
else
{
mysql_query("UPDATE parc_micro set Nom='" . $_POST['Nom']."' , User='"
. $_POST['User'] . "' ,Etat='".$_POST['Etat'] ."' ,
Service='".$_POST['Service']."'
,Bureau='".$_POST['Bureau']."',P_D_S='".$_POST['P_D_S']."',mP='".$_POST['mP']."'
WHERE id=" . $_POST['id_micro']);
}
}
if (isset($_GET['suppr_micro']))
{
mysql_query('DELETE FROM parc_micro WHERE id='.$_GET['suppr_micro']);
}
?>
<table><tr>
<th>Supprimer</th>
<th>Micro</th>
</tr>
<?
$dspmic = mysql_query('SELECT * FROM parc_micro ORDER BY Nom DESC');
while ($donnees = mysql_fetch_array($dspmic))
{
?>
<tr>
<td><? echo '<a
href='.$chemin.'micro/modif_micro.php?suppr_micro=' . $donnees['id'] .
'>'; ?>Supprimer</a></td>
<td><? echo ($donnees['Nom']); ?></td>
</tr>
<?
}
?>
</table>
<? echo '<a href='.$chemin.'micro/parc.php>';?>revenir</a>
</body>
</html>