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.
SALIENT 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.
TOPICS
COVERED :
Part
I: Working with My SQL
Database
Design with My SQL
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
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
MySQL Control Center
Using MacSQL
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
Part
II: Working with PHP
Getting
Started with PHP-Variables
Assigning
Simple Variables Within a Script
Delimiting strings
Assigning arrays within a script
Assigning two-dimensional arrays
in a script
Accessing
Variables Passed from the Browser
HTML forms variables
Passing arrays
Cookies
Sessions
Using
Built-in Variables
PHP variables
Apache variables
Other Web server variables
Testing Variables
isset0
empty0
is_null0
is_int0
is_double0
is_string0
is_array0
is_bool0
is_object0
is_resource0
is_scalar0
gettype0
Changing Variable
Types
Variable Variables
Control
Structures
The if Statement
Determining true or false
in PHP
Comparison operators
Logical operators
Complex if statement
if…else statements
if…elseif statements
switch…case
Loops
White…
do…while
for
foreach
continue and break
PHP’s
Built-in Functions
Function Basics
Arguments
Return values
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 functions
URL functions
Error functions
Output buffering
Information functions
Writing
Organized and Readable Code
Indenting
Code blocks
Function calls
SQL statements
Includes
Include0 and
Require0
Include_once0
and Require_once0
User-Defined
Functions
Function basics
Returning values
Using a variable number of
arguments
Variable scope
Object-Oriented
Programming
Classes, Continued
Object cloning
Part
III
Creating a shopping
Cart
Where users can shop for
Products and data stored in the backend
Admin
Module / Security
Giving Accesstom
Users / Clients / Admin
Creating the
entire admin module using seesions and cookies
Minimum
Pre-requisite to learn PHP
1)
Basics of 'C' Programming Language.
2)
OOPS
& C++ (Class, object, Inheritance)
3)
Any
database (Access/SQL/Oracle)
1.
C
1.1
Datatypes.
1.2
Operator.
1.3
Condition construct.
1.4
Looping
construct.
1.5
Functions.
1.6
Array.
Course
Duration ( C )
Fees
(Indian RS.)
Fees
(US $)
10 sessions
of 1 hr. each
2,000/-
60
2.
C++
2.1
Class.
2.2
Object.
2.3
Inheritance.
2.4
Functions.
2.5
Properties.
Course
Duration (C ++)
Fees
(Indian RS.)
Fees
(US $)
10 sessions
of 1 hr. each
2,000/-
60
3.
Database
3.1
Database
concept.
3.2
RDBMS
concept.
3.3
SQL
Query
3.3.1 - DML.
3.3.2
- DDL.
Course
Duration (Database)
Fees
(Indian RS.)
Fees
(US $)
10
sessions of 1 hr. each
2,000/-
60
Duration
Fees
(Indian RS.)
Fees
(US $)
65
sessions of 1 hr. each
9,500/-
275
Add
Service Tax=12.36% on all tuition fees.
Please
Note: Management has full right to change courses, contents, tuition fees without prior notice.
Lodging,
boarding and travelling not included in the fees.
The
above mentioned fees is for one course.
COMPUFIELDoffers a unique style of learning -
One computer
: One student : One Instructor
Maximum Instructor
to Student Ratio 1:4
Sessions :
Each session will be of 1 hour.
The timing
can be fixed based on our mutual convenience,
between 9.00 a.m. to 7.00 p.m.
Overseas Students
take 5 to 10 hours per day to complete their courses.
Course duration
in days = total sessions divide by number of sessions per day.
No extra charges/refund for more/less time taken to complete the course.
