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

may

16may(may 16)9:00 am18(may 18)7:00 pmHTML5 & CSS3 with Bootstrap 4Web 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 amPHP & MySQL Object Oriented ProgrammingWeb Development

23may(may 23)9:00 am24(may 24)7:00 pmWordPress CMSWeb development

29may(may 29)1:00 am31(may 31)1:00 amjQuery Essentialsfor Interactive Web Pages

29may(may 29)1:00 am31(may 31)1:00 amJavaScript EssentialsWeb Development

29may01junLaravel PHP FrameworkModel-View-Controller (MVC)

30may(may 30)1:00 am31(may 31)1:00 amWordPress Theming using DiviWeb Development

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

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

june

29may01junLaravel PHP FrameworkModel-View-Controller (MVC)

05jun(jun 5)9:00 am07(jun 7)7:00 pmHTML5 & CSS3 with BootstrapWeb Development

12jun(jun 12)1:00 am15(jun 15)1:00 amPHP & MySQL Object Oriented ProgrammingWeb Development

19jun(jun 19)1:00 am21(jun 21)1:00 amJavaScript EssentialsWeb Development

20jun(jun 20)9:00 am21(jun 21)7:00 pmDrupal CMSWeb Development

20jun(jun 20)9:00 am21(jun 21)7:00 pmWordPress CMSWeb development

26jun(jun 26)1:00 am28(jun 28)1:00 amjQuery Essentialsfor Interactive Web Pages

26jun(jun 26)1:00 am29(jun 29)1:00 amLaravel PHP FrameworkModel-View-Controller (MVC)

26jun(jun 26)9:00 am29(jun 29)7:00 pmCodeIgniter PHP FrameworkModel-View-Controller (MVC)

27jun(jun 27)1:00 am28(jun 28)1:00 amWordPress Theming using Divi 4Theme Development

27jun(jun 27)9:00 am28(jun 28)7:00 pmJoomla CMSWeb Development