CRUD—short for create, read, update, delete—represents the fYour most common operations performed on a database. Learn the MySQL syntax necessary to perform each one with SELECT, INSERT, UPDATE, and DELETE.
- [Narrator] At the beginning of this chapter,…I introduced you to this acronym: CRUD, C-R-U-D.…In this movie, we're going to learn…how you implement CRUD in MySQL.…You recall that CRUD is an acronym…for the four most basic operations…that we perform on databases:…Create, Read, Update, and Delete,…and these are the four things that we're going to do…over and over and over again with MySQL,…so we need to learn the syntax…that we can use to perform each one of these…and there's a specific syntax…and it's different for each one.…
So let's first start by looking at read,…this is the one we're going be performing the most often.…The idea is that we're reading information…back from the database,…we do that far more often than we create,…update, or delete data, we're constantly reading data back.…The way that we read data in MySQL…is with the select command.…So select and then we say what we want…to bring back from the database table.…I've got an asterisk because I want to bring back…all columns, so it's a while card saying,…
Author
Kevin Skoglund
Released
6/27/2017- Organizing project files
- Including and requiring files
- Working with URL parameters
- Encoding dynamic content
- Modifying headers and page redirection
- Creating forms and processing form data
- MySQL basics
- Using PHP to access database tables
- Creating, reading, updating, and deleting database records with PHP
- Validating data
- Preventing SQL injection
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome48s
-
-
1. Start a Database-Driven Project
-
Blueprint the application5m 49s
-
Establish your work area6m 27s
-
Make page assets reusable6m 30s
-
-
2. Build Web Pages with PHP
-
Links and URLs9m 40s
-
Use URL parameters8m 49s
-
Encode URL parameters8m 31s
-
Encode for HTML7m 18s
-
Challenge: Add pages3m 26s
-
Solution: Add pages7m 40s
-
-
3. Headers and Redirects
-
Modify headers8m 3s
-
Page redirection7m 1s
-
Output buffering6m 6s
-
-
4. Build Forms with PHP
-
Build forms8m 53s
-
Use form parameters4m 22s
-
Detect form submission5m 24s
-
Single-page form processing6m 45s
-
Challenge: Add forms2m 9s
-
Solution: Add forms5m 1s
-
-
5. MySQL Basics
-
MySQL introduction6m 15s
-
Create a database6m 30s
-
Create a database table6m 20s
-
CRUD in MySQL4m 1s
-
Populate a MySQL table6m 15s
-
Challenge: Pages table3m 51s
-
Solution: Pages table5m 15s
-
-
6. Use PHP to Access MySQL
-
Database APIs in PHP4m 22s
-
Connect to MySQL with PHP8m 56s
-
Retrieve data8m 1s
-
Work with retrieved data6m 50s
-
Error handling6m 51s
-
Challenge: List pages2m 1s
-
Solution: List pages5m 6s
-
-
7. CRUD with PHP
-
Find a single record8m 22s
-
Use form data to create records10m 38s
-
Use form data to update records11m 24s
-
Delete a record8m 23s
-
Challenge: Pages CRUD3m 10s
-
Solution: Pages CRUD8m 1s
-
-
8. Validate Data with PHP
-
Common data validation types9m 11s
-
Validate form values8m 23s
-
Display validation errors10m 11s
-
Solution: Validations8m 1s
-
-
9. Prevent SQL Injection
-
Understand SQL injection5m 17s
-
Sanitize data for SQL8m 57s
-
Delimit data values3m 54s
-
Prepared statements3m 21s
-
-
Conclusion
-
Next steps1m 8s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: CRUD in MySQL