Practice It: PHP with MySQL
54mIntermediate2023-10-20
Authors
Kevin Skoglund
Founder of NovaFabrica
Course details
In this course, get hands-on experience with essential PHP skills like creating, reading, updating, and deleting records in an SQL database—without the hassle of installing and configuring PHP and MySQL. Instructor Kevin Skoglund shows you how to incorporate URL parameters, form data, and error handling as you build web pages for content management. This course offers the flexibility to work with either procedural code, object-oriented code, or both, so you can find the approach that works best for you. Whether you need a refresher on the fundamentals or want to get comfortable with unfamiliar techniques, this course can help you achieve your goals.
Skills covered
MySQLPHPDatabase DevelopmentDatabase ManagementProgramming LanguagesOpen SourceSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - Hands-on practice with PHP and SQL databases
- 02 - Using GitHub Codespaces
1. Using PHP to Work with SQL Records
- 03 - Overview of exercises
- 04 - Try it - Use PHP to display SQL data
- 05 - Check it - Use PHP to display SQL data
- 06 - Try it - List records
- 07 - Check it - List records
- 08 - Try it - Filter records by criteria
- 09 - Check it - Filter records by criteria
- 10 - Try it - Find a record by ID
- 11 - Check it - Find a record by ID
- 12 - Try it - Create a record
- 13 - Check it - Create a record
- 14 - Try it - Update a record
- 15 - Check it - Update a record
- 16 - Try it - Delete a record
- 17 - Check it - Delete a record
Conclusion
- 18 - Continue your practice using PHP with SQL databases
Related courses
- PHP: Accessing Databases with PDO and MySQLi
- Practice It: PHP Classes and Objects
- WordPress Development: Coding Practice
- Writing and Refactoring Testable PHP
- PHP: User Authentication
- Building APIs in PHP Using the Slim Micro Framework
- Web Components and Modularization: Practical Approaches
- Practice It: Java Arrays