| Dynamic Web Pages with PHP and MySQL |
| |
| 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. |
|
| Covered Topics: |
- Discussion of Three Tier Architecture
- Client tier
- Middle tier
- Database tier
- Overview of the Case Study - The Winestore
- Populating Web pages from a database
- User-driven queries/browse
- Data Entry and Validation
- User Authentication and Management
- Reporting
- Learning PHP
- PHP Basics
- Conditions and Branches
- Loops
- Variables and Arrays
- Strings
- Functions
- MySQL databases
- Database Basics
- Loading a Database
- MySQL command Interpreter
- Creating a database
- Modifying a database
- Administering a database
- Developing an application using PHP and MySQL
- The Winestore
- MySQL functions in PHP
- Querying a database
- User-Driven Querying
- Previous and Next Browsing
- Inserts, Updates, and Deletes
- User Authentication and Management
- Ordering and Shipping
|
| Prerequisites: |
| A firm understanding of HTML/XHTML tags and a programming background. |
| Audience: |
| 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). |
|
| |
| Course Benefits: |
| Student will be able 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. |
| Materials Furnished: |
- Student Manual
- Textbook - "Web Database Applications with PHP & MySQL" O'Reilly
|
| Recommended Follow-On Course: |
|
|
|
|
|
|
