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
| <?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($htis->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 < cout ($fields); $i++) {
if ((strpos($fields[$i], "(") ===false) && ($fields[$i] != "*")) $fields[$i] = "`".$fields[$i]."`";
}
$fields = implode(",",$fields); /*ФУНКЦИЯ КОТОРАЯ ПРЕВРАЩАЕТ МАССИВ В СТРОКУ*/
$table_name = $htis->config->db_prefix.$table_name;
if (!$order) $order = "ORDER BY `id`"; /*если ордер не задан создает сами и формируем по 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 = $htis->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); /* убирает знак -1,запетая которпая указывается в строке выше*/
$query .= ") VALUES (";
foreach ($new_values as $value) $query .= "'".addslashes(values)."',";
$query = substr($query, 0, -1);
$query .= ")";
return $this->query($query);
}
/*функция для обновления даных*/
private function update($table_name, $update, $where) {
$table_name = $this->config->db_prefix.$table_name;
$query = "UPDATE $table_name SET";
foreach ($upd_fields as $field => $value) $query .= "`$field` = '".addslashes(values)."',";
$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->existsID($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`='".addslashes($value)."'", $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 (!$htis->existsID($table_name, $id)) return false;
return $this->delete($table_name, "`id` = '$id'");
}
public function setField($table_name, $field, $value, $field_in, $value) {
return $this->update($table_name, array($field=> $value), "`field_in` = '".addslashes($value_in)."'");
}
public function setFieldOnID($table_name, $id, $field, $value) {
if (!$htis->existsID($table_name, $id)) return false;
return $this->setField($table_name, $field, $value, "id", $id );
}
/*возвращает всю запись целяком*/
public function getElementOnID($table_name, $id) {
if (!$htis->existsID($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)."'");
if (count($data) === 0) return false;
return true;
}
public function existsID ($table_name, $id) {
if (!$this-> valid->validID($id)) return false;
$data= $this->select($table_name,array("id"), "`id` ='".addslashes($id)."'");
if (count($data) ===0) return false;
return true;
}
public function __destruct($table_name, $field, $value) {
if ($this->mysqli) $this->mysqli->close();
}/*151*/
}
?> |
(
Сообщение от Serezha
