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