PHP mysql_num_rows() function definition and example usage display-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

PHP mysql_num_rows() function definition and example usage display

May 26, 2017 pm 04:12 PM

PHP mysql_num_rows() function definition and usage introduction

Definition and usage

mysql_num_rows() function returns the number of rows in the result set.

Syntax

mysql_num_rows(data)

Copy after login

Parameter description:

data Required. Result set. This result set is obtained from a call to mysql_query().

Description

mysql_num_rows() returns the number of rows in the result set. This command is only valid for SELECT statements. To get the number of rows affected by an INSERT, UPDATE, or DELETE query, use mysql_affected_rows().

Tips and Notes

Note: If you use mysql_unbuffered_query(), mysql_num_rows() cannot return the correct value until all rows in the result set have been fetched.

Note: For data results queried using the mysql_unbuffered_query() function, you cannot use the mysql_num_rows() function to obtain the number of records in the query result set.

Example

&lt;?php
$con = mysql_connect(&quot;localhost&quot;, &quot;hello&quot;, &quot;321&quot;);
if (!$con)
  {
  die(&#39;Could not connect: &#39; . mysql_error());
  }
$db_selected = mysql_select_db(&quot;test_db&quot;,$con);
$sql = &quot;SELECT * FROM person&quot;;
$result = mysql_query($sql,$con);
echo mysql_num_rows($result);
mysql_close($con);
?&gt;

Copy after login

Output is similar:

Copy after login

Example 2:

Use the mysql_num_rows() function to get the number of records in the result set

&lt;html&gt;
&lt;body&gt;
    &lt;!--上传文件表单--&gt;
    &lt;form method=&quot;post&quot; action=&quot;&quot; name = form1&gt;
        &lt;table&gt;
           &lt;tr&gt;
               &lt;td width=&quot;605&quot; height=&quot;51&quot; bgcolor=&quot;#CC99FF&quot;&gt;
                   &lt;p align=&quot;center&quot;&gt;请输入查询内容
                       &lt;input type=&quot;text&quot; name=&quot;txt_book&quot; id=&quot;txt_book&quot; size=&quot;25&quot;&gt;&amp;nbsp;
                       &lt;input type=&quot;submit&quot; name=&quot;Submit&quot; value=&quot;查询&quot;&gt;
                   &lt;/p&gt;
               &lt;/td&gt;
           &lt;/tr&gt;
            &lt;/table&gt;
        &lt;/form&gt;
&lt;/body&gt;
&lt;/html&gt;
&lt;?php
header(&quot;Content-Type:text/html; charset=utf-8&quot;);
$link = mysql_connect(&quot;localhost&quot;,&quot;root&quot;,&quot;root&quot;)or die(&quot;连接数据库失败&quot;.mysql_error());
mysql_select_db(&quot;php_cn&quot;,$link);
mysql_query(&quot;set names gb2312&quot;);   //设置编码，防止发生乱发
$query = &quot;SELECT * FROM tb_book&quot;;
$sql = mysql_query($query);       //执行查询语句
//$info = mysql_fetch_array($sql);//获取查询结果，返回值为数组
if(@$_POST[&#39;Submit&#39;]){                    // 判断按钮的值是否为查询
    $txt_book = $_POST[&#39;txt_book&#39;];              //获取文本框提交的值
    $sql = mysql_query(&quot;select * from tb_book where bookname like &#39;%&quot;.trim($txt_book).&quot;%&#39;&quot;);  //执行模糊查询
    //$info = mysql_fetch_array($sql);             // 获取查询结果
}
if($info = false){  //如果检索的信息不存在，则输出相对的提示信息
    echo &quot;&lt;p align=&#39;center&#39; style=&#39;color: #FF0000;font-size: 12px&#39;&gt;对不起，你要查询的信息不存在&lt;/p&gt;&quot;;
}
do {      //do...while 循环
?&gt;
    &lt;table&gt;
        &lt;tr align=&quot;left&quot; bgcolor=&quot;#FFFFFF&quot;&gt;
            &lt;td height=&quot;20&quot; align=&quot;center&quot;&gt;&lt;?php echo $info[&quot;id&quot;] ?&gt;&lt;/td&gt;
            &lt;td height=&quot;20&quot; align=&quot;center&quot;&gt;&lt;?php echo $info[&quot;bookname&quot;] ?&gt;&lt;/td&gt;
            &lt;td height=&quot;20&quot; align=&quot;center&quot;&gt;&lt;?php echo $info[&quot;data&quot;] ?&gt;&lt;/td&gt;
            &lt;td height=&quot;20&quot; align=&quot;center&quot;&gt;&lt;?php echo $info[&quot;price&quot;] ?&gt;&lt;/td&gt;
            &lt;td height=&quot;20&quot; align=&quot;center&quot;&gt;&lt;?php echo $info[&quot;maker&quot;] ?&gt;&lt;/td&gt;
            &lt;td height=&quot;20&quot; align=&quot;center&quot;&gt;&lt;?php echo $info[&quot;publisher&quot;] ?&gt;&lt;/td&gt;
        &lt;/tr&gt;
    &lt;/table&gt;
&lt;?php
}while($info = mysql_fetch_array($sql));
?&gt;

Copy after login

The above is the detailed content of PHP mysql_num_rows() function definition and example usage display. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn