Initial commit of ext/mysql shim for PHP 7

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;
+        }
+    }
+}