PDO connection setup in PHP - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does PDO stand for in PHP?

PDO stands for PHP Data Objects. It is a way to connect and work with databases in PHP.

beginner

What is the basic syntax to create a new PDO connection?

Use new PDO(dsn, username, password) where dsn is the data source name, including database type and name.

beginner

Why should you use try-catch blocks when setting up a PDO connection?

To catch errors if the connection fails and handle them gracefully instead of crashing the program.

intermediate

What is the purpose of setting the PDO attribute PDO::ATTR_ERRMODE to PDO::ERRMODE_EXCEPTION?

It makes PDO throw exceptions on errors, which helps in debugging and error handling.

beginner

Show a simple example of PDO connection setup to a MySQL database named 'testdb' on localhost with user 'root' and no password.

try { $pdo = new PDO('mysql:host=localhost;dbname=testdb', 'root', ''); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); echo 'Connected successfully'; } catch (PDOException $e) { echo 'Connection failed: ' . $e->getMessage(); }

What is the correct way to start a PDO connection in PHP?

A PDO_connect('localhost', 'testdb')

B connectPDO('localhost', 'testdb', 'user', 'pass')

C new PDO('mysql:host=localhost;dbname=testdb', 'user', 'pass')

D mysql_connect('localhost', 'user', 'pass')

The correct syntax uses the PDO constructor with a DSN string and credentials.

Why do we use try-catch blocks with PDO connections?

A To handle connection errors without crashing the script

B To speed up the connection

C To encrypt the database password

D To automatically close the connection

Try-catch blocks catch exceptions if the connection fails, allowing graceful error handling.

What does setting PDO::ATTR_ERRMODE to PDO::ERRMODE_EXCEPTION do?

A Makes PDO throw exceptions on errors

B Disables error reporting

C Logs errors to a file

D Automatically retries failed queries

This setting makes PDO throw exceptions, which helps detect and handle errors.

Which of these is NOT part of the DSN string for a MySQL PDO connection?

A charset

B dbname

C host

D user

The username is passed separately, not inside the DSN string.

What will happen if the PDO connection fails and there is no try-catch block?

A The connection will retry automatically

B The script will stop with a fatal error

C The script will ignore the error and continue

D The database will connect anyway

Without try-catch, a failed connection throws a fatal error stopping the script.

Explain how to set up a PDO connection to a MySQL database in PHP.

Think about the steps to connect safely and handle errors.

Why is it important to set PDO error mode to exceptions when connecting to a database?

Consider how errors are handled in your code.