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, ∼2943🔥, 0💬
Popular Posts:
How To Pass Arrays By References? in PHP? Like normal variables, you can pass an array by reference ...
Where to get the detailed description of the json_encode() Function in PHP? Here is the detailed des...
How To Read Data from Keyboard (Standard Input) in PHP? If you want to read data from the standard i...
How to extend json.JSONEncoder class? I want to encode other Python data types to JSON. If you encod...
Where to find tutorials on PHP language? I want to know how to learn PHP. Here is a large collection...