11111
<p>mysqli_num_rows
<LINK TITLE="Improved MySQL Extension" HREF="ref.mysqli.html"><LINK TITLE="mysqli_num_fields" HREF="function.mysqli-num-fields.html"><LINK TITLE="mysqli_options" HREF="function.mysqli-options.html">
<p><a href="function.mysqli-num-fields.html">Пред.</a>
<p><a href="function.mysqli-options.html">След.</a>
<p><h1><a name="function.mysqli-num-rows"></a>mysqli_num_rows</h1><div><a name="AEN99697"></a>
<p>(PHP 5)mysqli_num_rows --
<p>Gets the number of rows in a result
<p></div><div><a name="AEN99700"></a><h2>Description</h2>
<p>Procedural style:int mysqli_num_rows (mysqli result)
<p>Object oriented style (property):class <B CLASS="classname">mysqli {
<p>int num_rows
<p>}
<p>- Returns the number of rows in the result set.
<p>- The use of mysqli_num_rows() depends on whether you use
<p>buffered or unbuffered result sets.
<p>In case you use unbuffered resultsets mysqli_num_rows()
<p>will not correct the correct number of rows until all the rows in the result
<p>have been retrieved.
<p></div><div><a name="AEN99720"></a><h2>Возвращаемые значения</h2>
<p>- Returns number of rows in the result set.
<p><DIV><BLOCKQUOTE>
<p>Замечание:
<p>If the number of rows is greater than maximal int value, the number
<p>will be returned as a string.
<p></BLOCKQUOTE></div></div><div><a name="AEN99725"></a><h2>Смотрите также</h2>
<p>- <a href="function.mysqli-affected-rows.html">mysqli_affected_rows()</a>,
<p><a href="function.mysqli-store-result.html">mysqli_store_result()</a>,
<p><a href="function.mysqli-use-result.html">mysqli_use_result()</a> и
<p><a href="function.mysqli-query.html">mysqli_query()</a>.
<p></div><div><a name="AEN99732"></a><h2>Примеры</h2><table><tr><td><DIV><a name="AEN99734"></a>
<p>Пример 1. Object oriented style<table><tr><td><code>
<p>&lt;?php
<p>$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
<p>
<p>/* check connection */
<p>if (mysqli_connect_errno()) {
<p>printf("Connect failed: %s\n", mysqli_connect_error());
<p>exit();
<p>}
<p>
<p>if ($result = $mysqli->query("SELECT Code, Name FROM Country ORDER BY Name")) {
<p>
<p>/* determine number of rows result set */
<p>$row_cnt = $result->num_rows;
<p>
<p>printf("Result set has %d rows.\n", $row_cnt);
<p>
<p>/* close result set */
<p>$result->close();
<p>}
<p>
<p>/* close connection */
<p>$mysqli->close();
<p>?>
<p>
<p></code></TABLE></div></TABLE><table><tr><td><DIV><a name="AEN99737"></a>
<p>Пример 2. Procedural style<table><tr><td><code>
<p>&lt;?php
<p>$link = mysqli_connect("localhost", "my_user", "my_password", "world");
<p>
<p>/* check connection */
<p>if (mysqli_connect_errno()) {
<p>printf("Connect failed: %s\n", mysqli_connect_error());
<p>exit();
<p>}
<p>
<p>if ($result = mysqli_query($link, "SELECT Code, Name FROM Country ORDER BY Name")) {
<p>
<p>/* determine number of rows result set */
<p>$row_cnt = mysqli_num_rows($result);
<p>
<p>printf("Result set has %d rows.\n", $row_cnt);
<p>
<p>/* close result set */
<p>mysqli_free_result($result);
<p>}
<p>
<p>/* close connection */
<p>mysqli_close($link);
<p>?>
<p>
<p></code></TABLE></div></TABLE>
<p>Результат выполнения данного примера:<table><tr><td><PRE>Result set has 239 rows.</PRE></TABLE></div>
<p><a href="function.mysqli-num-fields.html">Пред.</a>
<p><a href="index.html">Начало</a>
<p><a href="function.mysqli-options.html">След.</a>
<p>mysqli_num_fields
<p><a href="ref.mysqli.html">Уровень выше</a>
<p>mysqli_options
22222
<div style="text-align:right;position:fixed;bottom:3px;right:3px;width:100%;z-index:999999;cursor:pointer;line-height:0;display:block;"><a target="_blank" href="https://www.freewebhostingarea.com" title="Free Web Hosting with PHP5 or PHP7"><img alt="Free Web Hosting" src="https://www.freewebhostingarea.com/images/poweredby.png" style="border-width: 0px;width: 180px; height: 45px; float: right;"></a></div>