Kevin Skoglund - PHP with MySQL Essential Training | 2.03GB
Duration: 14h 24m | Video: AVC 960x600(16:10) 30fps 995kbps | Audio: AAC 128kbps 48KHz 2channels
Released: 2013 | Genre: eLearning | Level: Beginner | Language: English
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.
Content
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
Screenshots:
Download File Size:1.95 GB
|
