PHP Easy Tutorial to Database Connections using a PDO class

PHP Easy Tutorial to Database Connections using a PDO class, available at Free, has an average rating of 4.55, with 54 lectures, based on 57 reviews, and has 1267 subscribers.

You will learn about UNDERSTAND what VANILLA PDO functions already do and stop using legacy code that is confusing you. Gain a SOLID FOUNDATION to take other courses involving PHP and database connections. Learn how to practice new code concepts in the world of code automation The minimalist presentation facilitates your reviewing over time This course is ideal for individuals who are Students of other PHP courses who may still want further explanation on using PDO or Beginner PHP developers with some previous knowledge of syntax or Intermediate web developers wanting to learn more about the PHP 7 PDO class or Database SQL users who want to learn how to connect by using modern PHP techniques or Researchers who are interested in PHP database connectivity or Anyone who wants to know how to connect a MYSQL database to HTML It is particularly useful for Students of other PHP courses who may still want further explanation on using PDO or Beginner PHP developers with some previous knowledge of syntax or Intermediate web developers wanting to learn more about the PHP 7 PDO class or Database SQL users who want to learn how to connect by using modern PHP techniques or Researchers who are interested in PHP database connectivity or Anyone who wants to know how to connect a MYSQL database to HTML.

Enroll now: PHP Easy Tutorial to Database Connections using a PDO class

Summary

Title: PHP Easy Tutorial to Database Connections using a PDO class

Price: Free

Average Rating: 4.55

Number of Lectures: 54

Number of Published Lectures: 53

Number of Curriculum Items: 54

Number of Published Curriculum Objects: 53

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

UNDERSTAND what VANILLA PDO functions already do and stop using legacy code that is confusing you.

Gain a SOLID FOUNDATION to take other courses involving PHP and database connections.

Learn how to practice new code concepts in the world of code automation

The minimalist presentation facilitates your reviewing over time

Who Should Attend

Students of other PHP courses who may still want further explanation on using PDO

Beginner PHP developers with some previous knowledge of syntax

Intermediate web developers wanting to learn more about the PHP 7 PDO class

Database SQL users who want to learn how to connect by using modern PHP techniques

Researchers who are interested in PHP database connectivity

Anyone who wants to know how to connect a MYSQL database to HTML

Target Audiences

Students of other PHP courses who may still want further explanation on using PDO

Beginner PHP developers with some previous knowledge of syntax

Intermediate web developers wanting to learn more about the PHP 7 PDO class

Database SQL users who want to learn how to connect by using modern PHP techniques

Researchers who are interested in PHP database connectivity

Anyone who wants to know how to connect a MYSQL database to HTML

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 empoweryou 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.

Course Curriculum

Chapter 1: Create a MySQL database for testing

Lecture 1: How to do the exercises (use 1.25x speed)

Lecture 2: What is PDO? (use 1.25x speed)

Lecture 3: About your development environment

Lecture 4: Alternative database creation using the terminal

Lecture 5: Creating a database with phpMyAdmin

Lecture 6: Practicing exercise 1 – New database

Chapter 2: Connect to a database using the PHP PDO class

Lecture 1: Making a database connection using PDO

Lecture 2: Using individual variables to hold credential values

Lecture 3: Practicing exercise 2 – Connecting to the blogs database

Lecture 4: Result for exercise 2

Lecture 5: Using a try catch statement to handle PDO connection errors

Lecture 6: Discussed code and resources

Chapter 3: Basic database querying and browser displaying using PHP

Lecture 1: Creating a new database connection

Lecture 2: Note about the next video

Lecture 3: The two PDO methods for querying a database

Lecture 4: Extracting data from the POD Statement

Lecture 5: Discussed code and resources

Lecture 6: Converting special characters to HTML entities

Lecture 7: Review – Things to know

Lecture 8: Moving SQL statements to variables

Lecture 9: Discussed code and resources

Chapter 4: Prepare and execute a MySQL Statement using a PHP PDO object

Lecture 1: Creating a new connection for prepared statements

Lecture 2: Stage 1: Preparing the query

Lecture 3: Stage 2: Executing the query – rowCount

Lecture 4: Discussed code and resources

Lecture 5: Named placeholders

Lecture 6: Submitting the execute function without any arguments. Running multiple queries

Lecture 7: Discussed code and resources

Chapter 5: The insert into statement

Lecture 1: Create a new connection file named dbinsert

Lecture 2: Initial Code

Lecture 3: Inserting a new record with Prepared Statements

Lecture 4: Discussed code and resources

Lecture 5: Displaying the number of affected rows

Lecture 6: Displaying content from the last inserted id

Lecture 7: Preparing output with HTML entities

Lecture 8: Discussed code and resources

Chapter 6: The SQL update statement via a PDO object

Lecture 1: Initial code for this session

Lecture 2: SQL UPDATE with Prepared Statements

Lecture 3: Final code for this session

Chapter 7: The delete statement

Lecture 1: Initial Code

Lecture 2: Deleting a record with Prepared Statements

Lecture 3: Final code for this session

Chapter 8: Odds & ends

Lecture 1: Including a single database credential for multiples files

Lecture 2: Hiding a folder from the browser using htaccess

Lecture 3: Resources for this section

Lecture 4: Fetch arguments

Lecture 5: Final code and resources

Lecture 6: Enabling or disabling emulation of prepared statements (part 1)

Lecture 7: Initial code

Lecture 8: Enabling or disabling emulation of prepared statements (part 2)

Lecture 9: Final code and resources

Lecture 10: Bibliography

Chapter 9: Thank you

Lecture 1: Thank you

Instructors

Tony de Araujo
Tech Writer – Published Author on Programming [Amazon]

Rating Distribution

1 stars: 0 votes

2 stars: 1 votes

3 stars: 3 votes

4 stars: 15 votes

5 stars: 38 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!