Pelaksanaan kod laman utama lengkap sistem pinjaman buku mudah dibangunkan dalam PHP
Bahagian ini melaksanakan kod fungsi halaman utama seperti yang ditunjukkan di bawah
Halaman utama ialah index.php, yang merangkumi pemilihan kategori, keluar pengguna, meminjam dan memulangkan buku, dan pelbagai rancangan paging.
<?php
include("config.php");
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>圖書(shū)管理系統(tǒng)主頁(yè)面</title>
<style>
body,td,th {font-family: 微軟雅黑;font-size: 9px;color: #222;}
body {background-color: #FFFFFF;line-height:20px;}
a:link {color: #222;text-decoration: none;}
a:visited {text-decoration: none;color: #222;}
a:hover {text-decoration: underline;color: #FF0000;}
a:active {text-decoration: none;color: #999999;}
</style>
</head>
<body>
<?php include("head.php");?>
<table width="782" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="22">
<?php
$pagesize=5; //每頁(yè)顯示5條數(shù)據(jù)
if(!urldecode($_GET['proid'])){
//urldecode()函數(shù)將 URL 編碼后字符串還原成未編碼的樣子。編碼使用 %## 的格式
$sql="select * from yx_books order by id desc"; //倒序排列
}else{
$sql="select * from yx_books where type='".urldecode($_GET['proid'])."'";
//將查詢(xún)出來(lái)的書(shū)目類(lèi)別中文字轉(zhuǎn)換為編碼形式
}
$rs=mysqli_query($link,$sql);
$recordcount=mysqli_num_rows($rs); //輸出查詢(xún)的總數(shù)
//mysql_num_rows() 返回結(jié)果集中行的數(shù)目。此命令僅對(duì) SELECT 語(yǔ)句有效。
$pagecount=($recordcount-1)/$pagesize+1; //計(jì)算總頁(yè)數(shù)
$pagecount=(int)$pagecount;
$pageno=empty($_GET["pageno"])?'':$_GET["pageno"]; //當(dāng)前頁(yè)
if($pageno=="") //當(dāng)前頁(yè)為空時(shí)顯示第一頁(yè)
{
$pageno=1;
}
if($pageno<1) //當(dāng)前頁(yè)小于第一頁(yè)時(shí)顯示第一頁(yè)
{
$pageno=1;
}
if($pageno>$pagecount) //當(dāng)前頁(yè)數(shù)大于總頁(yè)數(shù)時(shí)顯示總頁(yè)數(shù)
{
$pageno=$pagecount;
}
$startno=($pageno-1)*$pagesize; //每頁(yè)從第幾條數(shù)據(jù)開(kāi)始顯示
if(!urldecode($_GET["proid"])){
$sql="select * from yx_books order by id desc limit $startno,$pagesize";
}else{
$sql="select * from yx_books where type='".urldecode($_GET['proid'])."'
order by id desc limit $startno,$pagesize";
}
$rs=mysqli_query($link,$sql);
?>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td width="88" height="30" align="center" bgcolor="#FFFFFF" class="line2">ID</td>
<td width="103" align="center" bgcolor="#FFFFFF" class="line2">書(shū)名</td>
<td width="77" align="center" bgcolor="#FFFFFF" class="line2">價(jià)格</td>
<td width="152" align="center" bgcolor="#FFFFFF" class="line2">入庫(kù)時(shí)間</td>
<td width="107" align="center" bgcolor="#FFFFFF" class="line2">類(lèi)別</td>
<td width="126" align="center" bgcolor="#FFFFFF" class="line2">現(xiàn)有數(shù)量(本)</td>
<td width="121" align="center" bgcolor="#FFFFFF" class="line2">操作</td>
</tr>
<?php
if(!empty($rs)){
while($rows=mysqli_fetch_array($rs))
{
?>
<tr>
<td height="30" align="center" bgcolor="#FFFFFF"><?php echo $rows["id"];?></td>
<td align="center" bgcolor="#FFFFFF"><?php echo $rows["name"];?></td>
<td align="center" bgcolor="#FFFFFF"><?php echo $rows["price"];?></td>
<td align="center" bgcolor="#FFFFFF"><?php echo $rows["uploadtime"];?></td>
<td align="center" bgcolor="#FFFFFF"><?php echo $rows["type"];?></td>
<td align="center" bgcolor="#FFFFFF"><?php echo $rows["leave_number"];?></td>
<td align="center" bgcolor="#FFFFFF" class="line2">
<?php
$rs2=mysqli_query($link,"select * from lend where book_id='".$rows['id']."'
and user_id='".$_SESSION['id']."'");
$rows2=mysqli_fetch_assoc($rs2);
if($rows2['book_id']){
echo "<font color='red'>您已借閱</font>
<a href=huanshu.php?book_id=".$rows['id'].">我要還書(shū)</a>";
}else{
if($rows["leave_number"]==0){
echo "<font color='#cccc00'>該書(shū)已借完</font>";
}else{
echo "<a href=jieshu.php?book_id=".$rows['id'].">我要借書(shū)</a>";
}
}
?> </td>
</tr>
<?php
}
}
?>
</table>
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td height="35" align="center" bgcolor="#FFFFFF">
<?php
if($pageno==1)
{
?>
首頁(yè) | 上一頁(yè) |
<?php if($pageno+1<= $pagecount) { ?>
<a href="index.php?proid=<?php echo empty($_GET['proid'])?'':urlencode($_GET['proid']);?>
&pageno=<?php echo $pageno + 1 ?>">下一頁(yè)</a> |
<a href="index.php?proid=<?php echo empty($_GET['proid'])?'':urlencode($_GET['proid']);?>
&pageno=<?php echo $pagecount ?>">末頁(yè)</a>
<?php
}
}
else if($pageno==$pagecount)
{
?>
<a href="index.php?proid=<?php echo urlencode($_GET['proid']);?>&pageno=1">首頁(yè)</a> |
<a href="index.php?proid=<?php echo urlencode($_GET['proid']);?>
&pageno=<?php echo $pageno-1?>">上一頁(yè)</a> | 下一頁(yè) | 末頁(yè)
<?php
}
else
{
?>
<a href="index.php?proid=<?php echo urlencode($_GET['proid']);?>&pageno=1">首頁(yè)</a> |
<a href="index.php?proid=<?php echo urlencode($_GET['proid']);?>
&pageno=<?php echo $pageno-1?>">上一頁(yè)</a> |
<a href="index.php?proid=<?php echo urlencode($_GET["proid"]);?>
&pageno=<?php echo $pageno+1?>" class="forumRowHighlight">下一頁(yè)</a> |
<a href="?pageno=<?php echo $pagecount?>">末頁(yè)</a>
<?php
}
?>
頁(yè)次：<?php echo $pageno ?>/<?php echo $pagecount ?>
頁(yè) 共有<?php echo $recordcount?>條信息</td>
</tr>
</table></td></tr>
</table>
<table width="782" height="30" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td height="19" align="center"> Copyright @ 2013-2016</td>
</tr>
</table>
</body>
</html>
