PHP 5 and later can work with a MySQL database using

1. MySQLi extension (the "i" stands for improved)

2. PDO (PHP Data Objects)

MySQL Examples in Both MySQLi and PDO Syntax

In this, and in the following chapters we demonstrate three ways of working with PHP and MySQL:

1. MySQLi (Object-oriented)

2. MySQLi (Procedural)

3. PDO

1. Open a Connection to MySQL ( MySQLi Object-Oriented )

<?php
$servername = "localhost";
$username = "username";
$password = "password";

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error)
{
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>

2. Open a Connection to MySQL ( MySQLi Procedural )

<?php
$servername = "localhost";
$username = "username";
$password = "password";

// Create connection
$conn = mysqli_connect($servername, $username, $password);

// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
?>

3. Open a Connection to MySQL ( PDO )

<?php
$servername = "localhost";
$username = "username";
$password = "password";

try
{
$conn = new PDO("mysql:host=$servername;dbname=myDB",
$username, $password);
// set the PDO error mode to exception
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
echo "Connected successfully";
}
catch(PDOException $e)
{
echo "Connection failed: " . $e->getMessage();
}
?>

Close the Connection

The connection will be closed automatically when the script ends. To close the connection before, use the following:

1. MySQLi Object-Oriented

$conn->close();

2. MySQLi Procedural

mysqli_close($conn);

3. PDO

$conn = null;