Clinical Professor, School of Information
Building Database Applications in PHP
What You'll Learn
- Learn about the object-oriented patterns available in PHP.
- Build your first 'complete' application that has multiple screens to Create, Read, Update and Delete your data.
- Learn how PHP uses cookies and manages session data.
5 Modules
25 Hours
5 hrs per module (approx.)
Rating
About Building Database Applications in PHP
In this course, we'll look at the object oriented patterns available in PHP. You'll learn how to connect to a MySQL using the Portable Data Objects (PDO) library and issue SQL commands in the the PHP language. We'll also look at how PHP uses cookies and manages session data. You'll learn how PHP avoids double posting data, how flash messages are implemented, and how to use a session to log in users in web applications. We'll then build the first 'complete' application that has multiple screens to Create, Read, Update and Delete (CRUD) our data. This brings all the previous concepts together and will form the basis for all later web applications. It is assumed that learners have already taken the Building Web Applications course in this specialization.
Skills You'll Gain
- MySQL
- Object-Oriented Programming (OOP)
- PHP Data Objects (PDO)
- PHP Development
- PHP Development Tools
- PHP Frameworks
What You'll Earn
- Certificate of Completion:
- Certificates of completion acknowledge knowledge acquired upon completion of a non-credit course or program.
Welcome Message
Welcome to Building Database Applications in PHP, an online course designed to teach you how to create dynamic, data-driven web applications using PHP. You will learn object-oriented programming patterns, connect PHP to MySQL with Portable Data Objects (PDO), manage cookies and sessions, prevent double-posting, implement flash messages, and build a complete Create, Read, Update, and Delete (CRUD) application. This course assumes prior completion of Building Web Applications.
This abbreviated syllabus description was created with the help of AI tools and reviewed by staff. The full syllabus is available to those who enroll in the course.
Course Schedule
Module 1: PHP Objects
- Reading: Textbook
- Discussion Prompt: Your Own PHP/SQL/HTML/CSS Experience
- Reading: Help Us Learn More About You!
- Video: Welcome to the Course
- Video: Object Oriented Concepts
- Video: Creating Objects in PHP
- Video: Object Oriented Libraries in PHP
- Video: Object Life Cycle in PHP
- Video: Object Inheritance in PHP
- Graded Assignment: PHP Objects
- Reading: About This Section
- Reading: Installation Handouts
- Video: Installing MAMP on Macintosh
- Video: Installing MAMP on Windows10
- Video: Installing XAMPP on Windows10
- Reading: Installing LAMP On Linux
- Reading: Submitting your code to the autograder
- Video: Windows: Using NGrok with the Autograder
- Video: Macintosh: Using NGrok with the Autograder
- Video: Bonus: Office Hours New York City
Module 2: Connecting PHP and MySQL
- Video: PHP Database Libraries
- Video: Running SQL Queries in PHP
- Video: Accessing MySQL Using PDO: Inserting Data
- Video: Security Issue: Avoiding SQL Injection
- Video: Error Handling with PDO
- Video: Code Walkthrough - PHP, MySQL, and PDO
- Video: Code Walkthrough - Inserting and Deleting Data
- Video: Code Walkthrough - Security and SQL Injection
- Practice Quiz: PDO
- Reading: Assignment Specification: Autos Database
- Video: Bonus: Office Hours Orem, Utah
- Graded: Autograder: Autos Database
- Graded: Peer graded: Autos Database
Module 3: PHP Cookies and Sessions
- Video: Cookies
- Video: Sessions
- Video: Sessions Without Cookies
- Video: Code Walkthrough - Cookies and Sessions
- Graded Assignment: Sessions
- Video: Bonus: Office Hours, Detroit, Michigan
- Graded: Auto-Grader: Cookies and Session
Module 4: PHP Redirect, Routing, and Authentication
- Video: Redirect, Routing, and Authentication
- Video: Code Walkthrough - Routing and Redirect
- Video: POST / Refresh / Redirect
- Video: Code Walkthrough - POST / Redirect
- Video: Implementing Login and Logout
- Video: Code Walkthrough - Login and Logout (3)
- Graded Assignment: Routing
- Reading: Assignment Specification: Autos with Post-Redirect
- Video: Bonus: Office Hours/Reunion Bletchley Park
- Graded: Auto-Grader: Autos with Post-Redirect
- Graded: Peer-Grader: Autos with Post-Redirect
Module 5: Building a CRUD Application
- Video: Create, Read, Update and Delete (CRUD)
- Video: Code Walkthrough - CRUD in PHP
- Reading: Assignment Specification: Autos C.R.U.D.
- Video: Bonus: Office Hours - Atlanta, Georgia
- Video: Fun: Dr. Chuck Pretends to be a News Anchor
- Video: Fun: Graduation Ceremony
- Reading: Post-Course Survey
- Graded: Auto-Grader: Autos CRUD
- Graded: Peer-Grader: Autos CRUD
Grading Policy
Course materials and assignments are self-paced. You must earn an overall grade of 80% to pass and receive the certificate. Assignments in each module are worth 25% of your final grade.
Course content developed by U-M faculty and managed by the university. Faculty titles and affiliations are updated periodically.
Intermediate Level
Some related experience required
