@@ -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 | |