1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| $codesql = "UPDATE Annonce
SET
titre = :titre,
description = :description,
id_user = :id_user,
date = :date,
categorie = :categorie
WHERE id = :id";
try{
$cree = $connexion->prepare($codesql);
$cree->bindValue(':titre', $Titre);
$cree->bindValue(':description', $Description);
$cree->bindValue(':id_user', $id_user);
$cree->bindValue(':date', $date);
$cree->bindValue(':categorie', $Categorie);
$cree->bindValue(':id', $_GET['id']);
$cree->execute();
catch(Exception $e){
echo "Erreur ! " . $e->getMessage() . "<br/>";
} |