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.
이 강좌는 Web Applications for Everybody 전문 분야의 일부입니다.
Building Database Applications in PHP
제공자:
About this Course
최근 조회 24,048회
귀하가 습득할 기술
Hypertext Preprocessor (PHP)Create, Read, Update And DeleteMySQL
강의 계획 - 이 강좌에서 배울 내용
주
1완료하는 데 3시간 필요
PHP Objects
We look at the object oriented patterns available in PHP.
14 videos (Total 104 min), 6 readings, 1 quiz
14개의 동영상
Object Oriented Concepts12m
Creating Objects in PHP7m
Object Oriented Libraries in PHP6m
Object Life Cycle in PHP5m
Object Inheritance in PHP9m
Installing MAMP on Macintosh7m
Installing MAMP on Windows1014m
Installing XAMPP on Windows109m
Windows: Using NGrok with the Autograder5m
Windows: Using LocalTunnel with the Autograder4m
Macintosh: Using NGrok with the Autograder9m
Macintosh: Using LocalTunnel with the Autograder4m
Bonus: Office Hours New York City4m
6개의 읽기 자료
Textbook10m
Help Us Learn More About You!10m
About This Section10m
Installation Handouts10m
Installing LAMP On Linux10m
Submitting your code to the autograder10m
1개 연습문제
PHP Objects16m
주
2완료하는 데 6시간 필요
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 videos (Total 76 min), 1 reading, 3 quizzes
9개의 동영상
Running SQL Queries in PHP11m
Accessing MySQL Using PDO: Inserting Data10m
Security Issue: Avoiding SQL Injection9m
Error Handling with PDO8m
Code Walkthrough - PHP, MySQL, and PDO8m
Code Walkthrough - Inserting and Deleting Data9m
Code Walkthrough - Security and SQL Injection8m
Bonus: Office Hours Orem, Utah1m
1개의 읽기 자료
Assignment Specification: Autos Database10m
1개 연습문제
PDO10m
주
3완료하는 데 3시간 필요
PHP Cookies and Sessions
We look at how PHP uses cookies and manages session data.
5 videos (Total 36 min), 2 quizzes
5개의 동영상
Cookies7m
Sessions10m
Sessions Without Cookies4m
Code Walkthrough - Cookies and Sessions10m
Bonus: Office Hours, Detroit, Michigan1m
1개 연습문제
Sessions34m
주
4완료하는 데 6시간 필요
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 videos (Total 59 min), 1 reading, 3 quizzes
7개의 동영상
Code Walkthrough - Routing and Redirect5m
POST / Refresh / Redirect10m
Code Walkthrough - POST / Redirect6m
Implementing Login and Logout10m
Code Walkthrough - Login and Logout (3)6m
Bonus: Office Hours/Reunion Bletchley Park9m
1개의 읽기 자료
Assignment Specification: Autos with Post-Redirect10m
1개 연습문제
Routing22m
4.9
65개의 리뷰67%
이 강좌를 수료한 후 새로운 경력 시작하기
57%
이 강좌를 통해 확실한 경력상 이점 얻기
Building Database Applications in PHP의 최상위 리뷰
Awesome course, I think anyone who wants to do web app stuff should try this. Although it would a little difficult to go through the autograder, but believe me, It's worth it. Dedication is the key.
I appreciated this course. It was simple and succinct. I'm using the topics learned as a basis for more learning. Sadly, there are no courses on Advanced PHP.
강사
Charles Severance
ProfessorSchool of Information
미시건 대학교 정보
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.
Web Applications for Everybody 전문 분야 정보
This specialization is a basic introduction to building web applications, and is an excellent starting point for learners who already have a basic understanding of programming, HTML, and CSS. In Web Applications for Everybody, learners will be introduced to web and database applications in PHP, using SQL for database creation, as well as functionality in JavaScript, jQuery, and JSON.
This specialization (and its prerequisites) will prepare learners with no experience in programming or technology for an entry level web developer position in PHP.
자주 묻는 질문
강의 및 과제를 언제 이용할 수 있게 되나요?
강좌에 등록하면 바로 모든 비디오, 테스트 및 프로그래밍 과제(해당하는 경우)에 접근할 수 있습니다. 상호 첨삭 과제는 이 세션이 시작된 경우에만 제출하고 검토할 수 있습니다. 강좌를 구매하지 않고 살펴보기만 하면 특정 과제에 접근하지 못할 수 있습니다.
이 전문 분야를 구독하면 무엇을 이용할 수 있나요?
강좌를 등록하면 전문 분야의 모든 강좌에 접근할 수 있고 강좌를 완료하면 수료증을 취득할 수 있습니다. 전자 수료증이 성취도 페이지에 추가되며 해당 페이지에서 수료증을 인쇄하거나 LinkedIn 프로필에 수료증을 추가할 수 있습니다. 강좌 내용만 읽고 살펴보려면 해당 강좌를 무료로 청강할 수 있습니다.
환불 규정은 어떻게 되나요?
재정 지원을 받을 수 있나요?
What software will be required?
All software used in this course is free and open source and can be installed on Windows, Macintosh or Linux computers.
Is there a textbook?
Yes - the textbook “The Missing Link: An Introduction to Web Development and Programming" is freely downloadable in PDF and ePub formats and print copies can be purchased if desired.
궁금한 점이 더 있으신가요? 학습자 도움말 센터를 방문해 보세요.
Coursera provides universal access to the world’s best education,
partnering with top universities and organizations to offer courses online.
© 2019 Coursera Inc. All rights reserved.
