-
PHP Course Curriculum
PHP with My SQL works great in Web-based Applications developed. PHP scripting language mostly used in web development and coding executed in a server within the server-side. MySQL uses structured Query Languages. PHP with MySQL work together by connecting and querying data from the script.
-
Session -1
- Web Basics
- Web Architecture
- XAMPP Installation
- PHP,APACHE, MYSQL configurations
-
Session -2
- PHP Basics
- PHP Delimiters and Comments
- Variables and Datatypes in PHP
- Type Casting & Type Juggling.
-
Session- 3
- Decisions
- Comparison Operators and Conditions
- IF and ELSE Control Structure
- Logical Operators
-
Session -4
Multiple Control Structures and Loops
- Multiple Control Structures
- WHILE, DO-WHILE, FOR and FOREACH Loops
-
Session -5
PHP Functions and Variable Scopes
- Creating Code Re-usability with Functions
- Function and Variable Scopes
- Parameters and Return Values
- Built-in PHP Function Libraries
-
Session -6
Arrays
- Creating an Array
- Associative Arrays
- Creating Multidimensional Arrays
- Traversing and Manipulating Arrays
- Built-in Functions
-
Session -7
Strings
- Manipulating Strings
- Built-in String Functions
- Regular Expressions
-
Session -8 - Forms in PHP
- Forms Review
- Using Super global to Read Form Inputs(GET, POST,REQUEST)
-
Session -9
Utilizing Internet Tools
- Environment and Server Variables
- Using HTTP Headers , Buffers
- Sending Emails
-
Session -10
Date and Time
- PHPMyAdmin
- SQL.
- Date and Time Standards
- Date and Time Functions
-
Session -11
Using Files
- Including and Requiring Files
- Reading and Writing Files
- Upload & Download Files
- Reading and Writing CSV Files.
-
Session -12
Using Directories
- Creating Directories
- Reading and Writing Directories
-
Session -13
Cookies & Sessions
- Cookies and Use Of Cookies
- Session and Use of Sessions
- Session Security.
-
Session -14
Object-Oriented PHP
- Classes, Properties, and Methods
- Object Instantiation and Class Scope
- Inheritance, Abstraction and Polymorphism
-
Session -15
Advanced Concepts in Object-Oriented PHP
- Constructors, Destructors, Constant and Magic Methods
- Advanced Access Control: Abstract, Final, and Static
- Interfaces
-
Session -16
Advanced Concepts in Object-Oriented PHP
- Exception Handling and namespaces.
- MVC Architecture
- CRUD application using OOPS.
-
Session -17
Advanced Concepts (WEB-SERVICES)
- Design Patterns.
- Introduction to REST,SOAP, SMTP & POP3
- XML Parsing (reading & Writing XML Files).
-
Part- 2
-
Session 1
Introduction
- History of Database, Database Modelling
- Introductions of MySQL, MySQLi
- Databases and Permissions
-
Session -2
Creating Tables
- Creating and Checking Tables
- Inserting Values into Tables
- Retrieving Data from Tables
-
Session -3
Searching Through Tables
- Exploring the “where” and “like” Keyword
- Updating and Deleting Data
-
Session -4
Managing Tables
- Altering, Renaming, Deleting Tables
-
Session -5
Managing Table Entries
- Optimizing with Indexes and Keys
- Auto increment and Primary Keys
-
Session -6
Advance Concepts of Databases
- Joins, Views & sub queries
- Trigger, Stored Procedures and Functions
-
Session -7
Managing Query Results
- Group By and Preventing Duplicate Results
- Searching and Counting Within Groups
- Renaming, Deleting, Limiting Results
-
Session -8
Database Programming with PHP
- PHP Connection to MySQL, MySQLI using Procedural & Object.
- Executing SQL Commands • Delimiting Queries
-
Session -9 — Project, Part 1
- Project Description
- Table Layout AND Table Creation
-
Session 10 — Project, Part 2
- Design and develop Control panel
- User Authentication
- Implementing categories, products, users Modules
- Product search and Pagination
-
Session -11 — Project , Part 3
- Front end design
- Listing products
- Adding product to cart
- Order confirmation & checkout process
- Deployment
- FTP Server & C-panel
- Creating database & importing tables
- Output on LIVE server
-
AJAX
- Introduction
- What is XMLHTTPRequest , ActiveXObject?
- Sending Asynchronous request to server
- Tracking the request
- Output the response in desired manner
- Cascading Select-boxes
- Implementing AJAX in shopping cart
-
jQuery
- Introduction
- Selectors, Filters, effects & animation
- Form Validation
- jQuery with AJAX
- JQuery with PHP AND MYSQL.
-
JSON
- Introduction
- Synatx, Filters, Http
- Read & Write JSON Content.
-
Session -1 — Linux
- Introduction to Linux
- Install
- File system
- Basic Commands