@@ -21,12 +21,12 @@ |
||
21 | 21 | |
22 | 22 | if(count($columnas) > 0) |
23 | 23 | { |
24 | - foreach ($columnas as $campo) |
|
25 | - { |
|
26 | - $campos = $campo.','.$campos; |
|
27 | - } |
|
24 | + foreach ($columnas as $campo) |
|
25 | + { |
|
26 | + $campos = $campo.','.$campos; |
|
27 | + } |
|
28 | 28 | |
29 | - $campos = trim($campos, ','); |
|
29 | + $campos = trim($campos, ','); |
|
30 | 30 | } |
31 | 31 | else |
32 | 32 | { |
@@ -29,14 +29,14 @@ |
||
29 | 29 | public function conectar(): PDO |
30 | 30 | { |
31 | 31 | try |
32 | - { |
|
33 | - $this->_pdo = new PDO('mysql:host='.$this->_hostBaseDeDatos->hostBaseDeDatos().';dbname='.$this->_baseDeDatos->baseDeDatos().';chartset=utf8mb4',$this->_usuarioBaseDeDatos->usuarioBaseDeDatos(),$this->_contraseñaBaseDeDatos->contraseñaBaseDeDatos()); |
|
34 | - $this->_pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); |
|
35 | - } |
|
36 | - catch(PDOException) |
|
37 | - { |
|
38 | - throw new ConexionABaseDeDatosException("Error al conectar con base de datos"); |
|
39 | - } |
|
32 | + { |
|
33 | + $this->_pdo = new PDO('mysql:host='.$this->_hostBaseDeDatos->hostBaseDeDatos().';dbname='.$this->_baseDeDatos->baseDeDatos().';chartset=utf8mb4',$this->_usuarioBaseDeDatos->usuarioBaseDeDatos(),$this->_contraseñaBaseDeDatos->contraseñaBaseDeDatos()); |
|
34 | + $this->_pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); |
|
35 | + } |
|
36 | + catch(PDOException) |
|
37 | + { |
|
38 | + throw new ConexionABaseDeDatosException("Error al conectar con base de datos"); |
|
39 | + } |
|
40 | 40 | |
41 | 41 | return $this->_pdo; |
42 | 42 | } |
@@ -23,8 +23,8 @@ discard block |
||
23 | 23 | } |
24 | 24 | |
25 | 25 | public function consulta(): PDOStatement |
26 | - { |
|
27 | - $consulta = $this->_conexionBaseDeDatos->prepare($this->_query->query()); |
|
26 | + { |
|
27 | + $consulta = $this->_conexionBaseDeDatos->prepare($this->_query->query()); |
|
28 | 28 | |
29 | 29 | if(!empty($this->_query->valores())) |
30 | 30 | { |
@@ -46,5 +46,5 @@ discard block |
||
46 | 46 | } |
47 | 47 | |
48 | 48 | return $consulta; |
49 | - } |
|
49 | + } |
|
50 | 50 | } |
51 | 51 | \ No newline at end of file |
@@ -19,7 +19,7 @@ discard block |
||
19 | 19 | } |
20 | 20 | |
21 | 21 | public function insert(): string |
22 | - { |
|
22 | + { |
|
23 | 23 | $keys = array_keys($this->_valoresAInsertar->valoresAInsertar()); |
24 | 24 | $values = ''; |
25 | 25 | |
@@ -37,5 +37,5 @@ discard block |
||
37 | 37 | } |
38 | 38 | |
39 | 39 | return "INSERT INTO ". $this->_tabla->tabla()." (`". implode('`, `', $keys) ."`) VALUES ({$values})"; |
40 | - } |
|
40 | + } |
|
41 | 41 | } |
42 | 42 | \ No newline at end of file |
@@ -29,13 +29,13 @@ |
||
29 | 29 | public function update(): string |
30 | 30 | { |
31 | 31 | $set = ""; |
32 | - $values = []; |
|
32 | + $values = []; |
|
33 | 33 | |
34 | - foreach ($this->_valoresAInsertar->valoresAInsertar() as $key => $value) |
|
35 | - { |
|
36 | - $set = $set. ' ' .$key. ' = ?,'; |
|
37 | - array_push($values, $value); |
|
38 | - } |
|
34 | + foreach ($this->_valoresAInsertar->valoresAInsertar() as $key => $value) |
|
35 | + { |
|
36 | + $set = $set. ' ' .$key. ' = ?,'; |
|
37 | + array_push($values, $value); |
|
38 | + } |
|
39 | 39 | |
40 | 40 | $valores = trim($set, ','); |
41 | 41 |