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, 1430🔥, 0💬
Popular Posts:
How to search for the first match of a regular expression using re.search()? The re.search() functio...
FYIcenter JSON Validator and Formatter is an online tool that checks for syntax errors of JSON text ...
Why I am getting "The Windows SDK version 8.1 was not found" error, when building my C++ application...
How to access Query String parameters from "context.Request.Url.Que ry"object in Azure API Policy? Q...
What is EPUB 2.0 Metadata "dc:creator" and "dc:contributor" elements? EPUB 2.0 Metadata "dc:creator"...