Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Migrasi PHP 5 ke PHP 7
<?php
# PHP MySQL to MySQLi migration shim library
# purpose: Redefines deprecated or missing mysql_ functions and calls mysqli_ functions for PHP5.5+.
# website: http://mysql.dotpointer.com/
# author: Robert Klebe, dotpointer, dotpointer at gmail.com
# licensing: Public domain, edit and share without permission.
# changelog
# 2013-09-24 xx:xx:xx - first version
# 2013-09-25 xx:xx:xx - updated with is_mysql_resource() and bugfixes
# 2013-09-26 19:23:00 - adding some more function wrappers
# 2013-10-24 23:16:41 - bugfix, mysql_connect used invalid error functions
# 2013-11-11 xx:xx:xx - updated mysql_result() contributed by marc17 (GitHub)
# 2014-02-16 xx:xx:xx - updated mysql_result() contributed by marc17 (GitHub)
# 2015-03-24 21:57:45 - updated is_mysql_resource() with suggestions from Colin McKinnon
# 2015-03-25 00:06:50 - updated is_mysql_resource() with suggestions from Colin McKinnon
# 2016-02-20 00:35:36 - checking that function error return values are the same as the original ones as suggested by Yaff Are
# 2016-02-23 21:30:57 - bugfix, mysql_connect halted execution upon invalid credentials
# 2016-02-23 21:58:43 - bugfix, mysql_create_db - quotation forbidden
# 2016-02-23 22:19:36 - bugfix, mysql_list_dbs - null when no link
# 2016-02-23 22:24:20 - bugfix, mysql_list_tables - quotation forbidden
# 2016-02-23 22:27:38 - bugfix, mysql_ping - null when no link
# 2016-02-23 22:47:44 - bugfix, mysql_info - null when no link
# 2016-02-23 22:59:36 - bugfix, mysql_errno, mysql_error - null when no link
# 2016-02-23 23:34:45 - adding mysql_db_name
# 2016-02-23 23:38:01 - bugfix, mysql_client_encoding - null when no link
# 2016-02-23 22:19:36 - bugfix, mysql_data_seek - null when invalid row number
# 2016-02-23 23:55:36 - bugfix, mysql_drop_db - quotation forbidden
# 2016-02-24 00:12:41 - bugfix, mysql_db_query - selected database could be bypassed
# 2016-02-24 00:38:04 - bugfix, mysql_fetch_field - null when invalid parameters
# 2016-02-24 01:02:44 - bugfix, mysql_fetch_lengths - null when invalid parameters
# 2016-02-24 02:17:27 - bugfix, mysql_field_flags returned invalid value, adding mysql_field_bitflags_to_flags
# 2016-02-24 02:35:15 - bugfix, mysql_field_seek - null when invalid parameters
# 2016-02-24 02:55:09 - bugfix, mysql_field_type - returned invalid value, adding mysql_field_bittypes_to_types
# 2016-02-24 03:40:26 - bugfix, mysql_get_client_info, adding link argument
# 2016-02-24 03:43:55 - bugfix, mysql_get_host_info - null when invalid parameters
# 2016-02-24 04:10:19 - bugfix, mysql_get_proto_info - null when invalid parameters
# 2016-02-24 04:25:01 - bugfix, mysql_get_server_info - null when invalid parameters
# 2016-02-24 15:13:31 - bugfix, mysql_affected_rows - invalid value when invalid parameters
# 2016-02-24 15:17:10 - bugfix, mysql_thread_i - null when invalid parameters
# 2016-02-24 17:47:23 - bugfix, mysql_insert_id - null when invalid parameters
# 2016-02-24 18:29:02 - adding mysql_list_processes
# 2016-02-24 19:21:21 - bugfix, mysql_num_fields - null when invalid parameters
# 2016-02-25 16:08:51 - cleanup
# 2016-02-25 18:08:54 - cleanup
# notes
# mysql constants are directly translated to mysqli, so the actual value may differ
# mysql_escape_string now takes the last used connection
# to check if an item is a (mysql) resource or a mysqli object
# note that all types of resources must get through as this is a
# generic replacement for is_resource()
function is_mysqli_or_resource($r) {
# get the type of the variable
switch(gettype($r)) {
# if it is a resource - could be mysql, file handle etc...
case 'resource':
return true;
# if it is an object - must be a mysqli object then
case 'object':
# is this an instance of mysqli?
if ($r instanceof mysqli) {
# make sure there is no connection error
return !($r->connect_error);
}
# or is this an instance of a mysqli result?
if ($r instanceof mysqli_result) {
return true;
}
return false;
# negative on all other variable types
default:
return false;
}
}
# alias for is_mysqli_or_resource()
function is_mysql_resource($r) {
return is_mysqli_or_resource($r);
}
# alias for is_mysqli_or_resource()
function is_generic_resource($r) {
return is_mysqli_or_resource($r);
}
# to check if an item is a resource/object - replace is_resource with this
# old version, this will break if testing file handles too
function is_mysql_resource_old($result) {
# first try to treat as resource if original mysql is loaded
if (extension_loaded('mysql')) return is_resource($result);
# or if mysqli is loaded, try to check object
if (extension_loaded('mysqli')) return is_object($result);
die('Fatal error, mysqli extension not loaded.');
}
# only do this is mysql extension is not there
if (!extension_loaded('mysql')) {
# check if mysqli extension is loaded - its required as we rely on it
if (!extension_loaded('mysqli')) die('Fatal error, mysqli extension not loaded.');
# --- helper variables and constants ---------------------------------------------------------------------------------------------------
# a list of connections, used to get the last one
$mysql_links = array();
# our own constants to reach default connection values in INI file
define('MYSQL_DEFAULT_HOST', ini_get("mysql.default_host"));
define('MYSQL_DEFAULT_USER', ini_get("mysql.default_user"));
define('MYSQL_DEFAULT_PASSWORD', ini_get("mysql.default_password"));
# --- MySQL constants (from PHP.net) ---------------------------------------------------------------------------------------------------
# MySQL client constants
define('MYSQL_CLIENT_COMPRESS', MYSQLI_CLIENT_COMPRESS); # Use compression protocol
define('MYSQL_CLIENT_IGNORE_SPACE', MYSQLI_CLIENT_IGNORE_SPACE); # Allow space after function names
define('MYSQL_CLIENT_INTERACTIVE', MYSQLI_CLIENT_INTERACTIVE); # Allow interactive_timeout seconds
# (instead of wait_timeout ) of
# inactivity before closing the connection.
define('MYSQL_CLIENT_SSL', MYSQLI_CLIENT_SSL); # Use SSL encryption. This flag is only
# available with version 4.x of the MySQL
# client library or newer. Version 3.23.x is
# bundled both with PHP 4 and Windows binaries
# of PHP 5.
# mysql_fetch_array() uses a constant for the different types of result arrays. The following constants are defined:
# MySQL fetch constants
define('MYSQL_ASSOC', MYSQLI_ASSOC); # Columns are returned into the array having
# the fieldname as the array index.
define('MYSQL_BOTH', MYSQLI_BOTH); # Columns are returned into the array having
# both a numerical index and the fieldname as
# the array index.
define('MYSQL_NUM', MYSQLI_NUM); # Columns are returned into the array having a
# numerical index to the fields. This index
# starts with 0, the first field in the result.
# --- helper functions ---------------------------------------------------------------------------------------------------
# internal function to convert bitflags of mysqli to flags in text of mysql
# thanks to andre at koethur dot de at http://www.php.net/manual/en/mysqli-result.fetch-fields.php#101828
function mysql_field_bitflags_to_flags($flags_num) {
$flags = array();
$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 = array();
foreach ($flags as $n => $t) {
if ($flags_num & $n) {
$result[] = $t;
}
}
return implode(' ', $result);
}
# function to convert bit-types of mysqli to types in text of mysql
# thanks to andre at koethur dot de at http://www.php.net/manual/en/mysqli-result.fetch-fields.php#101828
function mysql_field_bittypes_to_types($type_id) {
$types = array();
$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;
}
# lib helper function - to ensure mysql link as mysqli always needs one
# but mysql takes last one
function mysql_ensure_link($link_identifier) {
# no link specified
if ($link_identifier === NULL) {
global $mysql_links;
# no connection at all - then go null
if (!count($mysql_links)) return NULL;
# get the last item of the array
$last = end($mysql_links);
# return the last stored link
return $last['link'];
}
return $link_identifier;
}
# --- MySQL functions (from PHP.net) ---------------------------------------------------------------------------------------------------
# mysql_affected_rows - Get number of affected rows in previous MySQL operation
# int mysql_affected_rows ([ resource $link_identifier = NULL ] )
# int mysqli_affected_rows ( mysqli $link )
function mysql_affected_rows($link_identifier = NULL) {
# mysql_affected_rows = -1 if the last query failed
# mysqli_affected_rows = -1 indicates that the query returned an error
$temp = mysqli_affected_rows(mysql_ensure_link($link_identifier));
if ($temp === NULL || $temp === false) {
return -1;
}
return $temp;
}
# mysql_client_encoding - Returns the name of the character set
# string mysql_client_encoding ([ resource $link_identifier = NULL ] )
# mysqli_character_set_name ( mysqli $link )
function mysql_client_encoding($link_identifier = NULL) {
# note that mysqlI_client_encoding ALSO is deprecated, so we cannot use that
# mysql_client_encoding/mysqli_character_set_name = Returns the default character set name for the current connection.
$temp = mysqli_character_set_name(mysql_ensure_link($link_identifier));
if ($temp === NULL) {
return false;
}
return $temp;
}
# mysql_close - Close MySQL connection
# bool mysql_close ([ resource $link_identifier = NULL ] )
# bool mysqli_close ( mysqli $link )
function mysql_close($link = NULL) {
# mysql_close/mysqli_close = returns TRUE on success or FALSE on failure.
global $mysql_links;
$link = mysql_ensure_link($link);
$thread_id = isset($link->thread_id) && is_numeric($link->thread_id) ? $link->thread_id : false;
$result = mysqli_close($link);
# did the removal suceed and and we have thread id
if ($result && $thread_id) {
# walk the links
foreach ($mysql_links as $k => $v) {
# does this thread-id match the one we just removed?
if ($v['thread_id'] === $thread_id) {
# then remove it from connection array
array_splice($mysql_links, $k, 1);
break;
}
}
# when connection already has been closed this error appears:
# Couldn't fetch mysqli in mysql.php on line xxx
# and this gives null instead of false
} else if ($result === null) {
return false;
}
return $result;
}
# mysql_connect - Open a connection to a MySQL Server
# resource mysql_connect ([ string $server = ini_get("mysql.default_host") [, string $username = ini_get("mysql.default_user") [, string $password = ini_get("mysql.default_password") [, bool $new_link = false [, int $client_flags = 0 ]]]]] )
# mysqli mysqli_connect ([ string $host = ini_get("mysqli.default_host") [, string $username = ini_get("mysqli.default_user") [, string $passwd = ini_get("mysqli.default_pw") [, string $dbname = "" [, int $port = ini_get("mysqli.default_port") [, string $socket = ini_get("mysqli.default_socket") ]]]]]] )
function mysql_connect($server = MYSQL_DEFAULT_HOST, $username = MYSQL_DEFAULT_USER, $password = MYSQL_DEFAULT_PASSWORD, $new_link = false, $client_flags = 0) {
global $mysql_links;
# no newlink but s/u/p matches prev ones-take last link
if (!$new_link) {
global $mysql_links;
# are there prev links?
if (count($mysql_links)) {
# get the last one made
$last = end($mysql_links);
# does the s/u/p match last one?
if ($server === $last['server'] && $username === $last['username'] && $password === $last['password'] && is_resource($last['link'])) {
# then take that
return mysql_ensure_link(NULL);
}
}
}
# try to connect using current credentials
$link = mysqli_connect($server,$username,$password,"");
if (mysqli_connect_errno()) {
# printf("Connect failed: %s\n", mysqli_connect_error());
# die();
return false;
}
# store this
$mysql_links[] = array(
'thread_id' => $link->thread_id,
'server' => $server,
'username' => $username,
'password' => $password,
'link' => $link
);
return $link;
}
# mysql_create_db - Create a MySQL database
# bool mysql_create_db ( string $database_name [, resource $link_identifier = NULL ] )
# CREATE DATABASE
function mysql_create_db($database_name, $link_identifier = NULL) {
# mysql_create_db/mysql_query+CREATE DATABASE = false on error
return mysql_query('CREATE DATABASE '.mysql_real_escape_string($database_name), $link_identifier);
}
# mysql_data_seek - Move internal result pointer
# bool mysql_data_seek ( resource $result , int $row_number )
# bool mysqli_data_seek ( mysqli_result $result , int $offset )
function mysql_data_seek($result , $row_number) {
# mysql_data_seek/mysqli_data_seek = false on error
$temp = mysqli_data_seek($result, $row_number);
if ($temp === NULL) {
return false;
}
return true;
}
# mysql_db_name - Retrieves database name from the call to # mysql_list_dbs
# string mysql_db_name ( resource $result , int $row [, mixed $field = NULL ] )
# SELECT DATABASE()
function mysql_db_name($result , $row, $field = NULL) {
# return mysql_query('SELECT DATABASE()', mysql_ensure_link($link_identifier));
# null does not fit mysql_result
$field = $field === null ? 0 : $field;
return mysql_result($result, $row, $field);
}
# mysql_db_query - Selects a database and executes a query on it
# resource mysql_db_query ( string $database , string $query [, resource $link_identifier = NULL ] )
# mysqli_select_db() then the query
function mysql_db_query($database, $query, $link_identifier = NULL) {
# mysql_db_query = false on error, mysql_query+sql = false on error
if (mysql_select_db($database, $link_identifier) !== true) {
return false;
}
return mysql_query($query, $link_identifier);
}
# mysql_drop_db - Drop (delete) a MySQL database
# bool mysql_drop_db ( string $database_name [, resource $link_identifier = NULL ] )
# DROP DATABASE
function mysql_drop_db($database_name, $link_identifier = NULL) {
# mysql_drop_db = false on error, mysql_query+DROP DATABASE = false on error
return mysql_query('DROP DATABASE '.mysql_real_escape_string($database_name), $link_identifier);
}
# mysql_errno -Returns the numerical value of the error message from previous MySQL operation
# int mysql_errno ([ resource $link_identifier = NULL ] )
# int mysqli_errno ( mysqli $link )
function mysql_errno($link_identifier = NULL) {
# mysql_errno/mysqli_errno = returns a number, 0 if no error
$temp = mysqli_errno (mysql_ensure_link($link_identifier));
if ($temp === NULL) {
return false;
}
return $temp;
}
# mysql_error - Returns the text of the error message from previous MySQL operation
# string mysql_error ([ resource $link_identifier = NULL ] )
# string mysqli_error ( mysqli $link )
function mysql_error($link_identifier = NULL) {
# mysql_error/mysqli_error = returns empty string on no error
$temp = mysqli_error(mysql_ensure_link($link_identifier));
if ($temp === NULL) {
return false;
}
return $temp;
}
# mysql_escape_string - Escapes a string for use in a # mysql_query
# string mysql_escape_string ( string $unescaped_string )
# string mysqli::real_escape_string ( string $escapestr )
function mysql_escape_string($unescaped_string) {
# mysql_escape_string = returns the escaped string
# mysql_real_escape_string = returns FALSE on error
return mysql_real_escape_string($unescaped_string);
}
# mysql_fetch_array - Fetch a result row as an associative array, a numeric array, or both
# array mysql_fetch_array ( resource $result [, int $result_type = MYSQL_BOTH ] )
# mixed mysqli_fetch_array ( mysqli_result $result [, int $resulttype = MYSQLI_BOTH ] )
function mysql_fetch_array($result, $result_type = MYSQL_BOTH) {
# mysql_fetch_array = Returns an array of strings that corresponds to the fetched row, or FALSE if there are no more rows
# mysqli_fetch_array = Returns an array of strings that corresponds to the fetched row or NULL if there are no more rows in resultset
# store the result in a temporarily array
$temp = mysqli_fetch_array($result, $result_type);
# is the result null?
if ($temp === NULL) {
# then return false as the old function did
return false;
}
return $temp;
}
# mysql_fetch_assoc - Fetch a result row as an associative array
# array mysql_fetch_assoc ( resource $result )
# array mysqli_fetch_assoc ( mysqli_result $result )
function mysql_fetch_assoc ($result) {
# mysql_fetch_assoc = returns FALSE if there are no more rows
# mysqli_fetch_assoc = returns NULL if there are no more rows in resultset
$temp = mysqli_fetch_assoc($result);
# is the result null?
if ($temp === NULL) {
# then return false as the old function did
return false;
}
return $temp;
}
# mysql_fetch_field - Get column information from a result and return as an object
# object mysql_fetch_field ( resource $result [, int $field_offset = 0 ] )
# object mysqli_fetch_field ( mysqli_result $result ) - but field_offset is missing
function mysql_fetch_field($result, $field_offset = NULL) {
# if field offset is specified
if (is_numeric($field_offset)) {
# then seek to that
mysqli_field_seek($result, $field_offset);
}
$temp = mysqli_fetch_field($result);
if ($temp === NULL) {
return false;
}
return $temp;
}
# mysql_fetch_lengths - Get the length of each output in a result
# array mysql_fetch_lengths ( resource $result )
# array mysqli_fetch_lengths ( mysqli_result $result )
function mysql_fetch_lengths($result) {
# mysql_fetch_lengths/mysqli_fetch_lengths = FALSE on error
$temp = mysqli_fetch_lengths($result);
if ($temp === NULL) {
return false;
}
return $temp;
}
# mysql_fetch_object - Fetch a result row as an object
# object mysql_fetch_object ( resource $result [, string $class_name [, array $params ]] )
# object mysqli_fetch_object ( mysqli_result $result [, string $class_name [, array $params ]] )
function mysql_fetch_object ($result, $class_name=NULL, $params=NULL) {
# mysql_fetch_object = FALSE if there are no more rows
# mysqli_fetch_object = NULL if there are no more rows in resultset
if ($class_name !== NULL && $params !== NULL) {
$temp = mysqli_fetch_object($result, $class_name, $params);
} else if ($class_name !== NULL) {
$temp = mysqli_fetch_object($result, $class_name);
} else {
$temp = mysqli_fetch_object($result);
}
# is the result null?
if ($temp === NULL) {
# then return false as the old function did
return false;
}
return $temp;
}
# mysql_fetch_row - Get a result row as an enumerated array
# array mysql_fetch_row ( resource $result )
# mixed mysqli_fetch_row ( mysqli_result $result )
function mysql_fetch_row ($result) {
# mysql_fetch_row = FALSE if there are no more rows
# mysqli_fetch_row = NULL if there are no more rows in result set
$temp = mysqli_fetch_row($result);
# is the result null?
if ($temp === NULL) {
# then return false as the old function did
return false;
}
return $temp;
}
# mysql_field_flags - Get the flags associated with the specified field in a result
# string mysql_field_flags ( resource $result , int $field_offset )
# mysqli_fetch_field_direct() [flags]
# -> object mysqli_fetch_field_direct ( mysqli_result $result , int $fieldnr )
function mysql_field_flags($result, $field_offset) {
# mysql_field_flags = FALSE on failure
# mysqli_fetch_field_direct = FALSE if no field information for specified fieldnr is available
$tmp = mysqli_fetch_field_direct($result, $field_offset);
if (!is_object($tmp)) return false;
$tmp = (array)$tmp;
return isset($tmp['flags']) ? mysql_field_bitflags_to_flags($tmp['flags']) : false;
}
# mysql_field_len - Returns the length of the specified field
# int mysql_field_len ( resource $result , int $field_offset )
# mysqli_fetch_field_direct() [length]
# -> object mysqli_fetch_field_direct ( mysqli_result $result , int $fieldnr )
function mysql_field_len($result, $field_offset) {
# mysql_field_len = FALSE on failure
# mysqli_fetch_field_direct = FALSE if no field information for specified fieldnr is available
$tmp = mysqli_fetch_field_direct($result, $field_offset);
if (!is_object($tmp)) return false;
$tmp = (array)$tmp;
return isset($tmp['length']) ? $tmp['length'] : false;
}
# mysql_field_name - Get the name of the specified field in a result
# string mysql_field_name ( resource $result , int $field_offset )
# mysqli_fetch_field_direct() [name] or [orgname]
# -> object mysqli_fetch_field_direct ( mysqli_result $result , int $fieldnr )
function mysql_field_name($result, $field_offset) {
# mysql_field_name = FALSE on failure
# mysqli_fetch_field_direct = FALSE if no field information for specified fieldnr is available
$tmp = mysqli_fetch_field_direct($result, $field_offset);
if (!is_object($tmp)) return false;
$tmp = (array)$tmp;
return isset($tmp['name']) ? $tmp['name'] : false;
}
# mysql_field_seek - Set result pointer to a specified field offset
# bool mysql_field_seek ( resource $result , int $field_offset )
# bool mysqli_field_seek ( mysqli_result $result , int $fieldnr )
function mysql_field_seek($result, $field_offset) {
# mysql_field_seek/mysqli_field_seek = FALSE on failure
$temp = mysqli_field_seek($result, $field_offset);
if ($temp === NULL) {
return false;
}
return $temp;
}
# mysql_field_table - Get name of the table the specified field is in
# string mysql_field_table ( resource $result , int $field_offset )
# mysqli_fetch_field_direct() [table] or [orgtable]
# -> object mysqli_fetch_field_direct ( mysqli_result $result , int $fieldnr )
function mysql_field_table($result, $field_offset) {
# mysql_field_table = error return value not defined
# mysqli_fetch_field_direct = FALSE if no field information for specified fieldnr is available
$tmp = mysqli_fetch_field_direct($result, $field_offset);
if (!is_object($tmp)) return false;
$tmp = (array)$tmp;
return isset($tmp['table']) ? $tmp['table'] : false;
}
# mysql_field_type - Get the type of the specified field in a result
# string mysql_field_type ( resource $result , int $field_offset )
# mysqli_fetch_field_direct() [type]
# -> object mysqli_fetch_field_direct ( mysqli_result $result , int $fieldnr )
function mysql_field_type($result, $field_offset) {
# mysql_field_type = error return value not defined
# mysqli_fetch_field_direct = FALSE if no field information for specified fieldnr is available
$tmp = mysqli_fetch_field_direct($result, $field_offset);
if (!is_object($tmp)) return false;
$tmp = (array)$tmp;
return isset($tmp['type']) ? mysql_field_bittypes_to_types($tmp['type']) : false;
}
# mysql_free_result - Free result memory
# bool mysql_free_result ( resource $result )
# void mysqli_free_result ( mysqli_result $result )
function mysql_free_result($result) {
# mysql_free_result = FALSE on failure
# mysqli_free_result = No value is returned.
mysqli_free_result($result);
# note that mysqli does not return any boolean, so we do it
return true;
}
# mysql_get_client_info - Get MySQL client info
# string mysql_get_client_info ( void )
# string mysqli_get_client_info ( mysqli $link )
function mysql_get_client_info($link_identifier = null) {
# mysql_get_client_info/mysqli_get_client_info = not defined what is returned on error
# note that mysql does not have a link argument while mysqli does
return mysqli_get_client_info(mysql_ensure_link($link_identifier));
}
# mysql_get_host_info - Get MySQL host info
# string mysql_get_host_info ([ resource $link_identifier = NULL ] )
# string mysqli_get_host_info ( mysqli $link )
function mysql_get_host_info ($link_identifier = NULL) {
# mysql_get_host_info = FALSE on failure
# mysqli_get_host_info = error return value not defined
$temp = mysqli_get_host_info(mysql_ensure_link($link_identifier));
if ($temp === NULL) {
return false;
}
return $temp;
}
# mysql_get_proto_info - Get MySQL protocol info
# int mysql_get_proto_info ([ resource $link_identifier = NULL ] )
# int mysqli_get_proto_info ( mysqli $link )
function mysql_get_proto_info($link_identifier = NULL) {
# mysql_get_proto_info = FALSE on failure
# mysqli_get_proto_info = error return value not defined
$temp = mysqli_get_proto_info(mysql_ensure_link($link_identifier));
if ($temp === NULL) {
return false;
}
return $temp;
}
# mysql_get_server_info - Get MySQL server info
# string mysql_get_server_info ([ resource $link_identifier = NULL ] )
# string mysqli_get_server_info ( mysqli $link )
function mysql_get_server_info($link_identifier = NULL) {
# mysql_get_server_info = FALSE on failure
# mysqli_get_server_info = error return value not defined
$temp = mysqli_get_server_info(mysql_ensure_link($link_identifier));
if ($temp === NULL) {
return false;
}
return $temp;
}
# mysql_info - Get information about the most recent query
# string mysql_info ([ resource $link_identifier = NULL ] )
# string mysqli_info ( mysqli $link )
function mysql_info($link_identifier = NULL) {
# mysql_info = FALSE on failure
# mysqli_info = returns empty string on failure
$temp = mysqli_info(mysql_ensure_link($link_identifier));
if ($temp === NULL) {
return false;
}
return $temp;
}
# mysql_insert_id - Get the ID generated in the last query
# int mysql_insert_id ([ resource $link_identifier = NULL ] )
# mixed mysqli_insert_id ( mysqli $link )
function mysql_insert_id($link_identifier = NULL) {
# mysql_insert_id = FALSE if no MySQL connection was established
# mysqli_insert_id = error value not defined
$temp = mysqli_insert_id(mysql_ensure_link($link_identifier));
if ($temp === null) {
return false;
}
return $temp;
}
# mysql_list_dbs - List databases available on a MySQL server
# resource mysql_list_dbs ([ resource $link_identifier = NULL ] )
# SQL Query: SHOW DATABASES
function mysql_list_dbs ($link_identifier = NULL) {
global $mysql_list_dbs_cache;
# mysql_list_dbs/mysql_query = FALSE on failure
$temp = mysql_query('SHOW DATABASES', mysql_ensure_link($link_identifier));
$mysql_list_dbs_cache = $temp;
# when no working link is passed we get null
if ($temp === NULL) {
return false;
}
return $temp;
}
# mysql_list_fields - List MySQL table fields
# resource mysql_list_fields ( string $database_name , string $table_name [, resource $link_identifier = NULL ] )
# SQL Query: SHOW COLUMNS FROM sometable
function mysql_list_fields ($database_name, $table_name, $link_identifier = NULL) {
# mysql_list_fields/mysql_query = FALSE on failure
return mysql_query('SHOW COLUMNS FROM '.mysql_real_escape_string($database_name).'.`'.mysql_real_escape_string($table_name).'`', mysql_ensure_link($link_identifier));
}
# mysql_list_processes - List MySQL processes
# resource mysql_list_processes ([ resource $link_identifier = NULL ] )
# mysqli_thread_id()
function mysql_list_processes($link_identifier = NULL) {
# mysql_list_processes = FALSE on failure
$temp = mysql_query("SHOW PROCESSLIST", mysql_ensure_link($link_identifier));
if ($temp === null) {
return false;
}
return $temp;
}
# mysql_list_tables - List tables in a MySQL database
# resource mysql_list_tables ( string $database [, resource $link_identifier = NULL ] )
# SQL Query: SHOW TABLES FROM sometable
function mysql_list_tables ($database_name, $table_name, $link_identifier = NULL) {
# mysql_list_tables/mysql_query = FALSE on failure
return mysql_query('SHOW TABLES FROM '.mysql_real_escape_string($database_name), mysql_ensure_link($link_identifier));
}
# mysql_num_fields - Get number of fields in result
# int mysql_num_fields ( resource $result )
# int mysqli_field_count ( mysqli $link )
function mysql_num_fields ($result) {
# mysql_num_fields/mysqli_fetch_fields = FALSE on failure
# mysql takes a result, where mysqli takes link and takes the most recent query
# so instead we fetch all the fields and then count that
$tmp = mysqli_fetch_fields($result);
if ($tmp === null) {
return false;
}
return count($tmp);
}
# mysql_num_rows - Get number of rows in result
# int mysql_num_rows ( resource $result )
# int mysqli_num_rows ( mysqli_result $result )
function mysql_num_rows($result) {
# mysql_num_rows = FALSE on failure
# mysqli_num_rows = error return value not defined
return mysqli_num_rows($result);
}
# mysql_pconnect - Open a persistent connection to a MySQL server
# resource mysql_pconnect ([ string $server = ini_get("mysql.default_host") [, string $username = ini_get("mysql.default_user") [, string $password = ini_get("mysql.default_password") [, int $client_flags = 0 ]]]] )
# mysqli_connect() with p: host prefix
function mysql_pconnect($server = MYSQL_DEFAULT_HOST, $username = MYSQL_DEFAULT_USER, $password = MYSQL_DEFAULT_PASSWORD, $client_flags = 0) {
# mysql_pconnect/mysql_connect = FALSE on error
return mysql_connect('p:'.$server, $username, $password, true, $client_flags);
}
# mysql_ping - Ping a server connection or reconnect if there is no connection
# bool mysql_ping ([ resource $link_identifier = NULL ] )
# bool mysqli_ping ( mysqli $link )
function mysql_ping($link_identifier = NULL) {
# mysql_ping/mysqli_ping = FALSE on error
$temp = mysqli_ping(mysql_ensure_link($link_identifier));
if ($temp === NULL) {
return false;
}
return $temp;
}
# mysql_query - Send a MySQL query
# resource mysql_query ( string $query [, resource $link_identifier = NULL ] )
# mixed mysqli_query ( mysqli $link , string $query [, int $resultmode = MYSQLI_STORE_RESULT ] )
function mysql_query ($query, $link_identifier = NULL) {
# mysql_query/mysqli_query = FALSE on error
return mysqli_query(mysql_ensure_link($link_identifier), $query);
}
# mysql_real_escape_string - Escapes special characters in a string for use in an SQL statement
# string mysql_real_escape_string ( string $unescaped_string [, resource $link_identifier = NULL ] )
# string mysqli_real_escape_string ( mysqli $link , string $escapestr )
function mysql_real_escape_string($unescaped_string, $link_identifier = NULL) {
# mysql_real_escape_string = FALSE on error
# mysqli_real_escape_string = error return value not defined
return mysqli_real_escape_string(mysql_ensure_link($link_identifier), $unescaped_string);
}
# mysql_result - Get result data
# string mysql_result ( resource $result , int $row [, mixed $field = 0 ] )
# no equivalent function exists in mysqli - mysqli_data_seek() in conjunction with mysqli_field_seek() and mysqli_fetch_field()
function mysql_result($result , $row , $field = 0) {
# mysql_result = FALSE on failure
# try to seek position, returns false on failure
if (mysqli_data_seek($result, $row) === false) return false;
$row = mysqli_fetch_array($result);
if ($row === NULL || !isset($row[$field])) return false;
return $row[$field];
}
# mysql_select_db - Select a MySQL database
# bool mysql_select_db ( string $database_name [, resource $link_identifier = NULL ] )
function mysql_select_db ($database_name, $link_identifier = NULL) {
# mysql_select_db/mysqli_select_db = FALSE on failure
return mysqli_select_db(mysql_ensure_link($link_identifier), $database_name);
}
# mysql_set_charset - Sets the client character set
# bool mysql_set_charset ( string $charset [, resource $link_identifier = NULL ] )
# bool mysqli_set_charset ( mysqli $link , string $charset )
function mysql_set_charset($charset, $link_identifier = NULL) {
# mysql_set_charset/mysqli_set_charset = FALSE on failure
return mysqli_set_charset(mysql_ensure_link($link_identifier), $charset);
}
# mysql_stat - Get current system status
# string mysql_stat ([ resource $link_identifier = NULL ] )
# string mysqli_stat ( mysqli $link )
function mysql_stat($link_identifier = NULL) {
# mysql_stat = NULL on error
# mysqli_stat = FALSE on error
$temp = mysqli_stat(mysql_ensure_link($link_identifier));
if ($temp === FALSE) {
return NULL;
}
return $temp;
}
# mysql_tablename - Get table name of field
# string mysql_tablename ( resource $result , int $i )
# no mysqli equivalent exists - SHOW TABLES [FROM db_name] [LIKE 'pattern']
function mysql_tablename ($result, $i) {
# return mysql_query('SHOW COLUMNS FROM "'.mysql_real_escape_string($database_name).'.'.mysql_real_escape_string($table_name).'"', mysql_ensure_link($link_identifier));
return mysql_result($result, $i);
}
# mysql_thread_id - Return the current thread ID
# int mysql_thread_id ([ resource $link_identifier = NULL ] )
# int mysqli_thread_id ( mysqli $link )
function mysql_thread_id($link_identifier = NULL) {
# mysql_thread_id = FALSE on failure
# mysqli_thread_id = no error return value defined
$temp = mysqli_thread_id(mysql_ensure_link($link_identifier));
if ($temp === NULL) {
return false;
}
return $temp;
}
}
?>
@berlinpadang18

This comment has been minimized.

Copy link

@berlinpadang18 berlinpadang18 commented Aug 11, 2020

ketika digunakan ada tulisan ini
"Warning: mysqli_query() expects parameter 1 to be mysqli, null given in C:\xampp\htdocs\votingKPU\parser-php-version1.php on line 764
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in C:\xampp\htdocs\votingKPU\parser-php-version1.php on line 764"
itu kenapa ya?

@kumbang-kobum

This comment has been minimized.

Copy link

@kumbang-kobum kumbang-kobum commented Aug 18, 2020

sama aqpun begitu.. admin bantu comen donk

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.