What are the key differences in function signatures between mysql and mysqli in PHP?

When using MySQL in PHP, the function signatures typically start with "mysql_" followed by the specific function name. However, when using the improved MySQL extension, MySQLi, the function signatures start with "mysqli_" followed by the specific function name. This means that when transitioning from MySQL to MySQLi, you need to update the function calls in your code to match the new function signatures. 

// MySQL
$link = mysql_connect('localhost', 'username', 'password');
mysql_select_db('database_name', $link);

// MySQLi
$link = mysqli_connect('localhost', 'username', 'password');
mysqli_select_db($link, 'database_name');

Keywords

mysql mysqli function signatures differences PHP

Related Questions