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)

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

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

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

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