This course is intended for UNIX and Windows Users, Web Developers and Programmers wishing to create web based systems utilising PHP and MySQL.

• Install and Test MySQL
• Basic SQL Syntax
• Connect to a MySQL Database with Error Checking
• Use PHP to Interact with a MySQL Database
• Utilise PHP with the HTML Environment
• Work with Email and Cookies
• Consider Security Implications when using PHP and MySQL

Session 1: MySQL

• Installing MySQL
• Testing MySQL

Session 2: BASIC SQL STATEMENTS

• Creating Databases and Tables
• Inserting Data into Tables
• Viewing Tables
• UPDATE
• Drop

Session 3: CONNECTING TO MySQL

• mysql_connect
• mysql_error
• mysql_select_db
• Die

Session 4: USING PHP TO PERFORM DATABASE FUNCTIONS

• Inserting Data into a Database
• Creating Queries
• Executing Queries
• Processing the Returned Query Data
• Updating the Database

Session 5: GENERATING HTML USING PHP

• PHP Inside HTML
• HTML Form with Embedded PHP
• Multiple HTML Pages/Forms with PHP

Session 6: EMAIL AND COOKIES USING PHP

• Generating Email using PHP
• Generating Cookies using PHP
• Using Cookies

Session 7: PHP AND DATABASE SECURITY

• Designing Databases
• Connecting to Database
• Encrypted Storage Model
• SQL Injection
• Security Techniques
• Error Reporting
• User Submitted Data

• APH, Apache Web Server
• MYSI, Introduction to MySQL
• PERL, Perl Programming