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 69 70 71
| $response = $bdd->prepare( 'INSERT INTO `biens` (
`Code_Bien`,
`Agence`,
`Type_Vente`,
`Type_Bien`,
`Date_Fiks`,
`Date_Immoweb`,
`Date_Expiration`,
`Actif`,
`Etat`,
`Certif_PEB`,
`Photos`,
`Plan`,
`PDF_Plan`,
`Modif_Plan`,
`Fichier_Plan`,
`Date_Reception`,
`Date_Creation`,
`Date_Envoie`,
`Date_Corrections`,
`Date_Publication`,
`Remarques`
) VALUES (
:Code_bien,
:Agence,
:Type_Vente,
:Type_Bien,
:Date_Fiks,
:Date_Immoweb,
:Date_Expiration,
:Actif,
:Etat,
:Certif_PEB,
:Photos,
:Plan,
:PDF_Plan,
:Modif_Plan,
:Fichier_Plan,
:Date_Reception,
:Date_Creation,
:Date_Envoie,
:Date_Corrections,
:Date_Publication,
:Remarques
);' );
$response->execute( array(
':Code_Bien'=>$_POST['codebien'],
':Agence'=> $_POST['agence'],
':Type_Vente'=>$_POST['typevente'],
':Type_Bien'=>$_POST['typebien'],
':Date_fiks'=>$_POST['datefiks'],
':Date_Immoweb'=>$_POST['dateimmo'],
':Date_Expiration'=>$_POST['dateexpir'],
':Actif'=>$_POST['actif'],
':Etat'=>$_POST['etat'],
':Certif_PEB'=>$_POST['certifpeb'],
':Photos'=>$_POST['photo'],
':Plan'=>$_POST['plan'],
':PDF_Plan'=>$_POST['newpdf'],
':Modif_Plan'=>$_POST['modif'],
':Fichier_Plan'=>$_POST['fichier'],
':Date_Reception'=>$_POST['reception'],
':Date_Creation'=>$_POST['creation'],
':Date_Envoie'=>$_POST['dateagence'],
':Date_Corrections'=>$_POST['correction'],
':Date_Publication'=>$_POST['publication'],
':Remarques'=>$_POST['remarque']
) ); |
Partager