if($host != null){
                    $this->host=$host;
                    $this->username=$username;
                    $this->password=$password;
                    $this->database=$datababe;
            }
            try{
           $this->bd=new PDO('mysql:host='.$this->host.';dbname='.$this->database,$this->username,$this->password, 
           array(
                PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
                PDO::ATTR_ERRMODE=>PDO::ERRMODE_WARNING
                )); 
            }catch(PDOException $e){
                    die('Un problème est survenue lors de la connexion à la base de données! Contactez l\'équipe technique Dowhile ou redemarrer le serveur');
            }
    } 
 
    public function query($sql,$data=array()){
        $article=$this->bd->prepare($sql);
        $article->execute($data);
        return $article->fetchAll(PDO::FETCH_OBJ);
        $article->closeCursor();
 
    }
    public function insert($sql,$data=array()){
        $article=$this->bd->prepare($sql);
        $article->execute($data);
        return $article;
        $article->closeCursor();
    }
    
    public function row($sql,$data=array()){
        $article=$this->bd->prepare($sql);
        $article->execute($data);
        $totale=$article->rowCount();
        return $totale;
        $article->closeCursor();
 
    }
 

                        </div>
                        <?php endif ?>
 
                        <?php endif ?>
 
                        <div class="course-info d-flex justify-content-between align-items-center">
                            <h5 class="text-dark">Quartier </h5>
                            <?php 
              $number=$DB->row('SELECT * FROM quartier WHERE id_quartier=:id',array('id'=>$selects->quartier));
              if($number > 0):
              $quartier=$DB->query('SELECT * FROM quartier WHERE id_quartier=:id',array('id'=>$selects->quartier));
                    foreach($quartier as $quartiers):
              ?>
                            <p class="text-dark"><?= $quartiers->nom ?></p>
 
                            <?php endforeach ?>
                            <?php endif ?>
                            <?php 
                            if($number ==0): 
                                $quartier=$DB->query('SELECT * FROM quartier_commune WHERE id_quartier=:id',array('id'=>$selects->quartier));
                                foreach($quartier as $quartiers):
                            ?>
                            <p class="text-dark"><?= $quartiers->nom ?></p>
                            <?php endforeach ?>
                            <?php endif ?>
                        </div>
                        <div class="course-info d-flex justify-content-between align-items-center">
                            <h5 class="text-dark">lieu dit</h5>
                            <p class="text-dark"><?= $selects->lieu ?></p>
                        </div>
                        <?php if($selects->piscine == 'oui'): ?>
                        <div class="course-info d-flex justify-content-between align-items-center">
                            <h5 class="text-dark">Piscine</h5>
                            <p class="text-dark"><?= $selects->piscine ?></p>
                        </div>
                        <?php endif ?>
                        <div class="course-info d-flex justify-content-between align-items-center">
                            <h5 class="text-dark">Parking</h5>
                            <p class="text-dark"><?= $selects->parking ?></p>
                        </div>

<?php 
require dirname(__DIR__).'/vendor/autoload.php';
$whoops= new \Whoops\Run;
$whoops->pushHandler(new \Whoops\Handler\PrettyPageHandler);
$whoops->register();
$uri = $_SERVER['REQUEST_URI'];
$router = new AltoRouter();
require dirname(__DIR__).'/config/routes.php';
// match des routes
$match = $router->match();
if(is_array($match)){
    if(is_callable($match['target']))
    {
    call_user_func_array($match['target'],$match['params']);
    }else{
        $params=$match['params'];
        require "../templates/{$match['target']}.php";
    }   
}else
// page 404 a affichers
{
    require '../templates/404.php';
}