PHP Easy Tutorial to Database Connections using a PDO class

Why is PDO important?

PDO provides a data-access abstraction layer in PHP, which means that, regardless of what database you’re using, you write the same functions to issue queries and fetch data.  It’s that simple! However, you still need to set a database-specific PDO driver in your php.ini to access the correct database server.

How is this course different?

• This is a hands-on project; no fluff or history lessons that you can always search if you’re interested.

• This updated course was originally written in 2019 using PHP 7.3,
  but it has been reviewed in 2023 using PHP 8.2 to assure its integrity.

• Each section starts with independent code after a brief review of concepts.
  Wash, Rinse, and Repeat.

Upon completion of this project, you should be able to:

1. Summarize and remember the steps involved in using PHP to accomplish a basic database connection and CRUD.
2. Have a solid foundation to take other courses involving PHP and database connections, like using Symfony components, for example.
3. Your PDO training starts here.

The purpose of this short course is to empower you by giving you the basics before you tackle a framework where everything is more abstract. It’s a short study project designed to go slow by repeating core exercises.

Why PHP?

In 2024, PHP still powers 76% of websites around the world. PHP has evolved into a powerful, object oriented language. We are not in 2005 anymore.  The job market is wide open for good PHP developers that take time to study fundamentals.

This project informs and teaches; and that is great for reviewing concepts as well.

Add it to your collection of periodic drills you must do to stay current with the basics.

Subscribe today, even if you want to start at a later date.