PHP with MySQL

Duration : 60-70 Days

Fees : Rs. 5000/-

Training Certificate

Minor Project on Shopping Cart

About PHP

PHP is a widely-used general-purpose scripting language that is especially suited for Web development and can be embedded into HTML.

  • PHP can generate dynamic page content
  • PHP can create, open, read, write, and close files on the server
  • PHP can collect form data
  • PHP can send and receive cookies
  • PHP can add, delete, modify data in your database
  • PHP can restrict users to access some pages on your website
  • PHP can encrypt data

Course Contents


HTML (the Hypertext Markup Language) and CSS (Cascading Style Sheets) are two of the core technologies for building Web pages. HTML provides the structure of the page, CSS the (give your HTML pages their beautiful appreance) layout, for a variety of devices. Along with graphics and scripting, HTML and CSS are the basis of building Web pages and Web Applications.


HTML5 is the newest version of Hyper Text Markup Language used for structuring and presenting content on the World Wide Web. It is the fifth and current version of the HTML standard. CSS3 is the latest version of the CSS specification. CSS3 include support for additional selectors, drop shadows, rounded corners, multiple backgrounds, animation, transparency, and much more.

JavaScript / jQuery

JavaScript is a high-level, dynamic, untyped, and interpreted programming language. It has been standardized in the ECMAScript language specification. jQuery is a cross-platform JavaScript library designed to simplify the client-side scripting of HTML. jQuery is the most popular JavaScript library in use today.

Introduction to PHP

  • History of PHP
  • Versions and Differences between them
  • Practicality
  • Power
  • Installation and configuring Apache and PHP

PHP Basics

  • Default Syntax & Styles
  • Comments, O/p functions & Datatypes
  • Configuration Settings
  • Error Types

Variables in PHP

  • Variable Declarations
  • Variable Scope
  • Configuration Settings
  • Superglobal Variables

Constants in PHP

  • Magic Constants
  • Standard & user defined Constants
  • Core Pre-difined Languages

Control Structures

  • Execution Control Statements
  • Conditional Statements
  • Looping Statements


  • Creating Functions
  • Passing Arguments by Value
  • Passing Arguments by Reference
  • Recursive Functions


  • What is an Array?
  • How to create an Array
  • Traversing Arrays
  • Array Functions

Include Functions

  • Include and Include_once
  • Require and Require_once

Regular Expressions

  • Validating textboxes,emails,phone number etc
  • Creating custom regular expressions

Object Oriented Programming

  • Classes, Objects, Fields
  • Properties, Constants, Methods
  • Encaptulation
  • Inheritance
  • Polymorphism
  • Static Class,Helper Functions
  • Object Cloning, Reflections


  • Integration with MySQL
  • MySQL functions
  • Data Grid options
  • SQL Injectio
  • Registration,Login with Editing page
  • Pagging,Sorting
  • File Upload & Mail Sending

Strings and Regular Expressions

  • Declarations styles of String Variables
  • Heredoc style
  • String Functions

File Handling

  • File Functions
  • Open, Create and Delete files
  • Directory Operations
  • Calculating File, Directory and Disk Sizes

Exception Handling

  • Configuration Directives
  • Exception Class
  • Custom Exceptions


  • HTTP Authentication
  • PHP Authentication
  • Authentication Methodologies


  • Types of Cookie
  • Create and Access Cookie


  • Creating,Retriving and Destroying
  • Encoding and Decoding

MySQL Concepts

  • Introduction
  • Storage Engines
  • Functions
  • Operators
  • Constraints
  • DDL commandsg
  • DML Commands
  • DCL Command
  • TCL Commands
  • Views
  • Joins
  • Curosrs
  • Indexing
  • Stored Procedures
  • Mysql with PHP Programming


  • Ajax
  • Date and Time Functions
  • XML
  • Captcha
  • Email Sending
  • SQL Injection
  • Visitors IP Address
  • Find and Replace Application