PHP & MySQL - Training + Live Project

Time Period – 50 Days
Daily 2 Hours – Theory & Practical
Time Distribution

PHP      MySQL       Projects      Total

20 Days      5 Days      1 No. Dummy – 10 Days / 2 No. Live – 15 Days 25 Days 50 Days

Preliminary Requirements

• Should have basic knowledge of HTML / JavaScript / CSS.
•  Should know / not know the basic of any other language like C / C++.

Description
Introduction Class – HTML / JavaScript / PHP / MySQL / XAMPP

• What is PHP?
• Who / When Is It Developed.
• Basic Details of Web Development Tool Kits.
• Basic Working Principal.
• Basic Syntax Declaration of PHP?
• File Creation?

Environment Creation

• Configuration & installation of PHP / MySQL – XAMPP
•   XAMPP Basic & Fundamentals

Program Building Blocks

•   Syntax
•   Comments
•   Variable Declaration
•   Variable Naming Rules
•   Type of Web Variables – Form / Server / Session / Environment / Cookie
•   Data Types
•   Operators & Expressions
•   Constants

Control Flows

• Condition Checking

1.  If o If…Else
2.  If…Else If … Else
3.  Switch Case

•  Loops

1.  For
2.  For each
3.  Do…While
4.  While

Functions

• Types
• Inbuilt Function
• User Defined Function
• String Function
• Date & Time Functions
• Numerical Functions
• User Interaction Method for Function

Arrays

•   Types
•   Array Functions

Other Basic of PHP

•   Objects & Class
•    Include
•    Require
•    Header

Forms

•  Processing Forms
•   Form Validation

Form Communication

Cookies & User Session Management

• Files & Directories
•   Dynam ic Creation
•   Dynamic Deletion
•   Dynamic Modification •   Display

Images

•   Loading / Display
•   Uploading
•    Storing
•    Cropping & Converting
•   Readin
• Mails-Concept

MySQL

•    History
•    Why to use MySQL
•    Basic of MySQL
•    Fundamentals
•    Different type of Web Support
•   Using Phpmyadmin
•    Interacting With Databases Commands
•   MySQL Connect
•  MySQL Create
•   MySQL Insert
•   MySQL Select
•    MySQL Where
•    MySQL Order By
•  MySQL Update
•   MySQL Delete

Integration – Putting It all together

•  PHP – MySQL Connections
•   User Access Overview
•   Creating Login System
•   Creating Authorization & Mai ntaining Sessions
•    Creating Logout Pages

Projects (Any 1)

•   Creating Simple Mailing Lists
•   Online Address Books
•   Discussion Forum
•   Online Store Front
•   Shopping Cart Mechanize
•    Event Calendar
•   Restricting Access To Application
•   Content Management System

Final Round Off – Live Projects

•   Documentation
•   Designing
•   Database Planning
•   Data Organizing
•   Developments
•    Testing
•    Error Correction
•     Final Installation & Release of Site