Скачать или смотреть MySQL Update Records | Tutorial

Course Title: Web Development Masterclass
Course Link: http://youaccel.com/admin/cdisplay.ph...

Facebook:   / youaccel  
Twitter:   / youaccel  
Website: http://youaccel.com

Tutorial Contents:

So far we have retrieved, inserted and deleted records from our table.

In this lesson we will show you how to update records in a table using the SQL UPDATE statement.

We will be creating a script that allows us to UPDATE the firstname, lastname and email of any user in our table.

First, open your delete.php file and let's add an Update link next to our Delete link.

Notice the update link has a variable id, which will send the id value to our update.php page.

Now, create a new file and save it as update.php. The update.php file, will like as shown in this example.

The page will load the first name, last name and email of the user corresponding to the id number sent in the url from our delete.php page.

In the update.php file, we start by creating a connection to the database.

Next, we create an id variable and get the value using the $_GET method..

We use a SQL statement to SELECT the records from the users table where the id column is equal to the value id stored in our variable.

We then Execute the SQL query.

Using an if statement and while loop we go through each record and store the firstname, lastname and email of each user in a variable.

Next we create a basic html page structure.

Set the form action to updateuser.php using the POST method.

Create a value attribute, for the fname field and set the value to the $fname variable.

Do the same for lname and email.

This will make sure the values are automatically placed into the input fields on page load.

Create a hidden input with the name id and value set to the id variable. This will transmit the id to our next php file.

The last page we need to create is the updateuser.php file.

This page will contain the script that actually updates a record, when the user clicks the Update button.

Start by creating your database connection variables.

Next create your validation function, and four variables that will store the user inputs from the update.php page form.

Set your database connection.

Now create a SQL UPDATE statement to update the firstname, lastname and email to the new variable values, where the record id is equal to the $id variable.

Lastly, setup a redirect to your main page (delete.php).