-
Notifications
You must be signed in to change notification settings - Fork 0
/
lib.php
102 lines (80 loc) · 2.13 KB
/
lib.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
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
<?php
class ConectorBD
{
private $host;
private $user;
private $password;
private $conexion;
function __construct($host, $user, $password){
$this->host = $host;
$this->user = $user;
$this->password = $password;
}
function initConexion($nombredb){
$this->conexion = new mysqli($this->host, $this->user, $this->password, $nombredb);
if ($this->conexion->connect_error) {
return "Error:" . $this->conexion->connect_error;
}else {
return "OK";
}
}
function ejecutarQuery($query){
return $this->conexion->query($query);
}
function cerrarConexion(){
$this->conexion->close();
}
function insertData($tabla, $data){
$sql = 'INSERT INTO '.$tabla.' (';
$i = 1;
foreach ($data as $key => $value) {
$sql .= $key;
if ($i<count($data)) {
$sql .= ', ';
}else $sql .= ')';
$i++;
}
$sql .= ' VALUES (';
$i = 1;
foreach ($data as $key => $value) {
$sql .= "'".$value."'";
if ($i<count($data)) {
$sql .= ', ';
}else $sql .= ');';
$i++;
}
return $this->ejecutarQuery($sql);
}
function eliminarRegistro($tabla, $condicion){
$sql = "DELETE FROM ".$tabla." WHERE ".$condicion.";";
return $this->ejecutarQuery($sql);
}
function consultar($tablas, $campos, $condicion = ""){
$sql = "SELECT ";
//$ultima_key = end(array_keys($campos));
$a = array_keys($campos);
$ultima_key = end($a);
foreach ($campos as $key => $value) {
$sql .= $value;
if ($key!=$ultima_key) {
$sql.=", ";
}else $sql .=" FROM ";
}
//$ultima_key = end(array_keys($tablas));
$a = array_keys($tablas);
$ultima_key = end($a);
foreach ($tablas as $key => $value) {
$sql .= $value;
if ($key!=$ultima_key) {
$sql.=", ";
}else $sql .= " ";
}
if ($condicion == "") {
$sql .= ";";
}else {
$sql .= $condicion.";";
}
return $this->ejecutarQuery($sql);
}
}
?>