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