Explore

Building Database Applications in PHP

Approx. 24 hours to complete

Save Course

Go to Course

Course Summary

This course teaches how to build web applications with PHP and MySQL. It covers everything from creating a database to deploying a web application.

Key Learning Points

Learn how to build a database from scratch
Understand how to design and implement database applications with PHP
Get hands-on experience building a web application

Job Positions & Salaries of people who have taken this course might have

- USA: $75,487
- India: ₹5,67,834
- Spain: €36,772
- USA: $75,487
- India: ₹5,67,834
- Spain: €36,772
- USA: $83,957
- India: ₹6,34,486
- Spain: €41,163
- USA: $75,487
- India: ₹5,67,834
- Spain: €36,772
- USA: $83,957
- India: ₹6,34,486
- Spain: €41,163
- USA: $91,635
- India: ₹6,89,987
- Spain: €44,738

Learning Outcomes

Understand the basics of PHP and MySQL
Design and implement a database application
Deploy a web application

Prerequisites or good to have knowledge before taking this course

Basic knowledge of HTML and CSS
Familiarity with programming concepts

Course Difficulty Level

Intermediate

Course Format

Online self-paced
Video lectures
Programming assignments
Quizzes

Similar Courses

Web Applications for Everybody
Full-Stack Web Development with React

Related Education Paths

Related Books

Description

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.

Outline

PHP Objects
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
Installing MAMP on Macintosh
Installing MAMP on Windows10
Installing XAMPP on Windows10
Windows: Using NGrok with the Autograder
Macintosh: Using NGrok with the Autograder
Bonus: Office Hours New York City
Textbook
Help Us Learn More About You!
About This Section
Installation Handouts
Installing LAMP On Linux
Submitting your code to the autograder
PHP Objects

Connecting PHP and MySQL
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
Bonus: Office Hours Orem, Utah
Assignment Specification: Autos Database
PDO

PHP Cookies and Sessions
Cookies
Sessions
Sessions Without Cookies
Code Walkthrough - Cookies and Sessions
Bonus: Office Hours, Detroit, Michigan
Sessions

PHP Redirect, Routing, and Authentication
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)
Bonus: Office Hours/Reunion Bletchley Park
Assignment Specification: Autos with Post-Redirect
Routing

Building a CRUD Application
Create, Read, Update and Delete (CRUD)
Code Walkthrough - CRUD in PHP
Bonus: Office Hours - Atlanta, Georgia
Fun: Dr. Chuck Pretends to be a News Anchor
Fun: Graduation Ceremony
Assignment Specification: Autos C.R.U.D.
Post-Course Survey
Keep Learning with Michigan Online

Summary of User Reviews

Learn how to create database applications using PHP with this highly recommended course from Coursera. Students have praised the comprehensive material and hands-on approach of the course, resulting in a high overall rating.

Key Aspect Users Liked About This Course

Students have praised the practical exercises which help them gain a better understanding of the concepts.

Pros from User Reviews

Comprehensive material that covers all important topics
Practical exercises that allow students to apply their knowledge
In-depth explanations of complex concepts
Engaging and knowledgeable instructors
Flexible schedule and self-paced learning

Cons from User Reviews

Some students found the pace too slow
Limited interaction with instructors and other students
Occasional technical issues with the platform
Lack of quizzes or assessments to test knowledge
Not suitable for students with no prior experience in PHP

Recommended for you

Build REST APIs with PHP 7 and Laravel 5

Learn to create secure, scalable, and maintainable RESTful APIs with PHP and Laravel You will first learn the basic concepts associated with the REST architectural style....

Save Course

Advanced SQL Server High Availability & Disaster Recovery

Implement tried-and-true high availability and disaster recovery solutions with SQL Server Business continuity is of utmost importance. You’ll learn what is Always On, it’s pros and cons, prerequisites, and restrictions....

Save Course