Corporate Training in PHP & MySQL

PHP is a powerful cross platform server side scripting language. It is a full featured programming language capable of managing huge database driven online environments. Using PHP you can query databases, create dynamic images, create e-commerce websites, manage security for online transactions, read & write files on the server, talk to remote servers - the possibilities are endless. MySQL is a small, compact database server ideal for stand-alone and enterprise applications. The PHP-MySQL combination is also cross-platform.

Sailent Features

PHP is an HTML-embedded server side scripting language. Much of its syntax is borrowed from C, Java and Perl with a couple of unique PHP-specific features thrown in. The goal of the language is to allow web developersto write dynamically generated database driven pages quickly.

Application

Open source has brought a lot more than Unux to the computing world. It has also given us Linux, PHP and MySQL. PHP and MySQL are the world's best combination for creating database-driven sites.

Working with PHP (Getting Started with PHP-Variables )

Module 1: Assigning Simple Variables Within a Script
Delimiting strings
Assigning arrays within a script
Assigning two-dimensional arrays in a script

Module 2: Accessing Variables Passed from the Browser
HTML forms variables
Passing arrays
Cookies
Sessions

Module 3: Using Built-in Variables
PHP variables
Apache variables
Other Web server variables

Module 4: Testing Variables
isset0
empty0
is_null0
is_int0
is_double0
is_string0
is_array0
is_bool0
is_object0
is_resource0
is_scalar0
gettype0

Module 5: Changing Variable Types
Variable Variables

Module 6: Control Structures (The if Statement)
Determining true or false in PHP
Comparison operators
Logical operators
Complex if statement
if...else statements
if...elseif statements

Module 7: switch...case (Loops)
While...
do...while
for
foreach
continue and break

Module 8: PHP's Built-in Functions (Function Basics)
Arguments
Return values

Module 9: Function Documentation (Important PHP Functions)
String handling functions
Regular expression functions
Variable functions
Type-conversion functions
Array functions
Object/class functions
Print functions
Date/time functions
File-system functions
Script Control functions
Random number generator functions
Session functions
MySQL functions
HTTP header functions
Image functions
Mail function
URL functions
Error functions
Output buffering
Information function

Module 10: Writing Organized and Readable Code (Indenting)
Code blocks
Function calls
SQL statements

Includes
Include0 and Require0
Include_once0 and Require_once0
Module 11: User-Defined Functions
Function basics
Returning values
Using a variable number of arguments
Variable scope

Module 12: Object-Oriented Programming
Classes, Continued
Object cloning
Destructors
Variable scope

Working with PHP

Module 1: Creating a shopping Cart
Where usres can shop for Products and data stored in the backen

Module 2: Admin Module / Security
Giving Access to Users / Clients / Admin
Creating the entire admin module using sessions and cookies

Module 3: Minimum Pre-requisite to learn PHP
Basics of 'C' Programming Language
OOPS & C++ (Class, object, Inheritance)
Any database (Access / SQL / Oracle)


Working with MySQL

Database Design with MySQL
Why use a Relational Database?

Blasted Anomalies
# The update anomaly
# The delete anomaly
# The insert anomaly

Normalization
# First normal form
# Second normal form
# Third normal form

Types of Relationships
# The one-to-many relationship
# The one-to-one relationship
# The many-to-many relationship

Advanced Database Concepts
# Referential integrity
# Transactions
# Stored procedures

The Structured query Language for Creating and Altering Tables

Essential Definitions

# Null Values
# Indexes

The create database Statement

The use database Statement

The create table Statement

Column Types
# String column types
# Numeric column types
# Date and time types

Creating Indexes

Table Types
# MyISAM InnoDB Tables
# Berkeley DB
# Heap

The alter table Statement
# Changing a table name
# Adding columns
# Dropping columns
# Adding indexes
# Dropping indexes
# Changing column definitions

Using the show Command
# show databases
# show tables
# show columns
# show index
# show table status
# show create table

GUI Tools for Manipulating MySQL Tables and Data
# Using phpMyAdmin


The Structured Query Language for Inserting, Editing, and Selecting Data
# The insert Statement
# The update Statement
# The delete Statement
# The replace Statement

The Basic select Statement
# The Where clause
# order by
# limit
# group by and aggregate functions

Joining Tables
# The two-table join (equi-join)
# The multi-table join
# The outer join
# The self join
# Unions
# Correlated subqueries