What are the advantages of using PDO over mysqli in PHP?

When comparing PDO and mysqli in PHP, PDO offers several advantages such as supporting multiple database systems, providing a consistent interface for database access, and allowing for prepared statements to prevent SQL injection attacks. Additionally, PDO offers better error handling capabilities and supports object-oriented programming. 

// Using PDO to connect to a MySQL database
$dsn = 'mysql:host=localhost;dbname=my_database';
$username = 'username';
$password = 'password';

try {
    $pdo = new PDO($dsn, $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}

Keywords

PDO mysqli advantages PHP database connectivity

Related Questions