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>新書管理功能頁(yè)</title>
<link rel="stylesheet" href="css.css" type="text/css">
</head>
<body>
<?php
$pagesize = 8; //每頁(yè)顯示數(shù)
$sql = "select * from yx_books";
$rs = mysqli_query($link,$sql);
$recordcount = mysqli_num_rows($rs);
//mysql_num_rows() 返回結(jié)果集中行的數(shù)目。此命令僅對(duì) SELECT 語(yǔ)句有效。
$pagecount = ($recordcount-1)/$pagesize+1; //計(jì)算總頁(yè)數(shù)
$pagecount = (int)$pagecount;
$pageno = $_GET["pageno"]; //獲取當(dāng)前頁(yè)
if($pageno == "")
{
$pageno=1; //當(dāng)前頁(yè)為空時(shí)顯示第一頁(yè)
}
if($pageno<1)
{
$pageno=1; //當(dāng)前頁(yè)小于第一頁(yè)時(shí)顯示第一頁(yè)
}
if($pageno>$pagecount) //當(dāng)前頁(yè)數(shù)大于總頁(yè)數(shù)時(shí)顯示總頁(yè)數(shù)
{
$pageno=$pagecount;
}
$startno=($pageno-1)*$pagesize; //每頁(yè)從第幾條數(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">入庫(kù)時(shí)間</td>
<td width="11%" align="center" bgcolor="#FFFFFF">類別</td>
<td width="11%" align="center" bgcolor="#FFFFFF">入庫(kù)總量</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)
{
?>
首頁(yè) | 上一頁(yè) | <a href="?pageno=<?php echo $pageno+1?>&id=<?php echo $id?>">下一頁(yè)</a> |
<a href="?pageno=<?php echo $pagecount?>&id=<?php echo $id?>">末頁(yè)</a>
<?php
}
else if($pageno==$pagecount)
{
?>
<a href="?pageno=1&id=<?php echo $id?>">首頁(yè)</a> |
<a href="?pageno=<?php echo $pageno-1?>&id=<?php echo $id?>">上一頁(yè)</a> | 下一頁(yè) | 末頁(yè)
<?php
}
else
{
?>
<a href="?pageno=1&id=<?php echo $id?>">首頁(yè)</a> |
<a href="?pageno=<?php echo $pageno-1?>&id=<?php echo $id?>">上一頁(yè)</a> |
<a href="?pageno=<?php echo $pageno+1?>&id=<?php echo $id?>" class="forumRowHighlight">下一頁(yè)</a> |
<a href="?pageno=<?php echo $pagecount?>&id=<?php echo $id?>">末頁(yè)</a>
<?php
}
?>
頁(yè)次：<?php echo $pageno ?>/<?php echo $pagecount ?>頁(yè) 共有<?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.
