2015
Lynda
Kevin Skoglund
14:24
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.
Introduction
Welcome
Using the exercise files
1. PHP Overview
What is PHP?
The history of PHP
Why choose PHP?
Installation overview
2. Mac Installation
Overview
Working with Apache Web Server
Changing the document root
Installing to Yosemite NEW
Enabling PHP
Upgrading PHP
Configuring PHP
Installing MySQL
Configuring MySQL
Text editor
3. Windows Installation
Overview
Installing WampServer
Finding the document root
Configuring PHP
Configuring MySQL
Text editor
4. First Steps
Embedding PHP code on a page
Outputting dynamic text
The operational trail
Inserting code comments
5. Exploring Data Types
Variables
Strings
String functions
Numbers part one: Integers
Numbers part two: Floating points
Arrays
Associative arrays
Array functions
Booleans
NULL and empty
Type juggling and casting
Constants
6. Control Structures: Logical Expressions
If statements
Else and elseif statements
Logical operators
Switch statements
7. Control Structures: Loops
While loops
For loops
Foreach loops
Continue
Break
Understanding array pointers
8. User-Defined Functions
Defining functions
Function arguments
Returning values from a function
Multiple return values
Scope and global variables
Setting default argument values
9. Debugging
Common problems
Warnings and errors
Debugging and troubleshooting
10. Building Web Pages with PHP
Links and URLs
Using GET values
Encoding GET values
Encoding for HTML
Including and requiring files
Modifying headers
Page redirection
Output buffering
11. Working with Forms and Form Data
Building forms
Detecting form submissions
Single-page form processing
Validating form values
Problems with validation logic
Displaying validation errors
Custom validation functions
Single-page form with validations
12. Working with Cookies and Sessions
Working with cookies
Setting cookie values
Reading cookie values
Unsetting cookie values
Working with sessions
13. MySQL Basics
MySQL introduction
Creating a database
Creating a database table
CRUD in MySQL
Populating a MySQL database
Relational database tables
Populating the relational table
14. Using PHP to Access MySQL
Database APIs in PHP
Connecting to MySQL with PHP
Retrieving data from MySQL
Working with retrieved data
Creating records with PHP
Updating and deleting records with PHP
SQL injection
Escaping strings for MySQL
Introducing prepared statements
15. Building a Content Management System (CMS)
Blueprinting the application
Building the CMS database
Establishing your work area
Creating and styling the first page
Making page assets reusable
Connecting the application to the database
16. Using Site Navigation to Choose Content
Adding pages to the navigation subjects
Refactoring the navigation
Selecting pages from the navigation
Highlighting the current page
Moving the navigation to a function
17. Application CRUD
Finding a subject in the database
Refactoring the page selection
Creating a new subject form
Processing form values and adding subjects
Passing data in the session
Validating form values
Creating an edit subject form
Using single-page submission
Deleting a subject
Cleaning up
Assignment: Pages CRUD
Assignment results: Pages CRUD
18. Building the Public Area
The public appearance
Using a context for conditional code
Adding a default subject behavior
The public content area
Protecting page visibility
19. Regulating Page Access
User authentication overview
Admin CRUD
Encrypting passwords
Salting passwords
Adding password encryption to CMS
New PHP password functions
Creating a login system
Checking for authorization
Creating a logout page
Conclusion
Next steps
http://www.lynda.com/
Download File Size:1.48 GB
|
