Forum d'entraide PHPFrance

Array ( [0] => 00000 ) 1

include '../config/connect.php';
$ID = $_GET['ID'];
$modele = $_POST['MODELE'];
$active = $_POST['ACTIVE'];
$description = $_POST['DESCRIPTION'];
$places = $_POST['PLACES'];
$long = $_POST['LONG'];
$cab = $_POST['CAB'];
$image1 = $_POST['IMAGE1'];
$image2 = $_POST['IMAGE2'];
$image3 = $_POST['IMAGE3'];
$image4 = $_POST['IMAGE4'];
$image5 = $_POST['IMAGE5'];
$image6 = $_POST['IMAGE6'];
$image7 = $_POST['IMAGE7'];
$image8 = $_POST['IMAGE8'];
$image9 = $_POST['IMAGE9'];
$image10 = $_POST['IMAGE10'];

// modifier selon ID
$req = $bdd->prepare('UPDATE voiture SET modele = :modele, active = :active, description = :description, places = :places, long = :long, cab = :cab, image1 = :image1, image2 = :image2, image3 = :image3, image4 = :image4, image5 = :image5 WHERE ID = :ID') or die(print_r($bdd->errorInfo()));
$req->execute(array(
	'ID' => $ID,
	'modele' => $modele,
	'active' => $active,
	'description' => $description,
	'places' => $places,
	'long' => $long,
	'cab' => $cab,
	'image1' => $image1,
	'image2' => $image2,
	'image3' => $image3,
	'image4' => $image4,
	'image5' => $image5
	
	))or die(print_r($bdd->errorInfo()));


echo "<script language='JavaScript'>document.location.href = 'acces.php';
alert('Modification OK ! Reconnexion Obligatoire');
</script>";

on ne vérifie pas erreur de PDO avec des or die, enlève tous ça et fait une vraie gestion : http://php.net/manual/fr/pdo.error-handling.php

Warning: PDOStatement::execute() [pdostatement.execute]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'long = '4', cab = 'aston.jpg', image1 = NULL, image' at line 1 in F:\...\envoi_modif_voiture.php on line 44

c'est l'accent grave