Introduction to MySQL/PHP

Revision: TE6102_20080404

(4.81 KB) View, Download, or Print Catalog as a PDF.

Course Length:

5 Days

Course Description:

This five day class is broken down into three sections: Part I - learning PHP syntax which weds well with HTML/XHTML; Part II - learning how to create MySQL databases and querying them with SQL; and Part III - applying this knowledge in the development of an application. The student will be able to run three tier applications by the end of the class. The core of the curriculum is focused on the Middle tier using the PHP scripting language to develop the application logic.

Who Should Attend:

This course is designed for individuals who have been developing web pages with a GUI and want to progress to developing using a three tier architecture (Client, Middle, and Database).

Benefits of Attendance:

Upon completion of this course, students will be able to:

• develop three tier applications utilizing: a web browser to display HTML/XHTML code at the Client tier for input and output; PHP scripting language for the Middle tier to tie together the application, and SQL and MySQL for the Database tier. This skills set moves a company's web page from simple display and data gathering to a more personalized, structured, and automated application.

Prerequisites:

Students should have a firm understanding of HTML/XHTML tags and a programming background.

Course Outline:

• Discussion of Three Tier Architecture
  1. Client tier
  2. Middle tier
  3. Database tier
• Overview of the Case Study - The Winestore
  1. Populating Web pages from a database
  2. User-driven queries/browse
  3. Data Entry and Validation
  4. User Authentication and Management
  5. Reporting
• Learning PHP
  1. PHP Basics
  2. Conditions and Branches
  3. Loops
  4. Variables and Arrays
  5. Strings
  6. Functions
• MySQL databases
  1. Database Basics
  2. Loading a Database
  3. MySQL command Interpreter
  4. Creating a database
  5. Modifying a database
  6. Administering a database
• Developing an application using PHP and MySQL
  1. The Winestore
  2. MySQL functions in PHP
  3. Querying a database
  4. User-Driven Querying
  5. Previous and Next Browsing
  6. Inserts, Updates, and Deletes
  7. User Authentication and Management
  8. Ordering and Shipping