Updating and deleting records with PHP is similar to the insert process, but there are two main differences: the need for an ID and the necessity of checking how many rows were actually affected by the query. This tutorial shows best practices for using MySQL commands for updating and deleting data, while explaining the pitfalls to watch out for when using these operations.
- View Offline
- Exercise Files
Updating and dealing records from PHP is going to be very similar to the insert …process that we just saw in the last movie. …However there are two important differences, let's take a look. …To begin with let's open up databases insert.php, because what we're going to …be doing is going to be very similar to this one. …But don't mess with this, let's just do a Save As and instead of Insert let's make …it Update.php. Now, the process is going to be very …similar, like I said, we're going to do our database connection opening at the …top, then we'll do our query and then we'll close it at the bottom. …There's not going to be any data for us to work with.…
So, let's paste in our update query, just a basic SQL update query. …Update statement, set. And then I'm setting menu name equal to …whatever the menu name is, position equal to position, visible equal to visible and …where id equals id. Notice that I have single quotes around …the string which is the menu name. And then there's commas in between all …
- What is PHP?
- Installing and configuring PHP and MySQL
- Exploring data types
- Controlling code with logical expressions and loops
- Using PHP's built-in functions
- Writing custom functions
- Building dynamic webpages
- Working with forms and form data
- Using cookies and sessions to store data
- Connecting to MySQL with PHP
- Creating and editing database records
- Building a content management system
- Adding user authentication
Skill Level Beginner
PHP with MySQL Beyond the Basicswith Kevin Skoglund10h 26m Intermediate
1. PHP Overview
2. Mac Installation
3. Windows Installation
4. First Steps
5. Exploring Data Types
6. Control Structures: Logical Expressions
7. Control Structures: Loops
8. User-Defined Functions
10. Building Web Pages with PHP
11. Working with Forms and Form Data
12. Working with Cookies and Sessions
13. MySQL Basics
14. Using PHP to Access MySQL
15. Building a Content Management System (CMS)
16. Using Site Navigation to Choose Content
17. Application CRUD
18. Building the Public Area
19. Regulating Page Access
Next steps2m 4s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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.