Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- namespace App;
- use \PDO;
- class Database
- {
- private $db_name;
- private $db_user;
- private $db_pass;
- private $db_host;
- private $pdo;
- public function __construct($db_name, $db_user = 'root', $db_pass = '', $db_host = 'localhost')
- {
- $this->db_name = $db_name;
- $this->db_user = $db_user;
- $this->db_pass = $db_pass;
- $this->db_host = $db_host;
- }
- private function getPDO()
- {
- if($this->pdo === null)
- {
- $pdo = new PDO('mysql:dbname=coursphp;host=localhost', 'root', 'khuM12a58Z');
- $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $this->pdo = $pdo;
- }
- return $pdo;
- }
- public function query($statement, $class_name, $one = false)
- {
- $req = $this->getPDO()->query($statement);
- $req->setFetchMode(PDO::FETCH_CLASS, $class_name);
- if($one)
- {
- $datas = $req->fetch();
- }
- else
- {
- $datas = $req->fetchAll();
- }
- return $datas;
- }
- public function prepare($statement, $attributes, $class_name, $one = false)
- {
- $req = $this->getPDO()->prepare($statement);
- $req->execute($attributes);
- $req->setFetchMode(PDO::FETCH_CLASS, $class_name);
- if($one)
- {
- $datas = $req->fetch();
- } else
- {
- $datas = $req->fetchAll();
- }
- return $datas;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement