What are the advantages of using PDO compared to other methods of accessing databases in PHP?

PDO (PHP Data Objects) offers several advantages over other methods of accessing databases in PHP:

• Versatility: PDO supports many different database systems (MySQL, PostgreSQL, SQLite, Oracle, etc.) through a single interface, making code portability easier.

• Security: PDO supports prepared statements, which protect against SQL injection.

• Object-oriented interface: Code with PDO is cleaner and easier to maintain.

• Error handling flexibility: PDO allows configuring error handling modes (e.g., throwing exceptions).

• Transaction support: Simple management of transactions via methods like beginTransaction(), commit(), rollBack().

Example of using PDO with a prepared statement:

$pdo = new PDO('mysql:host=localhost;dbname=testdb', 'user', 'password');
$stmt = $pdo->prepare('SELECT * FROM users WHERE email = :email');
$stmt->execute(['email' => $email]);
$user = $stmt->fetch(PDO::FETCH_ASSOC);