PHP/MySql Web Development Course Content:

Module 1 [Fundamentals]

• Software Engineering
• Basics of Designing
• Web Programming
• SQL Queries
• OOPS

Module 2 [Static Website Designing (HTML & CSS)]

HTML

• HTML Elements
• HTML Tags
• HTML Anchor Tag
• Images
• HTML List
• HTML Table
• HTML Form
• HTML Events
• Div And Span

CSS

• CSS Selector
• Applying CSS – Internal, External, Inline
• CSS Background
• CSS Classes and ID
• CSS Pseudo-Classes

Javascript

• JS variables
• JS statements
• JS operators
• JS comparisons
• JS if-else
• JS switch
• JS functions

Jquery

• Basic idea about jquery
• Advantages of using j-query
• Simple but essential application of jquery
• Jquery File Upload
• Creating picture slider with jquery
• Jquery light-box
• Submitting forms with help of jquery
• Form validation using jquery

 Exam based on the above topics (HTML,CSS,JS,JQ)

Module 3 [Learning the Language]

• Introduction to PHP
• PHP with Web Design
• PHP Syntax
• Variables in PHP
• Expressions
• PHP Operators
• Conditions, Events and Flows
• Loops
• PHP Functions
• PHP Arrays
• String Functions
• Date And Time Functions
• PHP Include File
• HTTP Protocol
• Header Function
• Forms And User Input – Form Validation, PHP $_Get, PHP $_Post, PHP $_REQUEST, PHP $_SERVER, PHP $_FILES

 Exam On PHP

Module 4 [Database Connectivity]

• DBMS & RDBMS
• PHP & MySQL
• MySQL Database and Queries
• Connection to MySQL Database
• Creating database and Tables in MySQL
• MySQL Data Types
• Database Terminology
• PHP MySQL Insert into
• PHP MySQL Select
• PHP MySQL Where Clause
• PHP MySQL Order By Keyword
• Difference Between Group By and Order By
• Joins
• PHP MySQL Update
• PHP MySQL Delete Form
• Normalization
• Encryption & Securities

 Exam On MySQL

Module 5 [Applicability to Industry Standards]

• PHP with MVC Architecture
• OOPS Concepts
• String Manipulation and Regular
• Expression
• PHP Sessions and Cookies
• PHP File Handling
• Files and Directory Access
• Handling Emails
• Ajax
• Email and Security
• XML
• Photo upload – single and bulk upload in PHP
• Basic website security like how to prevent SQL Injection

Module 6 [Select anyone of the below]

Module 7 [PHP Practical Examples]

• Creating user login form using Database
• Creating Registration form using Database
• Search Module
• Creating Administrator for Websites
• Min Options in Administrator – Using Login, Registration, Authentication, Search, Edit & update & Delete Users & Data, Changing Content Dynamically
• Real-time Project

Seminar Presentation on Information Search and Analysis

Module 8 [Applicability to Industrial Projects]

• Shopping Cart
• Embedding PHP Code into HTML Pages
• Payment Gateway Integration
• Product Catalogue

Final Project Submission