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

february

31jan(jan 31)9:00 am02feb(feb 2)7:00 pmHTML5 & CSS3 with BootstrapWeb Development

07feb(feb 7)1:00 am10(feb 10)1:00 amPHP & MySQL Object Oriented ProgrammingWeb Development

14feb(feb 14)1:00 am16(feb 16)1:00 amJavaScript EssentialsWeb Development

14feb(feb 14)1:00 am17(feb 17)1:00 amCodeigniter PHP FrameworkModel-View-Controller (MVC)

15feb(feb 15)9:00 am16(feb 16)7:00 pmDrupal CMSWeb Development

21feb(feb 21)1:00 am24(feb 24)1:00 amLaravel PHP FrameworkModel-View-Controller (MVC)

22feb(feb 22)9:00 am23(feb 23)7:00 pmJoomla CMSWeb Development

22feb(feb 22)9:00 am23(feb 23)7:00 pmWordPress CMSWeb development

28feb01marHTML5 & CSS3 with BootstrapWeb Development

29feb01marWordPress Theming using DiviTheme Development

march

28feb01marHTML5 & CSS3 with BootstrapWeb Development

29feb01marWordPress Theming using DiviTheme Development

06mar(mar 6)1:00 am09(mar 9)1:00 amPHP & MySQLObject Oriented Programming

13mar(mar 13)9:00 am15(mar 15)7:00 pmJavaScript EssentialsWeb Development

14mar(mar 14)9:00 am15(mar 15)7:00 pmWordPress CMSWeb Development

20mar(mar 20)1:00 am23(mar 23)1:00 amLaravel PHP FrameworkModel-View-Controller (MVC)

21mar(mar 21)9:00 am22(mar 22)7:00 pmWordPress Theming with Divi 3.0Theme Development

21mar(mar 21)9:00 am22(mar 22)7:00 pmJoomla CMSWeb Development

27mar(mar 27)9:00 am30(mar 30)7:00 pmCodeigniter PHP FrameworkModel-View-Controller (MVC)

28mar(mar 28)9:00 am29(mar 29)7:00 pmDrupal CMSWeb Development