Return To Main Page

Data Driven Sites with PHP/MySQl

Middle ware packages such as PHP, ASP and ColdFusion are powerful tools for developing dynamic websites. When combined with web authoring tools such as Flash, rich web applications that add value to a users experience, wether it be for education or business, can be achieved. The resources on this page are materials that can be used as a basis to create different applications. Additional resources will be added as they are developed or found.

Handling and manipulating form data
This lesson introduces the basic syntax of PHP. Students are shown how to grab data from an HTML form, manipulate it and write out the results using the echo command.
Control Structures: IF-Then Statements
This page shows example used to help master the concept of IF-THEN statements.
Control Structures: Looping
This page shows example used to help master the concept of looping.
Basic Database Application (under repair) This application shows the basic framework for creating an information system that allows you to add view, edit and delete records to from a database.
Login System
This application shows cookies can be used in a login system.
Popup Login
This script shows how to use http authentication to password protect a single page by displaying a password window that must be correctly completed before the page is displayed.
Sending Emails (under repair)
Shows an example of the use of the mail command.
Flash forms (under repair)
Flash and middleware applications such as PHP and ASP can be combined to create powerful interactive applications. This example shows how data can be sent from Flash to PHP to MySQL and from MySQL to PHP to Flash.
Search Form
Shows how to build a search form using three input fields
File Upload
This page shows how to use php to upload and download files directly into/from a MySQL database
Materials for creating keyword searches
 
Materials for creating dynamic menus
 
Batch Update(under repair)
Being able to make changes to a list of records and submit all the changes at once is a useful feature. This part of the site demonstrates batch updates.