VTC: PHP Project Solutions Tutorials

Course: PHP Project Solutions

Author: Dave Mercer

SKU: 33475

ISBN: 1932072713

Release Date: 2004-02-10

Duration: 6.5 hrs / 87 lessons

Work Files: Yes

Captions: No

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.

PHP Projects Introduction
PHP Project Solutions Prerequisites (04:27)
Course Introduction - Course Requirements (03:10)
Short History of PHP/HTML/the Web (05:29)
Creating a Web Application with PHP (06:35)
PHP Data Processing in a Web Page (04:13)
Web Interaction with PHP (Query Strings) (04:54)
Web Interaction with PHP (HTML Forms) (04:05)

PHP Sessions and Variables/Connections/SQL
Overview (02:13)
Sessions and Variables pt. 1 (05:04)
Sessions and Variables pt. 2 (03:18)
Sessions and Variables pt. 3 (04:41)
Sessions and Variables pt. 4 (05:51)
Creating Postgres Database Tables (06:07)
Include Files for Database Connections (05:20)
Running SQL Queries pt. 1 (06:35)
Running SQL Queries pt. 2 (05:24)

The Admin Area and Login Function
Overview (02:41)
Creating the Admin Table and Index File (05:06)
Client-side Validation (03:56)
Server-side Validation (05:55)
Managing Admin Users pt. 1 (03:51)
Managing Admin Users pt. 2 (05:55)
Managing Registered Customers pt. 1 (05:14)
Managing Registered Customers pt. 2 (02:57)

Online Card Game
Overview (05:17)
The Game Flow (05:15)
Creating the Cards (05:05)
Creating the Screens as Web Pages (06:58)
Creating the Database Tables (06:50)
Generating Random Numbers (06:11)
Creating Card Image and Value Arrays (04:07)
Dealing Cards - Storing Scores (06:25)
Calculating Scores (04:02)
Determining the Next Move (07:16)
Playing the Game (03:15)

Shopping Cart
Overview (04:38)
Building Products and Orders Tables pt. 1 (04:04)
Building Products and Orders Tables pt. 2 (04:35)
Sessions and Arrays (06:34)
Registration Screen (05:26)
Displaying Products (06:38)
Starting an Order (04:41)
Editing and Order pt. 1 (05:04)
Editing and Order pt. 2 (05:03)
Checking Out and Sending Order (05:59)
Confirmation Screen (03:33)
The Cart in Action (05:53)

Email Newsletter
Overview (02:56)
Creating a Newsletter Table (02:40)
Selecting Recipients (01:56)
Composing Newsletters (03:08)
Validating Email Addresses (03:18)
Sending with PHP Mail Functions (05:01)
The Newsletter System in Action (03:28)

Content Management System
Overview (03:56)
Storing Content in a Database (03:38)
File System Functions (03:13)
Working With File System Functions (04:36)
Copying Template Files (04:44)
Writing to Files (04:27)
Displaying Files for Editing pt. 1 (04:13)
Displaying Files for Editing pt. 2 (05:03)
Uploading Files (04:42)
Setting File Permissions (02:13)
Creating Site Pages (03:59)
Editing Site Page Content (04:27)
Uploading Image Files (03:00)

Online Survey System
Overview (04:03)
Design Considerations (02:51)
Tables for Polls/Questions/Answers (06:03)
The Logic for Scoring Answers pt. 1 (04:08)
The Logic for Scoring Answers pt. 2 (03:59)
Creating a Poll and Questions (03:58)
Displaying the Poll (05:43)
Preventing Poll Misuse (02:57)
Creating a Poll in Action (06:11)
Viewing a Poll in Action (01:44)

XML Files
Overview (04:16)
What is XML? (04:45)
Parsing XML (01:42)
Displaying XML (03:39)
Creating XML Files from Database Records (03:46)
The Admin Interface Page (03:17)
Editing the XML File (02:15)
Using the XML Functions (03:13)

Applications Map
Application and Admin Files and Folders (07:16)

Credits
About this Author (02:06)

more info @http://www.vtc.com/products/PHP-Project-Solutions-tutorials.htm

http://rapidshare.com/files/148426515/VTC_-_PHP_Project_Solutions_Tutorials.rar.html