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
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
| <?php
require_once "config_class.php";
require_once "checkvalid_class.php";
class DataBase {
private $config;
private $mysqli;
private $valid;
public function __construct() {
$this->config = new Config ();
$this->valid = new CheckValid();
$this->mysqli = new mysqli($this->config->host, $this->config->user, $this->config->password, $this->config->db);
$this->mysqli->query("SET NAMES 'utf8'");
}
private function query($query) {
return $this->mysqli->query($query);
}
private function select($table_name, $fields, $where = "", $order = "", $up = true, $limit = "") {
for ($i = 0; $i < count ($fields); $i++) {
if ((strpos($fields[$i], "(") === false) && ($fields[$i] != "*")) $fields[$i] = "`".$fields[$i]."`";
}
$fields = implode(",",$fields);
$table_name = $this->config->db_prefix.$table_name;
if (!$order) $order = "ORDER BY `id`";
else {
if ($order != "RAND()") {
$order = "ORDER BY `$order`";
if (!up) $order .= " DESC";
}
else $order = "ORDER BY $order";
}
if ($limit) $limit = "LIMIT $limit";
if ($where) $query = "SELECT $fields FROM $table_name WHERE $where $order $limit";
else $query = "SELECT $fields FROM $table_name $order $limit";
$result_set = $this->query($query);
if (!$result_set) return false;
$i = 0;
while ($row = $result_set->fetch_assoc()) {
$data[$i] = $row;
$i++;
}
$result_set->close();
return $data;
}
public function insert ($table_name, $new_values) {
$table_name = $this->config->db_prefix.$table_name;
$query = "INSERT INTO $table_name (";
foreach ($new_values as $field => $value) $query .= "`".$field."`,";
$query = substr($query, 0, -1);
$query /= ") VALUES (";
foreach ($new_values as $value) $query .= "'".addslashes($value)."',";
$query = substr($query, 0, -1);
$query .= ")";
return $this->query($query);
}
private function update($table_name, $upd_fields, $where) {
$table_name = $this->config->db_prefix.$table_name;
$query = "UPDATE $table_name SET";
foreach ($upd_fields as $field => $value) $query .= "`$field` = '".addslashes($value)."',";
$query = substr($query, 0, -1);
if ($where) {
$query .= " WHERE $where";
return $this->query($query);
}
else return false;
}
public function delete($table_name, $where = "") {
$table_name = $this->config->db_prefix.$table_name;
if ($where) {
$query = "DELETE FROM $table_name WHERE $where";
return $this->query($query);
}
else return false;
}
public function deleteAll ($table_name) {
$table_name = $this->config->db_prefix.$table_name;
$query = "TRUNCATE TABLE `$table_name`";
return $this->query($query);
}
public function getField($table_name, $field_out, $field_in, $value_in) {
$data = $this->select($table_name, array($field_out), "`$field_in`='".addslashes($value_in)."'");
if (count($data) != 1) return false;
return $data[0][$field_out];
}
public function getFieldOnID($table_name, $id, $field_out) {
if (!$this->exitsID($table_name, $id)) return false;
return $this->getField($table_name, $field_out, "id", $id);
}
public function getAll($table_name, $order, $up) {
return $this->select($table_name, array("*"), "",$order, $up);
}
public function getAllOnField($table_name, $field, $value, $order, $up) {
return $this->select($table_name, array("*"), "`$field_in`='".addslashes($value_in)."'", $order, $up);
}
public function getLastID($table_name) {
$data = $this->select($table_name, array("MAX (`id`"));
return $data[0]["MAX(`id`)"];
}
public function deleteOnID($table_name, $id) {
if (!$this->exitsID($table_name, $id)) return false;
return $this->delete($table_name, "`id` = '$id'");
}
public function setField($table_name, $field, $value, $field_in, $value_in) {
return $this->update($table_name, array ($field => $value), "`$field_in` = '".addslashes($value_in)."'");
}
public function setFieldOnID($table_name, $id, $field, $value) {
if (!$this->existstID($table_name,$id)) return false;
return $this->setField($table_name, $field, $value, "id", $id);
}
public function getElementOnID($table_name, $id) {
if (!$this->existstID($table_name, $id)) return false;
$arr = $this->select($table_name, array("*"), "`id` = '$id'");
return $arr[0];
}
public function getRandomElements($table_name, $count) {
return $this->select($table_name, array("*"), "", "RAND()",true, $count);
}
public function getCount($table_name) {
$data = $this->select($table_name, array("COUNT(`id`)"));
return $data[0]["COUNT(`id`)"];
}
public function isExists($table_name, $field, $value) {
$data = $this->select($table_name, array("id"), "`$field` = '".addslashes($value_in)."'");
if (count($data) === 0) return false;
return true;
}
private function existsID($table_name, $id) {
if (!$this->valid->validID($id)) return false;
$data = $this->select($table_name, array("id"), "`$field` = '".addslashes($id)."'");
if (count($data) === 0) return false;
return true;
}
public function __destruct() {
if ($this->mysqli) $this->mysqli->close();
}
}
?> |