PHP WITH MY SQL

Html

Introduction to HTML

HTML Tags

Creating Forms

Creating tables

Css

Introduction to CSS

Three ways to use CSS

CSS Properties

Designing website

Working with Templates

JavaScript

Introduction to JavaScript

Three ways to use JavaScript

Working with events

Client-side Validation

Introduction to PHP

Evaluation of PHP

Basic Syntax

Defining variable and constant

PHP Data type

Operator and Expression

Decisions and loop

Making Decisions

Doing Repetitive task with looping

Mixing Decisions and looping with Html

Function

What is a function

Define a function

Call by value and Call by reference

Recursive function

String

Creating and accessing String

Searching & Replacing String

Formatting String

String Related Library function

Array

Anatomy of an Array

Creating index based and Associative array

Accessing array Element

Looping with Index based array

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

Some useful Library function

Working with file and Directories

Understanding file& directory

Opening and closing a file

Coping ,renaming and deleting a file

Working with directories

Building a text editor

File Uploading & Downloading

Handling Html Form with PHP

Capturing Form Data

Dealing with Multi-value filed

Generating File uploaded form

Redirecting a form after submission

State management

Using query string(URL rewriting)

Using Hidden field

Using cookies

Using session

String matching with regular expression

What is regular expression

Pattern matching in PHP

Replacing text

Splitting a string with a Regular Expression

Exception Handling

Understanding Exception and error

Try, catch, throw

Database Connectivity with MySQL

Introduction to RDBMS

Connection with MySQL Database

Performing basic database operation(DML) (Insert, Delete, Update, Select)

Setting query parameter

Executing query

Join (Cross joins, Inner joins, Outer Joins, Self joins.)