maxdb_stmt_num_rows

maxdb_stmt::num_rows

(PECL maxdb >= 1.0)

maxdb_stmt_num_rows -- maxdb_stmt::num_rows — Return the number of rows in statements result set

说明

过程化风格

maxdb_stmt_num_rows ( resource $stmt ) : int

面向对象风格

int $maxdb_stmt->num_rows;

Returns the number of rows in the result set.

返回值

An integer representing the number of rows in result set.

范例

Example #1 面向对象风格

<?php
/* Open a connection */
$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");

/* check connection */
if (maxdb_connect_errno()) {
   printf("Connect failed: %s\n", maxdb_connect_error());
   exit();
}

$query = "SELECT zip, name FROM hotel.city ORDER BY name";
if ($stmt = $maxdb->prepare($query)) {

   /* execute query */
   $stmt->execute();

   /* store result */
   $stmt->store_result();

   printf("Number of rows: %d.\n", $stmt->num_rows);

   /* close statement */
   $stmt->close();
}

/* close connection */
$maxdb->close();
?>

Example #2 过程化风格

<?php
/* Open a connection */
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");

/* check connection */
if (maxdb_connect_errno()) {
   printf("Connect failed: %s\n", maxdb_connect_error());
   exit();
}

$query = "SELECT zip, name FROM hotel.city ORDER BY name";
if ($stmt = maxdb_prepare($link, $query)) {

   /* execute query */
   maxdb_stmt_execute($stmt);

   /* store result */
   maxdb_stmt_store_result($stmt);

   printf("Number of rows: %d.\n", maxdb_stmt_num_rows($stmt));

   /* close statement */
   maxdb_stmt_close($stmt);
}

/* close connection */
maxdb_close($link);
?>

以上例程的输出类似于：

Number of rows: 25.

参见

相关文章
php cubrid mysql 兼容性函数 return the number of rows affected by the last sql statementphp cubrid 函数 return the number of columns in the result setphp cubrid mysql 兼容性函数 return the number of columns in the result setphp cubrid 函数 get the number of rows in the result setphp frontbase 函数 get number of rows in resultphp firebird/interbase 函数 return the number of rows that were affected by the previous queryphp firebird/interbase 函数 get the number of fields in a result setphp maxdb 函数 returns the next field in the result setphp maxdb 函数 returns an array of resources representing the fields in a result setphp maxdb 函数 gets the number of rows in a resultphp maxdb 函数 returns the total number of rows changed deleted or inserted by the last executed statementphp maxdb 函数 return the number of rows in statements result setphp maxdb 函数 returns result set metadata from a prepared statementphp sqlite 函数 returns the number of fields in a result setphp sqlite 函数 returns the number of rows in a buffered result setphp sqlsrv 函数 retrieves the number of rows in a result setphp sybase 函数 gets the number of fields in a result setphp sybase 函数 get number of rows in a result setphp mysqli stmt return the number of rows in statements result setphp solrquery specifies the maximum number of rows to return in the result
关注编程学问公众号