Building Database Applications in PHP (Coursera)

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.

Course 3 of 4 in the Web Applications for Everybody Specialization

Syllabus

WEEK 1

PHP Objects

We look at the object oriented patterns available in PHP.

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.

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.

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.

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.

Graded: Auto-Grader: Autos CRUD

Graded: Peer-Grader: Autos CRUD