UPDATE table_name SET column1=value, column2=value2. WHERE column_name=some_value Let's make a SQL query using the UPDATE statement and WHERE clause, after that we will execute this query through passing it to the PHP mysqli_query() function to update the tables records. Consider the following persons table inside the demo database: +----+------------+-----------+----------------------+| id| first_name| last_name| email| +----+------------+-----------+----------------------+| 1| Peter| Parker| [email protected]|| 2| John| Rambo| [email protected]|| 3| Clark| Kent| [email protected]|| 4| John| Carter| [email protected]|| 5| Harry| Potter| [email protected]| +----+------------+-----------+----------------------+ The PHP code in the following example will update the email address of a person in the persons table whose id is equal to 1. In this article. Step 1: Enable the submit data connection. Step 2: Configure the submit options. When you design a form template that is based on a Microsoft SQL Server database, the Data Connection Wizard enables a submit data connection to the database if the following conditions are met.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |