Collections:
PHP ODBC - Updating Existing Rows in a Table
PHP ODBC - How To Update Existing Rows in a Table?
✍: Guest
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 $con = odbc_connect('FYI_SQL_SERVER','sa','FYIcenter'); $sql = "UPDATE fyi_links SET notes='Nice site.', counts=8" . " WHERE id = 102"; $res = odbc_exec($con, $sql); if (!$res) { print("SQL statement failed with error:\n"); print(odbc_error($con).": ".odbc_errormsg($con)."\n"); } else { $number_of_rows = odbc_num_rows($res); print("$number_of_rows rows updated.\n"); } odbc_close($con); ?>
If you run this script, you will get something like this:
1 rows updated.
⇒ PHP ODBC - Deleting Existing Rows in a Table
⇐ PHP ODBC - odbc_fetch_array() - Looping through Returning Rows
⇑ SQL Server FAQs - PHP ODBC Functions - Managing Tables and Data Rows
2024-05-29, 1399🔥, 0💬
Popular Posts:
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...