Lessons: 9Length: 1.1 hours
- Overview
- Transcript
1.1 Introduction
Hi, my name is Jeremy McPeak, and I invite you to spend some time with me as we practice and learn how to use databases in PHP. You'll learn how to:
- connect to a MySQL database
- store, retrieve, update, and delete data
- handle user input
- secure your application against SQL and JavaScript injection attacks
1.Introduction
1.1Introduction01:23
1.2What You Need09:44
2.Working With Data
2.1Creating Records (Inserting Data)13:20
2.2Reading Data08:10
2.3Updating Data With a Form: Retrieving the Record09:39
2.4Updating Data With a Form: Writing the New Record05:52
2.5Deleting Data07:47
2.6Refactoring for Clarity and Security11:55
3.Conclusion
3.1Conclusion00:56
1.1 Introduction
We write software so that we can work with data. That data can reside and files on the file system or in a web service. But for the vast majority of web applications, we use a database to store our data. And unlike files and web services there are special things that we need to be familiar with in order to connect to a database and manipulate the data it contains. And so to anyone getting started with web development working with a database can be intimidating and confusing. I mean we've all been there and I am here to help. Hi, my name is Jeremy McPeak. And I invite you to spend some time with me as we practice and learn database interaction with PHP. We'll build a simple address book in this course and you'll learn how to connect with a MySQL database and how to store, retrieve, update, and delete data within it. You'll also learn how to handle user input and how you can protect your applications from SQL injection and JavaScript injection attacks. We won't be using any third party libraries or frameworks, just plain on PHP and SQL. So that by the end of this course, you will have the confidence to start building your own secured data driven application. When you are ready queue up the next video and we will get started.
