Building Database Applications in PHP

Go to class
Write Review

Free Online Course: Building Database Applications in PHP provided by Coursera is a comprehensive online course, which lasts for 5 weeks long, 24 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from Coursera. Building Database Applications in PHP is taught by Charles Severance.

Overview
  • 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.

Syllabus
    • 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.

Tags