PHP & MySQL for Web Development - A 2 Day Course
Synopsis
This course is designed to give delegates the knowledge to develop/maintain HTML/PHP code that utilizes the MySQL Database system.
Course Objectives
On completion of the course the delegate will have a good practical knowledge of how to write successful HTML/PHP code utilising a MySQL database. The delegate will learn to:
- 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
Suitable For
UNIX and Windows Users, Web Developers and Programmers wishing to create web based systems utilising PHP and MySQL.
Prerequisites
- PHP Programming
Publicly scheduled dates, locations, and prices
London — £645 (+VAT)
- 20–21 May 2010
- 29–30 Jul 2010
- 16–17 Sep 2010
- 4–5 Nov 2010
- 9–10 Dec 2010
Course Contents
Introduction
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
MySQL
- Installing MySQL
- Testing MySQL
Basic SQL Statements
- Creating Databases and Tables
- Inserting Data into Tables
- Viewing Tables
- UPDATE
- Drop
Connecting to MySQL
- mysql_connect
- mysql_error
- mysql_select_db
- Die
Using PHP to Perform Database Functions
- Inserting Data into a Database
- Creating Queries
- Executing Queries
- Processing the Returned Query Data
- Updating the Database
Generating HTML using PHP
- PHP Inside HTML
- HTML Form with Embedded PHP
- Multiple HTML Pages/Forms with PHP
Email and Cookies using PHP
- Generating Email using PHP
- Generating Cookies using PHP
- Using Cookies
PHP and Database Security
- Designing Databases
- Connecting to Database
- Encrypted Storage Model
- SQL Injection
- Security Techniques
- Error Reporting
- User Submitted Data
