<?php

include_once '../include/DBConnect.php';

var_dump($dbh);

class Users {

    private $db;
    private $self;

    public function __construct($database) {
        $this->db = $database;
        $this->self = $this;
        var_dump($this->self);
        /* PDO::ATTR_AUTOCOMMIT
          PDO::ATTR_CASE
          PDO::ATTR_CLIENT_VERSION
          PDO::ATTR_CONNECTION_STATUS
          PDO::ATTR_DRIVER_NAME
          PDO::ATTR_ERRMODE
          PDO::ATTR_ORACLE_NULLS
          PDO::ATTR_PERSISTENT
          PDO::ATTR_PREFETCH
          PDO::ATTR_SERVER_INFO
          PDO::ATTR_SERVER_VERSION
          PDO::ATTR_TIMEOUT */
        echo $this->db->getAttribute(PDO::ATTR_AUTOCOMMIT).'</br>';
        echo $this->db->getAttribute(PDO::ATTR_CASE).'</br>';
        echo $this->db->getAttribute(PDO::ATTR_CLIENT_VERSION).'</br>';
        echo $this->db->getAttribute(PDO::ATTR_CONNECTION_STATUS).'</br>';
        echo $this->db->getAttribute(PDO::ATTR_DRIVER_NAME).'</br>';
        echo $this->db->getAttribute(PDO::ATTR_ERRMODE).'</br>';
        echo $this->db->getAttribute(PDO::ATTR_ORACLE_NULLS).'</br>';
        echo $this->db->getAttribute(PDO::ATTR_PERSISTENT).'</br>';
        //echo $this->db->getAttribute(PDO::ATTR_PREFETCH);
        echo $this->db->getAttribute(PDO::ATTR_SERVER_VERSION).'</br>';
        echo $this->db->getAttribute(PDO::ATTR_SERVER_INFO).'</br>';
        //echo $this->db->getAttribute(PDO::ATTR_TIMEOUT).'</br>';
        
    }

    public function selectData($data) {
        $query = $this->db->prepare("SELECT * FROM `staff` WHERE `root_id` = '$data' AND `actived`= 1 and `deleted`=0");
        $query->execute();
        $result = $query->fetchAll(PDO::FETCH_ASSOC);
        var_dump($result);
        return $result;
    }
    
    public function selectAssistant($data){
        $this->self->selectData($data);
    }

}

$user = new Users($dbh);
$selectionResult = $user->selectAssistant(1);
//var_dump($selectionResult);
?>