MySQLi

MySQLi is referred to MySQL improved. It is an extension for PHP . This is released together with PHP5 and allows to use MySQL version 4.1.3 or newer.

It is object oriented

Supports to run more than one query at a time

More Secure

Connecting to MySQLi in Object Oriented way is as follow

<?php
$sql = new mysqli('hostname','username','password','databasename');
?>

Procedural way of connecting to database with MySQLi
<?php
$link = mysqli_connect('hostname','username','password','databasename');
?>