1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
| class DB{
private $host = 'localhost';
private $username = 'root';
private $password = 'password';
private $database = 'dashboard';
private $db;
public function __construct($host = null, $username = null, $password = null, $database =null ){
if($host != null){
$this ->host = $host;
$this ->username = $username;
$this ->password = $password;
$this ->database = $database;
}
try{
$this->db = 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_WARNING));
}catch(PDOException $e){
die('<h1>Erreur connexion BDD </h1>');
}
}
public function query($sql){
$req = $this->db->prepare($sql);
$req->execute();
return $req->fetchAll();
}
} |
