1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53
|
function mise_a_jour (){
if (isset( $_POST['ajour'])){
if ($_POST['action']=="nouveau")
return nouveau();
if ($_POST['action']=="modifier")
return modifier();
if ($_POST['action']=="supprimer")
return supprimer();
}
}
function nouveau () {
$route="44 ".$_POST['route']."".$_POST['num_route']."";
$prabs ="44 ".$_POST['route']."".$_POST['num_route']."".$_POST['pr']."".$_POST['distance_pr']."";
$date = date_angl($_POST['date']);
$query = "INSERT INTO accident
(`id`,`id_user` ,`id_route` , `id_prabs` , `commune` , `date` ,
`heure` , `route` , `num_route` , `pr` , `distance_pr` ,
`agglo_camp` , `etat` , `type` , `gravite` , `observation` )
VALUES ( '' ,
'".$_SESSION['id_user']."',
'".$route."',
'".$prabs."',
'".$_POST['commune']."',
'".$date."',
'".$_POST['heure']."',
'".$_POST['route']."',
'".$_POST['num_route']."',
'".$_POST['pr']."',
'".$_POST['distance_pr']."',
'".$_POST['agglo_camp']."',
'".$_POST['etat']."',
'".$_POST['type']."',
'".$_POST['gravite']."',
'".$_POST['observation']."' );" ;
$res = mysql_query($query) or die($query . " - " . mysql_error());
return $res;
}
//Main
connexion ();
$succes = mise_a_jour();
//deconnexion();
// enregistre la requete a executé dans la variable de session req
$_SESSION["req"]=selection();
deconnexion(); |
Partager