MySQLi

The MySQLi Extension (<a href="/facts/MySQL/QEEDNBDP">MySQL</a> Improved) is a <a href="/facts/Relational_database/pEKGmJLy">relational database</a> driver used in the <a href="/facts/PHP/vU6YRJX0">PHP</a> <a href="/facts/Scripting_language/8pF4ajBL">scripting language</a> to provide an interface with MySQL protocol compatible <a href="/facts/Database/VYcpkevb">databases</a> (<a href="/facts/MariaDB/QWobVFIq">MariaDB</a>, <a href="/facts/MySQL/QEEDNBDP">MySQL</a>, <a href="/facts/Percona_Server/oA61b3Pf">Percona Server</a>, <a href="/facts/TiDB/lesmbgpA">TiDB</a>).
There are three main <a href="/facts/API/GMlN4vUr">API</a> options when considering connecting to a MySQL database server:

<ul><li>PHP's MySQL Extension</li>
<li>PHP's MySQLi Extension</li>
<li>PHP Data Objects (PDO)</li></ul>
The PHP code consists of a core, with optional extensions to the core functionality. PHP's MySQL-related extensions, such as the MySQLi extension, and the MySQL extension, are implemented using the PHP extension framework. An extension typically exposes an API to the PHP developer, to allow its facilities to be used programmatically. However, some extensions which use the PHP extension framework do not expose an API to the PHP developer.
The PDO MySQL driver extension, for example, does not expose an API to the PHP developer, but provides an interface to the PDO layer above it.
MySQLi is an improved version of the older PHP MySQL driver, offering various benefits.
The authors of the PHP scripting language recommend using MySQLi when dealing with MySQL server versions 4.1.3 and newer (takes advantage of new functionality).

MySQLi open-in-new

MySQLi