Differences

This shows you the differences between two versions of the page.

--- mysql:database_api [2016/10/13 15:52] – peter
+++ mysql:database_api [2020/07/15 09:30] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ====== MySQL - Database API ======
+PHP offers three different APIs to connect to MySQL.
 ===== Choosing an API =====
@@ Line 7: / Line 9: @@
 <code php>
 <?php
-// mysqli
-$mysqli = new mysqli("example.com", "user", "password", "database");
-$result = $mysqli->query("SELECT 'Hello, dear MySQL user!' AS _message FROM DUAL");
-$row = $result->fetch_assoc();
-echo htmlentities($row['_message']);
 // PDO
 $pdo = new PDO('mysql:host=example.com;dbname=database', 'user', 'password');
 $statement = $pdo->query("SELECT 'Hello, dear MySQL user!' AS _message FROM DUAL");
 $row = $statement->fetch(PDO::FETCH_ASSOC);
+echo htmlentities($row['_message']);
+// mysqli
+$mysqli = new mysqli("example.com", "user", "password", "database");
+$result = $mysqli->query("SELECT 'Hello, dear MySQL user!' AS _message FROM DUAL");
+$row = $result->fetch_assoc();
 echo htmlentities($row['_message']);
@@ Line 29: / Line 31: @@
 It is recommended to use either the PDO_MySQL or mysqli extensions.  It is not recommended to use the old mysql extension for new development, as it was deprecated in PHP 5.5.0 and was removed in PHP 7.
+PDO has the advantage that you only need to learn one PHP API if you need to work with different DBMS in the future.
+MySQLi is more powerful and probably more complex to learn.