<?php
    /**
     * Database Class - Manager pour les autres classes
     */
    class Database
    {
        const host = 'localhost';
        const dbname = 'food';
        const user = 'root';
        const mdp = '';

        private $_db;

        //Methode de connection à la base de données
        public function getConnection()
        {
            $this->_db = new PDO('mysql:host='.self::host.';dbname='.self::dbname,self::user,self::mdp);
        }
        //Fonction d'hydratation des différentes classes
        public function hydrate($array){
            foreach ($array as $key => $value)
            {
                $method = 'set'.ucfirst($key);
                if (method_exists($this, $method))
                {
                    $this->$method(empty($value) ? null : $value);
                }
            }
        }
        //Methode de requete
        public function PreparedQueryOne($sql,$array){
            $req = $this->_db->prepare($sql);
            $req->execute($array);
        }
    }