<?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 = 'xx', $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){

            //Création de la connexion ä la db
            $pdo = new PDO('mysql:dbname='.$this->db_name.';host='.$this->db_host,$this->db_user,$this->db_pass);


            //Activation des erreurs
            $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

            //$pdo->exec("SET CHARACTER SET utf8");

            $this->pdo = $pdo;

        }
        return $this->pdo;

    }

    public function query($statement){

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

        //Récupération du résultat sous forme d'objet (PDO::FETCH_OBJ)
        $data = $req->fetchAll(PDO::FETCH_OBJ);

        return $data;
    }





}
?>