mysql2i.class.php

<?php

class MySQL2i
{
    public static $currObj;

    public static function mysql_affected_rows($link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        return mysqli_affected_rows($link);
    }

    public static function mysql_client_encoding($link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        return mysqli_character_set_name($link);
    }

    public static function mysql_close($link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        return mysqli_close($link);
    }

    public static function mysql_connect($host = '', $username = '', $passwd = '', $new_link = false, $client_flags = 0)
    {
        $link = mysqli_connect($host, $username, $passwd);
        self::$currObj = $link;

        return $link;
    }

    public static function mysql_create_db($database_name, $link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        $query = 'CREATE DATABASE `'.$database_name.'`';
        mysqli_query($link, $query);

        $e = mysqli_errno($link);

        if (empty($e)) {
            return true;
        }

        return false;
    }

    public static function mysql_data_seek($result, $offset)
    {
        return mysqli_data_seek($result, $offset);
    }

    public static function mysql_db_name($result, $row, $field = null)
    {
        mysqli_data_seek($result, $row);

        $f = mysqli_fetch_row($result);

        return $f[0];
    }

    public static function mysql_db_query($database, $query, $link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }
        mysqli_select_db($link, $database);
        $r = mysqli_query($link, $query);

        return $r;
    }

    public static function mysql_drop_db($database, $link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        $query = 'DROP DATABASE `'.$database.'`';
        mysqli_query($link, $query);

        $e = mysqli_errno($link);

        if (empty($e)) {
            return true;
        }

        return false;
    }

    public static function mysql_errno($link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        return mysqli_errno($link);
    }

    public static function mysql_error($link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        return mysqli_error($link);
    }

    public static function mysql_escape_string($escapestr)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        return mysqli_real_escape_string($link, $escapestr);
    }

    public static function mysql_fetch_array($result, $resulttype = MYSQLI_BOTH)
    {
        return mysqli_fetch_array($result, $resulttype);
    }

    public static function mysql_fetch_assoc($result)
    {
        return mysqli_fetch_assoc($result);
    }

    public static function mysql_fetch_field($result, $field_offset = 0)
    {
        if (!empty($field_offset)) {
            for ($x = 0; $x < $field_offset; $x++) {
                mysqli_fetch_field($result);
            }
        }

        return mysqli_fetch_field($result);
    }

    public static function mysql_fetch_lengths($result)
    {
        return mysqli_fetch_lengths($result);
    }

    public static function mysql_fetch_object($result, $class_name = null, $params = [])
    {
        return mysqli_fetch_object($result, $class_name, $params);
    }

    public static function mysql_fetch_row($result)
    {
        return mysqli_fetch_row($result);
    }

    /*
    credit to andre at koethur dot de from php.net and NinjaKC from stackoverflow.com
    */
    public static function mysql_field_flags($result, $field_offset)
    {
        static $flags;

        $flags_num = mysqli_fetch_field_direct($result, $field_offset)->flags;

        if (!isset($flags)) {
            $flags = [];
            $constants = get_defined_constants(true);
            foreach ($constants['mysqli'] as $c => $n) {
                if (preg_match('/MYSQLI_(.*)_FLAG$/', $c, $m)) {
                    if (!array_key_exists($n, $flags)) {
                        $flags[$n] = $m[1];
                    }
                }
            }
        }

        $result = [];
        foreach ($flags as $n => $t) {
            if ($flags_num & $n) {
                $result[] = $t;
            }
        }

        $return = implode(' ', $result);
        $return = str_replace('PRI_KEY', 'PRIMARY_KEY', $return);
        $return = mb_strtolower($return);

        return $return;
    }

    public static function mysql_field_len($result, $field_offset)
    {
        $fieldInfo = mysqli_fetch_field_direct($result, $field_offset);

        return $fieldInfo->length;
    }

    public static function mysql_field_name($result, $field_offset)
    {
        $fieldInfo = mysqli_fetch_field_direct($result, $field_offset);

        return $fieldInfo->name;
    }

    public static function mysql_field_seek($result, $fieldnr)
    {
        return mysqli_field_seek($result, $fieldnr);
    }

    public static function mysql_field_table($result, $field_offset)
    {
        $fieldInfo = mysqli_fetch_field_direct($result, $field_offset);

        return $fieldInfo->table;
    }

    /*
    credit to andre at koethur dot de from php.net and NinjaKC from stackoverflow.com
    */
    public static function mysql_field_type($result, $field_offset)
    {
        static $types;

        $type_id = mysqli_fetch_field_direct($result, $field_offset)->type;

        if (!isset($types)) {
            $types = [];
            $constants = get_defined_constants(true);
            foreach ($constants['mysqli'] as $c => $n) {
                if (preg_match('/^MYSQLI_TYPE_(.*)/', $c, $m)) {
                    $types[$n] = $m[1];
                }
            }
        }

        return array_key_exists($type_id, $types) ? $types[$type_id] : null;
    }

    public static function mysql_free_result($result)
    {
        return mysqli_free_result($result);
    }

    public static function mysql_get_client_info()
    {
        $link = self::$currObj;

        return mysqli_get_client_info($link);
    }

    public static function mysql_get_host_info($link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        return mysqli_get_host_info($link);
    }

    public static function mysql_get_proto_info($link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        return mysqli_get_proto_info($link);
    }

    public static function mysql_get_server_info($link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        return mysqli_get_server_info($link);
    }

    public static function mysql_info($link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        return mysqli_info($link);
    }

    public static function mysql_insert_id($link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        return mysqli_insert_id($link);
    }

    public static function mysql_list_dbs($link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        $query = 'SHOW DATABASES';
        $r = mysqli_query($link, $query);
        $e = mysqli_errno($link);

        if (empty($e)) {
            return $r;
        }

        return false;
    }

    public static function mysql_list_fields($database_name, $table_name, $link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        $query = 'SHOW COLUMNS FROM `'.$table_name.'`';
        $r = mysqli_query($link, $query);
        $e = mysqli_errno($link);

        if (empty($e)) {
            return $r;
        }

        return false;
    }

    public static function mysql_list_processes($link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        return mysqli_thread_id($link);
    }

    public static function mysql_list_tables($database, $link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        $query = 'SHOW TABLES FROM `'.$database.'`';
        $r = mysqli_query($link, $query);
        $e = mysqli_errno($link);

        if (empty($e)) {
            return $r;
        }

        return false;
    }

    public static function mysql_num_fields($result)
    {
        $link = self::$currObj;

        return mysqli_field_count($link);
    }

    public static function mysql_num_rows($result)
    {
        return mysqli_num_rows($result);
    }

    public static function mysql_pconnect($host = '', $username = '', $passwd = '', $new_link = false, $client_flags = 0)
    {
        $link = mysqli_connect('p:'.$host, $username, $passwd);

        if (!$link) {
            echo mysqli_error($link).'<br>';
        }

        self::$currObj = $link;

        return $link;
    }

    public static function mysql_ping($link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        return mysqli_ping($link);
    }

    public static function mysql_query($query, $link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        $r = mysqli_query($link, $query);

        return $r;
    }

    public static function mysql_real_escape_string($escapestr, $link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        return mysqli_real_escape_string($link, $escapestr);
    }

    public static function mysql_result($result, $row, $field = 0)
    {

        //ver 1.5 code credited to Mario Lurig at https://mariolurig.com/coding/mysqli_result-function-to-match-mysql_result/
        $numrows = mysqli_num_rows($result);

        if ($numrows && $row <= ($numrows - 1) && $row >= 0) {
            mysqli_data_seek($result, $row);
            $resrow = (is_numeric($field)) ? mysqli_fetch_row($result) : mysqli_fetch_assoc($result);
            if (isset($resrow[$field])) {
                return $resrow[$field];
            }
        }

        return false;
    }

    public static function mysql_select_db($dbname, $link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        } elseif (is_object($link)) {
            self::$currObj = $link;
        }

        mysqli_select_db($link, $dbname);

        $e = mysqli_errno($link);

        if (empty($e)) {
            return true;
        }

        return false;
    }

    public static function mysql_set_charset($charset, $link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        return mysqli_set_charset($link, $charset);
    }

    public static function mysql_stat($link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        return mysqli_stat($link);
    }

    public static function mysql_tablename($result, $row, $field = null)
    {
        mysqli_data_seek($result, $row);

        $f = mysqli_fetch_array($result);

        return $f[0];
    }

    public static function mysql_thread_id($link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        return mysqli_thread_id($link);
    }

    public static function mysql_unbuffered_query($query, $link = null)
    {
        if (empty($link)) {
            $link = self::$currObj;
        }

        $r = mysqli_query($link, $query, MYSQLI_USE_RESULT);

        return $r;
    }
}