PHP and MySQL Course
While this textbook is aging, it is and oldie but a goodie. It is makes learning PHP and MySQL fun through engaging examples. The textbook is intended as a self-study book. To supplement the book, I have created the following slideshows for my students at Saint Paul College. The textbook has 12 chapters, but for the course I teach I only use chapters 1-10. After we finish chapter 10, the students complete a final project applying what they have learned in Chapters 1 - 10. The textbook provides starter files for each chapter, and as the students work through each chapter the files are added to with code from the chapter.
Aliens
Chapter 1: It's Alive! Intro to PHP
Chapter 2: How it fits together: Linking together the PHP and the database
Elvis Web Application
Chapter 3: Create a Web Application
Chapter 4: Verifications and Checks
Guitar Wars
Download Guitar Wars Initial Code
Chapter 5: Adding images to a database
Mismatch Dating
Download Mismatch Initial Code
Chapter 7: User login for web applications and duplicate code
Chapter 8: More complex queries
Risky Jobs
Download Risky Jobs Initial Code
Additional Slideshows
How to Create your Database Tables
Integrated Development Environments
Uploading a CSV File to phpMyAdmin
Final Project
Example Final Project Contact System
This simple web application is an example of what students could create for their final project. It has enough complexity to demonstrate PHP skills but the scope is very narrow. Contact Susan Metoxen for the username and password to access it.