-
Notifications
You must be signed in to change notification settings - Fork 0
/
query.php
72 lines (68 loc) · 1.64 KB
/
query.php
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
<?php
require 'classe_db.php';
class query extends connexion
{
public $result;
protected $conx;
public $num_rows;
//conection to database
private function protect()
{
# code...
$this->conx=$this->connexion1("your host","user","password","database name");
}
public function execute_requet($query)
{
$this->protect();
$this->verife($query);
return $this->result;
}
private function verife($requet)
{
$splited_query=explode(" ", $requet);
$type_query=strtoupper($splited_query[0]);
switch ($type_query) {
case "SELECT":
$this->select_query($requet);
//echo $requet."**";
break;
case 'INSERT':
$this->insert_query($requet);
break;
case 'DELETE':
$this->delete_query($requet);
break;
case "UPDATE":
$this->update_query($requet);
break;
default:
echo "erreur dans la requet";
break;
}
}
private function select_query($query)
{
$res=mysqli_query($this->result_con, $query)or die(mysqli_error($this->result_con));
$this->num_rows=mysqli_num_rows($res);
//echo $this->num_rows;
while ($ligne=mysqli_fetch_assoc($res)) {
$tableau[]=$ligne;
}
$this->result=$tableau;
}
private function insert_query($query)
{
# code...
mysqli_query($this->result_con, $query)or die(mysqli_error($this->result_con));
}
private function delete_query($query)
{
# code...
mysqli_query($this->result_con, $query)or die(mysqli_error($result_con));
}
private function update_query($query)
{
# code...
mysqli_query($this->result_con, $query)or die(mysqli_error($result_con));
}
}