<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML
1.0 Transitional//EN" "http
://www.w3.org/TR/xhtml
1/DTD/xhtml
1-transitional.dtd">
<html xmlns="http
://www.w3.org/
1999/xhtml"><!--
Instance
Beg
in template="/Templates/bookmanager.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<!--
Instance
Beg
inEditable name="doctitle" -->
<title>简单
查询</title>
<!--
InstanceEndEditable -->
<style>
.style
1{
z-
index
:4;
height
:74px;
}
</style>
<!--
Instance
Beg
inEditable name="head" --><!--
InstanceEndEditable -->
</head>
<?php
include("conn.php");
?>
<body>
<div id="apDiv
1" align="center"><img src="lili3277.jpg" width="796" height="
108" /></div>
<div id="apDiv2">
<table width="836" border="0" align="center" bgcolor="#00FF00">
<tr >
<td width="
133"><span class="style
1"><?PHP echo date("Y-m-d"); ?></span></td>
<td width="
109"><span class="style
1"><a href="
index.php">首页</a></span></td>
<td width="
137"><span class="style
1"><a href="borrow.php">浏览信息</a></span></td>
<td width="
110"><span class="style
1"><a href="add.php">添加图书</a></span></td>
<td width="92"><span class="style
1"><a href="search.php">简单
查询</a></span></td>
<td width="78"><span class="style
1"><a href="searchmore.php">复杂
查询</a></span></td>
<td width="77"><span class="style
1"><a href="group.php">分组统计</a></span></td>
<td width="66"><span class="style
1"><a href="quit.php">退出系统</a></span></td>
</tr>
</table>
</div>
<!--
Instance
Beg
inEditable name="EditRegion3" -->
<div id="apDiv3">
<form id="forml" name="forml" action="" method="post">
<table width="200" border="
1" align="center">
<tr>
<td>图书名称</td>
<td><la
bel><
input type="text" name="bookname" id="bookname" /></la
bel></td>
<td><la
bel><
input type="submit" name="submit" id="submit" value="
查询" /></la
bel></td>
</tr>
</table>
</form>
<?php
if($_POST[submit]=="
查询" or $_GET[bk]!=""){
$bookname=$_POST[submit];
if($bookname==""){$bookname=$_GET[bk];}
?>
<table width="778" border="
1" align="center" bgcolor="#FF66FF">
<tr>
<td width="97"><a href="?bk=<?php echo $bookname; ?>&od=id" class="style
1">图书编号</a></td>
<td width="93"><a href="?bk=<?php echo $bookname; ?>&od=bookname" class="style
1">图书名称</a></td>
<td width="95"><a href="?bk=<?php echo $bookname; ?>&od=issuDate" class="style
1">出版日期</a></td>
<td width="93"><a href="?bk=<?php echo $bookname; ?>&od=price" class="style
1">图书定价</a></td>
<td width="57"><a href="?bk=<?php echo $bookname; ?>&od=maker" class="style
1">作者</a></td>
<td width="76"><a href="?bk=<?php echo $bookname; ?>&od=publisher" class="style
1">出版社</a></td>
<td width="92"><span class="style
1">操作</span></td>
</tr>
<?php
$od=$_GET[od];
if($od==""){
$sql="select * from tb_book where bookname like '%".$bookname."%' order by id desc limit
12";}else{
$sql="select * from tb_book where bookname like '%".$bookname."%' order by ".$od." desc limit
12";
}
$result=
mysqli_query($conn,$sql);
$num=
mysqli_num_rows($result);
while($myrow=
mysqli_
fetch_
array($result)){
?>
<tr>
<td><span class="style
1"><?php echo $myrow[0]; ?></span></td>
<td><span class="style
1"><?php echo $myrow[
1]; ?></span></td>
<td><span class="style
1"><?php echo $myrow[2]; ?></span></td>
<td><span class="style
1"><?php echo $myrow[3]; ?></span></td>
<td><span class="style
1"><?php echo $myrow[4]; ?></span></td>
<td><span class="style
1"><?php echo $myrow[5]; ?></span></td>
<td><span class="style
1"><a href="del.php?id=<? echo $myrow[0]?>">删除</a>/<a href="update.php?id=<? echo $myrow[0]?>">修改</a></span></td>
</tr>
<?php
}
}?>
</table>
<p align="center">
<?php
echo "共".$num."条记录被查出";
?>
</p>
</div>
<!--
InstanceEndEditable -->
<div id="apDiv4">
<p align="center">版权所有：22电子商务专业</p>
<p align="center">校址：安徽省池州市教育园区</p>
</div>
</body>
<!--
InstanceEnd --></html>
这段PHP代码会有“
Warning: mysqli_num_rows
() expects parameter 1 to be mysqli_result,
boolean given in C
:\appserv\www\22ECbook\conn\search.php on l
ine 68”和“
Warning: mysqli_
fetch_
array() expects parameter 1 to be mysqli_result,
boolean given in C
:\appserv\www\22ECbook\conn\search.php on l
ine 69”两个报错，给我分析一下
本文介绍了在使用MySQL进行数据查询时的一些常见调试技巧，包括如何通过添加ordie(mysql_error())来查看具体的错误信息，以及在调试过程中需要注意的事项，如去掉‘@’符号以确保能够接收到错误提示。
扫一扫
1403
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
