157 lines
3.0 KiB
PHP
157 lines
3.0 KiB
PHP
<?php
|
|
// phpcs:ignoreFile
|
|
|
|
$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
|
|
|
|
if ($conn->connect_errno) {
|
|
die('Error connecting to MySQL: ' . $conn->connect_error);
|
|
}
|
|
|
|
$conn->set_charset('utf8mb4');
|
|
|
|
if (!defined('MYSQL_ASSOC')) {
|
|
define('MYSQL_ASSOC', MYSQLI_ASSOC);
|
|
}
|
|
|
|
if (!defined('MYSQL_NUM')) {
|
|
define('MYSQL_NUM', MYSQLI_NUM);
|
|
}
|
|
|
|
if (!defined('MYSQL_BOTH')) {
|
|
define('MYSQL_BOTH', MYSQLI_BOTH);
|
|
}
|
|
|
|
if (!function_exists('mysql_query')) {
|
|
function mysql_query($query)
|
|
{
|
|
global $conn;
|
|
|
|
return mysqli_query($conn, $query);
|
|
}
|
|
}
|
|
|
|
if (!function_exists('mysql_fetch_assoc')) {
|
|
function mysql_fetch_assoc($result)
|
|
{
|
|
return mysqli_fetch_assoc($result);
|
|
}
|
|
}
|
|
|
|
if (!function_exists('mysql_fetch_array')) {
|
|
function mysql_fetch_array($result, $result_type = MYSQL_BOTH)
|
|
{
|
|
return mysqli_fetch_array($result, $result_type);
|
|
}
|
|
}
|
|
|
|
if (!function_exists('mysql_fetch_row')) {
|
|
function mysql_fetch_row($result)
|
|
{
|
|
return mysqli_fetch_row($result);
|
|
}
|
|
}
|
|
|
|
if (!function_exists('mysql_fetch_object')) {
|
|
function mysql_fetch_object($result)
|
|
{
|
|
return mysqli_fetch_object($result);
|
|
}
|
|
}
|
|
|
|
if (!function_exists('mysql_num_rows')) {
|
|
function mysql_num_rows($result)
|
|
{
|
|
return mysqli_num_rows($result);
|
|
}
|
|
}
|
|
|
|
if (!function_exists('mysql_numrows')) {
|
|
function mysql_numrows($result)
|
|
{
|
|
return mysql_num_rows($result);
|
|
}
|
|
}
|
|
|
|
if (!function_exists('mysql_real_escape_string')) {
|
|
function mysql_real_escape_string($string)
|
|
{
|
|
global $conn;
|
|
|
|
return mysqli_real_escape_string($conn, $string);
|
|
}
|
|
}
|
|
|
|
if (!function_exists('mysql_insert_id')) {
|
|
function mysql_insert_id()
|
|
{
|
|
global $conn;
|
|
|
|
return mysqli_insert_id($conn);
|
|
}
|
|
}
|
|
|
|
if (!function_exists('mysql_error')) {
|
|
function mysql_error()
|
|
{
|
|
global $conn;
|
|
|
|
return mysqli_error($conn);
|
|
}
|
|
}
|
|
|
|
if (!function_exists('mysql_affected_rows')) {
|
|
function mysql_affected_rows()
|
|
{
|
|
global $conn;
|
|
|
|
return mysqli_affected_rows($conn);
|
|
}
|
|
}
|
|
|
|
if (!function_exists('mysql_data_seek')) {
|
|
function mysql_data_seek($result, $row_number)
|
|
{
|
|
return mysqli_data_seek($result, $row_number);
|
|
}
|
|
}
|
|
|
|
if (!function_exists('mysql_result')) {
|
|
function mysql_result($result, $row, $column = 0)
|
|
{
|
|
if (!mysqli_data_seek($result, $row)) {
|
|
return null;
|
|
}
|
|
|
|
$data = mysqli_fetch_array($result, MYSQL_BOTH);
|
|
|
|
if ($data === null) {
|
|
return null;
|
|
}
|
|
|
|
return $data[$column] ?? null;
|
|
}
|
|
}
|
|
|
|
if (!function_exists('mysql_free_result')) {
|
|
function mysql_free_result($result)
|
|
{
|
|
return mysqli_free_result($result);
|
|
}
|
|
}
|
|
|
|
if (!function_exists('mysql_close')) {
|
|
function mysql_close($connection = null)
|
|
{
|
|
global $conn;
|
|
|
|
$link = $connection ?: $conn;
|
|
|
|
if ($link instanceof mysqli) {
|
|
return mysqli_close($link);
|
|
}
|
|
|
|
return false;
|
|
}
|
|
}
|
|
?>
|