
PHP Training Course (Web Programming & MySQL Database)
Other courses you might be interested in:
- Web Design
- Graphic Design
- HTML5 & CSS3
- PHP Web Programming
- ASP.NET Web Programming
- WordPress
- SEO
- Mobile Web Design
- HTML Email Newsletter
- MCTS - SQL Server 2008
- JavaScript & jQuery
- iPhone App Development
- Android App Development
- MCSE Certification
- AJAX
- Flash
- iPad app development
- Objective C for Beginners
- After Effects
- Dreamweaver
- Photoshop
- Indesign
- Illustrator
- Digital Marketing
- Social Media
- JavaScript

Training Classroom Address
3-4 Kirby Street,
London,
EC1N 8TS,
UK
To find out the next start date for this course please contact us here.
- Classroom based course
- eNotes included
- Hands on training
- Free online support after course
You can SAVE upto £400 when you book your place for 2 or more certain courses
-100

PHP Web Programming

ASP.NET Web Programming
-200

Web Design

PHP Web Programming

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.Prerequisites:
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:
IntroductionIntroduction 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