About this course: 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.
Who is this class for: Students who would like to learn to build database-backed web applications
Created by: University of Michigan
Taught by: Charles Severance, Associate Professor
School of Information
| Basic Info | Course 3 of 4 in the Web Applications for Everybody Specialization |
| Level | Intermediate |
| Commitment | 8-10 hours per week |
| Language | English |
| Hardware Req | The typical student will use a laptop or desktop computer running MacOX, Windows, or Linux. |
| How To Pass | Pass all graded assignments to complete the course. |
| User Ratings |
Syllabus
WEEK 1
PHP Objects
We look at the object oriented patterns available in PHP.
7 videos, 2 readings, 1 practice quiz
- Reading: Textbook
- Discussion Prompt: Your Own PHP/SQL/HTML/CSS Experience
- Reading: Help Us Learn More About You!
- 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
- Practice Quiz: PHP Objects
- Video: Bonus: Office Hours New York City
WEEK 2
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, 1 reading, 1 practice quiz
- 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
WEEK 3
PHP Cookies and Sessions
We look at how PHP uses cookies and manages session data.
5 videos, 1 practice quiz
- Video: Sessions
- Video: Sessions Without Cookies
- Video: Code Walkthrough - Cookies and Sessions
- Practice Quiz: Sessions
- Video: Bonus: Office Hours, Detroit, Michigan
Graded: Auto-Grader: Cookies and Session
WEEK 4
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, 1 reading, 1 practice quiz
- 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)
- Practice Quiz: 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
WEEK 5
Building a CRUD Application
Now we build our 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.
5 videos, 2 readings
- 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
FAQs
How It Works
Coursework
Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.
Help from Your Peers
Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.
Certificates
Earn official recognition for your work, and share your success with friends, colleagues, and employers.
Creators
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.
Pricing
| Purchase Course | |
|---|---|
| Access to course materials | Available |
| Access to graded materials | Available |
| Receive a final grade | Available |
| Earn a shareable Course Certificate | Available |
Ratings and Reviews
Amazing Course, Amazing teacher! Thanks Chuck
Well structured course. Really liked the idea of working on one big project but learning new things to improve it. Really good tutorial videos.
I got here from the SQL introduction course. I must say this one was even better and it explains a lot that I have always been confused about.
Now, most of my challenges are about how to use the knowledge I could get here in order to construct efficient code for the web.
Coursera provides universal access to the world’s best education,
partnering with top universities and organizations to offer courses online.
© 2018 Coursera Inc. All rights reserved.
The best Instructor Professor Teacher I have ever seen!
Amazing course for anyone or everyone indeed!
Thanks endlessly to Dr.Chuck! He is Number 1!