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