<?php
class DA
{
    private static $instance = null;
    private $dbh;

    private function __construct(){
        try{
            $server = "172.0.0.1";
            $username = "localhost";
            $password = "root";
            $database = "frituur";
            $this->dbh = new PDO("mysql:host=$server; dbname=$database", $username, $password);
            $this->dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        }
        catch (PDOException $e){
            die($e->getMessage());
        }
    }

    public static function getInstance()
    {
        if(is_null(self::$instance)){
            self::$instance = new DA();
        }
        return self::$instance;
    }

    public function sluitDB()
    {
        $dbh = null;
    }

    public function geefAlleWerknemers()
    {
        try
        {
            $sql = "SELECT * FROM werknemers";
            $stmt = $this->dbh->prepare($sql);
            $stmt->execute();
            $werknemerstabel = $stmt->fetchAll(PDO::FETCH_CLASS);
        }
        catch (PDOException $e)
        {
            die($e->getMessage());
        }

        return $werknemerstabel;
    }


}
?>