mssql_rows_affected

(PHP 4 >= 4.0.4, PHP 5, PECL odbtp >= 1.1.1)

mssql_rows_affected — Returns the number of records affected by the query

Warning

This function was REMOVED in PHP 7.0.0.

Alternatives to this function include:

说明

mssql_rows_affected ( resource $link_identifier ) : int

Returns the number of records affected by the last write query.

参数

link_identifier

A MS SQL link identifier, returned by mssql_connect() or mssql_pconnect().

返回值

Returns the number of records affected by last operation.

范例

Example #1 mssql_rows_affected() example

<?php
// Delete all rows in a table
mssql_query('TRUNCATE TABLE [php].[dbo].[persons]');

echo 'Deleted ' . mssql_rows_affected($link) . ' row(s)';
?>

相关文章
php ibm db2 函数 returns the auto generated id of the last insert query that successfully executed on this connectionphp ibm db2 函数 returns the number of rows affected by an sql statementphp eio 函数 returns number of not yet handled requestsphp eio 函数 returns number of requests to be processedphp firebird/interbase 函数 return the number of rows that were affected by the previous queryphp informix 函数 get number of rows affected by a queryphp informix 函数 returns the number of columns in the queryphp ingres 函数 get the number of rows affected or returned by a queryphp maxdb 函数 gets the number of affected rows in a previous maxdb operationphp maxdb 函数 returns the number of columns for the most recent queryphp maxdb 函数 returns the number of warnings from the last query for the given linkphp msql 函数 returns number of affected rowsphp mssql 函数 returns the next batch of recordsphp mssql 函数 gets the number of rows in resultphp mssql 函数 returns the number of records affected by the queryphp paradox 函数 returns number of records in a databasephp sqlsrv 函数 returns the number of rows modified by the last insert update or delete query executedphp sybase 函数 gets number of affected rows in last queryphp mysqli returns the number of warnings from the last query for the given linkphp sdo das relational 函数 executes a given sql query against a relational database and returns the results as a normalised data graph
关注编程学问公众号