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-based applications.
This instructor-led, hands-on MySQL and PHP training course teaches attendees everything they need to know to successfully build dynamic web sites using MySQL and PHP. Students will be able to write, test, and debug their own code during the class. We focus on teaching real-world practices with a focus on security.
This class is designed for those who have an interest in creating powerful websites or web applications. No matter what programming experience you may or may not have, you'll find this an extremely helpful introduction to server programming with PHP. By the end of this course you'll be able to build form processing tools, guestbooks, random testimonial or ad rotation systems, and much more! We try to cover as much as possible yet our four day span allows us to work with students to ensure they understand the material.
Michael Botsko has been developing web applications using PHP and MySQL for six years for a wide variety of clients across the US. He has ten years of experience with x/html, css, and javascript and utilizes all of these technologies on a daily basis. Michael currently owns Botsko.net, LLC and spends his time working on PHP and MySQL projects. Michael lives in the Hillsboro area with his wife and three-year old son.
The primary class runs for four days from 9:00 am to 4:30 with a half-hour for lunch. Lunch and refreshments will be provided for each day of class. We offer a special fifth day which is completely open for you to ask additional questions, get instructor assistance with your personal projects, or briefly discuss more advanced topics.
| Title | Available Dates | Location | Registration Fee | Enrollment Deadline |
|---|---|---|---|---|
| Intro to PHP/MySQL Class | April 9 - 12, 20071 | 1100 NW Compton Road, Suite 307 | $1,500 | March 1, 2007 |
| Open Learning Day | April 13, 20071 | 1100 NW Compton Road, Suite 307 | $300* | March 1, 2007 |
* Any Botsko.net client with at least one active or completed project as of 2/15/2007 may enroll in the open learning day for free. We offer new client discounts for students or their employers. Please contact us for additional information.
| DAY ONE | |
|---|---|
|
* PHP Basics o Server-side vs. client-side scripting o Basic PHP Syntax + PHP Tags + PHP Statements and Whitespace + Comments + PHP Functions o Variables + Variable Types + Type Strength + Variable Scope + Superglobals + Constants + Variable-Testing and Manipulation Functions * Flow Control o If/Elseif/Else, Ternary, Switch o Loops + while + do...while + for |
|
| DAY TWO | |
|
* Arrays o Reading from Arrays o Looping through Arrays * String Manipulation o Formatting Strings o Concatenation o String Manipulation Functions o Magic Quotes + magic_quotes_gpc + magic_quotes_runtime + Recommendation on Magic Quotes * Reusing Code and Writing Functions o Including Files + require + require_once o User Functions + Defining and Calling Functions + Default Values + Variable Scope + By Reference vs. By Value |
|
| DAY THREE | |
|
* Understanding Databases * Simple SELECTs o Some Basics + Comments + Whitespace and Semi-colons + Case Sensitivity o SELECTing Specific Columns o Sorting Records o The WHERE Clause and Operator Symbols o The WHERE Clause and Operator Words o Checking Multiple Conditions + AND + OR + Order of Evaluation o Basic Joins * Inserting, Updating and Deleting Records * PHP and MySQL Working Together o Displaying Data o Saving Form Data * Discussing Database Abstraction Layers |
|
| DAY FOUR | |
|
* Sessions and Cookies o Sessions + Session Functions o Cookies * Sending Email with PHP o mail() o PHPMailer * Discussing security issues o Filter Input, Escape Output o SQL Injection o Cross-site request forgery o Error handling o Brief summary of popular classes, tools, and resources. o Final questions and reviews. |
|
| DAY FIVE (Additional Purchase) | |
|
* Open Day A full day for you to try writing that one script you've always wanted. The instructor is on hand all day to answer questions, review your code, or briefly discuss topics not covered in the introduction class. |
|
1 Class dates are subject to change if fewer than four students are enrolled by the enrollment deadline. Any registered students will be notified of any date changes and will automatically be re-enrolled in the next class.