PHP

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 developers to write dynamically generated database
driven pages quickly.

APPLICATION
Open source has brought a lot more than Unix 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 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
	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

MySQL


SALIENT FEATURES
It’s easy to use:
     MySQL software can be downloaded in less than 15 minutes.

It’s flexible:
     MySQL runs on more than 20 platforms, including Windows, Mac  OS X, and Linux, and its open source code allows you to customize it to fit your unique requirements.

It’s highly scalable:
     Whether you're looking to post a few things a month to your Web site or looking to add content daily, MySQL is fit to handle Web sites large and small and will easily grow as your business does.

It’s free: 
     A commercial license can be bought if you plan on redistributing it.

It’s secure:
    Security features ensure that only authorized users can access your databases.

It also provides 24/7 tech support and community support.

APPLICATION
Open source has brought a lot more than Unix 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 :

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
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

JOOMLA

SALIENT FEATURES The following lists a few Joomla! features: • Free source code • Simple workflow system • Caching mechanism to secure fast page creation with favorite pages • Wastepaper basket • Banner management • Data manager for uploading and administering data • Publication system for content • Content summaries in RSS format • Search-engine-friendly URLs • Multilingual front end • Macro language for data content (Mambots) • Administration interface that is separated from the homepage • Simple, expandable template, and component system • Simple, but powerful template system (HTML, CSS, PHP) without a complicated template language • Hierarchical user groups • Simple visitor statistics • WYSIWYG editor for content • Simple polling • System of evaluation for contents • Free extensions at http://www.mamboforge.net • After the split, a large and eager community of users and developers was quickly established APPLICATION Joomla is an award-winning content management system (CMS). A content management system is software that keeps track of every piece of content on your Web site, much like your local public library keeps track of books and stores them. Joomla is used all over the world to power Web sites of all shapes and sizes. Joomla is designed to be easy to install and set up even if you're not an advanced user. Joomla is the most popular open source CMS currently available as evidenced by a vibrant and growing community of friendly users and talented developers. Joomla is free, open, and available to anyone under the GPL license. TOPICS COVERED Terms and Concepts A Quick Glance into History Joomla!—How was it Developed?  Structure of a CMS  Front End and Back End  Configuration Settings  Access Rights  Content  Templates Extensions (Components)  Workflow Joomla! as Real Estate  Joomla! Versions  Numbering System of Joomla! Versions Roadmap Joomla! Features  Examples of Joomla! Pages Joomla.org  Porsche, Brazil  PC Praxis, Germany BSI DANS, Norway  Team Lesotho, Lesotho  Installation Setting Up the Local Server Environment Windows XAMPP for Windows  Linux SUSE (10.x) OpenSUSE  Debian/Ubuntu  Your Own Server at a Provider On a Virtual Server in the Net Installing Joomla! Selecting a Directory for Installation An Example Local Installation of Joomla! Directory Unpacking Joomla! Web Installer A Tour of Your New Homepage Front End Menus  Top Menu  Main Menu Other Menu  Content What is Content?  First Page/Front Page  The Latest Messages/The Most Often Read Messages  Advertising  Banner Area Functions  Login Area  Polling Who is Online? Feeds  Back  Search Field  Decorative Elements  Prospects  Back End  Customizing Joomla! A Different Look and Feel  Modifying the Menu Name  Changing the Template  Configuration of Joomla! Administration  Help Menu  Site Menu  Global Configuration  Site  Locale Content Database Server  Metadata Mail Cache Statistics SEO (Search Engine Optimization)  Language Manager  Media Manager  Preview  Statistics  Template Manager  Site Templates  Install  Administrator Templates  Install  Module Positions  Trash Manager User Manager  New  Menu Manager  Customize Existing Menu  New  Edit    Publish Unpublish Move  Copy  Trash  Create a New Menu  Content  Miscellaneous  Components  Links  Installers Menu  Messages Menu Inbox  Configuration  Configuration  System Menu  Global Check-In  Managing Content Content by Section  Section  Category Add/Edit Section Category  All Content Items  Static Content Manager  Content Parameters  Publishing  Images  Parameters Meta Info  Link to Menu Section Manager  Category Manager  Frontpage Manager  Archive Manager Components, Modules, and Mambots Components Menu  Installing and Uninstalling Components  Installed Components  Banner  Manage Clients  Manage Banners Contacts  Manage Contacts Contacts Categories  Mass Mail News Feeds  Manage Newsfeeds Manage Categories Polls  Syndicates  Weblinks  Weblink Items Weblink Categories  Module Menu  Install/Uninstall  Site Modules  All Menus (mod_mainmenu)  Banner  Login Form Syndicate Statistics  Template Chooser  Archive   Sections Related Items  Wrapper Polls  Who's Online  Random Image Newsflash  Latest News  Popular  Search Administrator Modules  Logged Components  Popular  Latest Items  Menu Stats Unread Messages Online Users Quick Icons System Message  Pathway Toolbar Full Menu Copying a Module Mambots Menu Installing New Mambots Site Mambots Search Mambots Forum, Comments, and Calendar Forum What can Simpleboard do? Installation of Simpleboard Uninstallation Simpleboard Administration Simpleboard Configuration Forum Administration User Administration Uploaded Files Browser Uploaded Images Browser Edit CSS File Prune Forums Prune Users Support Websites Load Sample Data Update Database to Version 1.1.0 Stable User Front End Set Up a User Profile Simpleboard Module Installation Comments Installation Administration View Comments Edit Settings Edit Language Front End Calendar Installation Configuration Events Config Manage Event Categories User Front End Module Event Mambot Image Gallery and Document Management Gallery zOOm Media Gallery Installation Administration Gallery Manager Media Manager zOOm Thumb Coder Settings Optimize Tables Update zOOm Media Gallery Integration of the Gallery into your Website User Front End Lightbox E-Cards Comments and Ratings Modules for the zOOm Media Gallery Document Management/Download Area Installation Administration Categories Group Files Documents Licenses Themes Configuration Updates Statistics Integration into the Website Modules Mambots E-Commerce and I18N Online Store Installation Configuration Work on Store Data Add Tax Rates Configuration Product Categories Joomla! Configuration The Order Process Order Administration in the Back End Modules Mambots Joomla! Internationalization Installation of a Different Language File  Translation of a Menu Entry Multilingualism with MambelFish Installation of MambelFish (Component and Module) MambelFish Configuration Translation with MambelFish Mambot for MambelFish Integrate your Own Components into MambelFish Your Own Templates Corporate Identity HTML/XHTML, CSS, and XML HTML/XHTML CSS In the Central HTML File In a Separate CSS File Within an HTML Tag Combinations XML Create Your Own Templates Concept Fixed Size or Variable Size Structure HTML Conversion File Structure of the Template First Trial Run Integration of the Joomla! Module Creating a Template Package Installation with the Joomla! Template Installer Creating Templates with Dreamweaver Extension Installation Create New Template File Template Structure Insertion of the Joomla! Modules Live Site Templates and <div> Tags Barrier Free Joomla! Criteria for Accessible Websites Clarity Browser Compatibility Valid Source Code and Logically Structured Page Architecture Contrasts Graphics and Pictures Font Sizes Additional Criteria and Information The Reality Is Joomla! Barrier-Free? Is it Possible to make Joomla! Barrier-Free? The Technology The People Barrier-Free Sites with Joomla! Your Own Program Extensions Sample joomlabook Component The MySQL Table  The Front End Integration into the Main Menu Joomla! Administration  Create Installation Package  Modules  Source Code  Installation  View of the Website  Mambots

Asynchronous JavaScript and XML (AJAX)


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 Drop-down Menu System Using XML With Ajax Understanding XML Loading XML into a Browser Object Navigating through XML Documents Using JavaScript Extracting data from text nodes Handling White Space in Mozilla and Firefox Accessing Attribute Values in XML Elements Accessing XML Elements by Name Validating XML You Get From the Server Validating XML With a DTD Using CSS With Ajax in Web Pages Introducing CSS Setting Styles Using an External Style Sheet Working with Text Styles Setting Colors and Backgrounds Getting Newly-displayed Text Noticed Showing Ajax Results Hiding Ajax Results Positioning Elements Positioning Elements: Absolute Positioning Positioning Elements: Relative Positioning Stacking Using PHP and Ajax Using PHP in Web Pages Understanding Basic PHP Syntax Working With Variables Working With Operators Working With Strings Working With Arrays Making Choices With the if Statement Using the switch Statemen Using for Loops in PHP Using while Loops in PHP   Sending Data to the Server Extracting Data from Checkboxes Extracting Data from Radio Buttons Extracting Data from Listboxes Uploading Files Reading Uploaded Files  Redirecting the Browser Doing It Right: Ajax Best Practices Handling the Back Button Remember - Google Can't See Your Ajax Content Watching Out for Browser Caching   Giving Visual Cues Wrap-up   XML & XSLT SALIENT FEATURES XML is designed to transport and store data. With XML You Invent Your Own Tags. XML Separates Data from HTML. XML Simplifies Platform Changes, Data Sharing and Data Transport. XML is Used to Create New Internet Languages like XHTML, WSDL, WAP and WML, RSS. APPLICATION XML's support for identity, storage and structure means it is possible to publish to the Web (as HTML) as well as to paper (as PDF) and to other formats (eg Braille, Audio, etc) from a single source document by using the appropriate stylesheets. XML is also very heavily used for enclosing or encapsulating information in order to pass it between different computing systems which would otherwise be unable to communicate. Weather services, e-commerce sites, blog newsfeeds, AJAX sites, and thousands of other data-exchange services use XML for data management and transmission, and the web browser for display and interaction. XML TOPICS COVERED XML Basics What is XML? A History of XML and SGML How are people using XML? XML Support in Web Browsers IE 5 Support Netscape 6 Support Browser XML Chart Server-side XML FIRST  XML DOCUMENT XML Example The Tree Structure of XML XML Tools Technology we use Non-validating Parsers Validating Parsers Translating DOM & SAX XML Syntax Differences between XML and HTML Differences between XML and HTML Common mistakes Quoting Attributes CAPITALIZATION Other Issues Required XML Elements XML Vocabulary XML Version 1 Resources XML Elements and Attributes What is an Element? What is an Attribute? When should you use Elements and Attributes? Using DTDs (Document Type Definitions) I What is a Document Type Definition? Declaring use of a DTD in your XML file Internal or External, or none? What is a Content Model? Using DTDs (Document Type Definitions) II Elements Attributes Entities Examples DTD: The Specifics ANY and EMPTY Aside: XML Schema XSLT TOPICS COVERED XSLT Basics eXtensible Stylesheet Language The Transformation Process An XSLT Stylesheet Output Types Elements and Attributes XPath XPath in XSLT XPath Expression Location Paths Node Test Axis Predicate Accessing Nodes Abbreviated Syntax Accessing Nodes with Abbreviated Syntax XPath Functions XPath Operators Using XPath Functions and Operators Flow Control Looping in XSLT Looping with xsl:for-each Sorting with XSLT Looping and Sorting Conditions with XSLT Conditionals Templates, Parameters and Variables xsl:apply-templates Using xsl:apply-templates xsl:call-template Passing Parameters Using xsl:call-template Removing Content Template Modes Template Priority XSLT Variables Multiple Documents Including XSLTs Importing XSLTs Conflict Resolution The document() Function Reusing Templates Working with Keys Key Basics Creating a Simple Key Improving Performance with Keys Improving Performance with Keys Grouping Grouping Songs By Artist Advanced Techniques Working with Numbered Lists Outputting Processing Instructions Copying Nodes Tying It All Together: XSLT Tying it all Together Transforming the Business Letter APPLICATION Transform XML schema to another schema.          A food retailer may represent an order based on one schema while the manufacturer may represent it with another. With XSLT, a customer order taken by the retailer can be transformed into an order that matches the manufacturer's requirements. Transform XML documents into HTML.         New Internet devices may not understand XML, but almost always will support HTML   XSLT transformations          Transform XML to HTML for devices such as handheld PCs, mobile phones, and TV set-top boxes   Transform XML documents into PDF.          Printers do not understand HTML, but almost always accept the Package Definition Format (PDF).          JavaScript & JSON      SALIENT FEATURES JavaScript was designed to add interactivity to HTML pages. JavaScript is a scripting language. A scripting language is a lightweight programming language. JavaScript is usually embedded directly into HTML pages. JavaScript is an interpreted language (means that scripts execute without preliminary compilation). Everyone can use JavaScript without purchasing a license APPLICATION Javascript is used for validation of WEB FORM input values to make sure that they will be accepted before they are submitted to the server. JavaScript can put dynamic text into an HTML page. It can respond to user actions quickly, making an application feel more responsive. Furthermore, JavaScript code can detect user actions which HTML alone cannot, such as individual keystrokes. Applications such as GMail take advantage of this: much of the user-interface logic is written in JavaScript. The wider trend of AJAX programming also exploits this strength.JavaScript can be used to detect the visitor's browser. TOPICS COVERED Javascript Basic Javascript Variables Javascript  Operators Javascript  Comparisons Javascript  IF..ELSE Javascript  Switch Javascript  PopUp Boxex Javascript  Functions Javascript  For Loop Javascript  While Loop Javascript   Break Loop Javascript  For..In Javascript  Events Javascript  Try..Catch JS Objects Javascript Objects intro Javascript  String Javascript  Comparisons Javascript  Date Javascript  Array Javascript  Boolean Javascript  Math Javascript  RegExp Javascript  HTML DOM Javascript ADVANCED Javascript   Browser Javascript  Cookies Javascript  Validation Javascript  Animation Javascript Image Maps Javascript Timing Pre-Requisite HTML C & C++ (Basics) Php & MySQL