Corporate Training in PHP & MySQL

COMPUFIELD® Computer Institute
In Mumbai

Price on request
You can also call the Study Centre
22236... More

Important information

Description

Important information
Venues

Where and when

Starts Location
On request
Mumbai
OPriya Bldg.,1st Floor, Dr. Peter Dias Road, Near Mehboob Studio,, 400050, Maharashtra, India
See map
On request
Mumbai
Chinoy Mansion, First Floor, Block #2, Opp. St.Stephen's Church, Warden Road,, 400036, Maharashtra, India
See map

Course programme

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