PHP with MySQL Essential Training: 1 The Basics

Introduction

• Welcome
• How to use the exercise files

1. Start a Database-Driven Project

• Blueprint the application
• Establish your work area
• Create and style the first page
• Include and require files
• Make page assets reusable

2. Build Web Pages with PHP

• Links and URLs
• Use URL parameters
• Default values for URL parameters
• Encode URL parameters
• Encode for HTML
• Challenge: Add pages
• Solution: Add pages

3. Headers and Redirects

• Modify headers
• Page redirection
• Output buffering

4. Build Forms with PHP

• Build forms
• Use form parameters
• Detect form submission
• Single-page form processing
• Challenge: Add forms
• Solution: Add forms

5. MySQL Basics

• 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

6. Use PHP to Access MySQL

• Database APIs in PHP
• Connect to MySQL with PHP
• Retrieve data
• Work with retrieved data
• Error handling
• Challenge: List pages
• Solution: List pages

7. CRUD with PHP

• 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

8. Validate Data with PHP

• Common data validation types
• Validate form values
• Display validation errors
• Problems with validation logic
• Challenge: Validations
• Solution: Validations

9. Prevent SQL Injection

• Understand SQL injection
• Sanitize data for SQL
• Delimit data values
• Prepared statements

Conclusion

• Next steps