Collections:
PHP MSSQL - mssql_rows_affected() - Number of Affected Rows
PHP MSSQL - How To Get the Number of Affected Rows?
✍: Guest
If you insert multiple rows with a single INSERT statement, you can use the mssql_rows_affected() function to find out how many rows were inserted. mssql_rows_affected($connection) returns the number of affected rows of the last INSET, UPDATE or DELETE statement.
The following tutorial script shows you report back the number of rows inserted properly:
<?php $con = mssql_connect('LOCALHOST','sa','FYIcenter'); mssql_select_db('FyiCenterData', $con); $sql = "INSERT INTO fyi_links" . " SELECT id+1000, REVERSE(url), notes, counts, time" . " FROM fyi_links WHERE id > 1000"; $res = mssql_query($sql,$con); if (!$res) { print("SQL statement failed with error:\n"); print(" ".mssql_get_last_message()."\n"); } else { $number_of_rows = mssql_rows_affected($con); print("$number_of_rows rows inserted.\n"); } mssql_close($con);
If you run this script, you should get:
2 rows inserted
⇒ PHP MSSQL - Returning Result Set Objects
⇐ PHP MSSQL - Inserting Multiple Rows with a Subquery
⇑ SQL Server FAQs - PHP MSSQL Functions - Managing Tables and Data Rows
2024-02-28, 1284🔥, 0💬
Popular Posts:
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...