PHP MySQL to MySQLi Changes: Difference between revisions
From Leo's Notes
This page was last edited on 13 January 2016, at 19:49.
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..." |
|||
| 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 | ||
Latest revision as of 19:49, 13 January 2016
With PHP 7 being released, the old MySQL functions such as mysql_connect have been removed. There are a couple ways to connect to MySQL with PHP 7 or higher: mysqli or the PDO driver.
The simplest way to fix old scripts is to make use of the 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.
| 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, $string) |
| 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
| PHP 5 or lower | PHP 7 or higher |
|---|---|
$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);
|
$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);
|