Collections:
PHP ODBC - odbc_num_rows() - Number of Affected Rows
PHP ODBC - How To Get the Number of Affected Rows?
✍: Guest
If you insert multiple rows with a single INSERT statement, you can use the odbc_num_rows() function to find out how many rows were inserted. odbc_num_rows($result_set) returns the number of affected rows based on the result set object returned by the last INSET, UPDATE or DELETE statement.
The following tutorial script shows you report back the number of rows inserted properly:
<?php $con = odbc_connect('FYI_SQL_SERVER','sa','FYIcenter'); $sql = "INSERT INTO fyi_links" . " SELECT id+1000, REVERSE(url), notes, counts, time" . " FROM fyi_links WHERE id > 1000"; $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 inserted.\n"); } odbc_close($con);
If you run this script, you should get:
2 rows inserted
⇒ PHP ODBC - Returning Result Set Objects
⇐ PHP ODBC - Inserting Multiple Rows with a Subquery
⇑ SQL Server FAQs - PHP ODBC Functions - Managing Tables and Data Rows
2024-05-29, 1318🔥, 0💬
Popular Posts:
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...