require("../../init.php");
$id_transmis=$_POST['id_transmis'];
$ident_bout=$_POST['ident_bout'];
$page_appelante=$_POST['page_appelante'];
$type=$_POST['type'];
$date=$_POST['date'];
$mission=$_POST['mission'];
$origine=$_POST['origine'];
$reference=$_POST['reference'];
$etat=$_POST['etat'];
$caracteristique=$_POST['caracteristique'];
$etat=$_POST['etat'];
if ($ident_bout=="suppr"){
mysql_query("delete from $sql_tble_mat where id = '$id_transmis'")
or die ("La requête delete a échoué");
}
elseif ($ident_bout=="enreg")
{
$tab = explode("/",$date);
$jour = $tab[0];
$mois = $tab[1];
$an = $tab[2];
$date=$an."-".$mois."-".$jour;
$modif= "UPDATE $sql_tble_mat SET
reference= '$reference',
caracteristique= '$caracteristique',
origine= '$origine',
localisation= '$etat',
date= '$date',
mission= '$mission',
date_maj = curdate()
where id ='$id_transmis'";
mysql_query("$modif")
or die ("la requete modif des champs a échouée");
}
// on ferme la connexion à mysql
mysql_close();
header("Location: liste.php?type=$type&page_appelante=$page_appelante");
?>