Want to learn how to implement a dynamic database-driven Web site? Need to learn it fast and within a structured, real-world environment? Antharia's 5-day PHP/MySQL Bootcamp 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. We will give you the knowledge you need to build any database-driven application. The last hour of each day of class is set aside for individual practice on the lessons learned during the day. The instructor is available to answer questions and assist students during this practice period.

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. You will learn how to formally use PHP & MySQL to create the end product.

Students are welcome to arrive as early as 10:15 and stay as late as 6:00 pm Monday - Thursday for open non-instructor led lab time.

Outline & Materials

Class includes PHP and MySQL for Dynamic Websites, course workbook, and class files. Students will also have 90 days of access to their instructor (via email) for questions and answers.

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

Objectives

Students in this class will take away the following key elements:

1. Students will learn the fundamentals of the PHP programming language, such as variables, control structures, functions, and built in variables and autoglobals.
2. Students will learn about data access in SQL and the fundamentals of database design. Students will be able to set up a database in MySQL, add users who can access it, and build and populate tables in the database.
3. Students will be able to connect to a MySQL database from PHP scripts, and retrieve, delete, and store values.
4. Students will be able to create a templating system using PHP, and be able to manage content stored in a database.
5. Students will learn about form validation, both server-side with PHP and client-side with JavaScript.
6. Students will learn about sessions, and how to use sessions to implement user log-in and maintain state data between page loads.
7. Students will gain experience using a variety of different database patterns to store information, and practice working with dates, text, integers, and other data field types.

Additional Details can be found at https://www.antharia.com/onevent/details.php?id=43 but to qualify for this special pricing you must register through Skill Share.