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.

Practice

1. What is the main purpose of using PDO in PHP?

easy

A. To connect to databases securely and easily

B. To create HTML pages

C. To handle user sessions

D. To send emails

Solution

1. Step 1: Understand PDO's role

   PDO is a PHP extension designed to connect to databases in a secure and consistent way.

2. Step 2: Compare other options

   Other options like creating HTML, handling sessions, or sending emails are unrelated to PDO.

3. Final Answer:

   To connect to databases securely and easily -> Option A

4. Quick Check:

   PDO = Secure database connection [OK]

Hint: PDO is for database connections only [OK]

Common Mistakes:

• Confusing PDO with HTML or session functions
• Thinking PDO sends emails
• Assuming PDO is for file handling

2. Which of the following is the correct way to create a new PDO connection to a MySQL database named 'testdb' on localhost with username 'user' and password 'pass'?

easy

A. $pdo = new PDO('host=localhost;dbname=testdb', 'user', 'pass');

B. $pdo = new PDO('mysql:localhost;dbname=testdb', 'user', 'pass');

C. $pdo = new PDO('mysql://localhost/testdb', 'user', 'pass');

D. $pdo = new PDO('mysql:host=localhost;dbname=testdb', 'user', 'pass');

Solution

1. Step 1: Check DSN format for MySQL

   The correct DSN format is 'mysql:host=hostname;dbname=database_name'.

2. Step 2: Verify options

   $pdo = new PDO('mysql:host=localhost;dbname=testdb', 'user', 'pass'); uses the correct DSN format with host and dbname separated by semicolon and includes username and password.

3. Final Answer:

   $pdo = new PDO('mysql:host=localhost;dbname=testdb', 'user', 'pass'); -> Option D

4. Quick Check:

   DSN format = 'mysql:host=...;dbname=...' [OK]

Hint: DSN must start with 'mysql:' and use semicolons [OK]

Common Mistakes:

• Omitting 'mysql:' prefix
• Using slashes instead of semicolons
• Missing 'host=' keyword

3. What will be the output of this PHP code snippet?

$dsn = 'mysql:host=localhost;dbname=testdb';
try {
    $pdo = new PDO($dsn, 'user', 'wrongpass');
    echo 'Connected';
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}

medium

A. Connected

B. Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'user'@'localhost' (using password: YES)

C. Syntax error

D. No output

Solution

1. Step 1: Analyze connection attempt

   The code tries to connect with username 'user' but a wrong password 'wrongpass'.

2. Step 2: Understand error handling

   PDO throws a PDOException on failure, caught by catch block, which prints the error message.

3. Final Answer:

   Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'user'@'localhost' (using password: YES) -> Option B

4. Quick Check:

   Wrong password triggers exception message [OK]

Hint: Wrong password triggers exception message [OK]

Common Mistakes:

• Expecting 'Connected' despite wrong password
• Ignoring try-catch block
• Assuming no output on failure

4. Identify the error in this PDO connection code:

try {
    $pdo = new PDO('mysql:host=localhost;dbname=testdb', 'user', 'pass');
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    echo 'Error: ' . $e->getMessage();
}

medium

A. Missing DSN string

B. Incorrect error mode constant

C. No error, code is correct

D. Missing semicolon after setAttribute

Solution

1. Step 1: Review DSN and credentials

   The DSN string is correct and includes host and dbname properly.

2. Step 2: Check error mode setting

   PDO::ATTR_ERRMODE and PDO::ERRMODE_EXCEPTION are valid constants to enable exceptions on errors.

3. Step 3: Verify syntax

   All lines end with semicolons and try-catch is properly structured.

4. Final Answer:

   No error, code is correct -> Option C

5. Quick Check:

   Correct DSN and error mode = no error [OK]

Hint: Check constants and syntax carefully [OK]

Common Mistakes:

• Using wrong error mode constants
• Forgetting semicolons
• Miswriting DSN string

5. You want to connect to a MySQL database using PDO and ensure that any connection error throws an exception. Which code snippet correctly sets up the connection and error handling?

hard

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

B. try {
$pdo = new PDO('mysql:host=localhost;dbname=testdb', 'user', 'pass');
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
} catch (Exception $e) {
echo 'Error';
}

C. $pdo = new PDO('mysql:host=localhost;dbname=testdb', 'user', 'pass');
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);

D. try {
$pdo = new PDO('mysql:host=localhost;dbname=testdb', 'user', 'pass');
} catch (PDOException $e) {
echo 'Error: ' . $e->getMessage();
}
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

Solution

1. Step 1: Check error mode setting

   Setting PDO::ATTR_ERRMODE to PDO::ERRMODE_EXCEPTION ensures exceptions on errors.

2. Step 2: Verify try-catch placement

   The error mode must be set inside the try block before any database operations, so exceptions are caught properly.

3. Step 3: Analyze options

   try { $pdo = new PDO('mysql:host=localhost;dbname=testdb', 'user', 'pass'); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { echo 'Connection failed: ' . $e->getMessage(); } correctly sets error mode inside try and catches PDOException with detailed message.

4. Final Answer:

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

5. Quick Check:

   Error mode exception + try-catch = try { $pdo = new PDO('mysql:host=localhost;dbname=testdb', 'user', 'pass'); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { echo 'Connection failed: ' . $e->getMessage(); } [OK]

Hint: Set error mode to exception inside try block [OK]

Common Mistakes:

• Setting error mode outside try block
• Using wrong error mode constants
• Catching wrong exception type