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.
Ce cours fait partie de la Spécialisation Web Applications for Everybody
Building Database Applications in PHP
Offert par
À propos de ce cours
44,843 consultations récentes
Résultats de carrière des étudiants
57%
ont commencé une nouvelle carrière après avoir terminé ce cours
50%
ont bénéficié d'un avantage concret dans leur carrières grâce à ce cours
Compétences que vous acquerrez
Hypertext Preprocessor (PHP)Create, Read, Update And DeleteMySQL
Résultats de carrière des étudiants
57%
ont commencé une nouvelle carrière après avoir terminé ce cours
50%
ont bénéficié d'un avantage concret dans leur carrières grâce à ce cours
Certificat partageable
Obtenez un Certificat lorsque vous terminez
100 % en ligne
Commencez dès maintenant et apprenez aux horaires qui vous conviennent.
Cours 3 sur 4 dans le
Dates limites flexibles
Réinitialisez les dates limites selon votre disponibilité.
Niveau intermédiaire
Approx. 20 heures pour terminer
Recommandé : 8-10 hours per week
Anglais
Sous-titres : Anglais, Coréen
Programme du cours : ce que vous apprendrez dans ce cours
3 heures pour terminer
PHP Objects
We look at the object oriented patterns available in PHP.
3 heures pour terminer
12 vidéos (Total 95 min), 6 lectures, 1 quiz
12 vidéos
Object Oriented Concepts12 min
Creating Objects in PHP7 min
Object Oriented Libraries in PHP6 min
Object Life Cycle in PHP5 min
Object Inheritance in PHP9 min
Installing MAMP on Macintosh7 min
Installing MAMP on Windows1014 min
Installing XAMPP on Windows109 min
Windows: Using NGrok with the Autograder5 min
Macintosh: Using NGrok with the Autograder9 min
Bonus: Office Hours New York City4 min
6 lectures
Textbook10 min
Help Us Learn More About You!10 min
About This Section10 min
Installation Handouts10 min
Installing LAMP On Linux10 min
Submitting your code to the autograder10 min
1 exercice pour s'entraîner
PHP Objects16 min
6 heures pour terminer
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.
6 heures pour terminer
9 vidéos (Total 76 min), 1 lecture, 3 quiz
9 vidéos
Running SQL Queries in PHP11 min
Accessing MySQL Using PDO: Inserting Data10 min
Security Issue: Avoiding SQL Injection9 min
Error Handling with PDO8 min
Code Walkthrough - PHP, MySQL, and PDO8 min
Code Walkthrough - Inserting and Deleting Data9 min
Code Walkthrough - Security and SQL Injection8 min
Bonus: Office Hours Orem, Utah1 min
1 lecture
Assignment Specification: Autos Database10 min
1 exercice pour s'entraîner
PDO10 min
3 heures pour terminer
PHP Cookies and Sessions
We look at how PHP uses cookies and manages session data.
3 heures pour terminer
5 vidéos (Total 36 min)
5 vidéos
Cookies7 min
Sessions10 min
Sessions Without Cookies4 min
Code Walkthrough - Cookies and Sessions10 min
Bonus: Office Hours, Detroit, Michigan1 min
1 exercice pour s'entraîner
Sessions34 min
6 heures pour terminer
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.
6 heures pour terminer
7 vidéos (Total 59 min), 1 lecture, 3 quiz
7 vidéos
Code Walkthrough - Routing and Redirect5 min
POST / Refresh / Redirect10 min
Code Walkthrough - POST / Redirect6 min
Implementing Login and Logout10 min
Code Walkthrough - Login and Logout (3)6 min
Bonus: Office Hours/Reunion Bletchley Park9 min
1 lecture
Assignment Specification: Autos with Post-Redirect10 min
1 exercice pour s'entraîner
Routing22 min
Avis
4.9
Meilleurs avis pour BUILDING DATABASE APPLICATIONS IN PHP
par AAJun 29, 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.
par TGSep 8, 2018
Not yet completed. Goodwill because of the instructor. Now [9 Sep 2018, 0259 +2GMT] just added another star to the course because of what I deem to be excellent lecturers
par AJAug 27, 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.
par JDApr 28, 2019
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.
par IIMay 18, 2018
The best Instructor Professor Teacher I have ever seen!\n\nAmazing course for anyone or everyone indeed!\n\nThanks endlessly to Dr.Chuck! He is Number 1!
par SKApr 3, 2018
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!
par CBMay 13, 2018
Well structured course. Really liked the idea of working on one big project but learning new things to improve it. Really good tutorial videos.
par DDMar 19, 2018
A very important course for backend web development. Thanks to the professor and teaching staff for making this course so much fun . :)
par CWJan 6, 2020
This course really helped me fill in all the gaps that being a self taught developer left. Can't wait to continue with others.
par SSep 2, 2019
Best Course For Database using PHP and you will learn a lot using assignments. Thank You sir, For this informative Course.
par DRJul 28, 2019
i think if we tought of how create a class object would make this course best.\n\nbut overal fantastic and well presented
par JRJul 3, 2018
This course will show you how to work on database in php from a basic way of thinking.And basic means the real god base.
par AAJul 5, 2018
This course is very nice as it helps to understand the basic of building the functional logic of any web application!!
par JNJul 13, 2019
Another highly educational class by the University of Michigan, presented by the entertaing Charles Severance!
par MCApr 6, 2019
It was a really fun course to learn and it was exactly what I was looking for! Would recommend it to a friend!
par RLMar 18, 2018
This course was AMAZING! It literally got me interested in web development and PHP! Thank you Dr. Chuck! :)
par HKJul 4, 2018
This makes my evrything super easy.Thank you to Dr.Chuck for very good explaiantion.I am glad to having you
par MZNov 7, 2018
Excellent Course.\n\nComplete PHP information / guidelines were provided including security measures.
par HHFeb 10, 2018
I really enjoyed this class. I not only learned more PHP, but I learned about databases and mySQL.
par CCDec 5, 2017
Everything is fine except peer review.... its really time consuming to wait for others to grade
Offert par
Université du 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.
À propos du Spécialisation 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.
Foire Aux Questions
Quand aurai-je accès aux vidéos de cours et aux devoirs ?
Une fois que vous êtes inscrit(e) pour un Certificat, vous pouvez accéder à toutes les vidéos de cours, et à tous les quiz et exercices de programmation (le cas échéant). Vous pouvez soumettre des devoirs à examiner par vos pairs et en examiner vous-même uniquement après le début de votre session. Si vous préférez explorer le cours sans l'acheter, vous ne serez peut-être pas en mesure d'accéder à certains devoirs.
À quoi ai-je droit si je m'abonne à cette Spécialisation ?
Lorsque vous vous inscrivez au cours, vous bénéficiez d'un accès à tous les cours de la Spécialisation, et vous obtenez un Certificat lorsque vous avez réussi. Votre Certificat électronique est alors ajouté à votre page Accomplissements. À partir de cette page, vous pouvez imprimer votre Certificat ou l'ajouter à votre profil LinkedIn. Si vous souhaitez seulement lire et visualiser le contenu du cours, vous pouvez accéder gratuitement au cours en tant qu'auditeur libre.
Quelle est la politique de remboursement ?
Une aide financière est-elle possible ?
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.
D'autres questions ? Visitez le Centre d'Aide pour les Etudiants.
