Advanced PHP Web Development

OUTLINE 1. Introducing the Course

• Getting familiar with the course methodology and format
• Understanding the course objectives and pre-requisites
• Why PHP and MySQL?

2. Introduction to PHP

• Basic Syntax
• Sending Data to the Web Browser
• Understanding PHP, HTML, and White Space
• Writing Comments
• What are Variables?
• About Strings
• About Numbers
• About Constants
• Single vs. Double Quotation Marks

3. Programming with PHP

• Creating an HTML Form
• Handling an HTML Form
• Managing Magic Quotes
• Conditionals and Operators
• Validating Form Data
• What are Arrays?
• For and While Loops

4. Creating Dynamic Web Sites

• Including Multiple Files
• Handling HTML Forms with PHP Redux
• Making Sticky Forms
• Creating and Calling your Own Functions
• Variable Scope
• Date and Time Functions
• Sending Email

5. Introduction to SQL and MySQL

• Choosing your Column Types
• Choosing Other Column Properties
• Using the MySQL Client
• Creating Databases and Tables
• Inserting Records
• Selecting Data
• Using Conditionals
• Using LIKE and NOT LIKE
• Sorting Query Results
• Limiting Query Results
• Updating Data
• Deleting Data
• Using Functions

6. Advanced SQL and MySQL

• Database Design
• Performing Joins
• Grouping Selected Results
• Creating Indexes
• Using Different Table Types
• Performing FULLTEXT Searches
• Database Optimization

7. Error Handling and Debugging

• General Error Types and Debugging
• Displaying PHP Errors
• Adjusting Error Reporting in PHP
• Creating Custom Error Handlers
• Logging PHP Errors
• PHP Debugging Techniques
• SQL and MySQL Debugging Techniques

8. Using PHP with MySQL

• Modifying the Template
• Connecting to MySQL and Selecting the Database
• Executing Simple Queries
• Retrieving Query Results
• Ensuring Secure SQL
• Counting Returned Records
• Updating Records with PHP

9. Web Application Development

• Adjusting Behavior for Server Settings
• Sending Values to a Script Manually
• Using Hidden Form Inputs
• Editing Existing Records
• Paginating Query Results
• Making Sortable Displays
• Understanding HTTP Headers

10. Cookies and Sessions

• Using Cookies
• Using Sessions
• Sessions and Cookies
• Improving Session Security

11. Web Application Security

• More Secure Form Validation
• Handling HTML
• Validating Data by Type
• Form Validation with JavaScript
• Regular Expressions
• Database Security and Encryption

12. Extended Topics

• Handling File Uploads
• PHP and JavaScript
• Using Output Buffering
• Using the Improved MySQL Extension
• New MySQL Features
• Using PEAR

13. Example-Content Management

• Creating the Template
• Creating the Basic Pages
• Managing URLs
• Managing Files

14. Example-User Registration

• Creating the Templates
• Writing the Configuration Scripts
• Creating the Home Page
• Registration
• Activating an Account
• Logging in and Logging Out
• Password Management

15. Example E-Commerce

• Creating the Database
• The Administrative Side
• Creating the Public Template
• The Product Catalogue
• The Shopping Cart
• Recording the Orders

TRAINING METHOD Presentation Discussion Case Study Evaluation FACILITY Training Kit Handout Certificate Lunch + 2x Coffee Break Souvenir Pick Up Participants (Yogyakarta)