Probleme de condition dans un EACH

PDO::PARAM_INT); $req->bindParam(':RefBdc', $Valeur, PDO::PARAM_STR); break; case 2: // dans le cas où $cas vaut 2 $req = $PDO->prepare('SELECT * FROM BonCommande LEFT JOIN agence ON boncommande.IdAgence

2
Erreur dans TP Création des classes Table

pdo === null ){ $pdo = new PDO('mysql:dbname=blog;host=localhost;charset=utf8','root',''); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $this->pdo = $pdo; } return $pdo; } public function query($statement

3
vérification if qui loupe au premier tours

PDO($dbdns1,$dbuser1 , $dbpass1, array( PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); $DBPDO-> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); try{ /////////recherche des avions la table traker_cil__aircraft

1
SQL State access violation

PDO; use \PDOException; class Crud { protected $pdo; public function __construct() { try{ $this->pdo = new PDO('mysql:host=blog;dbname=blog;port=3307;charset=utf8', 'root', '', [ PDO::ATTR_ERRMODE => PDO::ERRMODE

6
Fatal error: Call to a member function execute()

pdo = new PDO('mysql:host='.$this->host.';dbname='.$this->database, $this->username, $this->password, array( PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES UTF8', PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION, PDO

3
Pagination réorganisation

pdo; private $perPage; public function __construct(string $query, string $queryCount, string $classMapping, ?\PDO $pdo = null, int $perPage = 12) { $this->query = $query; $this->queryCount = $queryCount; $this->classMapping = $classMapping; $this->pdo = $pdo

10
problème de UPDATE MYSQL

pdo= new PDO('mysql:dbname=identifiantsclients;host=localhost','root',""); $pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION); $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE,PDO::FETCH_OBJ); $adresse_mail=htmlspecialchars

8
Problème affichage d’erreur "Identifiant ou mot de passe incorrecte"

pdo = new PDO('mysql:dbname=**************************;host=***************', '********', '***'); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ); ``` functions.php : ```

5
Problème avec le tutoriel POO en PHP "Création des classes tables"

pdo === null) { $pdo = new PDO('mysql:dbname=' . $this->db_name . ';host=' . $this->db_host . '', $this->db_user, $this->db_pass); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $this->pdo

4
Quoi envoyer au classe "Sql"

pdo->prepare($query); $prep->bindParam(':id', $objet->getId(), PDO::PARAM_INT); $prep->bindParam(':monChamp', $objet->getMonChamp(), PDO::PARAM_STR); try { $prep->execute(); return $this->pdo->lastInsertId(); } catch (PDOException $e) { conn

17