mysqli¶
The mysqli extension provide access to MySQL database server, with version 4.1 and above. The mysqli extension has replaced the previous mysql extension: the i means improved.
mysqli offers support to OOP and functional API, prepared statement, multiple queries and more.
mysqli is included in PHP core distribution since PHP 5.
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
/* Create table doesn't return a resultset */
$result = $mysqli->query("SELECT * FROM my_table");
?>
See also Developer Quickstart: PHP mysqli and MariaDB.
Related : MySQL, Database, Extensions, PHP Data Objects (PDO), Structured Query Language (SQL), Prepared Query, Object API
