Informações sobre o curso: 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.
Para quem é direcionado este curso: Students who would like to learn to build database-backed web applications
Desenvolvido por: Universidade de Michigan
Ministrado por: Charles Severance, Associate Professor
School of Information
| Informações básicas | Curso 3 de 4 no Web Applications for Everybody Specialization |
| Nível | Intermediate |
| Compromisso | 8-10 hours per week |
| Idioma | English |
| Requisitos de hardware | The typical student will use a laptop or desktop computer running MacOX, Windows, or Linux. |
| Como ser aprovado | Seja aprovado em todas as tarefas para concluir o curso. |
| Classificação do usuário |
Programa
SEMANA 1
PHP Objects
We look at the object oriented patterns available in PHP.
7 vídeos, 1 leitura, 1 questionário de prática
- Reading: Textbook
- Discussion Prompt: Your Own PHP/SQL/HTML/CSS Experience
- Vídeo: Welcome to the Course
- Vídeo: Object Oriented Concepts
- Vídeo: Creating Objects in PHP
- Vídeo: Object Oriented Libraries in PHP
- Vídeo: Object Life Cycle in PHP
- Vídeo: Object Inheritance in PHP
- Practice Quiz: PHP Objects
- Vídeo: Bonus: Office Hours New York City
SEMANA 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 vídeos, 1 leitura, 1 questionário de prática
- Vídeo: PHP Database Libraries
- Vídeo: Running SQL Queries in PHP
- Vídeo: Accessing MySQL Using PDO: Inserting Data
- Vídeo: Security Issue: Avoiding SQL Injection
- Vídeo: Error Handling with PDO
- Vídeo: Code Walkthrough - PHP, MySQL, and PDO
- Vídeo: Code Walkthrough - Inserting and Deleting Data
- Vídeo: Code Walkthrough - Security and SQL Injection
- Practice Quiz: PDO
- Reading: Assignment Specification: Autos Database
- Vídeo: Bonus: Office Hours Orem, Utah
Nota atribuída: Autograder: Autos Database
Nota atribuída: Peer graded: Autos Database
SEMANA 3
PHP Cookies and Sessions
We look at how PHP uses cookies and manages session data.
5 vídeos, 1 questionário de prática
- Vídeo: Cookies
- Vídeo: Sessions
- Vídeo: Sessions Without Cookies
- Vídeo: Code Walkthrough - Cookies and Sessions
- Practice Quiz: Sessions
- Vídeo: Bonus: Office Hours, Detroit, Michigan
Nota atribuída: Auto-Grader: Cookies and Session
SEMANA 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 vídeos, 1 leitura, 1 questionário de prática
- Vídeo: Redirect, Routing, and Authentication
- Vídeo: Code Walkthrough - Routing and Redirect
- Vídeo: POST / Refresh / Redirect
- Vídeo: Code Walkthrough - POST / Redirect
- Vídeo: Implementing Login and Logout
- Vídeo: Code Walkthrough - Login and Logout (3)
- Practice Quiz: Routing
- Reading: Assignment Specification: Autos with Post-Redirect
- Vídeo: Bonus: Office Hours/Reunion Bletchley Park
Nota atribuída: Auto-Grader: Autos with Post-Redirect
Nota atribuída: Peer-Grader: Autos with Post-Redirect
SEMANA 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 vídeos, 1 leitura
- Vídeo: Create, Read, Update and Delete (CRUD)
- Vídeo: Code Walkthrough - CRUD in PHP
- Reading: Assignment Specification: Autos C.R.U.D.
- Vídeo: Bonus: Office Hours - Atlanta, Georgia
- Vídeo: Fun: Dr. Chuck Pretends to be a News Anchor
- Vídeo: Fun: Graduation Ceremony
Nota atribuída: Auto-Grader: Autos CRUD
Nota atribuída: Peer-Grader: Autos CRUD
Perguntas frequentes
Como funciona
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.
Desenvolvedores
Universidade de Michigan
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.
Custo
| Comprar curso | |
|---|---|
| Acesso aos materiais do curso | Disponível |
| Acesso a materiais valendo nota | Disponível |
| Receba uma nota final | Disponível |
| Obtenha um Certificado de Curso compartilhável | Disponível |
Classificações e avaliações
One of the most insightful courses about interfacing HTML,CSS,mySQL, integrated with PHP. You will gain years of experience with Dr. Chuck's courses!
Very introductory, but a great way to get started in SQL if you're already familiar with PHP.
Great Course for starters
O Coursera proporciona acesso universal à melhor educação do mundo fazendo parcerias com as melhores universidades e organizações para oferecer cursos on-line.
© 2018 Coursera Inc. Todos os direitos reservados.
A amazing course...Thanks for the course