PHP & MySQL

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
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 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 Correlated subqueries
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 Destructors Exceptions
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
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
The different examples rapidly show how to use FPDF. You will find all main features explained.
	a) Minimal example b) Header, footer, page break and image c) Line breaks and colors d) Multi-columns e) Tables f) Links and flowing text g) Adding new fonts and encoding support
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. 2.  C++   2.1 Class.   2.2 Object.   2.3 Inheritance.   2.4 Functions.   2.5 Properties.   3.  Database   3.1 Database concept.   3.2 RDBMS concept.   3.3 SQL Query     3.3.1 - DML.     3.3.2 - DDL.