PHP with MySQL Essential Training: 1 The Basics

Course details

PHP is a popular programming language and the foundation of many smart, data-driven websites. This comprehensive course from Kevin Skoglund helps developers learn to use PHP to build interconnected webpages with dynamic content which can pass data between pages. Learn how PHP can simplify the creation of forms, read and validate form data, and display errors. Kevin also covers the fundamentals of MySQL and how to use PHP to efficiently and securely interact with a database to store and retrieve data. Throughout the course, he provides practical advice and offers examples of best practices.

Learning objectives
Organizing project files
Including and requiring files
Working with URL parameters
Encoding dynamic content
Modifying headers and page redirection
Creating forms and processing form data
MySQL basics
Using PHP to access database tables
Creating, reading, updating, and deleting database records with PHP
Validating data
Preventing SQL injection

Concepts

0. Introduction

01 - PHP with MySQL Essential Training - The Basics
02 - How to use the exercise files

1. Start a Database-Driven Project

03 - Blueprint the application
04 - Establish your work area
05 - Create and style the first page
06 - Include and require files
07 - Make page assets reusable

2. Build Web Pages with PHP

08 - Links and URLs
09 - Use URL parameters
10 - Default values for URL parameters
11 - Encode URL parameters
12 - Encode for HTML
13 - Challenge - Add pages
14 - Solution - Add pages

3. Headers and Redirects

15 - Modify headers
16 - Page redirection
17 - Output buffering

4. Build Forms with PHP

18 - Build forms
19 - Use form parameters
20 - Detect form submission
21 - Single-page form processing
22 - Challenge - Add forms
23 - Solution - Add forms

5. MySQL Basics

24 - MySQL introduction
25 - Create a database
26 - Create a database table
27 - CRUD in MySQL
28 - Populate a MySQL table
29 - Relational database tables
30 - Challenge - Pages table
31 - Solution - Pages table

6. Use PHP to Access MySQL

32 - Database APIs in PHP
33 - Connect to MySQL with PHP
34 - Retrieve data
35 - Work with retrieved data
36 - Error handling
37 - Challenge - List pages
38 - Solution - List pages

7. CRUD with PHP

39 - Find a single record
40 - Use form data to create records
41 - Use form data to update records
42 - Form options from database data
43 - Delete a record
44 - Challenge - Pages CRUD
45 - Solution - Pages CRUD

8. Validate Data with PHP

46 - Common data validation types
47 - Validate form values
48 - Display validation errors
49 - Problems with validation logic
50 - Challenge - Validations
51 - Solution - Validations

9. Prevent SQL Injection

52 - Understand SQL injection
53 - Sanitize data for SQL
54 - Delimit data values
55 - Prepared statements

Conclusion

56 - Next steps