<!DOCTYPE html PUBLIC "
-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1
-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><head>
<meta http
-equiv="Content
-Type" content="text/html; charset=utf
-8" />
<title>欢迎来到我的御书房</title>
<style>
.style1{
font
-family: "Times New Roman", Times, serif;
font
-size: 16px;
line
-height: 1.6;
color: #333;
}
a {
text
-decoration: none;
}
table {
width: 1000px;
border
-collapse: collapse;
background: linear
-gradient(to right, #e0eafc, #cfdef3);
}
th, td {
border: 1px solid #ddd;
padding: 8px;
text
-align: left;
border: 1px solid #ddd;
padding: 5px;
}
th {
background
-color: #f2f2f2;
text
-align: center;
}
th:hover {
color: #0056b3; /* 鼠标悬停时颜色稍变深 */
}
tr:nth
-child(odd) {
background
-color: #f2f2f2;
}
</style>
</head>
<?php
include("conn.php");
?>
<body>
<div id="apDiv1" align="center"><img src="lili3277.jpg" width="796" height="108" /></div>
<div id="apDiv2">
<table width="867" border="0" align="center" >
<tr>
<th width="105"><span class="style1"><?PHP echo date("Y
-m
-d"); ?></span></th>
<th width="114"><span class="style1"><a href="index.php">首页</a></span></th>
<th width="125"><span class="style1"><a href="borrow.php">浏览信息</a></span></th>
<th width="116"><span class="style1"><a href="add.php">添加图书</a></span></th>
<th width="102"><span class="style1"><a href="search.php">简单查询</a></span></th>
<th width="93"><span class="style1"><a href="searchmore.php">复杂查询</a></span></th>
<th width="90"><span class="style1"><a href="group.php">分组统计</a></span></th>
<th width="88"><span class="style1"><a href="quit.php">退出系统</a></span></th>
</tr>
</table>
</div>
<div id="apDiv3">
<form id="forml" name="forml" action="" method="post">
<table width="778" border="1" align="center">
<tr>
<th width="97"><a href=" ?od=id" class="style1">图书编号</a></th>
<th width="93"><a href=" ?od=bookname" class="style1">图书名称</a></th>
<th width="95"><a href=" ?od=issuDate" class="style1">出版日期</a></th>
<th width="93"><a href=" ?od=price" class="style1">图书定价</a></th>
<th width="57"><a href=" ?od=maker" class="style1">作者</a></th>
<th width="76"><a href=" ?od=publisher" class="style1">出版社</a></th>
<th width="92"><span class="style1">操作</span></th>
</tr>
<?php
$od=$_GET[od];
if($od==""){
$sql="
select * from tb_book order by id desc limit 12";}else{
$sql="
select * from tb_book order by ".$od." desc limit 12";
}
$result=mysqli_query($conn,$sql);
while($myrow=mysqli_fetch_array($result)){
?>
<tr>
<td><div align="center"><span class="style1"><?php echo $myrow[0]; ?></span></div></td>
<td><div align="center"><span class="style1"><?php echo $myrow[1]; ?></span></div></td>
<td><div align="center"><span class="style1"><?php echo $myrow[2]; ?></span></div></td>
<td><div align="center"><span class="style1"><?php echo $myrow[3]; ?></span></div></td>
<td><div align="center"><span class="style1"><?php echo $myrow[4]; ?></span></div></td>
<td><div align="center"><span class="style1"><?php echo $myrow[5]; ?></span></div></td>
<td><div align="center"><span class="style1"><a href="del.php?id=<? echo $myrow[0]?>">删除</a>/<a href="update.php?id=<? echo $myrow[0]?>">修改</a></span></div></td>
</tr>
<?php
}?>
</table>
</form>
</div>
<div id="apDiv4">
<p align="center">版权所有：22电子商务专业</p>
<p align="center">校址：安徽省池州市教育园区</p>
</div>
</body>
</html>
这个代码显示出的图书名称等信息是
乱码，帮我分析一下什么问题，
<?php
$conn = mysqli_connect("localhost", "root", "root", "db_database18") or die("连接数据库服务器失败！".mysqli_connect_error());
mysqli_query($conn,"set name utf8");
?>
上面这个是数据库连接文件，图书信息在数据库里可以正常显示
扫一扫
590
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
