PHP & MySQL
PHP is a powerful cross platform server side script language. It is a full featured programming language capable of managing huge database driven online environments. Using PHP you can query databases, create images, read & write files, talk to remote servers - the possibilities are endless.
SALIENT FEATURES
PHP is an HTML-embedded 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 developers to write dynamically generated pages quickly
APPLICATION
Open source has brought a lot more than Linux to the computing world. It has also given us PHP and MySQL. PHP and MySQL are the world's best combination for creating data-driven sites.
Working with My SQL
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)itch…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
16)
Smarty Templates - the compiling PHP template engine
Graphs (Bar, Lines)
Encrpytion (Into_Hexadecimal, Caesar Cipher)
Using Liabrary Funtions
Frames in PHP
Creating PDF files in PHP
17)
The different examples rapidly show how to use FPDF. You will find all main features explained
Minimal example
Header, footer, page break and image
Line breaks and colors
Multi-columns
Tables
Links and flowing text
Adding new fonts and encoding support
