<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/include/shared-manual.inc';
$TOC = array();
$TOC_DEPRECATED = array();
$PARENTS = array();
include_once dirname(__FILE__) ."/toc/class.mysqli-result.inc";
$setup = array (
  'home' => 
  array (
    0 => 'index.php',
    1 => 'PHP Manual',
  ),
  'head' => 
  array (
    0 => 'UTF-8',
    1 => 'zh',
  ),
  'this' => 
  array (
    0 => 'mysqli-result.num-rows.php',
    1 => 'mysqli_result::$num_rows',
    2 => 'Gets the number of rows in the result set',
  ),
  'up' => 
  array (
    0 => 'class.mysqli-result.php',
    1 => 'mysqli_result',
  ),
  'prev' => 
  array (
    0 => 'mysqli-result.lengths.php',
    1 => 'mysqli_result::$lengths',
  ),
  'next' => 
  array (
    0 => 'class.mysqli-driver.php',
    1 => 'mysqli_driver',
  ),
  'alternatives' => 
  array (
  ),
  'source' => 
  array (
    'lang' => 'en',
    'path' => 'reference/mysqli/mysqli_result/num-rows.xml',
  ),
  'history' => 
  array (
  ),
);
$setup["toc"] = $TOC;
$setup["toc_deprecated"] = $TOC_DEPRECATED;
$setup["parents"] = $PARENTS;
manual_setup($setup);

contributors($setup);

?>
<div id="mysqli-result.num-rows" class="refentry">
 <div class="refnamediv">
  <h1 class="refname">mysqli_result::$num_rows</h1>
  <h1 class="refname">mysqli_num_rows</h1>
  <p class="verinfo">(PHP 5, PHP 7, PHP 8)</p><p class="refpurpose"><span class="refname">mysqli_result::$num_rows</span> -- <span class="refname">mysqli_num_rows</span> &mdash; <span class="dc-title">Gets the number of rows in the result set</span></p>

 </div>

 <div class="refsect1 description" id="refsect1-mysqli-result.num-rows-description">
  <h3 class="title">说明</h3>
  <p class="para">面向对象风格</p>
  <div class="fieldsynopsis"><span class="type"><span class="type"><a href="language.types.integer.php" class="type int">int</a></span>|<span class="type"><a href="language.types.string.php" class="type string">string</a></span></span> <var class="varname"><a href="mysqli-result.num-rows.php">$mysqli_result-&gt;num_rows</a></var>;</div>

  <p class="para">过程化风格</p>
  <div class="methodsynopsis dc-description">
   <span class="methodname"><strong>mysqli_num_rows</strong></span>(<span class="methodparam"><span class="type"><a href="class.mysqli-result.php" class="type mysqli_result">mysqli_result</a></span> <code class="parameter">$result</code></span>): <span class="type"><span class="type"><a href="language.types.integer.php" class="type int">int</a></span>|<span class="type"><a href="language.types.string.php" class="type string">string</a></span></span></div>

  <p class="para rdfs-comment">
   Returns the number of rows in the result set.
  </p>
  <p class="para">
   The behaviour of <span class="function"><strong>mysqli_num_rows()</strong></span> depends on whether
   buffered or unbuffered result sets are being used.
   This function returns <code class="literal">0</code> for unbuffered result sets unless
   all rows have been fetched from the server.
  </p>
 </div>


 <div class="refsect1 parameters" id="refsect1-mysqli-result.num-rows-parameters">
  <h3 class="title">参数</h3>
  <p class="para">
   <dl>
    <dt>
<code class="parameter">result</code></dt><dd><p class="para">仅以过程化样式：由
<span class="function"><a href="mysqli.query.php" class="function">mysqli_query()</a></span>、<span class="function"><a href="mysqli.store-result.php" class="function">mysqli_store_result()</a></span>、
<span class="function"><a href="mysqli.use-result.php" class="function">mysqli_use_result()</a></span>、<span class="function"><a href="mysqli-stmt.get-result.php" class="function">mysqli_stmt_get_result()</a></span> 返回的 <span class="classname"><a href="class.mysqli-result.php" class="classname">mysqli_result</a></span> 对象。</p></dd>
   </dl>
  </p>
 </div>


 <div class="refsect1 returnvalues" id="refsect1-mysqli-result.num-rows-returnvalues">
  <h3 class="title">返回值</h3>
  <p class="para">
   An <span class="type"><a href="language.types.integer.php" class="type int">int</a></span> representing the number of fetched rows.
   Returns <code class="literal">0</code> in unbuffered mode unless all rows have been
   fetched from the server.
  </p>
  <blockquote class="note"><p><strong class="note">注意</strong>: 
<p class="para">If the number of rows is greater than <strong><code><a href="reserved.constants.php#constant.php-int-max">PHP_INT_MAX</a></code></strong>,
the number will be returned as a <span class="type"><a href="language.types.string.php" class="type string">string</a></span>.</p></p></blockquote>
 </div>


 <div class="refsect1 examples" id="refsect1-mysqli-result.num-rows-examples">
  <h3 class="title">示例</h3>
  <div class="example" id="example-1651">
   <p><strong>示例 #1 面向对象风格</strong></p>
   <div class="example-contents">
<div class="phpcode"><code><span style="color: #000000"><span style="color: #0000BB">&lt;?php<br /><br />mysqli_report</span><span style="color: #007700">(</span><span style="color: #0000BB">MYSQLI_REPORT_ERROR </span><span style="color: #007700">| </span><span style="color: #0000BB">MYSQLI_REPORT_STRICT</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$mysqli </span><span style="color: #007700">= new </span><span style="color: #0000BB">mysqli</span><span style="color: #007700">(</span><span style="color: #DD0000">"localhost"</span><span style="color: #007700">, </span><span style="color: #DD0000">"my_user"</span><span style="color: #007700">, </span><span style="color: #DD0000">"my_password"</span><span style="color: #007700">, </span><span style="color: #DD0000">"world"</span><span style="color: #007700">);<br /><br /></span><span style="color: #0000BB">$result </span><span style="color: #007700">= </span><span style="color: #0000BB">$mysqli</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT Code, Name FROM Country ORDER BY Name"</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">/* Get the number of rows in the result set */<br /></span><span style="color: #0000BB">$row_cnt </span><span style="color: #007700">= </span><span style="color: #0000BB">$result</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">num_rows</span><span style="color: #007700">;<br /><br /></span><span style="color: #0000BB">printf</span><span style="color: #007700">(</span><span style="color: #DD0000">"Result set has %d rows.\n"</span><span style="color: #007700">, </span><span style="color: #0000BB">$row_cnt</span><span style="color: #007700">);</span></span></code></div>
   </div>

  </div>
  <div class="example" id="example-1652">
   <p><strong>示例 #2 过程化风格</strong></p>
   <div class="example-contents">
<div class="phpcode"><code><span style="color: #000000"><span style="color: #0000BB">&lt;?php<br /><br />mysqli_report</span><span style="color: #007700">(</span><span style="color: #0000BB">MYSQLI_REPORT_ERROR </span><span style="color: #007700">| </span><span style="color: #0000BB">MYSQLI_REPORT_STRICT</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$link </span><span style="color: #007700">= </span><span style="color: #0000BB">mysqli_connect</span><span style="color: #007700">(</span><span style="color: #DD0000">"localhost"</span><span style="color: #007700">, </span><span style="color: #DD0000">"my_user"</span><span style="color: #007700">, </span><span style="color: #DD0000">"my_password"</span><span style="color: #007700">, </span><span style="color: #DD0000">"world"</span><span style="color: #007700">);<br /><br /></span><span style="color: #0000BB">$result </span><span style="color: #007700">= </span><span style="color: #0000BB">mysqli_query</span><span style="color: #007700">(</span><span style="color: #0000BB">$link</span><span style="color: #007700">, </span><span style="color: #DD0000">"SELECT Code, Name FROM Country ORDER BY Name"</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">/* Get the number of rows in the result set */<br /></span><span style="color: #0000BB">$row_cnt </span><span style="color: #007700">= </span><span style="color: #0000BB">mysqli_num_rows</span><span style="color: #007700">(</span><span style="color: #0000BB">$result</span><span style="color: #007700">);<br /><br /></span><span style="color: #0000BB">printf</span><span style="color: #007700">(</span><span style="color: #DD0000">"Result set has %d rows.\n"</span><span style="color: #007700">, </span><span style="color: #0000BB">$row_cnt</span><span style="color: #007700">);</span></span></code></div>
   </div>

   <div class="example-contents"><p>以上示例会输出：</p></div>
   <div class="example-contents screen">
<div class="examplescode"><pre class="examplescode">Result set has 239 rows.</pre>
</div>
   </div>
  </div>
 </div>


 <div class="refsect1 notes" id="refsect1-mysqli-result.num-rows-notes">
  <h3 class="title">注释</h3>
  <blockquote class="note"><p><strong class="note">注意</strong>: 
   <p class="para">
    In contrast to the <span class="function"><a href="mysqli-stmt.num-rows.php" class="function">mysqli_stmt_num_rows()</a></span> function,
    this function doesn&#039;t have object-oriented method variant.
    In the object-oriented style, use the getter property.
   </p>
  </p></blockquote>
 </div>


 <div class="refsect1 seealso" id="refsect1-mysqli-result.num-rows-seealso">
  <h3 class="title">参见</h3>
  <p class="para">
   <ul class="simplelist">
    <li><span class="function"><a href="mysqli.affected-rows.php" class="function" rel="rdfs-seeAlso">mysqli_affected_rows()</a> - Gets the number of affected rows in a previous MySQL operation</span></li>
    <li><span class="function"><a href="mysqli.store-result.php" class="function" rel="rdfs-seeAlso">mysqli_store_result()</a> - 传输上次查询的结果集</span></li>
    <li><span class="function"><a href="mysqli.use-result.php" class="function" rel="rdfs-seeAlso">mysqli_use_result()</a> - Initiate a result set retrieval</span></li>
    <li><span class="function"><a href="mysqli.query.php" class="function" rel="rdfs-seeAlso">mysqli_query()</a> - 对数据库执行查询</span></li>
    <li><span class="function"><a href="mysqli-stmt.num-rows.php" class="function" rel="rdfs-seeAlso">mysqli_stmt_num_rows()</a> - Returns the number of rows fetched from the server</span></li>
   </ul>
  </p>
 </div>


</div><?php manual_footer($setup); ?>