Buy Now AED 170.99 + VAT

Monthly Subscription Starting at AED 99 + VAT

Building Database Applications in PHP
  • Level Professional
  • Duration 24 hours
  • Course by University of Michigan
  • Offered by

About

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.

Modules

Course Materials

    • 3 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Your Own PHP/SQL/HTML/CSS Experience

3 Readings

  • Textbook
  • Help Us Learn More About You!
  • Syllabus

Lecture Content

    • 6 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • PHP Objects

6 Videos

  • Welcome to the Course
  • Object Oriented Concepts
  • Creating Objects in PHP
  • Object Oriented Libraries in PHP
  • Object Life Cycle in PHP
  • Object Inheritance in PHP

Optional: Setting up your PHP/MySql Development Environment

    • 5 Videos
    • 4 Readings
Show info about module content

5 Videos

  • Installing MAMP on Macintosh
  • Installing MAMP on Windows10
  • Installing XAMPP on Windows10
  • Windows: Using NGrok with the Autograder
  • Macintosh: Using NGrok with the Autograder

4 Readings

  • About This Section
  • Installation Handouts
  • Installing LAMP On Linux
  • Submitting your code to the autograder

Bonus Materials

    • 1 Videos
Show info about module content

1 Videos

  • Bonus: Office Hours New York City

Lecture Content

    • 8 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • PDO

8 Videos

  • PHP Database Libraries
  • Running SQL Queries in PHP
  • Accessing MySQL Using PDO: Inserting Data
  • Security Issue: Avoiding SQL Injection
  • Error Handling with PDO
  • Code Walkthrough - PHP, MySQL, and PDO
  • Code Walkthrough - Inserting and Deleting Data
  • Code Walkthrough - Security and SQL Injection

Assignments

    • 1 Readings
    • 2 ExternalTool
Show info about module content

2 External Tool

  • Autograder: Autos Database
  • Peer graded: Autos Database

1 Readings

  • Assignment Specification: Autos Database

Bonus Materials

    • 1 Videos
Show info about module content

1 Videos

  • Bonus: Office Hours Orem, Utah

Lecture Materials

    • 4 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Sessions

4 Videos

  • Cookies
  • Sessions
  • Sessions Without Cookies
  • Code Walkthrough - Cookies and Sessions

Assignment

    • 1 ExternalTool
Show info about module content

1 External Tool

  • Auto-Grader: Cookies and Session

Bonus Materials

    • 1 Videos
Show info about module content

1 Videos

  • Bonus: Office Hours, Detroit, Michigan

Lecture Content

    • 6 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Routing

6 Videos

  • Redirect, Routing, and Authentication
  • Code Walkthrough - Routing and Redirect
  • POST / Refresh / Redirect
  • Code Walkthrough - POST / Redirect
  • Implementing Login and Logout
  • Code Walkthrough - Login and Logout (3)

Assignments

    • 1 Readings
    • 2 ExternalTool
Show info about module content

2 External Tool

  • Auto-Grader: Autos with Post-Redirect
  • Peer-Grader: Autos with Post-Redirect

1 Readings

  • Assignment Specification: Autos with Post-Redirect

Bonus Materials

    • 1 Videos
Show info about module content

1 Videos

  • Bonus: Office Hours/Reunion Bletchley Park

Lecture Content

    • 2 Videos
Show info about module content

2 Videos

  • Create, Read, Update and Delete (CRUD)
  • Code Walkthrough - CRUD in PHP

Assignments

    • 1 Readings
    • 2 ExternalTool
Show info about module content

2 External Tool

  • Auto-Grader: Autos CRUD
  • Peer-Grader: Autos CRUD

1 Readings

  • Assignment Specification: Autos C.R.U.D.

Bonus Materials

    • 2 Videos
Show info about module content

2 Videos

  • Bonus: Office Hours - Atlanta, Georgia
  • Fun: Dr. Chuck Pretends to be a News Anchor

Graduation Ceremony

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Fun: Graduation Ceremony

2 Readings

  • Post-Course Survey
  • Keep Learning with Michigan Online

Auto Summary

"Building Database Applications in PHP" is a professional-level course in IT & Computer Science, led by Coursera. It focuses on object-oriented PHP, MySQL connections via PDO, session management, and CRUD operations. Ideal for those with prior web application knowledge, the course spans 1440 minutes and offers starter subscription options. Perfect for aspiring web developers.

Charles Russell Severance
Instructor

Charles Russell Severance