by Dave Mercer | Publisher: Virtual Training Company, Inc. | Release Date: February 2004 | ISBN: 01220110041SI

This course will provide in-depth coverage of major PHP syntax, built-in functions of PHP, web application programming techniques and recommended coding solutions based on common PHP requirements. The user will also learn how to create a complete web application using HTML/XHTML/XML, Javascript, Postgres/SQL and then learn to troubleshoot by example. Examples and code for an online card game, shopping cart, email newsletter, content management system and online survey system, are included within the tutorial. To get started today, simply click one of the movie topics below.

1. PHP Projects Introduction
   • PHP Project Solutions Prerequisites 00:04:27
   • Course Introduction - Course Requirements 00:03:10
   • Short History of PHP/HTML/the Web 00:05:28
   • Creating a Web Application with PHP 00:06:35
   • PHP Data Processing in a Web Page 00:04:13
   • Web Interaction with PHP (Query Strings) 00:04:53
   • Web Interaction with PHP (HTML Forms) 00:04:05
2. PHP Sessions and Variables/Connections/SQL
   • Overview 00:02:12
   • Sessions and Variables pt. 1 00:05:03
   • Sessions and Variables pt. 2 00:03:18
   • Sessions and Variables pt. 3 00:04:40
   • Sessions and Variables pt. 4 00:05:50
   • Creating Postgres Database Tables 00:06:06
   • Include Files for Database Connections 00:05:20
   • Running SQL Queries pt. 1 00:06:36
   • Running SQL Queries pt. 2 00:05:24
3. The Admin Area and Login Function
   • Overview 00:02:41
   • Creating the Admin Table and Index File 00:05:06
   • Client-side Validation 00:03:56
   • Server-side Validation 00:05:55
   • Managing Admin Users pt. 1 00:03:50
   • Managing Admin Users pt. 2 00:05:53
   • Managing Registered Customers pt. 1 00:05:14
   • Managing Registered Customers pt. 2 00:02:57
4. Online Card Game
   • Overview 00:05:17
   • The Game Flow 00:05:15
   • Creating the Cards 00:05:05
   • Creating the Screens as Web Pages 00:06:57
   • Creating the Database Tables 00:06:50
   • Generating Random Numbers 00:06:10
   • Creating Card Image and Value Arrays 00:04:07
   • Dealing Cards - Storing Scores 00:06:24
   • Calculating Scores 00:04:01
   • Determining the Next Move 00:07:16
   • Playing the Game 00:03:14
5. Shopping Cart
   • Overview 00:04:38
   • Building Products and Orders Tables pt. 1 00:04:04
   • Building Products and Orders Tables pt. 2 00:04:35
   • Sessions and Arrays 00:06:34
   • Registration Screen 00:05:26
   • Displaying Products 00:06:38
   • Starting an Order 00:04:41
   • Editing and Order pt. 1 00:05:04
   • Editing and Order pt. 2 00:05:02
   • Checking Out and Sending Order 00:05:59
   • Confirmation Screen 00:03:32
   • The Cart in Action 00:05:53
6. Email Newsletter
   • Overview 00:02:55
   • Creating a Newsletter Table 00:02:40
   • Selecting Recipients 00:01:56
   • Composing Newsletters 00:03:08
   • Validating Email Addresses 00:03:18
   • Sending with PHP Mail Functions 00:05:01
   • The Newsletter System in Action 00:03:28
7. Content Management System
   • Overview 00:03:56
   • Storing Content in a Database 00:03:38
   • File System Functions 00:03:13
   • Working With File System Functions 00:04:36
   • Copying Template Files 00:04:44
   • Writing to Files 00:04:27
   • Displaying Files for Editing pt. 1 00:04:12
   • Displaying Files for Editing pt. 2 00:05:03
   • Uploading Files 00:04:42
   • Setting File Permissions 00:02:13
   • Creating Site Pages 00:03:58
   • Editing Site Page Content 00:04:27
   • Uploading Image Files 00:03:00
8. Online Survey System
   • Overview 00:04:03
   • Design Considerations 00:02:51
   • Tables for Polls/Questions/Answers 00:06:02
   • The Logic for Scoring Answers pt. 1 00:04:08
   • The Logic for Scoring Answers pt. 2 00:03:59
   • Creating a Poll and Questions 00:03:58
   • Displaying the Poll 00:05:43
   • Preventing Poll Misuse 00:02:57
   • Creating a Poll in Action 00:06:11
   • Viewing a Poll in Action 00:01:44
9. XML Files
   • Overview 00:04:16
   • What is XML? 00:04:45
   • Parsing XML 00:01:41
   • Displaying XML 00:03:39
   • Creating XML Files from Database Records 00:03:46
   • The Admin Interface Page 00:03:17
   • Editing the XML File 00:02:15
   • Using the XML Functions 00:03:13
10. Applications Map
    • Application and Admin Files and Folders 00:07:15