Event #1798: PHP/MySQL Bootcamp // 5 Days

Date: 2005-10-17 Country: USA Category: Training URL: http://www.tdsinteractive.com/classes/detail.php?id=88 PHP/MySQL Bootcamp Cost: $1675.00 Description: Want to learn how to implement a dynamic database driven website? Need to learn it fast and within a structured, real world environment? TDS Interactive's 5-day PHP/MySQL Boot Camp arms you with the power to effectively implement today's most popular open-source scripting language and database on your website, intranet, or extranet. You will learn how to take advantage of the power of PHP and MySQL with hands-on, real world examples. This class takes 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 create and implement a database driven website through hands-on exercises. The last hour of each day of class is set aside for individual practice on the lessons learned during the day. An instructor is available to answer questions and assist students during this practice period. Students are not required to stay during this hour each day, if they feel confident with the materials. CLASS SCHEDULE: Monday through Thursday from 10:30 am to 5:30 pm and Friday from 10:30 am to 4:00 pm At the completion of this class students will be able to implement a database driven website with basic content management system, use PHP to call to and store information in a database and much, much more. DON'T FORGET, WE PROVIDE THE FOOD! The PHP/MySQL Bootcamp includes your meals! Antharia provides lunch four days of the week! We order from Atlanta Bread Company where you get to have the yummiest salads and sandwiches you ever did taste. Materials: Class includes PHP and MySQL for Dynamic Websites, course workbook, and class files. Audience/Prerequisites: Because of the materials covered in this class it is suggested that students are comfortable with basic HTML. Any previous PHP or programming skills are welcome. If you know PHP this class is still for you. You will learn how to formally use PHP & MySQL to create the end product. Outline/Objectives: 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=1798&action=approve http://master.php.net/manage/event.php?id=1798&action=reject http://master.php.net/manage/event.php?id=1798