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, 1216👍, 0💬
Popular Posts:
How to create a navigation file like navigation.xhtml for an EPUB 3.0 book? At least one navigation ...
Can Two Forms Be Nested? Can two forms be nested? The answer is no and yes: No. You can not nest two...
How to use the "set-backend-service" Policy Statement for an Azure API service operation? The "set-b...
Where to see resource detailed information of my API Management Service on Azure Portal? Once you ha...
How To Pad an Array with the Same Value Multiple Times in PHP? If you want to add the same value mul...