Return the number of rows in statements result set (original) (raw)

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

Description

Object oriented style

intmysqli_stmt->num_rows;

public mysqli_stmt::num_rows ( void ) : int

mysqli_stmt_num_rows ( mysqli_stmt $stmt ) : int

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

Parameters

stmt

Procedural style only: A statement identifier returned by mysqli_stmt_init().

Return Values

An integer representing the number of rows in result set.

Examples

Example #1 Object oriented style

<?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 = <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>m</mi><mi>y</mi><mi>s</mi><mi>q</mi><mi>l</mi><mi>i</mi><mo>−</mo><mo>></mo><mi>p</mi><mi>r</mi><mi>e</mi><mi>p</mi><mi>a</mi><mi>r</mi><mi>e</mi><mo stretchy="false">(</mo></mrow><annotation encoding="application/x-tex">mysqli->prepare(</annotation></semantics></math>mysqli−>prepare(query)) {/* execute query */ $stmt->execute();/* store result */ <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>s</mi><mi>t</mi><mi>m</mi><mi>t</mi><mo>−</mo><mo>></mo><mi>s</mi><mi>t</mi><mi>o</mi><mi>r</mi><msub><mi>e</mi><mi>r</mi></msub><mi>e</mi><mi>s</mi><mi>u</mi><mi>l</mi><mi>t</mi><mo stretchy="false">(</mo><mo stretchy="false">)</mo><mo separator="true">;</mo><mi>p</mi><mi>r</mi><mi>i</mi><mi>n</mi><mi>t</mi><mi>f</mi><mo stretchy="false">(</mo><mi mathvariant="normal">"</mi><mi>N</mi><mi>u</mi><mi>m</mi><mi>b</mi><mi>e</mi><mi>r</mi><mi>o</mi><mi>f</mi><mi>r</mi><mi>o</mi><mi>w</mi><mi>s</mi><mo>:</mo></mrow><annotation encoding="application/x-tex">stmt->store_result();printf("Number of rows: %d.\n", </annotation></semantics></math>stmt−>storeresult();printf("Numberofrows:stmt->num_rows);/* close statement */ $stmt->close(); }/* close connection */ $mysqli->close(); ?>

Example #2 Procedural style

<?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); ?>

The above examples will output: