Price: AED 745

    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
    Updated on 30 May, 2016

    About Global Academy

    Global Academy is The Talented Academy based in the heart of Cairo in Egypt.  Our main commercial focus is Training, website design and development for smooth running of businesses and promotions online/offline. 

    Oracle Gold Partner - Oracle Approved Education Center - ITIDA Accreditation - ICT Accreditation - Consulting - Outsourcing

    See all Global Academy courses
    Are you from Global Academy ? Claim your course!
    Courses you can instantly connect with... Do an online course on PHP Programming starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?

    or