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
26,179 recent views
Skills you will gain
Hypertext Preprocessor (PHP)Create, Read, Update And DeleteMySQL
Syllabus - What you will learn from this course
Week
13 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
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
Week
26 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
PDO10m
Week
33 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
Cookies7m
Sessions10m
Sessions Without Cookies4m
Code Walkthrough - Cookies and Sessions10m
Bonus: Office Hours, Detroit, Michigan1m
1 practice exercise
Sessions34m
Week
46 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
Routing22m
4.9
76 Reviews67%
started a new career after completing these courses
57%
got a tangible career benefit from this course
Top reviews from Building Database Applications in PHP
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.
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.
Instructor
Charles Russell Severance
Clinical ProfessorSchool 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 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.
Coursera provides universal access to the world’s best education,
partnering with top universities and organizations to offer courses online.
© 2019 Coursera Inc. All rights reserved.
