About this Course
24,200 recent views

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Intermediate Level


Subtitles: English, Korean

Skills you will gain

Hypertext Preprocessor (PHP)Create, Read, Update And DeleteMySQL

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Intermediate Level


Subtitles: English, Korean

Syllabus - What you will learn from this course

3 hours to complete

PHP Objects

We look at the object oriented patterns available in PHP.

14 videos (Total 104 min), 6 readings, 1 quiz
14 videos
Object Oriented Concepts12m
Creating Objects in PHP7m
Object Oriented Libraries in PHP6m
Object Life Cycle in PHP5m
Object Inheritance in PHP9m
Installing MAMP on Macintosh7m
Installing MAMP on Windows1014m
Installing XAMPP on Windows109m
Windows: Using NGrok with the Autograder5m
Windows: Using LocalTunnel with the Autograder4m
Macintosh: Using NGrok with the Autograder9m
Macintosh: Using LocalTunnel with the Autograder4m
Bonus: Office Hours New York City4m
6 readings
Help Us Learn More About You!10m
About This Section10m
Installation Handouts10m
Installing LAMP On Linux10m
Submitting your code to the autograder10m
1 practice exercise
PHP Objects16m
6 hours to complete

Connecting PHP and MySQL

We look at how we connect to a MySQL using the Portable Data Objects (PDO) library and issue SQL commands in the the PHP language.

9 videos (Total 76 min), 1 reading, 3 quizzes
9 videos
Running SQL Queries in PHP11m
Accessing MySQL Using PDO: Inserting Data10m
Security Issue: Avoiding SQL Injection9m
Error Handling with PDO8m
Code Walkthrough - PHP, MySQL, and PDO8m
Code Walkthrough - Inserting and Deleting Data9m
Code Walkthrough - Security and SQL Injection8m
Bonus: Office Hours Orem, Utah1m
1 reading
Assignment Specification: Autos Database10m
1 practice exercise
3 hours to complete

PHP Cookies and Sessions

We look at how PHP uses cookies and manages session data.

5 videos (Total 36 min), 2 quizzes
5 videos
Sessions Without Cookies4m
Code Walkthrough - Cookies and Sessions10m
Bonus: Office Hours, Detroit, Michigan1m
1 practice exercise
6 hours to complete

PHP Redirect, Routing, and Authentication

We look at how PHP avoids double posting data, how flash messages are implemented, and how we use a session to log in users in web applications.

7 videos (Total 59 min), 1 reading, 3 quizzes
7 videos
Code Walkthrough - Routing and Redirect5m
POST / Refresh / Redirect10m
Code Walkthrough - POST / Redirect6m
Implementing Login and Logout10m
Code Walkthrough - Login and Logout (3)6m
Bonus: Office Hours/Reunion Bletchley Park9m
1 reading
Assignment Specification: Autos with Post-Redirect10m
1 practice exercise
65 ReviewsChevron Right


started a new career after completing these courses


got a tangible career benefit from this course

Top reviews from Building Database Applications in PHP

By AAJun 30th 2018

Awesome course, I think anyone who wants to do web app stuff should try this. Although it would a little difficult to go through the autograder, but believe me, It's worth it. Dedication is the key.

By JDApr 29th 2019

I appreciated this course. It was simple and succinct. I'm using the topics learned as a basis for more learning. Sadly, there are no courses on Advanced PHP.



Charles Severance

School of Information

About University of Michigan

The mission of the University of Michigan is to serve the people of Michigan and the world through preeminence in creating, communicating, preserving and applying knowledge, art, and academic values, and in developing leaders and citizens who will challenge the present and enrich the future....

About the Web Applications for Everybody Specialization

This specialization is a basic introduction to building web applications, and is an excellent starting point for learners who already have a basic understanding of programming, HTML, and CSS. In Web Applications for Everybody, learners will be introduced to web and database applications in PHP, using SQL for database creation, as well as functionality in JavaScript, jQuery, and JSON. This specialization (and its prerequisites) will prepare learners with no experience in programming or technology for an entry level web developer position in PHP....
Web Applications for Everybody

Frequently Asked Questions

  • Once you enroll for a Certificate, you’ll have access to all videos, quizzes, and programming assignments (if applicable). Peer review assignments can only be submitted and reviewed once your session has begun. If you choose to explore the course without purchasing, you may not be able to access certain assignments.

  • When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

  • All software used in this course is free and open source and can be installed on Windows, Macintosh or Linux computers.

  • Yes - the textbook “The Missing Link: An Introduction to Web Development and Programming" is freely downloadable in PDF and ePub formats and print copies can be purchased if desired.

More questions? Visit the Learner Help Center.