connect_error)) { throw new Exception("Connect Error: " . $link->connect_error); } db::query("SET NAMES utf8mb4"); return $link; } /** * @param mysqli_result $result * @param int $row_number * @return bool */ public static function data_seek(mysqli_result $result, int $row_number): bool { return mysqli_data_seek($result, $row_number); } /** * @param $value * @return string */ public static function escape($value): string { return mysqli_real_escape_string(db::$DB, $value); } public static function escape_nvp(array $nvp): array { foreach($nvp as $name => $value) { $nvp[$name] = db::escape($value); } return $nvp; } /** * @return string */ public static function error(): string { return mysqli_error(db::$DB); } /** * @param mysqli_result $result * @return array|null */ public static function fetch_array(mysqli_result $result): ?array { return mysqli_fetch_array($result); } /** * @param mysqli_result $result * @return array|null */ public static function fetch_assoc(mysqli_result $result): ?array { return mysqli_fetch_assoc($result); } /** * @param mysqli_result $result * @return object|null */ public static function fetch_object(mysqli_result $result): ?object { return mysqli_fetch_object($result); } /** * @param mysqli_result $result * @return array|null */ public static function fetch_row(mysqli_result $result): ?array { return mysqli_fetch_row($result); } public static function free_result(mysqli_result $result): void { mysqli_free_result($result); } /** * @param array $nvp * @param bool $escape * @return string */ public static function get_value_string(array $nvp, bool $escape = false): string { if($escape) { $nvp = db::escape_nvp($nvp); } $string_array = []; foreach($nvp as $field => $value) { if(is_null($value)) { $string_array[] = "`$field`=NULL"; } else if(stripos($field, "binary")!==false && stripos($value, "x'")===0) { $string_array[] = "`$field`=$value"; } else { $string_array[] = "`$field`='$value'"; } } return implode(", ", $string_array); } /** * @param array $nvp * @param array|bool $options * @return string */ public static function get_where_string(array $nvp, $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) { $nvp = db::escape_nvp($nvp); } $string_array = []; foreach($nvp as $field => $value) { if($value === null) { $string_array[] = "`$field` IS NULL"; } else if(is_array($value)) { $values = array_map(function($str) { return "'$str'"; }, $value); if(empty($value)) $string_array[] = "0"; // Empty array else $string_array[] = "`$field` IN (" . implode(", ", $values) . ")"; } else if(is_a($value, "Constraint")) { $string_array[] = "`$field` " . $value->getConstraintString(); } else { $string_array[] = $fuzzy ? "`$field` LIKE '%$value%'" : "`$field`='$value'"; } } return implode(" AND ", $string_array); } /** * @param string $table * @param string $index_name * @return bool * @throws Exception */ public static function has_index(string $table, string $index_name): bool { $sql = "SHOW INDEX FROM `$table` WHERE `Key_name`='$index_name'"; $result = db::query($sql); return db::num_rows($result)==1; } /** * @return int */ public static function insert_id(): int { return mysqli_insert_id(db::$DB); } /** * @param mysqli_result $result * @return int */ public static function num_rows(mysqli_result $result): int { if(is_bool($result)) { return 0; } return mysqli_num_rows($result); } /** * @param mysqli_result $result * @return object|null */ public static function object_or_null(mysqli_result $result): ?object { return mysqli_num_rows($result)>0 ? db::fetch_object($result) : null; } /** * @param string $table * @param string $field * @param int $id * @return object|null * @throws Exception */ public static function object_with_id(string $table, string $field, int $id): ?object { $sql = "SELECT * FROM `$table` WHERE `$field`='$id'"; $result = db::query($sql); return db::object_or_null($result); } /** * @return bool */ public static function ping(): bool { return mysqli_ping(db::$DB); } /** * @param string $sql * @return bool|mysqli_result * @throws Exception */ public static function query(string $sql) { if(!is_string($sql)) return false; self::$last_query = $sql; $result = mysqli_query(db::$DB, $sql); if(!$result) { $error = mysqli_error(db::$DB); error_log("Query failed: $sql\n"); error_log("Error: $error\n"); if(!PRODUCTION) { throw new Exception("Query failed: $sql"); } else { throw new Exception("A database error has occurred. Please try again later."); } } self::$queries[] = $sql; self::$query_count++; return $result; } /** * @param string $name * @param mysqli|null $link_identifier * @return bool */ public static function select_db(string $name, mysqli $link_identifier = null): bool { if(is_null($link_identifier)) { return mysqli_select_db(db::$DB, $name); } else { return mysqli_select_db($link_identifier, $name); } } /** * @return int */ public static function thread_id(): int { return mysqli_thread_id(db::$DB); } }