Overview
-
Learn how to build dynamic, data-driven webpages using PHP with MySQL.
Syllabus
-
Introduction
- Welcome
- How to use the exercise files
- Blueprint the application
- Establish your work area
- Create and style the first page
- Include and require files
- Make page assets reusable
- Links and URLs
- Use URL parameters
- Default values for URL parameters
- Encode URL parameters
- Encode for HTML
- Challenge: Add pages
- Solution: Add pages
- Modify headers
- Page redirection
- Output buffering
- Build forms
- Use form parameters
- Detect form submission
- Single-page form processing
- Challenge: Add forms
- Solution: Add forms
- MySQL introduction
- Create a database
- Create a database table
- CRUD in MySQL
- Populate a MySQL table
- Relational database tables
- Challenge: Pages table
- Solution: Pages table
- Database APIs in PHP
- Connect to MySQL with PHP
- Retrieve data
- Work with retrieved data
- Error handling
- Challenge: List pages
- Solution: List pages
- Find a single record
- Use form data to create records
- Use form data to update records
- Form options from database data
- Delete a record
- Challenge: Pages CRUD
- Solution: Pages CRUD
- Common data validation types
- Validate form values
- Display validation errors
- Problems with validation logic
- Challenge: Validations
- Solution: Validations
- Understand SQL injection
- Sanitize data for SQL
- Delimit data values
- Prepared statements
- Next steps
