PHP with MYSQL

Introduction

About PHP

Understanding client/server roles

Installation

PHP Fundamentals

PHP Basic syntax, PHP data Types, PHP Variables

PHP Constants, PHP Expressions, PHP Operators

PHP Control Structures, PHP Loops, PHP break, continue, exit statement

PHP Arrays

PHP Arrays, PHP Associative Arrays

Accessing array Element

Looping with associative array using each() and foreach()

Array Functions

PHP Functions

PHP Functions, Syntax, Arguments, Return Values

Pass by Value & Pass by References

Variable Scope, PHP include(), PHP require()

PHP Forms

PHP Form handling, PHP GET, PHP POST, PHP Form Validation, PHP Form

PHP Cookies & PHP Sessions

PHP Cookie handling, PHP Session Handling, PHP Login Session

Maintaining state using hidden form fields and query strings

PHP Strings Handling

Creating and accessing String

String Related Library function

String matching with regular expression

What is regular expression

Pattern matching in Php

Replacing text

Splitting a string with a Regular Expression

HTML & CSS

HTML Tag, Creating Forms, Creating tables

Managing home page

Introduction to CSS

Three ways to use CSS

CSS Properties, Designing website

Working with Templates

Javascript Implementation

Introduction to Javascript

Function

Form/Client-Side validation

Jquery Implementation

Introduction to JQuery

Validation using JQuery

JQuery Forms, JQUERY library

JQuery Examples

AJAX Implementation

Introduction to AJAX

PHP with AJAX

Working with database

Working with Database MySQL, Simple SQL Queries

Introduction to RDBMS

Connection with MySql Database

Insert, Select, Update, Delete data

Joining and Functions

ER diagram and Data flow diagram of case study

Advanced SQL query building

WHERE condition, Order By, Group By, Having, LIKE, AND OR operators

Introduction to OOPS

Declaring Class, Constructor, Destructor

Access method and properties using $this variable

Public, private, protected properties and methods

Static properties and method

Inheritance & Polymorphism

Exception Handling

Understanding Exception and error

Try, catch, throw

File Handling

Open/Close, Read/Write, File Upload/ Downloading

Copying, renaming and deleting a file

Working with directories