Tools, FAQ, Tutorials:
Updating Existing Rows in PHP
How To Update Existing Rows in a Table in PHP?
✍: FYIcenter.com
Updating existing rows in a table requires to run the UPDATE statement with a WHERE clause to identify the row. The following sample script updates one row with two new values:
<?php include "mysql_connection.php"; $sql = "UPDATE fyi_links SET notes='Nice site.', counts=8" . " WHERE id = 102"; if (mysql_query($sql, $con)) { print(mysql_affected_rows() . " rows updated.\n"); } else { print("SQL statement failed.\n"); } mysql_close($con); ?>
If you run this script, you will get something like this:
1 rows updated.
⇒ Deleting Existing Rows in PHP
⇐ Looping through Returning Rows from a Query in PHP
2016-10-19, 1701🔥, 0💬
Popular Posts:
How to add request body examples to my Azure API operation to make it more user friendly? If you hav...
What Azure AD App Registration Manifest? Azure AD App Registration Manifest is JSON file that contai...
What is EPUB 2.0 Metadata "dc:publisher" and "dc:rights" elements? EPUB 2.0 Metadata "dc:publisher" ...
How to detect errors occurred in the json_decode() call? You can use the following two functions to ...
How To Use an Array as a Queue in PHP? A queue is a simple data structure that manages data elements...