<?php
class Database
{
private $db_host = 'localhost';
private $db_name = 'boom';
private $db_port = 3309;
private $db_charset = 'utf8';
private $db_user = 'root';
private $db_password = '';
private $dsn;
private $pdo;
private $error;
public function __construct()
{
$this->dsn = "mysql:host={$this->db_host};dbname={$this->db_name};port={$this->db_port};charset={$this->db_charset}";
try {
$this->pdo = new PDO($this->dsn, $this->db_user, $this->db_password);
$this->pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
echo $this->error = 'Erreur: ' . $e->getMessage();
}
}
public function prepare(String $stmt, Array $fields = []) {
$req = $this->pdo->prepare($stmt);
var_dump($fields);
$req->execute($fields);
return $req;
}
public function is_already_in_use(String $field, String $value, String $table):bool
{
$req = $this->pdo->prepare("SELECT id FROM $table WHERE $field = ?");
$req->execute([$value]);
$count = $req->rowCount();
$req->closeCursor();
return $count;
}
}
Image de la table users
Et enfin le message que j'ai quand je lance le formulaire :
Fatal error: Uncaught PDOException: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined in D:\serveur\www\boom\class\Database.php:29 Stack trace: #0 D:\serveur\www\boom\class\Database.php(29): PDOStatement->execute(Array) #1 D:\serveur\www\boom\profile.php(46): Database->prepare('UPDATE users\r\n ...', Array) #2 {main} thrown in D:\serveur\www\boom\class\Database.php on line 29
J'ai beau retourné le problème dans tous les sens, je ne trouve pas l'erreur que j'ai pu faire.
Si vous avez une idée ?
Cordialement
A voir également:
Uncaught pdoexception: sqlstate[hy093]: invalid parameter number: parameter was not defined
