SUMMARY:   This class provides delegates with the knowledge and skills necessary to install and develop with PHP. Delegates are taught how to install PHP (PHP:Hypertext PreProcessor) and MySQL software, and to develop PHP code that delivers exciting dynamic pages that can be frequently updated, cater for the end-user needs, manipulate a MySQL database, and offer highly-efficient e-commerce. This highly-practical course discusses PHP web development in the Windows and Linux environments, although the majority of the course is applicable to delegates using other platforms. AUDIENCE:   This course is intended for web masters, web developers and web support personnel wishing to use PHP to develop highly effective dynamic web sites. PREREQUISITES:   Delegates should be competent programmers in another programming language such as C, C++, C#, or a scripting language such as Perl or JavaScript. They should also have working knowledge of the Internet, building web pages with XHTML DURATION:   4 Days APPROACH:   Highly practical, workshop based modular training class. OBJECTIVES:   Describe the background, rationale and purpose of PHP and MySQL Install Apache, PHP and MySQL Use the basic language constructs of PHP to develop effective dynamic web pages Write Object-Oriented PHP Manage persistence with Sessions and Cookies Access and maintain files and directories Access and maintain databases through a device-independent API Access and maintain a MySQL database Process XML and e-mails with PHP COURSE CONTENT:   Introduction Background History, rationale and purpose of PHP Why MySQL Benefits and Considerations of PHP and MySQL Installation Requirements Platform Considerations Installing PHP with IIS Configuring and Starting PHP with IIS Installing PHP with Apache on Linux and Unix Configuring and Starting PHP with Linux and Unix Testing your installation Processing Web Pages Viewing a web page Server-side Scripting Caching Variables, data types, constants, initialization Web Forms The Form tag Form attributes HTML Form Controls and PHP Processing returned values Control structures If statements Multiple conditions - ..else..elsif, Nested If statements Switch statements Form validation While loops Do loops For loops Functions Defining and calling functions Switching functions Variable scope Passing values Recursion Include files Debugging Error handling in PHP Further form validation Debugging techniques Arrays Array concepts Initializing Arrays Sorting Arrays Array functions Multi-dimensional arrays Array multisorting Foreach loops Regular Expressions Pattern matching concepts Regular Expression Syntax Objects Object-oriented Terminology Using pre-defined classes Creating user-defined classes File Handling File processing Concepts Opening and closing files Reading and writing to files Getting information of files Copying, renaming and deleting files Directory processing Directory functions Navigating a directory hierarch Managing Persistence HTTP and HTML interactivity HTTP as a Stateless Protocol Hidden form fields Query Strings Reading cookies, cookie parameters Session variable Creation and Manipulation Object session variables, Serialization Managing databases through a device-independent API Data Modeling Database Architectures Database Products Database Design Managing databases with MySQL Why MySQL Introduction to SQL Running a MySQL client Selecting a database Manipulating data in a Database Handling server errors Managing databases and tables from MySQL Retrieving, inserting, updating and deleting data in MySQL using PHP Processing XML with PHP What is XML? XML Document Structure Well-formed XML DTDs Parsing XML with PHP and XPAT Parsing using the DOM-XML functions XSL templates, filtering output through XSL Processing e-mail with PHP Sending e-mails in PHP Anatomy of an e-mail Sending e-mail with attachments GH/06