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 number of rows affected by an sql statementphp eio 函数 returns number of threads currently in usephp 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 函数 returns the number of columns for the most recent queryphp maxdb 函数 returns rpl query typephp 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 函数 send ms sql queryphp mssql 函数 returns the number of records affected by the queryphp paradox 函数 returns number of records in a databasephp sqlite 函数 execute a query against a given database and returns an arrayphp sqlite 函数 executes a query against a given database and returns a result handlephp 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 columns for the most recent queryphp sdo das relational 函数 executes a given sql query against a relational database and returns the results as a normalised data graph
关注编程学问公众号