Database Connection With PDO

Understand how to initialize a MySQL database connection using PHP's PDO extension. Learn to organize connection settings, run SQL files to create and populate the database, and implement error handling with try/catch blocks.

We'll cover the following...

Run the installer
Wrap up

PDO (PHP Data Objects) is an extension that enables connection to any SQL database.

Let’s see how we can use this extension.

At the root our project, we’ll create a new file and call it install.php. Inside the file, we’ll create a new PDO() and store it under the $connection variable.

$connection = new PDO(params);

The parameters required for this process are:

DSN (data source name) that defines database type, host name, database name (optional)
The DSN (data source name), which defines the database type, host name, and database name (optional)
Username
Password
Additional options, such as encoding and error

Let’s ...

1.Introduction

2.App Initialization

3.Create and Read Records

4.Refactor the Application

5.PHP Data Validation

6.Generate Reports

7.Update and Delete Records

8.PHP Router

9.Conclusion

10.Appendix

Database Connection With PDO