Web Applications with PHP and MySQL

Course Overview

For those who want to keep their web applications cheap and simple, there is no better way than sticking to the tried and trusted technology of PHP combined with MySQL. PHP has become the de facto way of producing small to medium e-commerce sites, using a straightforward programming model combined with plenty of powerful features. MySQL provides the perfect introduction to databases, as its basic approach provides all that most web databases will need without the encumbrance or inefficiency of unnecessary complexities. They are also both completely free. PHP training and MySQL training thus provide the simplest, cheapest and most painless introduction to e-commerce.

This course first gives just the basic information necessary to build your first e-commerce application, which can be tailored to your requirements. The advanced concepts that are then taught thus make more sense by being seen in the context of your own self-created web site.

What You Will Learn

• The fundamentals of n-tier programming, web applications and middleware.
• Basic PHP structures and syntax.
• Program and Web Page Design.
• MySQL and the basics of Database design
• State management and Security
• Debugging and optimisation
• Advanced features of PHP
• Deployment and configuration of your Web Sites

Audience

Experienced programmers new to Web Applications.

Requirements

Duration

5 days

Structure

Learning Unit 1; The Fundamentals of PHP & n-tier architecture

1.1 The role of n-tier architecture

1.2 Structure and life-cycle of a PHP Web application

1.3 Comparison with CGI, ASP, JSP and Servlets, ASP.NET

Learning Unit 2; Your First Application

2.1 Using a PHP editor

2.2 Creating a basic web page, with PHP functions

2.3 Getting user input with simple forms (using GET and POST)

Learning Unit 3; PHP Language Basics

3.1 Data types, variables, assignment and arithmetic

3.2 Making decisions; if and switch

3.3 Iteration; while, do…while, for loops

3.4 Functions; PHP inbuilt and user-defined

3.5 Arrays

3.6 Debugging, error-handling and validation

Learning Unit 4; Program and Page Design

4.1 Program Structure

4.2 Include and require

4.3 Page Design; graphical objects and CSS

Learning Unit 5; PHP & MySQL

5.1 Introduction to Database Design

5.2 Introduction to SQL

5.3 Simple connection, open and query database and display results

5.4 Creating tables

5.5 Inserting, updating and deleting data

5.6 Complex queries

5.7 Other useful PHP and MySQL functions

5.8 Using the phpMyAdmin tool

Learning Unit 6; State Management and Security

6.1 Cookies

6.2 Sessions

6.3 Security

Learning Unit 7; Advanced features

7.1 PHP and object-orientation

7.2 File and Directory Access

7.3 IP Addresses and URLs from users

7.4 Showing different content to different browsers

7.5 Email

7.6 Shell Commands/Environment variables

7.7 Graphics and Fonts

7.8 XML & XHTML

7.9 LDAP

7.10 PHP and AJAX

Learning Unit 8; System Management

8.1 Installing PHP and MySQL

8.2 Application deployment

8.3 Configuration

8.4 Web Site Management

Back to Top