Leo: /* Function Name Changes */

2016-01-13T19:49:11Z

Function Name Changes

← Older revision		Revision as of 19:49, 13 January 2016
Line 75:		Line 75:
	\|-		\|-
	\| mysql_real_escape_string		\| mysql_real_escape_string
	\| mysqli_real_escape_string($link)		\| mysqli_real_escape_string($link, $string)
	\|-		\|-
	\| mysql_select_db		\| mysql_select_db

Leo: Created page with "With PHP 7 being released, the old MySQL functions such as {{code|mysql_connect}} have been removed. There are a couple ways to connect to MySQL with PHP 7 or higher: {{code|m..."

2016-01-13T19:46:54Z

Created page with "With PHP 7 being released, the old MySQL functions such as {{code|mysql_connect}} have been removed. There are a couple ways to connect to MySQL with PHP 7 or higher: {{code|m..."

New page

With PHP 7 being released, the old MySQL functions such as {{code|mysql_connect}} have been removed. There are a couple ways to connect to MySQL with PHP 7 or higher: {{code|mysqli}} or the PDO driver.

The simplest way to fix old scripts is to make use of the {{code|mysqli}} alias/facade functions that provide a familiar procedural interface.

== Function Name Changes ==
The procedural function wrappers provided by MySQLi is mostly the same as the deprecated functions. The parameters are also similar with the exception that the MySQL connection link must be passed as the first parameter and is not optional.

{| class="wikitable"
|-
! PHP 5 or lower
! PHP 7 or higher
|-
| mysql_affected_rows
| mysqli_affected_rows($link)
|-
| mysql_close
| mysqli_close($link)
|-
| mysql_data_seek
| mysqli_data_seek($result, $offset)
|-
| mysql_errno
| mysqli_errno($link)
|-
| mysql_error
| mysqli_error($link)
|-
| mysql_fetch_array
| mysqli_fetch_array($result, $type)
|-
| mysql_fetch_assoc
| mysqli_fetch_assoc($result)
|-
| mysql_fetch_lengths
| mysqli_fetch_lengths($result)
|-
| mysql_fetch_object
| mysqli_fetch_object($result, $class, $params)
|-
| mysql_fetch_row
| mysqli_fetch_row($result)
|-
| mysql_field_seek
| mysqli_field_seek($result, $number)
|-
| mysql_free_result
| mysqli_free_result(result)
|-
| mysql_get_client_info
| mysqli_get_client_info($link)
|-
| mysql_get_host_info
| mysqli_get_host_info($link)
|-
| mysql_get_proto_info
| mysqli_get_proto_info($link)
|-
| mysql_get_server_info
| mysqli_get_server_info($link)
|-
| mysql_info
| mysqli_info($link)
|-
| mysql_insert_id
| mysqli_insert_id($link)
|-
| mysql_num_rows
| mysqli_num_rows($result)
|-
| mysql_ping
| mysqli_ping($link)
|-
| mysql_query
| mysqli_query($link, $query)
|-
| mysql_real_escape_string
| mysqli_real_escape_string($link)
|-
| mysql_select_db
| mysqli_select_db($link, $database)
|-
| mysql_set_charset
| mysqli_set_charset($link, $charset)
|-
| mysql_stat
| mysqli_stat($link)
|-
| mysql_thread_id
| mysqli_thread_id($link)
|}

== Example ==

{| class="wikitable"
|-
! style="width: 50%" | PHP 5 or lower
! style="width: 50%" | PHP 7 or higher
|-
| {{highlight|lang=php|code=
$db = mysql_connect('host', 'user', 'password') or die (mysql_error());
mysql_select_db('database', $db);

$result = mysql_query('SELECT * FROM table', $db);

while ($data = mysql_fetch_array($result)) {
echo $data['field1'] . "\n";
}

mysql_close($db);
}}
| {{highlight|lang=php|code=
$db = mysqli_connect('host', 'user', 'password', 'database') or die (mysqli_connect_error($db));

$result = mysql_query($db, 'SELECT * FROM table');

while ($data = mysqli_fetch_array($result)) {
echo $data['field1'] . "\n";
}

mysqli_close($db);
}}
|}

[[Category:Coding]]

PHP MySQL to MySQLi Changes - Revision history

Leo: /* Function Name Changes */

Leo: Created page with "With PHP 7 being released, the old MySQL functions such as {{code|mysql_connect}} have been removed. There are a couple ways to connect to MySQL with PHP 7 or higher: {{code|m..."