• Technical IT

    Solutions delivered throughout the UK
  • Business Applications

    Solutions delivered throughout the UK
  • Professional Best Practice

    Solutions delivered throughout the UK
  • Professional Development

    Solutions delivered throughout the UK

PHP & MySQL for Web Development

  • Price £745.00
  • Duration 2 day(s)
All major credit cards accepted

Description

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.

Skills Gained
The delegate will learn to:

PHP Configuration
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

Who will the Course Benefit?
UNIX and Windows Users, Web Developers and Programmers wishing to create web based systems utilising PHP and MySQL.

Course 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.

Prerequisites

PHP Programming
Introduction to MySQL

Course Content

DAY 1

Course Introduction
Administration and Course Materials
Course Structure and Agenda
Delegate and Trainer Introductions

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


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

Make Enquiry

Course Enquiry
  •  
  •  

Book Now

Course Enquiry
  •  
  •  

Find your local training centre