<?php
class DB{
    private $dbName = 'acupuncture';
    private $pass = 'password';
    private $user = 'W-user';
    private function getDB() {
        $db = null;
        try {
            $db = new PDO('mysql:host=localhost;dbname='.$this->dbName, $this->user, $this->pass,array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
            }
        catch (Exception $e) {
            die('Erreur : ' . $e->getMessage());
            }
        return $db;
    }
    public function requete($sql) {
        $resu = null;
        $db = $this->getDB();
        foreach($db->query($sql) as $row) {
            $resu[] = $row;
        }
        return $resu;
    }
}
?>