PHP Project Solutions CD Training (CBT)

Duration: 6hrs

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.

Contents:
Getting Started
Introduction

PHP Projects Introduction
PHP Project Solutions Prerequisites
Course Introduction - Course Requirements
Short History of PHP/HTML/the Web
Creating a Web Application with PHP
PHP Data Processing in a Web Page
Web Interaction with PHP (Query Strings)
Web Interaction with PHP (HTML Forms)

PHP Sessions and Variables/Connections/SQL
Overview
Sessions and Variables part 1
Sessions and Variables part 2
Sessions and Variables part 3
Sessions and Variables part 4
Creating Postgres Database Tables
Include Files for Database Connections
Running SQL Queries part 1
Running SQL Queries part 2

The Admin Area and Login Function
Overview
Creating the Admin Table and Index File
Client-side Validation
Server-side Validation
Managing Admin Users part 1
Managing Admin Users part 2
Managing Registered Customers part 1
Managing Registered Customers part 2

Online Card Game
Overview
The Game Flow
Creating the Cards
Creating the Screens as Web Pages
Creating the Database Tables
Generating Random Numbers
Creating Card Image and Value Arrays
Dealing Cards - Storing Scores
Calculating Scores
Determining the Next Move
Playing the Game

Shopping Cart
Overview
Building Products and Orders Tables part 1
Building Products and Orders Tables part 2
Sessions and Arrays
Registration Screen
Displaying Products
Starting an Order
Editing and Order part 1
Editing and Order part 2
Checking Out and Sending Order
Confirmation Screen
The Cart in Action

Email Newsletter
Overview
Creating a Newsletter Table
Selecting Recipients
Composing Newsletters
Validating Email Addresses
Sending with PHP Mail Functions
The Newsletter System in Action

Content Management System
Overview
Storing Content in a Database
File System Functions
Working With File System Functions
Copying Template Files
Writing to Files
Displaying Files for Editing part 1
Displaying Files for Editing part 2
Uploading Files
Setting File Permissions
Creating Site Pages
Editing Site Page Content
Uploading Image Files

Online Survey System
Overview
Design Considerations
Tables for Polls/Questions/Answers
The Logic for Scoring Answers part 1
The Logic for Scoring Answers part 2
Creating a Poll and Questions
Displaying the Poll
Preventing Poll Misuse
Creating a Poll in Action
Viewing a Poll in Action

XML Files
Overview
What is XML?
Parsing XML
Displaying XML
Creating XML Files from Database Records
The Admin Interface Page
Editing the XML File
Using the XML Functions

Applications Map
Application and Admin Files and Folders