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
Related Topics for further study
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
IntermediateCourse 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
Charles Russell Severance
4.9 Raiting
Learn how to build a HTML 5 Login Framework Web Application
- 4.2
-
![]()
![]()
![]()
![]()
![]()
This HTML 5 login framework uses JavaScript, Ajax, JQuery, PHP & MySQL with MD5 encrypted passwords for added security. This course will show you how to build a HTML Login Framework....
Clean architecture & SOLID principles for Android in Kotlin
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Learn to implement Clean architecture in Android using SOLID principles and MVVM Learn Clean Architecture and SOLID principles with this new course on Android development and Kotlin....
SQLite for beginners
- 4.1
-
![]()
![]()
![]()
![]()
![]()
Practical Hands -on Introduction to SQLite SQLite is a software library that provides a relational database management system. SQLite does NOT require a server to run....
Introduction to Formal Concept Analysis
- 4.8
-
![]()
![]()
![]()
![]()
![]()
This course is an introduction into formal concept analysis (FCA), a mathematical theory oriented at applications in knowledge representation, knowledge acquisition, data analysis and visualization....
