PHP Training Course (Web Programming & MySQL Database)

Upcoming Web Design Classes:

Who is this course for?

This course is for you if you are interested in creating a dynamic website with database for yourself or for others. This course is designed for complete beginners of web programming. You must have knowledge of HTML. Some programming experience would be useful. No previous knowledge of PHP and MySQL is required.

Goal oriented approach

This PHP Course is designed to get you started in PHP web programming. If you have a project or an idea that you wanted to turn into a website then present that idea during the course and our trainers will help you to develop your own website.


A main prerequisite to this PHP course is knowledge of HTML, CSS etc - our web design course covers most of these prerequisites.
You should also have worked with concepts like Variable, Loops, Array, Functions, Class, Inheritance in any programming language of your choice. If you have never used these concepts please consider our Introduction to Programming combined with JavaScript & jQuery first.

Course content:

Introduction to dynamic websites
What is PHP?
What is Apache?
Server Side vs. Client Side Scripting
What is MySQL Database?
Why choose PHP and MySQL
Installing PHP, MySQL, phpMyAdmin, Apache web server

PHP Programming
PHP Syntax
Hello world String
PHP variables and data types
PHP Operators
Conditional statements using If, else & Switch
Creating Arrays
Numeric Arrays
Associative Arrays
Array() Construct
PHP For and While Loops
Server Side Includes (SSI)

PHP Functions
Defining your own PHP functions
Functions Parameters
Function return value
Calling a function
PHP Built-in Functions
PHP Date and String functions

PHP Object Oriented Programming (OOP)
Create a Class
Constructor and destructor

HTML Forms and PHP
What is Form
Form elements, Textbox, Textarea, select menu, file attachment, submit and reset button
Form action and method
How to send form data
How to capture and display form data
URL Parameters

PHP Global Variables

MySQL Database:
Database concepts & RDBMS (Relational Database Management Systems)
Introduction to SQL (Structured Query Language)
Creating ERD (Entity Relationship Diagram)
Understanding phpMyAdmin
What are MySQL data types
Creating and Editing Database and Tables
Primary key
Foreign key
Inserting Data in tables
Updating data
Deleting data
Selecting data
Searching for data using SQL Wild cards
Using group functions
MySQL built-in functions
Using table joins
Equi Join & Left Join multiple tables

Create Dynamic Pages using PHP and MySQL
Connect PHP with MySQL
Insert web page data into database
Update data from web pages
View dynamic data on web pages
How to delete data from web pages

How to setup a website development project
Project Structure
Folder and File Structure
Database design

Project 1: Build a Contact us Email Form
Create Form on web page
Accept data
Mail function

Project2: Build a Login system
Create a login page
Connect login page to database
Validate login data
Creating PHP Security using session

Project3: Build an online shop backend CMS

Database for shopping cart website
Add Product page
Upload product image
View products
Delete product from catalogue
Update products
View customers
View online orders

Project4: Create an E-commerce shopping cart website
E-commerce website design
Create a home page
Build a product search
Display e-commerce catalogue
Create a basket page
Add items to basket page
Update items quantity in basket
Remove items from basket
Customer checkout
Register customer details
Save Customer online order
Understand online transaction