Mammouth du PHP |
643 Messages
02 févr. 2017, 16:56
Oups,
En fait ca correspond à ma requete à savoir :
// Insertion
$req = $bdd->prepare("INSERT INTO `loisirs` (id_simply_user,titre,url_rewrite,price,photo,url_fnac,date_debut_sortie,date_fin_sortie,description,street,postcode,city,id_region,id_departements,id_type_loisirs,number,manufacturer,valide) VALUES ('$id_simply_user','$titre','$url_convertis','$price','$photo','$url_fnac','$date_debut_sortie', '$date_fin_sortie', '$description','$street','$postcode','$city','$region','$departement','$id_type_loisirs','$number','$manufacturer','$valide')");
$req->execute(array(
'id_simply_user'=>$id_simply_user,
'titre'=>$titre,
'url_rewrite'=>$url_convertis,
'price'=>$price,
'photo'=>$photo,
'url_fnac' => $url_fnac,
'date_debut_sortie' => $date_debut_sortie,
'date_fin_sortie' => $date_fin_sortie,
'description' => $description,
'street' => $street,
'postcode'=>$postcode,
'city'=>$city,
'id_region'=>$region,
'id_departements'=>$departement,
'id_type_loisirs'=>$id_type_loisirs,
'number'=>$number,
'manufacturer'=>$manufacturer,
'valide'=>$valide
)) or die('Problème lors de l\'insertion');
}