1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
<?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);
?>
|