Building Database Applications in PHP
Learn PHP object oriented patterns, connecting PHP to MySQL using PDO library, managing session data, avoiding double posting, implementing flash messages, and user authentication in web applications. Build a complete CRUD application. Assumes prior knowledge of Building Web Applications 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. It is assumed that learners have already taken the Building Web Applications course in this specialization.
What you will learn
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.
