Course Icon PROGRAMMING Training

PHP & MySQL for Web Development

0800 1337 401

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
See all of the available Technical Courses