Static Webpages are no longer sufficient for the needs of the Internet in the 21st Century. An increasing number of business sites use databases to store data and produce dynamic Webpages.

PHP and mySQL are a cost-effective but powerful solution to building database driven Websites which can be developed on Windows and deployed on either Windows or Unix(Linux)servers. This course does not cover the PHP language itself in great depth but concentrates on getting up and running with the mySQL database, using PHP as the server-side control.

PHP is a powerful, free server-side language which is relatively easy to learn for those who have never programmed before.

Day 1

• Installing PHP, mySQL and Apache Webserver on Windows 2000
  
• Using PHPmyAdmin to create and manage databases
  
• Password protection of private directories on Linux with .htaccess
  
• Using basic SQL language commands
  
• SELECT
  
• DELETE
  
• INSERT
  
• The basics of the PHP language
  
• Printing to the Screen
  
• Variables
  
• Maths functions
  
• Gathering data using Forms
  
• String manipulation and formatting

Day 2

• Control Functions
  
• Arrays
  
• Building your own functions
  
• Includes
  
• The php_info() file
  
• Using PHP to communicate with mySQL
  
• Building a database application
  
• Displaying database information in a table
  
• Managing the database: deleting and updating records
  
• Searching the database
  
• Splitting search results over multiple pages
  
• Displaying alternating row colours

Web development experienced and understanding of SQL commands. The participants should also be conversant with HTML.

The course is aim for participants who already know at least the basic of HTML and has done some programming in a modern programming language before.

Upon successful completion of this course, students will be able to:

• Install and configure PHP, mySQL and Apache Webserver on Windows
  
• How databases are used on the Web
  
• Use PHPmyAdmin to create and edit databases
  
• Query your database with basic SQL commands
  
• Program with basic PHP statements
  
• Use PHP to communicate with your database
  
• Add, Delete and Modify data in the browser
  
• Build a complete Data Management system with PHP and mySQL