PHP Manual
Informix 函数
Get number of rows affected by a query

ifx_affected_rows

(PHP 4, PHP 5 < 5.2.1)

ifx_affected_rows — Get number of rows affected by a query

说明

ifx_affected_rows ( resource $result_id ) : int

Returns the number of rows affected by a query associated with result_id.

For inserts, updates and deletes the number is the real number (sqlerrd[2]) of affected rows. For selects it is an estimate (sqlerrd[0]). Don't rely on it. The database server can never return the actual number of rows that will be returned by a SELECT because it has not even begun fetching them at this stage (just after the "PREPARE" when the optimizer has determined the query plan).

Useful after ifx_prepare() to limit queries to reasonable result sets.

参数

result_id: A valid result id returned by ifx_query() or ifx_prepare().

返回值

Returns the number of rows as an integer.

范例

Example #1 Informix affected rows

 <?php
$rid = ifx_prepare("select * from emp
                     where name like " . $name, $connid);
if (! $rid) {
    /* ... error ... */
}
$rowcount = ifx_affected_rows($rid);
if ($rowcount > 1000) {
    printf ("Too many rows in result set (%d)\n<br />", $rowcount);
    die ("Please restrict your query<br />\n");
}
?>

参见

ifx_num_rows() - Count the rows already fetched from a query

php cubrid mysql 兼容性函数 return the number of rows affected by the last sql statement php cubrid 函数 get the number of rows in the result set php ibm db2 函数 returns the number of rows affected by an sql statement php frontbase 函数 get number of affected rows in previous frontbase operation php frontbase 函数 get the number of rows affected by the last statement php firebird/interbase 函数 return the number of rows that were affected by the previous query php informix 函数 get number of rows affected by a query php informix 函数 formats all rows of a query into a html table php informix 函数 returns the number of columns in the query php informix 函数 count the rows already fetched from a query php ingres 函数 get the number of fields returned by the last query php ingres 函数 get the number of rows affected or returned by a query php mcve 函数 number of rows returned in a comma delimited response php maxdb 函数 gets the number of affected rows in a previous maxdb operation php maxdb 函数 return the number of rows in statements result set php msql 函数 returns number of affected rows php mssql 函数 returns the number of records affected by the query php sqlsrv 函数 returns the number of rows modified by the last insert update or delete query executed php sybase 函数 gets number of affected rows in last query php sybase 函数 get number of rows in a result set