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, 1402🔥, 0💬
Popular Posts:
How to read RSS validation errors at w3.org? If your RSS feed has errors, the RSS validator at w3.or...
Where to see some Examples of Invalid JSON Values? Here are some Examples of Invalid JSON Values: 1....
How to start Docker Daemon, "dockerd", on CentOS systems? If you have installed Docker on your CentO...
How to add a new operation to an API on the Publisher Dashboard of an Azure API Management Service? ...
What Happens If One Row Has Missing Columns? What happens if one row has missing columns? Most brows...