Introduction
Lessons
- 1. Introduction
- 2. Introduction to Servers
- 3. Processing HTML Forms & Data Validation
- 4. Troubleshooting and Debugging
- 5. Working with MySQL
- 6. Display Database Records in the Browser
- 7. Delete Database Records
- 8. More Database Query Techniques
- 9. Session Tracking
- 10. File Uploads
- 11. Final Enhancements
Students learn to create interactive and dynamic websites using the popular open source PHP server-side language and MySQL database. It is designed to be used with the book by Larry Ullman PHP and MySQL for Dynamic Web Sites 4th edition, ISBN 978-0321784070. Students learn to apply the techniques learned from the book and other resources and apply them to their own designs. Specifically, students work with the WAMP, MAMP or LAMP testing servers installed on their own computers. They learn to write scripts that process web-based input and output, troubleshoot programming code, connect to a database, and add, display, edit, and delete records with a bit of CSS and javascript thrown in. Their ultimate goal is to produce a visually aesthetic and functional website.
Course Outcomes
- Write PHP scripts that process web-based input and output. [assessed lessons 2-11]
- Troubleshoot programming code to resolve errors. [assessed lesson 4]
- Demonstrate the ability to connect a form to a database. [assessed lessons 5-11]
- Create scripts to display records in the database. [assessed lessons 6, 8-11]