diff options
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/mysql.php | 416 |
1 files changed, 416 insertions, 0 deletions
diff --git a/lib/mysql.php b/lib/mysql.php new file mode 100644 index 0000000..ecfb767 --- /dev/null +++ b/lib/mysql.php @@ -0,0 +1,416 @@ +<?php +namespace { + if (!function_exists('\mysql_connect')) { + function mysql_connect( + $hostname = null, + $username = null, + $password = null, + $new = false, + $flags = 0) + { + if ($new !== false) { + trigger_error('Argument $new is no longer supported in PHP > 7', E_USER_WARNING); + } + + if ($flags === 0) { + $conn = \Dshafik\MySQL::$last_connection = mysqli_connect($hostname, $username, $password); + return $conn; + } + + try { + $conn = \Dshafik\MySQL::$last_connection = mysqli_init(); + + mysqli_options($conn, $flags); + + mysqli_real_connect($conn, $hostname, $username, $password); + + return $conn; + } catch (\Throwable $e) { + var_dump($e); + } + } + + function mysql_pconnect( + $hostname = null, + $username = null, + $password = null, + $flags = 0) + { + $hostname = 'p:' . $hostname; + return mysql_connect($hostname, $username, $password, false, $flags); + } + + function mysql_close(\mysqli $link = null) + { + $isDefault = ($link === null); + + $link = \Dshafik\MySQL::getConnection($link, __FUNCTION__); + if ($link === null) { + return false; + } + + $return = mysqli_close($link); + if ($isDefault) { + Dshafik\MySQL::$last_connection = null; + } + return $return; + } + + function mysql_select_db($databaseName, \mysqli $link = null) + { + $link = \Dshafik\MySQL::getConnection($link); + + return mysqli_query( + $link, + "USE " . mysqli_real_escape_string($link) + ) !== false; + } + + function mysql_query($query, \mysqli $link = null) + { + return mysqli_query(\Dshafik\MySQL::getConnection($link), $query); + } + + function mysql_unbuffered_query($query, \mysqli $link = null) + { + $link = \Dshafik\MySQL::getConnection($link); + mysqli_real_query($link, $query); + return $link; + } + + function mysql_db_query($databaseName, $query, \mysqli $link = null) + { + mysql_select_db($databaseName, $link); + return mysql_query($query, $link); + } + + function mysql_list_dbs(\mysqli $link = null) + { + return mysql_query("SHOW DATABASES", $link); + } + + function mysql_list_tables(\mysqli $link = null) + { + return mysql_query("SHOW TABLES", \Dshafik\MySQL::getConnection($link)); + } + + function mysql_list_fields($databaseName, $tableName, \mysqli $link = null) + { + $link = \Dshafik\MySQL::getConnection($link); + return mysql_query( + "SHOW COLUMNS FROM " . + mysqli_real_escape_string($link, $databaseName) . "." . + mysqli_real_escape_string($link, $tableName), + $link + ); + } + + function mysql_list_processes(\mysqli $link = null) + { + return mysql_query("SHOW PROCESSLIST", $link); + } + + function mysql_error(\mysqli $link = null) + { + return mysqli_error(\Dshafik\MySQL::getConnection($link)); + } + + function mysql_errno(\mysqli $link = null) + { + return mysqli_errno(\Dshafik\MySQL::getConnection($link)); + } + + function mysql_affected_rows(\mysqli $link = null) + { + return mysqli_affected_rows(\Dshafik\MySQL::getConnection($link)); + } + + function mysql_insert_id($link = null) /*|*/ + { + return mysqli_insert_id(\Dshafik\MySQL::getConnection($link)); + } + + function mysql_result(\mysqli_result $result, $row, $field = 0) + { + if (!mysqli_data_seek($result, $row)) { + return false; + } + + if ($row = mysqli_fetch_array($result) === false) { + return false; + } + + if (isset($row[$field])) { + return $row[$field]; + } + + return false; + } + + function mysql_num_rows(\mysqli_result $result) + { + return mysqli_num_rows($result); + } + + function mysql_num_fields(\mysqli_result $result) + { + return mysqli_num_fields($result); + } + + function mysql_fetch_row(\mysqli_result $result) /* : array|null */ + { + return mysqli_fetch_row($result); + } + + function mysql_fetch_array(\mysqli_result $result) /* : array|null */ + { + return mysqli_fetch_array($result); + } + + function mysql_fetch_assoc(\mysqli_result $result) /* : array|null */ + { + return mysqli_fetch_assoc($result); + } + + function mysql_fetch_object(\mysqli_result $result, $class, array $params = []) /* : object|null */ + { + return mysqli_fetch_object($result, $class, $params); + } + + function mysql_data_seek(\mysqli_result $result, $offset) + { + return mysqli_data_seek($result, $offset); + } + + function mysql_fetch_lengths(\mysqli_result $result) /* : array|*/ + { + return mysqli_fetch_lengths($result); + } + + function mysql_fetch_field(\mysqli_result $result) /* : object|*/ + { + return mysqli_fetch_field($result); + } + + function mysql_field_seek(\mysqli_result $result, $field) + { + return mysqli_field_seek($result, $field); + } + + function mysql_free_result(\mysqli_result $result) + { + return mysqli_free_result($result); + } + + function mysql_field_name(\mysqli_result $result, $field) + { + return \Dshafik\MySQL::mysql_field_info($result, $field, 'name'); + } + + function mysql_field_table(\mysqli_result $result, $field) + { + return \Dshafik\MySQL::mysql_field_info($result, $field, 'table'); + } + + function mysql_field_len(\mysql_result $result, $field) + { + return \Dshafik\MySQL::mysql_field_info($result, $field, 'length'); + } + + function mysql_field_type(\mysql_result $result, $field) + { + return \Dshafik\MySQL::mysql_field_info($result, $field, 'type'); + } + + function mysql_field_flags(\mysql_result $result, $field) + { + return \Dshafik\MySQL::mysql_field_info($result, $field, 'flags'); + } + + function mysql_escape_string($unescapedString) + { + return mysql_real_escape_string($unescapedString, null); + } + + function mysql_real_escape_string($unescapedString, \mysqli $link = null) + { + return mysqli_escape_string(\Dshafik\MySQL::getConnection($link), $unescapedString); + } + + function mysql_stat(\mysqli $link = null) + { + return mysqli_stat(\Dshafik\MySQL::getConnection($link)); + } + + function mysql_thread_id(\mysqli $link = null) + { + return mysqli_thread_id(\Dshafik\MySQL::getConnection($link)); + } + + function mysql_client_encoding(\mysqli $link = null) + { + return mysqli_character_set_name(\Dshafik\MySQL::getConnection($link)); + } + + function mysql_ping(\mysqli $link = null) + { + return mysqli_ping($link); + } + + function mysql_get_client_info(\mysqli $link = null) + { + return mysqli_get_client_info(\Dshafik\MySQL::getConnection($link)); + } + + function mysql_get_host_info(\mysqli $link = null) + { + return mysqli_get_host_info(\Dshafik\MySQL::getConnection($link)); + } + + function mysql_get_proto_info(\mysqli $link = null) + { + return mysqli_get_proto_info(\Dshafik\MySQL::getConnection($link)); + } + + function mysql_get_server_info(\mysqli $link = null) + { + return mysqli_get_server_info(\Dshafik\MySQL::getConnection($link)); + } + + function mysql_info(\mysqli $link = null) + { + return mysqli_info(\Dshafik\MySQL::getConnection($link)); + } + + function mysql_set_charset($charset, \mysqli $link = null) + { + return mysqli_set_charset(\Dshafik\MySQL::getConnection($link), $charset); + } + + function mysql_db_name(\mysqli_result $result) + { + return mysqli_fetch_row($result)['Database']; + } + + function mysql_table_name(\mysqli_result $result) + { + return mysqli_fetch_row($result)['Table']; + } + + /* Aliases */ + + function mysql_fieldname(\mysqli_result $result) + { + return mysql_field_name($result); + } + + function mysql_fieldtable(\mysqli_result $result) + { + return mysql_field_table($result); + } + + function mysql_fieldlen(\mysqli_result $result) + { + return mysql_field_len($result); + } + + function mysql_fieldtype(\mysqli_result $result) + { + return mysql_field_type($result); + } + + function mysql_fieldflags(\mysqli_result $result) + { + return mysql_field_flags($result); + } + + function mysql_selectdb($databaseName, \mysql $link = null) + { + return mysql_select_db($databaseName, $link); + } + + function mysql_freeresult(\mysqli_result $result) + { + return mysql_free_result($result); + } + + function mysql_numfields(\mysqli_result $result) + { + return mysql_num_fields($result); + } + + function mysql_numrows(\mysqli_result $result) + { + return mysql_num_rows($result); + } + + function mysql_listdbs(... $args) + { + return mysql_list_dbs(... $args); + } + + function mysql_listtables(... $args) + { + return mysql_list_tables(... $args); + } + + function mysql_listfields(... $args) + { + return mysql_list_fields(... $args); + } + + function mysql_dbname(\mysqli_result $result) + { + return mysql_db_name($result); + } + + function mysql_tablename(\mysqli_result $result) + { + return mysql_table_name($result); + } + } +} + +namespace Dshafik { + class MySQL { + static public $last_connection = null; + + static public function getConnection($link = null, $func = null) + { + if ($link !== null) { + return $link; + } + + if (static::$last_connection === null) { + $err = "A link to the server could not be established"; + if ($func !== null) { + $err = $func . "(): no MySQL-Link resource supplied"; + } + trigger_error($err, E_USER_WARNING); + } + + return static::$last_connection; + } + + static public function mysql_field_info(\mysqli_result $result, $field, $what) + { + $field = mysqli_fetch_field_direct($result, $field); + if ($field === false) { + trigger_error( + E_WARNING, + sprintf( + "Field %d is invalid for MySQL result index %s", + $field, + spl_object_hash($result) + ) + ); + } + + if (isset($field->{$what})) { + return $field->{$what}; + } + + return false; + } + } +} |