PHP develops simple book background management system new book management complete code
This section shows the complete functional module of new book management in the book backend management system. First, we
need to introduce the database file config.php file and the ly_check.php file that determines whether the administrator is logged in
Call the css.css style in the HTML page
The new book management function page is named list.php
<?php
include("config.php");
require_once('ly_check.php');
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>新書管理功能頁</title>
<link rel="stylesheet" href="css.css" type="text/css">
</head>
<body>
<?php
$pagesize = 8; //每頁顯示數(shù)
$sql = "select * from yx_books";
$rs = mysqli_query($link,$sql);
$recordcount = mysqli_num_rows($rs);
//mysql_num_rows() 返回結(jié)果集中行的數(shù)目。此命令僅對(duì) SELECT 語句有效。
$pagecount = ($recordcount-1)/$pagesize+1; //計(jì)算總頁數(shù)
$pagecount = (int)$pagecount;
$pageno = $_GET["pageno"]; //獲取當(dāng)前頁
if($pageno == "")
{
$pageno=1; //當(dāng)前頁為空時(shí)顯示第一頁
}
if($pageno<1)
{
$pageno=1; //當(dāng)前頁小于第一頁時(shí)顯示第一頁
}
if($pageno>$pagecount) //當(dāng)前頁數(shù)大于總頁數(shù)時(shí)顯示總頁數(shù)
{
$pageno=$pagecount;
}
$startno=($pageno-1)*$pagesize; //每頁從第幾條數(shù)據(jù)開始顯示
$sql="select * from yx_books order by id desc limit $startno,$pagesize";
$rs=mysqli_query($link,$sql);
?>
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC" class="table" >
<tr>
<td height="27" colspan="7" align="left" bgcolor="#FFFFFF" class="bg_tr"> 后臺(tái)管理 >> 新書管理</td>
</tr>
<tr>
<td width="6%" height="35" align="center" bgcolor="#FFFFFF">ID</td>
<td width="25%" align="center" bgcolor="#FFFFFF">書名</td>
<td width="11%" align="center" bgcolor="#FFFFFF">價(jià)格</td>
<td width="16%" align="center" bgcolor="#FFFFFF">入庫時(shí)間</td>
<td width="11%" align="center" bgcolor="#FFFFFF">類別</td>
<td width="11%" align="center" bgcolor="#FFFFFF">入庫總量</td>
<td width="20%" align="center" bgcolor="#FFFFFF">操作</td>
</tr>
<?php
while($rows=mysqli_fetch_assoc($rs))
{
?>
<tr align="center">
<td class="td_bg" width="6%"><?php echo $rows["id"]?></td>
<td class="td_bg" width="25%" height="26"><?php echo $rows["name"]?></td>
<td class="td_bg" width="11%" height="26"><?php echo $rows["price"]?></td>
<td class="td_bg" width="16%" height="26"><?php echo $rows["uploadtime"]?></td>
<td width="11%" height="26" class="td_bg"><?php echo $rows["type"]?></td>
<td width="11%" height="26" class="td_bg"><?php echo $rows["total"]?></td>
<td class="td_bg" width="20%">
<a href="update.php?id=<?php echo $rows['id'] ?>" class="trlink">修改</a>
<a href="del.php?id=<?php echo $rows['id'] ?>" class="trlink">刪除</a>
</td>
</tr>
<?php
}
?>
<tr>
<th height="25" colspan="7" align="center" class="bg_tr">
<?php
if($pageno==1)
{
?>
首頁 | 上一頁 | <a href="?pageno=<?php echo $pageno+1?>&id=<?php echo $id?>">下一頁</a> |
<a href="?pageno=<?php echo $pagecount?>&id=<?php echo $id?>">末頁</a>
<?php
}
else if($pageno==$pagecount)
{
?>
<a href="?pageno=1&id=<?php echo $id?>">首頁</a> |
<a href="?pageno=<?php echo $pageno-1?>&id=<?php echo $id?>">上一頁</a> | 下一頁 | 末頁
<?php
}
else
{
?>
<a href="?pageno=1&id=<?php echo $id?>">首頁</a> |
<a href="?pageno=<?php echo $pageno-1?>&id=<?php echo $id?>">上一頁</a> |
<a href="?pageno=<?php echo $pageno+1?>&id=<?php echo $id?>" class="forumRowHighlight">下一頁</a> |
<a href="?pageno=<?php echo $pagecount?>&id=<?php echo $id?>">末頁</a>
<?php
}
?>
頁次：<?php echo $pageno ?>/<?php echo $pagecount ?>頁 共有<?php echo $recordcount?>條信息
</th>
</tr>
</table>
</body>
</html>When you click "Modify", jump to the update.php file modification page .
We will show the update.php file in full in the next section.
