Web Application Development with PHP & Mysql
Introduction
Introduction to www, History
Understanding client/server roles
Apache, PHP, MySQL, XAMPP Installation
PHP Fundamentals
PHP Basic syntax,
PHP data Types, PHP Variables,
PHP Constants, PHP Expressions,
PHP Operators, PHP Control Structures,
PHP Loops
PHP Arrays
PHP Enumerated Arrays, PHP Associative Arrays
Array Iteration, PHP Multi-Dimensional Arrays, Array Functions
PHP Functions
PHP Functions, Syntax, Arguments, Variables, References, Pass by Value & Pass by references, Return Values, Variable Scope, PHP include(), PHP require()
PHP Forms
PHP Form handling, PHP GET, PHP POST, PHP Form Validation, PHP Form Sanitization
PHP Cookies & PHP Sessions
PHP Cookie handling, PHP Session Handling, PHP Login Session, Managing user ACL
PHP Strings Handling
Strings and Patterns, Matching, Extracting, Searching Replacing, Formatting, PCRE
MySQL
Basic MySQL, Simple SQL queries
Database basics, Indexes, PHP MyAdmin
Connect &Pconnect, MySQL Create, MySQL Insert, MySQL Select, MySQL Update, MySQL Delete, MySQL Truncate, MySQL Drop
Advanced SQL query building
WHERE condintion, Order By, Group By, Having, LIKE, AND OR operators
SQL Functions
Using SQL functions AVG, COUNT, SUM, MIN, MAX, LCASE, UCASE
Importing , Exporting CSV data
Importing and Exporting CSV Files
Advanced MySQL Joins
INNER Join, MySQL LEFT Joins, MySQL RIGHT Joins,Complex SQL Queries