SUMMARY:   PHP and MySQL Web Development provides delegates with the knowledge and skills necessary to develop PHP code which delivers exciting dynamic pages that can be frequently updated, cater to the user needs, manipulate a MySQL database, and offer highly efficient e-commerce. This course is a practical discussion of the features, facilities and tools of PHP and MySQL. This course includes extensive hands-on exercises which provide practical experience in programming in PHP and MySQL, to develop effective dynamic web pages. AUDIENCE:   This course is valuable for Web masters, web developers and web support personnel wishing to use PHP to develop highly effective web sites. PREREQUISITES:   Delegates should have experience of a programming language such as Java, C, C++ or Perl, or a scripting language such as JavaScript. They should also have a working knowledge of the Internet, building web pages and HTML/XHTML. DURATION:   5 Days APPROACH:   This course is presented as a series of short tutorials with extensive practical experiences. OBJECTIVES:   Describe the background, rationale and purpose of PHP and MySQL Use the basic language constructs of PHP to develop effective dynamic web pages Manage persistence with Cookies Access and maintain files and directories Access and maintain a MySQL database COURSE CONTENT:   PHP BASICS How PHP Works PHP Syntax Variables Constants Operators First PHP Web Page FLOW CONTROL Conditional statements - if Loops - while, do...while, for, break, continue ARRAYS Enumerated arrays Associative Arrays Two-dimensional Arrays PHP & HTML FORMS How HTML forms work Sample HTML form STRING MANIPULATION Formatting strings String functions Magic quotes FUNCTIONS require, require_once User functions Variable scope Form processing DATABASE FUNDAMENTALS Database Concepts Relational Databases SQL MySQL introduced SELECTing DATA Basic principles Selecting by column Sorting records The where clause SUBQUERIES, JOINS & UNIONS Subqueries Joins Outer Joins Unions INSERTING, UPDATING & DELETING RECORDS INSERT UPDATE DELETE MANAGING DATA WITH MySQL mysqli() query access PEAR:DB REGULAR EXPRESSIONS Fundamentals of regular expressions Regular Expression Syntax Patterns, sub-patterns Form validation with regular expressions SESSION CONTROL Sessions Session Functions Cookies SENDING E-MAIL WITH PHP PHP Mailer FILE SYSTEM MANAGEMENT Opening/Closing files Reading/Writing files Uploading files via a form Directory manipulation GJH/07