PHP & MySQL For Web Development

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.

Course Contents

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

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