PHP Training Course

Overview

MySQL and PHP are two of the most popular open source technologies to emerge during the past decade. PHP is a powerful language for writing server-side Web applications. MySQL is the world's most popular open source database. Together, these two technologies provide you with a powerful platform for building database-driven Web applications.

This hands-on MySQL and PHP training course teaches participants everything they need to successfully build data-driven Web sites using MySQL and PHP.

Objectives

The objective of PHP Training course is to train participants in becoming proficient PHP/MySQL web developers.

At the end of the PHP Training course, participants will have basic understanding of the web technology and be able to architect, write, debug and run complete web applications using PHP and MySQL.

Suggested Audience - Programmers and Developers who would like to gain the knowledge in developing dynamic web pages.

Duration - 3 Days

Prerequisites - All participants must be fluent in HTML. The course can be customized to any level of programming and relational database familiarity.

Syllabus

1. PHP Basics How PHP Works The php.ini File Basic PHP Syntax PHP Tags PHP Statements and Whitespace Comments PHP Functions Hello World! Variables Variable Types Variable Names (Identifiers) Type Strength Hello Variables! Variable Scope Superglobals Constants Variable-Testing and Manipulation Functions PHP Operators Creating Dynamic Pages Single Quotes vs. Double Quotes Hello World! Conclusion	2. Flow Control Conditional Processing If Conditions If Conditions Loops while do...while for break and continue Conclusion
3. Arrays Enumerated Arrays Initializing Arrays Appending to an Array Reading from Arrays Looping through Arrays Associative Arrays Initializing Associative Arrays Reading from Associative Arrays Looping through Associative Arrays Superglobal Arrays Two-dimensional Arrays Reading from Two-dimensional Arrays Looping through Two-dimensional Arrays Array Manipulation Functions Conclusion	4. PHP and HTML Forms HTML Forms How HTML Forms Work A Sample HTML Form Form Variables Conclusion
5. String Manipulation Formatting Strings Concatenation String Manipulation Functions Examples of String Functions Magic Quotes magic_quotes_gpc magic_quotes_runtime Recommendation on Magic Quotes Conclusion Conclusion	6. Reusing Code and Writing Functions Including Files require require_once auto_prepend_file and auto_append_file User Functions Defining and Calling Functions Default Values Variable Scope By Reference vs. By Value Form Processing Code Organization Code Organization Conclusion
7. Simple SELECTs Introduction to the Northwind Database Some Basics Comments Whitespace and Semi-colons Case Sensitivity SELECTing All Columns in All Rows SELECTing Specific Columns Sorting Records Sorting By a Single Column Sorting By Multiple Columns Sorting By Column Position Ascending and Descending Sorts The WHERE Clause and Operator Symbols Checking for Equality Checking for Inequality Checking for Greater or Less Than Checking for NULL WHERE and ORDER BY The WHERE Clause and Operator Words The BETWEEN Operator The IN Operator The LIKE Operator The NOT Operator Checking Multiple Conditions AND OR Order of Evaluation Conclusion	8. Subqueries, Joins and Unions Subqueries Joins Table Aliases Multi-table Joins Outer Joins Unions UNION ALL UNION Rules Conclusion
9. Inserting, Updating and Deleting Records INSERT UPDATE DELETE Conclusion	10. Managing Data Querying a Database mysqli() Overview mysqli Methods and Properties Inserting and Updating Records mysqli Prepared Statements
11. PEAR:DB Advantages and Disadvantages of PEAR DB Why use a database abstraction layer? When not to use a database abstraction layer? Why use a database abstraction layer? When not to use a database abstraction layer? Using PEAR DB	12. Authentication with PHP and SQL A Database-less Login Form Conclusion
13. Regular Expressions Perl-compatible Regular Expression Functions preg_match() preg_replace() Regular Expression Tester Regular Expression Syntax Start and End ( ^ $ ) Number of Occurrences ( ? + * {} ) Common Characters ( . \d \D \w \W \s \S ) Grouping ( [] ) Negation ( ^ ) Subpatterns ( () ) Alternatives ( | ) Escape Character ( \ ) Form Validation Functions with Regular Expressions Conclusion	14. Session Control and Cookies Sessions Configuring Sessions Session Functions Conclusion
15. Sending Email with PHP mail() Shortcomings of mail() Shortcomings of mail() PHPMailer Conclusion	16. File System Management Opening a File fopen() Reading from a File fgets() Writing to a File fwrite() File Locking flock() Uploading Files via an HTML Form Getting File Information More File Functions Directory Functions Getting a Directory Listing