Training Details

Duration: 4 Days
Time: 9:00 AM – 7:00 PM

Course Overview

PHP is the most powerful and widely-used open source server-side scripting language for building database driven dynamic websites.

PHP is used by 81.7% of all websites that are on the internet. Here are just a few of the popular websites running on PHP: Google, Facebook, Apple, Yahoo!, Wikipedia, Digg, SitePoint, Amazon, Ebay, YouTube, Flickr, iStockPhoto, Tumblr, Joomla, WordPress, Drupal, Magento

MySQL is the most popular Open Source SQL database management system that is especially suited to work together with PHP for building dynamic websites and web applications.

Prerequisites

  • Basic computer knowledge and skills in Mac or PC.
  • Must be proficient in both HTML and CSS.

Inclusions

  • Unlimited Refresher Class (Validity : 1 year)
  • Certificate of Course Completion
  • References Materials (PDF)
  • Software Evaluation Copy
  • Other Add-ons

Course Outline

Introduction to PHP
PHP Requirements

  • Local Server
  • Text Editor
  • Web Browser

PHP Version
Basic Syntax

  • PHP Code Block
  • Opening and Closing Tag
  • Display message using echo() and print()

Variables
Constants

  • Arrays
  • Index Array
  • Associative Array
  • Multidimensional Array

Loops

  • For
  • Foreach
  • While
  • Do while

Logical Statement

  • … Else If….Else…. Statement
  • Switch Case Break Statement
  • Ternary Statement

Functions

  • PHP Default Functions
  • Custom Functions
  • Basic Custom Function
  • Custom Function with Arguments
  • Custom Function with Returning Values
  • Anonymous Functions

Introduction to OOP

  • Classes
  • Object
  • Properties
  • Methods
  • Access Modifiers
  • Constructors
  • Inheritance

PHP SuperGlobals using

  • $_POST
  • $_GET
  • $_SESSION
  • $_COOKIE
  • $_FILES
  • $_REQUEST
  • $_SERVER

MySQL Database
Creating Database
Creating Tables

  • Editing Tables
  • Using Single UNIQUE Columns
  • Using Multiple UNIQUE Columns

Deleting Table
Drop Database
Exporting Database
Importing Database
SQL Syntax

  • SELECT Clause
  • INSERT Clause
  • UPDATE Clause
  • DELETE Clause
  • WHERE Clause
  • AND Clause
  • ORDER BY Clause
  • Using ALIASES
  • Using AGGREGATE Functions

MySQL Connection
Inserting Record using HTML Form
Displaying record using SQL Select and PHP loop
Modifying display record using where and order by clause
Updating record using SQL Update
Deleting record using SQL Delete
Creating Pagenation Links
Uploading file
Removing uploaded file inside folder

Registration

Please refer to this link for our scheduled classes: Schedules

Course Fees & Discounts

PHP & MySQL
Course Fee

Php 12,000 Original Price

Php 3,000 less New Student Discount
Php 3,500 less Alumni Discount
HTML & CSS with Bootstrap + PHP & MySQL
2 Course Package

Php 21,500 Original Price
Php 5,000 less Package Discount

Php 16,500 Discounted Price

Course Schedules

july