Home > Article > Backend Development > PHP+MySQL uses mysql_num_rows to implement fuzzy query book information function
This article mainly introduces the use of PHP MySQL mysql_num_rows to realize the fuzzy query book information function, involving PHP's use of mysql's like query statement for fuzzy query and mysql_num_rows for structural statistics related operating skills, friends in need You can refer to the following
The example of this article describes how PHP MySQL uses mysql_num_rows to realize the fuzzy query book information function. Share it with everyone for your reference, the details are as follows:
1. Code
td{
font-size:9pt;
}
.style2 {color: #FFFFFF}<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="style.css" rel="external nofollow" rel="stylesheet">
<title>应用mysql_num_rows()函数获取查询结果集中的记录数</title>
</head>
<body>
<table width="609" height="134" border="1" cellpadding="0" cellspacing="0" bgcolor="#9E7DB4" align="center">
<form name="myform" method="post" action="">
<tr>
<td width="605" height="51" bgcolor="#CC99FF"><p align="center">请输入图书名称
<input name="txt_book" type="text" id="txt_book" size="25" >
<input type="submit" name="Submit" value="查询">
</p></td>
</tr>
</form>
<tr valign="top" bgcolor="#FFFFFF">
<td height="81">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="79" align="right" valign="top"> <br>
<table width="572" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#625D59">
<tr align="center" bgcolor="#CC99FF">
<td width="46" height="20">编号</td>
<td width="167">图书名称</td>
<td width="90">出版时间</td>
<td width="70">图书定价</td>
<td width="78">作者</td>
<td width="114">出版社</td>
</tr>
<?php
$link=mysql_connect("localhost","root","root") or die("数据库连接失败".mysql_error());
mysql_select_db("db_database13",$link);
mysql_query("set names gb2312");
$sql=mysql_query("select * from tb_book");
$info=mysql_fetch_object($sql);
if ($_POST[Submit]=="查询"){
$txt_book=$_POST[txt_book];
$sql=mysql_query("select * from tb_book where bookname like '%".trim($txt_book)."%'"); //如果选择的条件为"like",则进行模糊查询
$info=mysql_fetch_object($sql);
}
if($info==false){ //如果检索的信息不存在，则输出相应的提示信息
echo "<p align='center' style='color:#FF0000; font-size:12px'>对不起，您检索的图书信息不存在!</p>";
}
do{
?>
<tr align="left" bgcolor="#FFFFFF">
<td height="20" align="center"><?php echo $info->id; ?></td>
<td > <?php echo $info->bookname; ?></td>
<td align="center"><?php echo $info->issuDate; ?></td>
<td align="center"><?php echo $info->price; ?></td>
<td align="center"> <?php echo $info->maker; ?></td>
<td> <?php echo $info->publisher; ?></td>
</tr>
<?php
}while($info=mysql_fetch_object($sql));
?>
</table>
<br>
找到相关记录 <?php $nums=mysql_num_rows($sql);echo $nums;?> 条 </td>
</tr>
</table>
<br></td>
</tr>
</table>
</body>
</html>2. Running results
Note: Use mysql_num_rows() here to return the number of rows in the result set. This command is only valid for the SELECT statement. To get the rows affected by the INSERT, UPDATE or DELETE query number, you need to use <a href="//m.sbmmt.com/wiki/1162.html" target="_blank">mysql_affected_rows</a>().
Related recommendations:
##
The above is the detailed content of PHP+MySQL uses mysql_num_rows to implement fuzzy query book information function. For more information, please follow other related articles on the PHP Chinese website!