connect_errno !== 0) { throw new RuntimeException("Connect Error: " . $connection->connect_error); } self::$connection = $connection; self::query("SET NAMES utf8mb4"); self::query("SET SESSION sql_mode='ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'"); return self::$connection; } public static function dataSeek(mysqli_result $result, int $row_number): bool { return mysqli_data_seek($result, $row_number); } public static function escape(?string $string): string { return mysqli_real_escape_string(self::$connection, $string); } public static function error(): string { return mysqli_error(self::$connection); } public static function fetchArray(mysqli_result $result): ?array { return mysqli_fetch_array($result); } public static function fetchAssoc(mysqli_result $result): ?array { return mysqli_fetch_assoc($result); } public static function fetchObject(mysqli_result $result): ?object { return mysqli_fetch_object($result); } public static function fetchRow(mysqli_result $result): ?array { return mysqli_fetch_row($result); } public static function freeResult($result): void { mysqli_free_result($result); } public static function getValueString(array $pairs, bool $escape = false): string { if($escape) { $pairs = array_map("DB::escape", $pairs); } $string_array = []; foreach($pairs as $field => $value) { if($value === null) { $string_array[] = "`$field`=NULL"; } else { $string_array[] = "`$field`='$value'"; } } return implode(", ", $string_array); } /** * @param array $pairs * @param array|bool $options * @return string */ public static function getWhereString(array $pairs, $options = []): string { $escape = false; $fuzzy = false; if(is_bool($options)) { // Legacy escape $escape = $options; } if(is_array($options)) { $escape = $options["escape"] ?? false; $fuzzy = $options["fuzzy"] ?? false; } if($escape) { foreach($pairs as &$value) { $value = self::escape($value); } unset($value); } $parts = []; foreach($pairs as $field => $value) { if($value === null) { $parts[] = "`$field` IS NULL"; } else if(is_array($value)) { $values = array_map(static function(string $string) { return "'$string'"; }, $value); if(empty($value)) { $parts[] = "0"; } // Empty array else { $parts[] = "`$field` IN (" . implode(", ", $values) . ")"; } } else if(is_a($value, Constraint::class)) { /** @var Constraint $value */ $parts[] = "`$field` " . $value->getString(); } else { $parts[] = $fuzzy ? "`$field` LIKE '%$value%'" : "`$field`='$value'"; } } return implode(" AND ", $parts); } /** * @param string $table * @param string $name * @return bool * @throws Exception */ public static function hasIndex(string $table, string $name): bool { $sql = "SHOW INDEX FROM `$table` WHERE `Key_name`='$name'"; $result = self::query($sql); return self::numRows($result) > 0; } public static function insertId() { return mysqli_insert_id(self::$connection); } /** * @param mysqli_result|bool $result * @return int */ public static function numRows($result): int { if(is_bool($result)) { return 0; } return mysqli_num_rows($result); } public static function objectOrNull(mysqli_result $result): ?object { return mysqli_num_rows($result)>0 ? self::fetchObject($result) : null; } public static function ping(): bool { return mysqli_ping(self::$connection); } /** * @param string $sql * @return bool|mysqli_result * @throws Exception */ public static function query(string $sql) { if(self::$connection === null) { return false; } $is_development = ($_ENV["ENV"] === "development"); self::$queries[] = $sql; self::$lastQuery = $sql; self::$queryCount++; $result = mysqli_query(self::$connection, $sql); if($result === false) { if($is_development) { $error = self::error(); throw new RuntimeException("Query failed: $error $sql"); } throw new RuntimeException("A database error has occurred. Please try again later."); } return $result; } public static function selectDatabase(string $name): void { mysqli_select_db(self::$connection, $name); } public static function dts(): string { return gmdate("Y-m-d H:i:s"); } }