PDO Class

<?php

namespace Fastbooking;

use \PDO;

/**
 * @Class Database
 * Database Connexion
 */
class Database{

    /*
     * @var Database connexion params
     */
    private $db_name;

    private $db_user;

    private $db_pass;

    private $db_host;

    private $pdo;

    public function __construct($db_name, $db_user = 'root', $db_pass = 'root', $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=hdlsites;host=localhost', 'nclavilier', 'kWeNUu1e4SsHaoHV');

            $pdo->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

            $this->pdo = $pdo;

        }

        return $pdo;

    }

    public function query($statement){

        $req = $this->getPDO()->query($statement);

        $datas = $req->fetchAll(PDO::FETCH_ASSOC);

        return $datas;

    }

    public function insert($statement, $array = array()){

        $req = $this->getPDO()->prepare($statement);

        if($req->execute($array)){
            return true;
        } else{
            return false;
        }

    }
}




?>