mysqli_stmt::$num_rows

mysqli_stmt::num_rows

mysqli_stmt_num_rows

(PHP 5, PHP 7)

mysqli_stmt::$num_rows -- mysqli_stmt::num_rows -- mysqli_stmt_num_rows — Return the number of rows in statements result set

说明

面向对象风格

int $mysqli_stmt->num_rows;
mysqli_stmt::num_rows ( void ) : int

过程化风格

mysqli_stmt_num_rows ( mysqli_stmt $stmt ) : int

Returns the number of rows in the result set. The use of mysqli_stmt_num_rows() depends on whether or not you used mysqli_stmt_store_result() to buffer the entire result set in the statement handle.

If you use mysqli_stmt_store_result(), mysqli_stmt_num_rows() may be called immediately.

参数

stmt

仅以过程化样式：由 mysqli_stmt_init() 返回的 statement 标识。

返回值

An integer representing the number of rows in result set.

范例

Example #1 面向对象风格

<?php
/* Open a connection */
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

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

$query = "SELECT Name, CountryCode FROM City ORDER BY Name LIMIT 20";
if ($stmt = $mysqli->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 */
$mysqli->close();
?>

Example #2 过程化风格

<?php
/* Open a connection */
$link = mysqli_connect("localhost", "my_user", "my_password", "world");

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

$query = "SELECT Name, CountryCode FROM City ORDER BY Name LIMIT 20";
if ($stmt = mysqli_prepare($link, $query)) {

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

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

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

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

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

以上例程会输出：

Number of rows: 20.

参见

相关文章
php 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 maxdb 函数 return the number of rows in statements result setphp sqlite 函数 returns the number of rows in a buffered result setphp sqlite 函数 seek to the previous row number of a result setphp sqlsrv 函数 retrieves the number of rows in a result setphp sybase 函数 get number of rows in a result setphp mysqli result returns the lengths of the columns of the current row in the result setphp mysqli result gets the number of rows in a resultphp mysqli stmt returns the total number of rows changed deleted or inserted by the last executed statementphp mysqli stmt seeks to an arbitrary row in statement result setphp mysqli stmt returns the number of field in the given statementphp mysqli stmt gets a result set from a prepared statementphp mysqli stmt return the number of rows in statements result setphp mysqli stmt returns result set metadata from a prepared statementphp mysqli stmt transfers a result set from a prepared statementphp solrquery set the number of similar documents to return for each resultphp solrquery specifies the maximum number of rows to return in the resultphp sqlite3stmt executes a prepared statement and returns a result set object
关注编程学问公众号