Training in network engineering,-PHP| MySQL | CCNA| programmer| Linux-Mumbai-India.

Upcoming Workshop

Advance Excel 2 Days Workshop In Mumbai

Schedule For May - June 2010

Classroom Video -
1st May '2010


Images	Video

Microsoft Office

	MS-Word
	MS-Advance Word
	MS-Excel
	MS-Advance Excel
	MS-Excel-Macros
	MS-PowerPoint
	MS-Access
	MS-Outlook Express
	MS-Project Management


Creative Courses

	InDesign CS3
	CorelDRAW X4
	Photoshop CS3
	3D Studio Max
	AutoCad-2009


Network Courses

	MCSE - 2003
	CCNA
	LINUX


Web Designing

	HTML
	Dreamweaver
	Flash
	Flash Action Script
	Dreamweaver - 8.0 (Database)


Programming Courses

	C Programming
	C++Programming
	Java
	PHP & MySQL
	LAMP
	SQL Server 2005
	Oracle 9i SQL & PL-SQL
	Advance Excel+VB(Part)
	DOT NET Technologies
	Crystal Report 11

PHP & MySQL

2 Days Workshop In Mumbai For
MS Project Management- Click Here

To study this course in classroom - CLICK HERE

Introduction to PHP & MySQL

Duration : 4 days

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

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