1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
$sql = "INSERT INTO client (mdp, mail, prenom, nom, adresse, cp, ville, tel) VALUES ('".$mdp."', '".$mail."', '".$prenom."', '".$nom."', '".$adresse."', '".$cp."', '".$ville."', '".$tel."')";
mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
$id_client = mysql_insert_id();
$sql = "INSERT INTO vehicule (model, aut_model, aut_marque, imma, type, datemes, motor, nrj, preums, km, val, id_client) VALUES ('".$model."', '".$aut_model."', '".$aut_marque."', '".$imma."', '".$type."', '".$datemes."', '".$motor."', '".$nrj."', '".$preums."', '".$km."', '".$val."', '".$id_client."')";
mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
$id_vehicule = mysql_insert_id();
$sql = "INSERT INTO contrat (statut, niv, duree, paiement, date, mtt, id_client, id_vehicule) VALUES ('".$statut."', '".$niv."', '".$duree."', '".$paiement."', '".$date."', '".$mtt."', '".$id_client."', '".$id_vehicule."')";
mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
$id_contrat = mysql_insert_id();
$sql = "UPDATE client SET id_vehicule='".$id_vehicule."', id_contrat='".$id_contrat."' WHERE id='".$id_client."'";
mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
$sql = "UPDATE vehicule SET id_contrat='".$id_contrat."' WHERE id='".$id_vehicule."'";
mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error()); |
Partager