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
27,411 visualizações recentes
Learner Career Outcomes
57%
comecei uma nova carreira após concluir estes cursos
50%
consegui um benefício significativo de carreira com este curso
Habilidades que você terá
Hypertext Preprocessor (PHP)Create, Read, Update And DeleteMySQL
Programa - O que você aprenderá com este curso
Semana
13 horas para concluir
PHP Objects
We look at the object oriented patterns available in PHP.
14 vídeos (Total 104 mín.), 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
26 horas para concluir
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 (Total 76 mín.), 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
33 horas para concluir
PHP Cookies and Sessions
We look at how PHP uses cookies and manages session data.
5 vídeos (Total 36 mín.), 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
46 horas para concluir
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 (Total 59 mín.), 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
Convide seus amigos e ganhe 50% de desconto
Compartilhe seu amor pelo conhecimento! Convide um amigo para fazer um curso e vocês receberão 50% de desconto em um curso ou no primeiro mês de um curso integrado quando o seu amigo fizer uma compra.
Ver termos e condiçõesPrincipais avaliações do 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.
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 Russell Severance
Clinical ProfessorSchool of Information
Sobre 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.
Sobre Programa de cursos integrados 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.
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.
© 2019 Coursera Inc. Todos os direitos reservados.
