Learn how to connect a form to a database in PHP using PHP PDO. This course teaches how to establish a connection between PHP forms and a MySQL database, enabling CRUD operations such as Select, Insert, Update, and Delete. The course covers creating the PDO Connection file, building SQL queries, working with query results, and adding CSS styles to the application. The teaching method involves a step-by-step tutorial with practical examples and demonstrations. This course is designed for beginners in web development who have basic knowledge of PHP and want to enhance their skills by learning how to interact with databases.
How to Connect a Form to a Database in PHP - PDO Tutorial
Overview
Syllabus
Intro
A Note About Setup
Importing the World database
Creating the PDO Connection file
Creating the index page forms
Filtering Submitted Form Input
Building and Executing a SQL Select Query in PHP
Building and Executing a SQL Insert Query in PHP
Review the Logical Flow of the Application
Working with the results of the SQL Select Query
Creating the Update and Delete Forms
Reviewing the Logical Flow of the Application again
Creating the delete_record.php file
Creating the update_record.php file
A note about PHP files
Adding a confirmation to the index file
Reviewing the application in the browser
Testing and Debugging!
Adding CSS Styles
Discovering one more issue...and fixing it!
Finishing the CSS styling
Taught by
Dave Gray
