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.
Este curso forma parte de Programa Especializado - Web Applications for Everybody
Building Database Applications in PHP
ofrecido por
Acerca de este Curso
23,464 vistas recientes
Habilidades que obtendrás
Hypertext Preprocessor (PHP)Create, Read, Update And DeleteMySQL
Los estudiantes que toman este Course son
- Security Engineers
- Customer Care Reps
- Pharmacists
- Entrepreneurs
- Customer Service Agents
Programa - Qué aprenderás en este curso
Semana
13 horas para completar
PHP Objects
We look at the object oriented patterns available in PHP.
14 videos (Total 104 minutos), 6 lecturas, 1 cuestionario
14 videos
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 lecturas
Textbook10m
Help Us Learn More About You!10m
About This Section10m
Installation Handouts10m
Installing LAMP On Linux10m
Submitting your code to the autograder10m
1 ejercicio de práctica
PHP Objects16m
Semana
26 horas para completar
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 minutos), 1 lectura, 3 cuestionarios
9 videos
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 lectura
Assignment Specification: Autos Database10m
1 ejercicio de práctica
PDO10m
Semana
33 horas para completar
PHP Cookies and Sessions
We look at how PHP uses cookies and manages session data.
5 videos (Total 36 minutos), 2 cuestionarios
5 videos
Cookies7m
Sessions10m
Sessions Without Cookies4m
Code Walkthrough - Cookies and Sessions10m
Bonus: Office Hours, Detroit, Michigan1m
1 ejercicio de práctica
Sessions34m
Semana
46 horas para completar
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 minutos), 1 lectura, 3 cuestionarios
7 videos
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 lectura
Assignment Specification: Autos with Post-Redirect10m
1 ejercicio de práctica
Routing22m
67%
comenzó una nueva carrera después de completar estos cursos
57%
consiguió un beneficio tangible en su carrera profesional gracias a este curso
Principales revisiones sobre 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.
Instructor
Charles Russell Severance
ProfessorSchool of Information
Acerca de Universidad de Míchigan
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.
Acerca de Programa especializado Web Applications for Everybody
This Specialization is an introduction to building web applications for anybody who already has a basic understanding of responsive web design with JavaScript, HTML, and CSS. Web Applications for Everybody is your introduction to web application development. You will develop web and database applications in PHP, using SQL for database creation, as well as functionality in JavaScript, jQuery, and JSON.
Over the course of this Specialization, you will create several web apps to add to your developer portfolio. This Specialization (and its prerequisites) will prepare you, even if you have little to no experience in programming or technology, for entry level web developer jobs in PHP.
You’ll demonstrate basic concepts, like database design, while working on assignments that require the development of increasing challenging web apps. From installing a text editor to understanding how a web browser interacts with a web server to handling events with JQuery, you’ll gain a complete introductory overview of web application development.
Preguntas Frecuentes
¿Cuándo podré acceder a las lecciones y tareas?
Una vez que te inscribes para obtener un Certificado, tendrás acceso a todos los videos, cuestionarios y tareas de programación (si corresponde). Las tareas calificadas por compañeros solo pueden enviarse y revisarse una vez que haya comenzado tu sesión. Si eliges explorar el curso sin comprarlo, es posible que no puedas acceder a determinadas tareas.
¿Qué recibiré si me suscribo a este Programa especializado?
Cuando te inscribes en un curso, obtienes acceso a todos los cursos que forman parte del Programa especializado y te darán un Certificado cuando completes el trabajo. Se añadirá tu Certificado electrónico a la página Logros. Desde allí, puedes imprimir tu Certificado o añadirlo a tu perfil de LinkedIn. Si solo quieres leer y visualizar el contenido del curso, puedes auditar el curso sin costo.
¿Cuál es la política de reembolsos?
¿Hay ayuda económica disponible?
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.
¿Tienes más preguntas? Visita el Centro de Ayuda al Alumno.