About PHP:
PHP: Hypertext Preprocessor, is a widely used, general-purpose scripting language that was originally designed for web development, to produce dynamic web pages. It can be embedded into HTML and generally runs on a web server, which needs to be configured to process PHP code and create web page content from it. It can be deployed on most web servers and on almost every operating system andplatform free of charge. PHP is installed on over 20 million websites and 1 million web servers
Like Javascript, php employs a syntax similar to C, and provides strong support for pattern matching and database access. Extension for a communicating with other network resources, such as mail and directory servers, is also available
PHP is an open source product. As with other open source products, such as Linux operating system and Apache HTTP server, PHP is not a commercial product. It is, instead, the result of contributions from a community of interested developers. Freely contributing to,and supporting its code base. One important result of its open source nature is that PHP is now available on a large number of platforms. It is compatible with Windows NT as well as several UNIX operating systems, and with a number of HTTP servers such as Apache, Microsoft’s IIS, and Netscape Enterprise server. |
| |
Phase 1 |
|
|
1) |
Database
Design with My SQL |
2) |
Why use a Relational
Database? |
|
|
3) |
Blasted Anomalies |
|
The update
anomaly |
|
The delete
anomaly |
|
The insert
anomaly |
|
|
4) |
Normalization |
|
First normal
form |
|
Second normal
form |
|
Third normal
form |
|
|
5) |
Types of Relationships |
|
The one-to-many
relationship |
|
The one-to-one
relationship |
|
The many-to-many
relationship |
|
|
6) |
Advanced Database
Concepts |
|
Referential
integrity |
|
Transactions |
|
Stored procedures |
|
|
7) |
The
Structured query Language for Creating and Altering Tables |
|
Essential Definitions |
|
Null Values |
|
Indexes |
|
|
8) |
The create
database Statement |
|
|
9) |
The use database
Statement |
|
|
10) |
The create
table Statement |
|
|
11) |
Column Types |
|
String column
types |
|
Numeric column
types |
|
Date and time
types |
|
|
12) |
Creating Indexes |
|
|
13) |
Table Types |
|
MyISAM InnoDB
Tables |
|
Berkeley DB |
|
Heap |
|
|
14) |
The alter table
Statement |
|
Changing a
table name |
|
Adding columns |
|
Dropping columns |
|
Adding indexes |
|
Dropping indexes |
|
Changing column
definitions |
|
|
15) |
Using the show
Command |
|
show databases |
|
show tables |
|
show columns |
|
show index |
|
show table
status |
|
show create
table |
|
|
16) |
GUI Tools for
Manipulating MySQL Tables and Data |
|
Using phpMyAdmin |
|
MySQL Control
Center |
|
Using MacSQL |
|
|
| 17) |
The Structured
Query Language for Inserting, Editing, and Selecting Data |
|
The insert
Statement |
|
The update
Statement |
|
The delete
Statement |
|
The replace
Statement |
|
|
18) |
The Basic select
Statement |
|
The Where clause |
|
order by |
|
limit |
|
group by and
aggregate functions |
|
|
19) |
Joining Tables |
|
The two-table
join (equi-join) |
|
The multi-table
join |
|
The outer join |
|
The self join |
|
Unions |
|
Correlated
subqueries |
|
|
| Part
II: Working with PHP |
|
|
1) |
Getting Started
with PHP-Variables |
|
|
2) |
Assigning Simple
Variables Within a Script |
|
Delimiting
strings |
|
Assigning arrays
within a script |
|
Assigning two-dimensional
arrays in a script |
|
|
3) |
Accessing Variables
Passed from the Browser |
|
HTML forms
variables |
|
Passing arrays |
|
Cookies |
|
Sessions |
|
|
4) |
Testing Variables |
|
isset0 |
|
empty0 |
|
is_null0 |
|
is_int0 |
|
is_double0 |
|
is_string0 |
|
is_array0 |
|
is_bool0 |
|
is_object0 |
|
is_resource0 |
|
is_scalar0 |
|
gettype0 |
|
|
5) |
Changing Variable
Types |
|
Variable Variables |
|
|
6) |
Control Structures |
|
|
7) |
The if Statement |
|
Determining
true or false in PHP |
|
Comparison
operators |
|
Logical operators |
|
Complex if
statement |
|
if…else
statements |
|
if…elseif
statements |
|
|
8) |
switch…case |
|
Loops |
|
White… |
|
do…while |
|
for |
|
foreach |
|
continue and
break |
|
|
9) |
PHP’s
Built-in Functions |
|
Function Basics |
|
Arguments |
|
Return values |
|
|
10) |
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 |
|
|
| 11) |
Writing Organized
and Readable Code |
|
Indenting |
|
Code blocks |
|
Function calls |
|
SQL statements |
|
|
12) |
Includes |
|
Include0 and
Require0 |
|
Include_once0
and Require_once0 |
|
|
13) |
User-Defined
Functions |
|
Function basics |
|
Returning values |
|
Using a variable
number of arguments |
|
Variable scope |
|
|
14) |
Object-Oriented
Programming |
|
Classes, Continued |
|
Object cloning |
|
Destructors |
|
Exceptions |
|
|
| |
|
| Part
III |
15) |
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 |
|
|
This
is the "Project" undertaken
by our students
during the course |
| |
|
| |
|
