File manager

File manager - Edit - /home/autoph/public_html/connectv1/src/Core/Database.php

Back
<?php namespace App\Core; class Database { private static $host = DB_HOST; private static $user = DB_USER; private static $password = DB_PASS; private static $database = DB_NAME; private static $conn; private static $instance; function __construct() { self::$conn = self::connectDB(); //Server Config self::$conn->query("SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));"); } public static function connect() { if (is_null(self::$instance)) { self::$instance = new self(); } return self::$instance; } public static function connectDB() { $conn = mysqli_connect(self::$host, self::$user, self::$password, self::$database); return $conn; } public static function bindQueryParams($sql, $param_type, $param_value_array) { $param_value_reference[] = &$param_type; for ($i = 0; $i < count($param_value_array); $i++) { $param_value_reference[] = &$param_value_array[$i]; } call_user_func_array(array( $sql, 'bind_param' ), $param_value_reference); } public static function runQuery($query, $param_type = "", $param_value_array = []) { try { $sql = self::$conn->prepare($query); if (self::$conn->error) { return self::$conn->error; } if (!empty($param_value_array)) { self::bindQueryParams($sql, $param_type, $param_value_array); } $sql->execute(); $result = $sql->get_result(); $resultset = []; if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $resultset[] = $row; } } return $resultset; } catch (\Exception $e) { return $e->getMessage(); } } public static function selectQuery($query, $param_type = "", $param_value_array = []) { try { $sql = self::$conn->prepare($query); if (self::$conn->error) { return self::$conn->error; } if (!empty($param_value_array)) { self::bindQueryParams($sql, $param_type, $param_value_array); } $sql->execute(); $result = $sql->get_result(); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { return $row; } } return []; } catch (\Exception $e) { return $e->getMessage(); } } public static function insert($query, $param_type = "", $param_value_array = []) { try { $sql = self::$conn->prepare($query); if (self::$conn->error) { return self::$conn->error; } if (!empty($param_value_array)) { self::bindQueryParams($sql, $param_type, $param_value_array); } $sql->execute(); return $sql->insert_id; } catch (\Exception $e) { return $e->getMessage(); } } public static function update($query, $param_type = "", $param_value_array = []) { try { $sql = self::$conn->prepare($query); if (self::$conn->error) { return self::$conn->error; } if (!empty($param_value_array)) { self::bindQueryParams($sql, $param_type, $param_value_array); } $sql->execute(); return $sql->affected_rows; } catch (\Exception $e) { return $e->getMessage(); } } public static function select($query, $param_type = "", $param_value_array = []) { try { $sql = self::$conn->prepare($query); if (self::$conn->error) { return self::$conn->error; } if (!empty($param_value_array)) { self::bindQueryParams($sql, $param_type, $param_value_array); } $sql->execute(); $result = $sql->get_result(); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $resultset[] = $row; foreach ($resultset as $resultsetRow) { foreach ($resultsetRow as $resultsetRowRow) { return $resultsetRowRow; } } } } return ''; } catch (\Exception $e) { return $e->getMessage(); } } public static function runBaseQuery($query) { $result = self::$conn->query($query); if (self::$conn->error) { return self::$conn->error; } $resultset = []; if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $resultset[] = $row; } } return $resultset; } public static function selectBaseQuery($query) { $result = self::$conn->query($query); if (self::$conn->error) { return self::$conn->error; } if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $resultset[] = $row; foreach ($resultset as $resultsetRow) { foreach ($resultsetRow as $resultsetRowRow) { return $resultsetRowRow; } } } } else { return ''; } } public static function insertBaseQuery($query) { $sql = self::$conn->prepare($query); if (self::$conn->error) { return self::$conn->error; } $sql->execute(); $insertId = $sql->insert_id; return $insertId; } public static function updateBaseQuery($query) { $sql = self::$conn->prepare($query); if (self::$conn->error) { return self::$conn->error; } $sql->execute(); return $sql->affected_rows; } public static function checkQuery($query) { return $query; // $sql = self::$conn->prepare($query); // if (self::$conn->error) { // return self::$conn->error; // } // $sql->execute(); // return $sql->affected_rows; } //modify public static function return_result($query) { $result = self::connectDB()->query($query); $output = array(); while ($row = $result->fetch_assoc()) { array_push($output, $row); } return $output; } public static function select2($query) { $result = self::connectDB()->query($query); if ($result === false) { return false; } $row = $this->index_arr_values($result->fetch_assoc()); if (empty($row)) { return ""; } return $row[0]; } public function index_arr_values($value) { if (empty($value)) { return array(); } return array_values($value); } }

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings