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 faz parte do Programa de cursos integrados Web Applications for Everybody
Building Database Applications in PHP
oferecido por
Informações sobre o curso
4.9
184 classificações
Habilidades que você terá
Hypertext Preprocessor (PHP)Create, Read, Update And DeleteMySQL
Programa - O que você aprenderá com este curso
Semana
1PHP Objects
We look at the object oriented patterns available in PHP.
14 videos (Total 104 min), 6 leituras, 1 teste
14 videos
Object Oriented Concepts12min
Creating Objects in PHP7min
Object Oriented Libraries in PHP6min
Object Life Cycle in PHP5min
Object Inheritance in PHP9min
Installing MAMP on Macintosh7min
Installing MAMP on Windows1014min
Installing XAMPP on Windows109min
Windows: Using NGrok with the Autograder5min
Windows: Using LocalTunnel with the Autograder4min
Macintosh: Using NGrok with the Autograder9min
Macintosh: Using LocalTunnel with the Autograder4min
Bonus: Office Hours New York City4min
6 leituras
Textbook10min
Help Us Learn More About You!10min
About This Section10min
Installation Handouts10min
Installing LAMP On Linux10min
Submitting your code to the autograder10min
1 exercício prático
PHP Objects16min
Semana
2Connecting 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 leitura, 3 testes
9 videos
Running SQL Queries in PHP11min
Accessing MySQL Using PDO: Inserting Data10min
Security Issue: Avoiding SQL Injection9min
Error Handling with PDO8min
Code Walkthrough - PHP, MySQL, and PDO8min
Code Walkthrough - Inserting and Deleting Data9min
Code Walkthrough - Security and SQL Injection8min
Bonus: Office Hours Orem, Utah1min
1 leituras
Assignment Specification: Autos Database10min
1 exercício prático
PDO10min
Semana
3PHP Cookies and Sessions
We look at how PHP uses cookies and manages session data.
5 videos (Total 36 min), 2 testes
5 videos
Cookies7min
Sessions10min
Sessions Without Cookies4min
Code Walkthrough - Cookies and Sessions10min
Bonus: Office Hours, Detroit, Michigan1min
1 exercício prático
Sessions34min
Semana
4PHP 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 leitura, 3 testes
7 videos
Code Walkthrough - Routing and Redirect5min
POST / Refresh / Redirect10min
Code Walkthrough - POST / Redirect6min
Implementing Login and Logout10min
Code Walkthrough - Login and Logout (3)6min
Bonus: Office Hours/Reunion Bletchley Park9min
1 leituras
Assignment Specification: Autos with Post-Redirect10min
1 exercício prático
Routing22min
33%
comecei uma nova carreira após concluir estes cursos
83%
consegui um benefício significativo de carreira com este curso
Melhores avaliações
por AA•Jun 30th 2018
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.
por AJ•Aug 28th 2018
One of the best PHP contents I have ever seen. I practiced and learnt a lot. This course gives nudges in the rightful directions. Still have a long way to go.
Instrutores
Charles Severance
Associate ProfessorSchool of Information
Sobre 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.
Sobre o Programa de cursos integrados 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.
Perguntas Frequentes – FAQ
Quando terei acesso às palestras e às tarefas?
Ao se inscrever para um Certificado, você terá acesso a todos os vídeos, testes e tarefas de programação (se aplicável). Tarefas avaliadas pelos colegas apenas podem ser enviadas e avaliadas após o início da sessão. Caso escolha explorar o curso sem adquiri-lo, talvez você não consiga acessar certas tarefas.
O que recebo ao me inscrever nesta Especialização?
Quando você se inscreve no curso, tem acesso a todos os cursos na Especialização e pode obter um certificado quando concluir o trabalho. Seu Certificado eletrônico será adicionado à sua página de Participações e você poderá imprimi-lo ou adicioná-lo ao seu perfil no LinkedIn. Se quiser apenas ler e assistir o conteúdo do curso, você poderá frequentá-lo como ouvinte sem custo.
Qual é a política de reembolso?
Existe algum auxílio financeiro disponível?
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.
Mais dúvidas? Visite o Central de Ajuda ao Aprendiz.
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.
