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 57 58 59 60 61 62 63 64 65 66 67 68
|
// déclaration de la requête
$base="INSERT INTO partenaire";
$cols="";
$vals="";
$cols .= "nom_partenaire";
$vals .= "'" . $nom . "'";
if ($info != '') {
$cols .= ", info_sup_partenaire";
$vals .= ",'" . $info ."'";
}
if ($adresse != '') {
$cols .= ", adresse_partenaire";
$vals .= ",'" . $adresse ."'";
}
if ($adresse2 != '') {
$cols .= ", adresse2_partenaire";
$vals .= ",'" . $adresse2 ."'";
}
if ($cp != '') {
$cols .= ", cp_partenaire";
$vals .= ",'" . $cp ."'";
}
if ($ville != '') {
$cols .= ", ville_partenaire";
$vals .= ",'" . $ville ."'";
}
if ($tel != '') {
$cols .= ", tel_partenaire";
$vals .= ",'" . $tel ."'";
}
if ($fax != '') {
$cols .= ", fax_partenaire";
$vals .= ",'" . $fax ."'";
}
if ($gsm != '') {
$cols .= ", gsm_partenaire";
$vals .= ",'" . $gsm ."'";
}
if ($email != '') {
$cols .= ", email_partenaire";
$vals .= ",'" . $email ."'";
}
if ($logo2 != '') {
$cols .= ", logo_partenaire";
$vals .= ",'" . $logo2 ."'";
}
if ($web != '') {
$cols .= ", web_partenaire";
$vals .= ",'" . $web ."'";
}
$cols .= ", id_categorie";
$vals .= ",'" . $categorie ."'";
$requete = $base . "(" . $cols .") VALUES (" . $vals . ")"; |
Partager