<!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
).
"%'"
);
$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>