PHP Training

Course details

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.

Prerequisites:

A main prerequisite to this PHP course is knowledge of HTML, CSS etc - our web design course covers most of these prerequisites. 
It is not necessary to have knowledge of any programming language before you start this PHP course but it is beneficial if you have a basic knowledge of any programming language.

Course content:
Introduction

• 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
• Object

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

• POST and GET
• Cookies
• Session

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