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.
This course is part of the Web Applications for Everybody Specialization
Building Database Applications in PHP
Offered By
About this Course
37,864 recent views
Learner Career Outcomes
57%
started a new career after completing these courses
50%
got a tangible career benefit from this course
Skills you will gain
Hypertext Preprocessor (PHP)Create, Read, Update And DeleteMySQL
Learner Career Outcomes
57%
started a new career after completing these courses
50%
got a tangible career benefit from this course
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Course 3 of 4 in the
Flexible deadlines
Reset deadlines in accordance to your schedule.
Intermediate Level
Approx. 20 hours to complete
Suggested: 8-10 hours per week
English
Subtitles: English, Korean
Offered by
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.
Syllabus - What you will learn from this course
3 hours to complete
PHP Objects
We look at the object oriented patterns available in PHP.
3 hours to complete
12 videos (Total 95 min), 6 readings, 1 quiz
12 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
Macintosh: Using NGrok with the Autograder9m
Bonus: Office Hours New York City4m
6 readings
Textbook10m
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.
6 hours to complete
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
PDO10m
3 hours to complete
PHP Cookies and Sessions
We look at how PHP uses cookies and manages session data.
3 hours to complete
5 videos (Total 36 min)
5 videos
Cookies7m
Sessions10m
Sessions Without Cookies4m
Code Walkthrough - Cookies and Sessions10m
Bonus: Office Hours, Detroit, Michigan1m
1 practice exercise
Sessions34m
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.
6 hours to complete
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
Routing22m
Reviews
4.9
TOP REVIEWS FROM BUILDING DATABASE APPLICATIONS IN PHP
by AAJun 29, 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 TGSep 8, 2018
Not yet completed. Goodwill because of the instructor. Now [9 Sep 2018, 0259 +2GMT] just added another star to the course because of what I deem to be excellent lecturers
by AJAug 27, 2018
One of the best PHP contents I have ever seen. I practiced and learnt a lot. This course gives nudges in the rightful directions. Still have a long way to go.
by JDApr 28, 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.
About the Web Applications for Everybody Specialization
This Specialization is an introduction to building web applications for anybody who already has a basic understanding of responsive web design with JavaScript, HTML, and CSS. Web Applications for Everybody is your introduction to web application development. You will develop web and database applications in PHP, using SQL for database creation, as well as functionality in JavaScript, jQuery, and JSON.
Over the course of this Specialization, you will create several web apps to add to your developer portfolio. This Specialization (and its prerequisites) will prepare you, even if you have little to no experience in programming or technology, for entry level web developer jobs in PHP.
You’ll demonstrate basic concepts, like database design, while working on assignments that require the development of increasing challenging web apps. From installing a text editor to understanding how a web browser interacts with a web server to handling events with JQuery, you’ll gain a complete introductory overview of web application development.
Frequently Asked Questions
When will I have access to the lectures and assignments?
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.
What will I get if I subscribe to this Specialization?
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.
What is the refund policy?
Is financial aid available?
What software will be required?
All software used in this course is free and open source and can be installed on Windows, Macintosh or Linux computers.
Is there a textbook?
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.