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

april

18apr(apr 18)1:00 am20(apr 20)1:00 amHTML5 & CSS3 with BootstrapWeb Development

18apr(apr 18)9:00 am19(apr 19)7:00 pmWordpress CMSWeb Development

24apr(apr 24)1:00 am26(apr 26)1:00 amJavaScript EssentialsWeb Development

24apr(apr 24)1:00 am27(apr 27)1:00 amCodeigniter PHP FrameworkModel-View-Controller (MVC)

24apr(apr 24)1:00 am27(apr 27)1:00 amLaravel PHP FrameworkModel-View-Controller (MVC)

24apr(apr 24)1:00 am27(apr 27)1:00 amPHP & MySQL Object Oriented Programming

24apr(apr 24)9:00 am27(apr 27)7:00 pmRuby on Rails (R.O.R)Web Development Framework

25apr(apr 25)1:00 am26(apr 26)1:00 amWordPress Theming with Divi 3.0Theme Development

25apr(apr 25)9:00 am26(apr 26)7:00 pmDrupal CMSWeb Development

25apr(apr 25)9:00 am26(apr 26)7:00 pmJoomla CMSWeb Development

may

01may9:00 am03(may 3)7:00 pmHTML5 & CSS3 with BootstrapWeb Development

08may(may 8)1:00 am11(may 11)1:00 amPHP & MySQL Object Oriented ProgrammingWeb Development

15may(may 15)1:00 am17(may 17)1:00 amJavaScript EssentialsWeb Development

16may(may 16)9:00 am17(may 17)7:00 pmWordPress CMSWeb development

22may(may 22)1:00 am24(may 24)1:00 amjQuery Essentialsfor Interactive Web Pages

22may(may 22)1:00 am25(may 25)1:00 amLaravel PHP FrameworkModel-View-Controller (MVC)

23may(may 23)1:00 am24(may 24)1:00 amWordPress Theming using DiviWeb Development

30may(may 30)9:00 am31(may 31)7:00 pmJoomla CMSWeb Development