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 54 55 56
| <?
## requête d'update d'un client
$req_update = mysql_query("UPDATE CLIENT SET
nom_cli = '".$_POST['nom']."',
prenom_cli = '".$_POST['prenom']."',
ddn_cli = '".transform_date_to_mysql_date($_POST['datenaissance'])."',
adresse_cli = '".$_POST['adresse']."',
cp_cli = '".$_POST['codepostal']."',
ville_cli = '".$_POST['ville']."',
telfix_cli = '".$_POST['telfixe']."',
telmob_cli = '".$_POST['telmobile']."',
fax_cli = '".$_POST['fax']."',
mail1_cli = '".$_POST['email1']."',
mail2_cli = '".$_POST['email2']."',
observation_cli = '".$_POST['observation']."',
sport1 = '".$_POST['sport1']."',
sport2 = '".$_POST['sport2']."',
sport3 = '".$_POST['sport3']."',
datepret = '".transform_date_to_mysql_date($_POST['datepret'])."',
nom_banque = '".$_POST['nombanque']."',
nom_cons = '".$_POST['nomcons']."',
email_cons = '".$_POST['emailcons']."',
tel_cons = '".$_POST['telcons']."',
fax_cons = '".$_POST['faxcons']."',
num_sit = '".$_POST['sitmat']."',
num_civ = '".$_POST['civilite']."',
num_enf = '".$_POST['enfant']."',
num_csp = '".$_POST['csp']."',
num_fum = '".$_POST['fumeur']."',
num_risqmed = '".$_POST['risquemedical']."',
num_risqspo = '".$_POST['risquesportif']."',
num_tns = '".$_POST['tns']."',
num_pro = '".$_POST['profession']."'
WHERE num_cli = '".$_GET['id_client']."'");
if (empty($_POST['submit']))
{
$result=@mysql_query($req_update) or die(mysql_error());
echo 'Le client a bien été modifié
<a href="index.php">Retour</a>';
}
else
{
echo 'L\'exécution de la requête a échoué.<br>';
echo $req_update;
echo mysql_error().'<br><br>
<a href="index.php">Retour</a>';
}
?> |
Partager