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
|
try{
$chaine_connexion='mysql:host=localhost;dbname=images_site';
$utilisation_UFT8=array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8");
$connexion_bdd = new PDO($chaine_connexion, 'root', '', $utilisation_UFT8);
$connexion_bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch(PDOException $e){
$msg = 'ERREUR PDO dans ' . $e->getFile() . ' L.' . $e->getLine() . ' : ' . $e->getMessage();
die($msg);
}
$photoId = intval($_POST['photoId']);
$photo_query = 'SELECT * FROM liste_image WHERE id_photo = :photoId';
$requete3 = $connexion_bdd ->prepare($photo_query);
$requete3->execute();
foreach($requete3->fetchAll() as $donnee)
{
$taille=$donnee['taille'];
$numero=$donnee['numero'];
$nom_image=$donnee['intitule'];
$description_image=$donnee['description'];
}
$requete3 -> closeCursor();
$requete3 = NULL; |