View original (French)

Erreur : SQLSTATE[42000] : Erreur de syntaxe ou violation d'accès : 1064 Vous avez une err

Solved
modemo2018 Posted messages 254 Status Member -  
Reivax962 Posted messages 3742 Status Member -
Bonjour, je suis en train d'approfondir le PHP PDO. Quand j'essaie de lire les données, il me renvoie cette erreur

Erreur : 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 ' class = 'CM2 '' at line 1

Voici le code PHP 

 //début de ton fichier php .... ça veut dire .. DEBUT !!!: error_reporting ( E_ALL ); ini_set ( 'display_errors', TRUE ); ini_set ( 'display_startup_errors', TRUE ); $class = !empty ( $_GET['class'] ) ? $_GET['class'] : NULL; $cycle = !empty ( $_GET['cycle'] ) ? $_GET['cycle'] : NULL; $iduser = !empty ( $_SESSION['id'] ) ? $_SESSION['id'] : NULL; try { $req = $bdd->prepare('SELECT nom, prenom FROM eleve WHERE iduser = :iduser, class = :class '); $req->execute(array('iduser' => $iduser, 'class' => $class )); //Somme des élèves de la classe } catch(Exception $e) { die('Erreur : '.$e->getMessage()); }


Quelqu'un peut-il m'aider à résoudre cette erreur ?

1 answer

Answer 1 / 1
Reivax962 Posted messages 3742 Status Member 1 011
 
Hello,

In the WHERE clause, fields are not separated by commas as in a SELECT or UPDATE, but with logical operators like AND, OR, etc.

Xavier
0
modemo2018 Posted messages 254 Status Member 2
 
Here is a part of my program code that works well, the fields are separated by commas:


< basic code>
try {
$req = $bdd->prepare ( $sql );
$req->execute();
$result = $req->fetchColumn ();
$id = $result + 1;
$sql = 'INSERT INTO matiere(nomat, coefficient, `class`, `cycle`, `serie`, idmat, iduser)
VALUES(:nomat, :coefficient, :class, :cycle, :serie, :idmat, :iduser)';
$datas = array(':nomat' => $nomat, ':coefficient' => $coef, ':class' => $class, ':cycle' => $cycle, ':serie' => $serie, ':idmat' => $id, ':iduser' => $iduser);
try {
$req = $bdd->prepare ( $sql );
if ( $req->execute ( $datas ) ) {

}

< /code>
0
Reivax962 Posted messages 3742 Status Member 1 011
 
Yes, but this is not a WHERE clause, it's an INSERT clause... In which we list fields, then we list values.
Whereas in fact, a WHERE clause represents not a list of fields, but a calculation of conditions.
0