關於此課程：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.
此課程適用人群：Students who would like to learn to build database-backed web applications
製作方： 密歇根大学
教學方： Charles Severance, Associate Professor
School of Information
| 基本信息 | 課程 3（共 4 門，Web Applications for Everybody Specialization ） |
| 級別 | 中級 |
| 承諾學習時間 | 8-10 hours per week |
| 語言 | English |
| 硬件要求 | The typical student will use a laptop or desktop computer running MacOX, Windows, or Linux. |
| 如何通過 | 通過所有計分作業以完成課程。 |
| 用戶評分 |
授課大綱
第 1 週
PHP Objects
We look at the object oriented patterns available in PHP.
7 個視頻, 2 個閱讀材料, 1 個練習測驗
- Reading: Textbook
- Discussion Prompt: Your Own PHP/SQL/HTML/CSS Experience
- Reading: Help Us Learn More About You!
- 視頻: Object Oriented Concepts
- 視頻: Creating Objects in PHP
- 視頻: Object Oriented Libraries in PHP
- 視頻: Object Life Cycle in PHP
- 視頻: Object Inheritance in PHP
- Practice Quiz: PHP Objects
- 視頻: Bonus: Office Hours New York City
第 2 週
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.
9 個視頻, 1 個閱讀材料, 1 個練習測驗
- 視頻: 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
- Practice Quiz: PDO
- Reading: Assignment Specification: Autos Database
- 視頻: Bonus: Office Hours Orem, Utah
已評分: Autograder: Autos Database
已評分: Peer graded: Autos Database
第 3 週
PHP Cookies and Sessions
We look at how PHP uses cookies and manages session data.
5 個視頻, 1 個練習測驗
- 視頻: Sessions
- 視頻: Sessions Without Cookies
- 視頻: Code Walkthrough - Cookies and Sessions
- Practice Quiz: Sessions
- 視頻: Bonus: Office Hours, Detroit, Michigan
已評分: Auto-Grader: Cookies and Session
第 4 週
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.
7 個視頻, 1 個閱讀材料, 1 個練習測驗
- 視頻: Code Walkthrough - Routing and Redirect
- 視頻: POST / Refresh / Redirect
- 視頻: Code Walkthrough - POST / Redirect
- 視頻: Implementing Login and Logout
- 視頻: Code Walkthrough - Login and Logout (3)
- Practice Quiz: Routing
- Reading: Assignment Specification: Autos with Post-Redirect
- 視頻: Bonus: Office Hours/Reunion Bletchley Park
已評分: Auto-Grader: Autos with Post-Redirect
已評分: Peer-Grader: Autos with Post-Redirect
第 5 週
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.
5 個視頻, 2 個閱讀材料
- 視頻: Code Walkthrough - CRUD in PHP
- Reading: Assignment Specification: Autos C.R.U.D.
- 視頻: Bonus: Office Hours - Atlanta, Georgia
- 視頻: Fun: Dr. Chuck Pretends to be a News Anchor
- 視頻: Fun: Graduation Ceremony
- Reading: Post-Course Survey
已評分: Auto-Grader: Autos CRUD
已評分: Peer-Grader: Autos CRUD
常見問題解答
運作方式
Coursework
Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.
Help from Your Peers
Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.
Certificates
Earn official recognition for your work, and share your success with friends, colleagues, and employers.
製作方
密歇根大学
The mission of the University of Michigan is to serve the people of Michigan and the world through preeminence in creating, communicating, preserving and applying knowledge, art, and academic values, and in developing leaders and citizens who will challenge the present and enrich the future.
價格
| 購買課程 | |
|---|---|
| 訪問課程材料 | 可用 |
| 訪問評分的材料 | 可用 |
| 收到最終成績 | 可用 |
| 獲得可共享的課程證書 | 可用 |
評分和審閱
Not yet completed. Goodwill because of the instructor. Now [9 Sep 2018, 0259 +2GMT] just added another star to the course because of what I deem to be excellent lecturers
Great course!
Very thorough an worth the time to invest in. The last assignment for CRUD brings it together.
Love the course. I learned a lot.