Файловый менеджер - Редактировать - /home2/cocinasdalloway/public_html/grupodly.com/models/Tools/Connection.php
Назад
<?php class Connection { protected $IP = "localhost"; protected $USER = "dly_ecommerce"; protected $PASSWORD = "Ecommerce2019dly"; protected $DBNAME = "comercializadora_dly"; protected $connection; public function Exec_store_procedure_json($sql_parameters,$sql_output){ try { $result = $this->QueryReturn($sql_parameters); $sqlStatement = "select ".$sql_output." as result"; $result = $this->QueryReturn($sqlStatement); while ($fila = $result->fetch_assoc()) { $data = $fila['result']; } // echo $sql_parameters; return json_decode(preg_replace("/[\r\n|\n|\r]+/", " ", $data),JSON_FORCE_OBJECT ); } catch (Exception $e) { throw $e; } catch (InvalidArgumentException $e) { throw $e; } } public function ExecSPLog($sql_parameters,$sql_output){ try { $result = $this->QueryReturn($sql_parameters); $sqlStatement = "select ".$sql_output." as result"; $result = $this->QueryReturn($sqlStatement); while ($fila = $result->fetch_assoc()) { $data = $fila['result']; } // echo $sql_parameters; return json_decode(preg_replace("/[\r\n|\n|\r]+/", " ", $data),JSON_FORCE_OBJECT ); } catch (Exception $e) { throw $e; } catch (InvalidArgumentException $e) { throw $e; } } public function conexion() { try { $this->connection = new \mysqli($this->IP, $this->USER, $this->PASSWORD, $this->DBNAME); $this->connection->set_charset("utf8"); return $this->connection; } catch (mysqli_sql_exception $e) { throw $e; } catch (Exception $e) { throw $e; } } public function autocomit() { $this->connection->query("SET AUTOCOMMIT=0;"); } public function beginTransaction() { $this->connection->query("START TRANSACTION;"); } public function commit() { $this->connection->query("COMMIT;"); } public function rollback() { $this->connection->query("ROLLBACK;"); } public function simpleQuery($sql) { $this->connection->query($sql); } public function QueryReturn($sql) { $data = $this->connection->query($sql); return $data; } public function closeConnection() { $this->connection->close(); } }
| ver. 1.4 |
Github
|
.
| PHP 8.2.22 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка