PHP & MySQL & AJAX

Our Programming Student's Review
Programming Review 1 2 3 4 5
Our Programming Student's Video Review
View more Video Review's

• 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 Sstatement
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 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 Asynchronous JavaScript and XML (AJAX) Ajax (also known as AJAX), shorthand for "Asynchronous JavaScript and XML," is a web development technique for creating interactive web applications. The intent is to make web pages feel more responsive by exchanging small amounts of data with the server behind the scenes, so that the entire web page does not have to be reloaded each time the user requests a change. This is intended to increase the web page's interactivity, speed, and usability. SALIENT FEATURES XHTML (or HTML) and CSS, for marking up and styling information. The DOM accessed with a client-side scripting language, especially ECMAScript implementations such as JavaScript and JScript, to dynamically display and interact with the information presented. The XMLHttpRequest object is used to exchange data asynchronously with the web server. In some Ajax frameworks and in certain situations, an IFrame object is used instead of the XMLHttpRequest object to exchange data with the web server, and in other implementations, dynamically added <script> tags may be used. XML is sometimes used as the format for transferring data between the server and client, although any format will work, including preformatted HTML, plain text, JSON and even EBML. These files may be created dynamically by some form of server-side scripting. APPLICATION standards-based presentation using XHTML and CSS; dynamic display and interaction using the Document Object Model; data interchange and manipulation using XML and XSLT; asynchronous data retrieval using XMLHttpRequest; and JavaScript binding everything together. and JavaScript binding everything together. TOPICS COVERED Introduction Welcome System Requirements Getting to know Ajax Downloading Data Behind the Scenes Modifying Web Pages on the Fly Searching in Real Time with Live Searches Getting the Answer With Autocomplete Dragging and Dropping HTML Elements With Ajax Writing Ajax Working With JavaScript in Browsers  Creating an XMLHttpRequest Object in JavaScript  Checking the XMLHttpRequest Object's readyState property  Checking the XMLHttpRequest Object's status property  Getting Your Data With the XMLHttpRequest Object  Problems creating an XMLHttpRequest Object  Fetching Text Data From the Browser  Decoding the Fetched Data    Selecting Relative or Absolute URLs  Getting XMLHttpRequest Objects in Other Ways  Using Server-Side Scripting  Storing Ajax Data in XML  Passing Data to the Server with GET  Passing Data to the Server with POST  Getting More Ajax Power Determining Which Browser the User Has Handling Head Requests for More Data Creating a Live Search Pt.1 Creating a Live Search Pt.2 Connecting to Google Suggest   Calling a Different Domain Safely Using Two XMLHttpRequest objects Handling Multiple XMLHttpRequest Requests  Returning JavaScript Objects From the Server Creating Ajax Applications Downloading Images Using Ajax Creating a Shopping Cart Handling Mouse Events Enabling Dragging Handling Drops Communicating With the Shopping Cart on the Server Creating an Ajax-driven Drop-down Menu System  Downloading Data with Drop-down Menu System  Displaying a Menu with a