1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| class Database
{
private $dbh;
public function __contruct($login, $database_name , $password, $host = 'localhost')
{
$this->dbh = new PDO("mysql:host=$host;dbname=$database_name", $login, $password);
$this->dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$this->dbh->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);
$this->dbh->query("SET CHARACTER SET utf8");
}
public function query($sql, $params)
{
$stmt = $this->dbh->prepare($sql); // il me dit une erreur ici...
$stmt->execute($params);
return $stmt;
}
} |
Partager