Acerca de este 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 quién es esta clase: Students who would like to learn to build database-backed web applications
Creada por: University of Michigan
Enseñado por: Charles Severance, Associate Professor
School of Information
| Información básica | Curso 3 de 4 en Web Applications for Everybody Specialization |
| Nivel | Intermedio |
| Compromiso | 8-10 hours per week |
| Idioma | English |
| Requerimientos de hardware | The typical student will use a laptop or desktop computer running MacOX, Windows, or Linux. |
| Cómo aprobar | Aprueba todas las tareas calificadas para completar el curso. |
| Calificaciones del usuario |
Programa
SEMANA 1
PHP Objects
We look at the object oriented patterns available in PHP.
7 videos, 2 lecturas, 1 cuestionario de práctica
- Leyendo: Textbook
- Cuadro de aviso de la discusión: Your Own PHP/SQL/HTML/CSS Experience
- Leyendo: Help Us Learn More About You!
- 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
- Cuestionario de práctica: 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 videos, 1 lectura, 1 cuestionario de práctica
- 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
- Cuestionario de práctica: PDO
- Leyendo: Assignment Specification: Autos Database
- Vídeo: Bonus: Office Hours Orem, Utah
Calificado: Autograder: Autos Database
Calificado: Peer graded: Autos Database
SEMANA 3
PHP Cookies and Sessions
We look at how PHP uses cookies and manages session data.
5 videos, 1 cuestionario de práctica
- Vídeo: Sessions
- Vídeo: Sessions Without Cookies
- Vídeo: Code Walkthrough - Cookies and Sessions
- Cuestionario de práctica: Sessions
- Vídeo: Bonus: Office Hours, Detroit, Michigan
Calificado: 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 videos, 1 lectura, 1 cuestionario de práctica
- 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)
- Cuestionario de práctica: Routing
- Leyendo: Assignment Specification: Autos with Post-Redirect
- Vídeo: Bonus: Office Hours/Reunion Bletchley Park
Calificado: Auto-Grader: Autos with Post-Redirect
Calificado: 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 videos, 2 lecturas
- Vídeo: Code Walkthrough - CRUD in PHP
- Leyendo: 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
- Leyendo: Post-Course Survey
Calificado: Auto-Grader: Autos CRUD
Calificado: Peer-Grader: Autos CRUD
Preguntas Frecuentes
Cómo funciona
Trabajo del curso
Cada curso es como un libro de texto interactivo, con videos pregrabados, cuestionarios y proyectos.
Ayuda de tus compañeros
Conéctate con miles de estudiantes y debate ideas y materiales del curso, y obtén ayuda para dominar los conceptos.
Certificados
Obtén reconocimiento oficial por tu trabajo y comparte tu éxito con amigos, compañeros y empleadores.
Creadores
University of 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.
Tarifa
| Comprar curso | |
|---|---|
| Accede a los materiales del curso | Disponible |
| Accede a los materiales con calificación | Disponible |
| Recibe una calificación final | Disponible |
| Obtén un Certificado de curso para compartir | Disponible |
Calificaciones y revisiones
This was really challenging, but excellent!
Great course learned a LOT!
This course is very nice as it helps to understand the basic of building the functional logic of any web application!!
Coursera brinda acceso universal a la mejor educación del mundo, al asociarse con las mejores universidades y organizaciones, para ofrecer cursos en línea.
© 2018 Coursera Inc. Todos los derechos reservados.
SE
amazing! just amazing!