COURSE 5375 | 3-day SESSION
PHP Programming with MySQL

---

Course Outline

Introductions

• Instructor
  
• Class
  
• Students
  
• Technologies Involved
  • XHTML
    
  • PHP
    
  • SQL
    
  • MySQL
• Resources

Three Second Guide to (X)HTML

• Basic Page
  
• Basic Form
  
• More Form Inputs

Introduction to PHP

• Basic Syntax
  
• Testing Your Installation
  
• Sending Data to the Web Browser
  
• Understanding White Space
  
• Writing Comments

Variables

• Naming Rules
  
• Assigning Values
  
• Printing Values
  
• Strings
  
• Numbers
  
• Arrays

Programming with PHP

• Creating an HTML Form
  
• Handling Form Data
  
• Conditionals and Operators
  • Assignment
    
  • Arithmetic
    
  • Comparison
• Loops
  • For
    
  • While
    
  • Foreach
• Validating Form Data

Introduction to MySQL

• Database Design
  
• Choosing Your Column Types
  
• Choosing Other Column Properties
  
• Using the mysql Client
  
• Using phpMyAdmin
  
  

SQL Basics

• Creating Databases and Tables
  
• Inserting Records
  
• Selecting Data
  
• Using Conditionals
  
• Sorting Query Results
  
• Limiting Query Results
  
• Updating Data
  
• Deleting Data

MySQL Functions

• Text
  
• Number
  
• Date & Time
  

Date Formatting

• Using PHP with MySQL
  
• Connecting to MySQL
  
• Executing Simple Queries
  
• Retrieving Query Results
  
• Counting Returned Records
  
• Updating Records with PHP
  

Improving Security

• Debugging
  
• Revealing Errors
  
• Understanding Errors
  
• Suppressing Errors
  

Debugging Techniques

• Web Application Development
  
• Using Multiple Files
  
• Working with Cookies
  
• Maintaining State with Sessions
  
• Sending Headers
  
• Sending Email
  
• Defining Your Own Functions
  
• Handling File Uploads
  
• PHP's Date & Time Functions

Hands-On Labs:

• Testing a PHP installation
  
• Mathematical and string manipulations
  
• Creating useful HTML forms
  
• Validating all types of form data using PHP
  
• Providing feedback to end users
  
• Designing a database for a participant suggested example
  
• Using PHP to store user-submitted data in a database
  
• Using PHP to retrieve records from a database
  
• Editing database records with PHP
  
• Creating modular, multi-page applications
  
• Using templates to separate content from presentation
  
• User registration, login, and authentication
  
• Restricting access to site content
  
• Send emails using PHP
  
• Handle file uploads and downloads through the Web browser
  
• Tricks and techniques for managing errors and facilitating debugging
  
• Preventing hacks, attacks, and other attempts at malfeasance