PDO connection setup in PHP - Mini Project: Build & Apply

PDO connection setup

📖 Scenario: You are building a simple PHP script to connect to a MySQL database using PDO. This is a common task when working with databases in PHP.

🎯 Goal: Create a PHP script that sets up a PDO connection to a MySQL database with given credentials and prints a success message if the connection works.

📋 What You'll Learn

Create a variable with the database connection details

Create a variable for PDO options

Create a PDO object using the connection details and options

Print a success message if the connection is established

💡 Why This Matters

🌍 Real World

Connecting to a database is essential for many web applications to store and retrieve data.

💼 Career

Knowing how to set up a PDO connection is a fundamental skill for PHP developers working with databases.

1

Create the database connection variables

Create four variables: $host with value 'localhost', $dbname with value 'testdb', $username with value 'root', and $password with value '' (empty string).

PHP

# Your code here

Need a hint?

Use simple assignment statements to create these variables with the exact names and values.

2

Create the PDO options array

Create a variable called $options and set it to an array with the key PDO::ATTR_ERRMODE set to PDO::ERRMODE_EXCEPTION.

PHP

<?php
$host = 'localhost';
$dbname = 'testdb';
$username = 'root';
$password = '';

# Your code here

Need a hint?

Use square brackets to create the array and set the error mode to throw exceptions.

3

Create the PDO connection

Create a variable called $pdo and set it to a new PDO object using the DSN string "mysql:host=$host;dbname=$dbname", the $username, the $password, and the $options array.

PHP

 PDO::ERRMODE_EXCEPTION
];

# Your code here

Need a hint?

Use the new PDO() syntax with the correct parameters in order.

4

Print a success message

Write a print statement to display the text 'Connection successful!'.

PHP

 PDO::ERRMODE_EXCEPTION
];

$pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password, $options);

# Your code here

Need a hint?

Use print('Connection successful!'); to show the message.