Newer
Older
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
<?php
/**
* To use this trait, the PHP Object's constructor should have
* $id, $conn, $tabel variables set.
*
* $id - The ID of the MySQL Table Row.
* $conn - The MySQL Connection.
* $table - The MySQL Table Name.
*/
trait SQLGetterSetter {
public function __call($name, $arguments)
{
$property = preg_replace("/[^0-9a-zA-Z]/", "", substr($name, 3));
$property = strtolower(preg_replace('/\B([A-Z])/', '_$1', $property));
if (substr($name, 0, 3) == "get") {
return $this->_get_data($property);
} elseif (substr($name, 0, 3) == "set") {
return $this->_set_data($property, $arguments[0]);
} else {
throw new Exception("Post::__call() -> $name, function unavailable.");
}
}
private function _get_data($var)
{
if ($this->conn) {
$this->conn = Database::getConnection();
}
$sql = "SELECT `$var` FROM `$this->table` WHERE `id` = $this->id";
//print($sql);
$result = $this->conn->query($sql);
if ($result and $result->num_rows == 1) {
//print("Res: ".$result->fetch_assoc()["$var"]);
return $result->fetch_assoc()["$var"];
} else {
return null;
}
}
private function _set_data($var, $data)
{
if (!$this->conn) {
$this->conn = Database::getConnection();
}
$sql = "UPDATE `$this->table` SET `$var`='$data' WHERE `id`=$this->id;";
if ($this->conn->query($sql)) {
return true;
} else {
return false;
}
}
}