Building Database Applications in PHP

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. It is assumed that learners have already taken the Building Web Applications course in this specialization.

• PHP Objects
• We look at the object oriented patterns available in PHP.
• 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.
• PHP Cookies and Sessions
• We look at how PHP uses cookies and manages session data.
• 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.
• 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.