Event #1088: PHP/MySQL Building a CMS (MD)

Start Date: 2003-9-29 End Date: 2003-10-1 Country: USA Category: Training URL: http://www.tdsinteractive.com/classes/php/php-mysql-crash.php PHP / MySQL Crash Course Building Content Management Systems Instructors: Chrissy Rey Want to learn how to create dynamic content management systems? Need to learn it fast and within a structured, real world environment? This 3 day (18 hour) crash course is intended to take students from concept to completion. From Intro to PHP & MySQL to understanding databases you will learn how to take advantage of PHP and MySQL and through hands-on exercises create and implement a fully functional content management system. $1425 for 3 days of hands-on training! Say you saw us on php.net and save $100 on your registration. Email jordan@antharia.com to take advantage of the discount. Course includes workbook, sample files and copies of THE NEW CORE PHP PROGRAMMING (PHP 5) and CORE MySQL. COURSE OUTLINE: This is a hands-on class where students work through the basics of PHP & MySQL and build a complete content management system. Lesson 1: Introduction • What do PHP and MySQL Do? • A Brief History of PHP and MySQL • The Sample Application Lesson 2: PHP Basics • Embedding PHP in Web Pages • Language Structure • Testing & Debugging While You Work • Data Types • Variables • Expressions and Operators • Using Functions Lesson 3: Arrays • Creating Arrays • Indexed vs. Associative Arrays • Multidimensional Arrays • Sorting Arrays Lesson 4: MySQL and SQL • Relational Database Basics • Designing a Database • Accessing MySQL • MySQL Users • Creating a Databases & Tables • Inserting, Updating, and Deleting Data • Selecting Data Lesson 5: Displaying MySQL Data • MySQL Functions • Connection to a MySQL Database with PHP • Querying the Database • Displaying the Results • Using HTTP GET variables • Displaying Record Details Lesson 6: Control Statements • if, else, elseif • switch • while • for • foreach Lesson 7: Functions • Defining a Function • Variable Scope • Returning a Value • Using Parameters Lesson 8: Writing to the Database • Using HTTP POST Variables • Inserting Data • Updating Data • Deleting Data Lesson 9: Validation on the Server and Client • Server-side Validation • Client-side Validation • Sessions • Keeping State with Sessions • When to Use Sessions • Starting a Session • Using Session Variables • Destroying and Unsetting Sessions EXTRAS: Installation & Additional Resources -- http://master.php.net/manage/event.php?id=1088&action=approve http://master.php.net/manage/event.php?id=1088&action=reject http://master.php.net/manage/event.php?id=1088