PHP membangunkan sistem pengurusan latar belakang buku ringkas kod lengkap pengurusan buku baharu
Bahagian ini menunjukkan modul berfungsi lengkap pengurusan buku baharu dalam sistem pengurusan bahagian belakang buku Pertama, kami
perlu memperkenalkan fail config.php pangkalan data dan fail ly_check.php yang menentukan sama ada fail tersebut. pentadbir dilog masuk
Panggil gaya css.css dalam halaman HTML
Halaman fungsi pengurusan buku baharu dinamakan 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>Apabila anda mengklik "Ubah suai", lompat ke halaman pengubahsuaian fail update.php .
Kami akan menunjukkan fail update.php sepenuhnya di bahagian seterusnya.
