
PHP & MySQL for Web Development
Overview
The PHP & MySQL for Web Development course is designed to give delegates the knowledge to develop/maintain HTML/PHP code that utilises the MySQL Database system.
Objectives
On completion of the PHP & MySQL for Web Development course the delegate will have a good practical knowledge of how to write successful HTML/PHP code utilising a MySQL database.
Outline
Course Contents - DAY 1
Course Introduction
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
Session 1: PHP CONFIGURATION
- Working with External Files
- Error Reporting
- Interacting with External Programs
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
Course Contents - DAY 2
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