Revision history [back]

Here are some of the basic PDO code that you can change to mysqli code:

1. Opening a connection to the database: PDO:

$pdo = new PDO('mysql:host=localhost;dbname=mydatabase', 'username', 'password');

Mysqli:

$mysqli = new mysqli('localhost', 'username', 'password', 'mydatabase');

1. Executing a prepared statement: PDO:

$stmt = $pdo->prepare('SELECT * FROM users WHERE id = ?');
$stmt->execute([$id]);
$user = $stmt->fetch();

Mysqli:

$stmt = $mysqli->prepare('SELECT * FROM users WHERE id = ?');
$stmt->bind_param('i', $id);
$stmt->execute();
$result = $stmt->get_result();
$user = $result->fetch_assoc();

1. Inserting data into the database: PDO:

$stmt = $pdo->prepare('INSERT INTO users(name, email) VALUES(:name, :email)');
$stmt->execute(['name' => $name, 'email' => $email]);

Mysqli:

$stmt = $mysqli->prepare('INSERT INTO users(name, email) VALUES(?, ?)');
$stmt->bind_param('ss', $name, $email);
$stmt->execute();

1. Retrieving the last inserted ID: PDO:

$id = $pdo->lastInsertId();

Mysqli:

$id = $mysqli->insert_id;

1. Handling errors: PDO:

try {
    // Execute PDO code here
} catch(PDOException $e) {
    echo 'Error: ' . $e->getMessage();
}

Mysqli:

if(!$mysqli->query('SELECT * FROM users')) {
    echo 'Error: ' . $mysqli->error;
}