PHP With MySQL Essential Training

14h 24m – Beginner

PHP is a popular, reliable programming language at the foundation of many smart, data-driven websites. This comprehensive course from Kevin Skoglund helps developers learn the basics of PHP (including variables, logical expressions, loops, and functions), understand how to connect PHP to a MySQL database, and gain experience developing a complete web application with site navigation, form validation, and a password-protected admin area. Kevin also covers the basic CRUD routines for updating a database, debugging techniques, and usable user interfaces. Along the way, he provides practical advice, offers examples of best practices, and demonstrates refactoring techniques to improve existing code.

Topics include:
What is PHP?
Installing and configuring PHP and MySQL
Exploring data types
Controlling code with logical expressions and loops
Using PHP’s built-in functions
Writing custom functions
Building dynamic webpages
Working with forms and form data
Using cookies and sessions to store data
Connecting to MySQL with PHP
Creating and editing database records
Building a content management system
Adding user authentication

Introduction – 4m 8s
Welcome – 1m 0s
Using the exercise files – 3m 8s

1. PHP Overview – 15m 6s
What is PHP? – 3m 52s
The history of PHP – 2m 51s
Why choose PHP? – 4m 10s
Installation overview – 4m 13s

2. Mac Installation – 54m 53s
Overview – 2m 33s
Working with Apache Web Server – 6m 56s
Changing the document root – 7m 24s
Enabling PHP – 6m 16s
Upgrading PHP – 3m 30s
Configuring PHP – 10m 3s
Installing MySQL – 5m 46s
Configuring MySQL – 7m 24s
Text editor – 5m 1s

3. Windows Installation – 31m 25s
Overview – 3m 27s
Installing WampServer – 5m 46s
Finding the document root – 2m 24s
Configuring PHP – 8m 12s
Configuring MySQL – 5m 45s
Text editor – 5m 51s

4. First Steps – 19m 12s
Embedding PHP code on a page – 6m 43s
Outputting dynamic text – 5m 55s
The operational trail – 2m 27s
Inserting code comments – 4m 7s

5. Exploring Data Types – 1h 18m
Variables – 7m 50s
Strings – 4m 38s
String functions – 8m 54s
Numbers part one: Integers – 6m 27s
Numbers part two: Floating points – 5m 25s
Arrays – 10m 0s
Associative arrays – 6m 37s
Array functions – 6m 33s
Booleans – 3m 50s
NULL and empty – 5m 15s
Type juggling and casting – 8m 27s
Constants – 4m 43s

6. Control Structures: Logical Expressions – 27m 37s
If statements – 6m 0s
Else and elseif statements – 4m 16s
Logical operators – 7m 30s
Switch statements – 9m 51s

7. Control Structures: Loops – 42m 15s
While loops – 8m 41s
For loops – 5m 59s
Foreach loops – 8m 16s
Continue – 8m 28s
Break – 4m 8s
Understanding array pointers – 6m 43s

8. User-Defined Functions – 37m 25s
Defining functions – 8m 25s
Function arguments – 5m 32s
Returning values from a function – 7m 33s
Multiple return values – 4m 53s
Scope and global variables – 6m 2s
Setting default argument values – 5m 0s

9. Debugging – 20m 18s
Common problems – 3m 47s
Warnings and errors – 8m 36s
Debugging and troubleshooting – 7m 55s

10. Building Web Pages with PHP – 57m 57s
Links and URLs – 5m 33s
Using GET values – 5m 35s
Encoding GET values – 8m 41s
Encoding for HTML – 9m 26s
Including and requiring files – 7m 40s
Modifying headers – 6m 45s
Page redirection – 6m 43s
Output buffering – 7m 34s

11. Working with Forms and Form Data – 1h 3m
Building forms – 7m 28s
Detecting form submissions – 5m 59s
Single-page form processing – 7m 57s
Validating form values – 10m 40s
Problems with validation logic – 9m 54s
Displaying validation errors – 7m 23s
Custom validation functions – 6m 28s
Single-page form with validations – 7m 25s

12. Working with Cookies and Sessions – 28m 5s
Working with cookies – 2m 49s
Setting cookie values – 5m 55s
Reading cookie values – 6m 1s
Unsetting cookie values – 4m 51s
Working with sessions – 8m 29s

13. MySQL Basics – 48m 39s
MySQL introduction – 6m 43s
Creating a database – 7m 41s
Creating a database table – 7m 42s
CRUD in MySQL – 5m 48s
Populating a MySQL database – 7m 32s
Relational database tables – 6m 40s
Populating the relational table -6m 33s

14. Using PHP to Access MySQL – 56m 4s
Database APIs in PHP – 4m 51s
Connecting to MySQL with PHP – 7m 45s
Retrieving data from MySQL – 8m 47s
Working with retrieved data – 6m 12s
Creating records with PHP – 6m 58s
Updating and deleting records with PHP – 9m 6s
SQL injection – 3m 5s
Escaping strings for MySQL – 6m 45s
Introducing prepared statements – 2m 35s

15. Building a Content Management System (CMS) – 35m 58s
Blueprinting the application – 7m 19s
Building the CMS database – 5m 14s
Establishing your work area – 4m 38s
Creating and styling the first page – 4m 22s
Making page assets reusable – 6m 36s
Connecting the application to the database -7m 49s

16. Using Site Navigation to Choose Content – 32m 49s
Adding pages to the navigation subjects – 5m 58s
Refactoring the navigation – 6m 7s
Selecting pages from the navigation – 6m 2s
Highlighting the current page – 5m 26s
Moving the navigation to a function – 9m 16s

17. Application CRUD – 1h 45m
Finding a subject in the database – 9m 48s
Refactoring the page selection – 10m 52s
Creating a new subject form – 6m 55s
Processing form values and adding subjects – 11m 20s
Passing data in the session – 9m 16s
Validating form values – 9m 40s
Creating an edit subject form – 8m 30s
Using single-page submission – 7m 44s
Deleting a subject – 9m 44s
Cleaning up – 10m 37s
Assignment: Pages CRUD – 4m 30s
Assignment results: Pages CRUD – 6m 10s

18. Building the Public Area – 39m 26s
The public appearance – 8m 52s
Using a context for conditional code – 11m 37s
Adding a default subject behavior – 6m 9s
The public content area – 5m 51s
Protecting page visibility – 6m 57s

19. Regulating Page Access – 1h 3m
User authentication overview – 4m 3s
Admin CRUD – 8m 41s
Encrypting passwords – 7m 26s
Salting passwords – 5m 42s
Adding password encryption to CMS – 11m 54s
New PHP password functions – 3m 13s
Creating a login system – 11m 28s
Checking for authorization – 5m 48s
Creating a logout page – 5m 40s

Conclusion – 2m 4s
Next steps – 2m 4s

Facebook Comments