allbook2.php

图书管理系统

<?php	
echo "<div id='main'>";
echo "<div class='hr'><hr /></div>";
echo "<div id='example'>";

// 建立数据库连接
require "conn.php";
// 获取当前页数
if( isset($_GET['page']) )
{
   $page = intval( $_GET['page'] );
}
else
{
   $page = 1;
} 
// 每页数量
$page_size = 2; 
// 获取总数据量
$sql = "select count(*)  from $book";
$result = mysql_query($sql);
$row = mysql_fetch_row($result);
$amount = $row[0]; 
//echo $amount;
// 记算总共有多少页
if($amount)
{
   if( $amount < $page_size )
   { 
   	//如果总数据量小于$pagesize，那么只有一页
	$page_count = 1;
   }
   //取总数据量除以每页数的余数               
   if( $amount % $page_size )
   {                                  
       //如果有余数，则页数等于总数据量除以每页数的结果取整再加一
	   $page_count = (int)($amount / $page_size) + 1;           
	}
	else
   {
       //如果没有余数，则页数等于总数据量除以每页数的结果
	   $page_count = $amount / $page_size;                      
   }
}
else
{
   $page_count = 0;
}

			echo "<h2>所 有 图 书</h2>";
			echo "<blockquote>";
				echo "<p>管理员可以查查看、修改及删除下述图书记录:</p>";
			echo "</blockquote>";

			echo "<fieldset>";
			echo "<ul>";
			echo "<li>";
			echo "<label for='lbookid'>图书编号-></label>";
			echo "<label for='lbookid'>图书名称-></label>";
			echo "<label for='lbookid'>图书数量-></label>";
			echo "<label for='lbookid'>当前状态-></label>";
			echo "<label for='lbookid'>图书修改-></label>";
			echo "<label for='lbookid'>图书删除</label>";
			echo "</li>";
			echo "</ul>";
			echo "<ol>";

// 获取数据，以二维数组格式返回结果
if( $amount )
{
   $sql = "select * from $book order by id desc limit ". ($page-1)*$page_size .", $page_size";
   $result = mysql_query($sql);
   $num = mysql_num_rows($result);
   //echo $num;
		for ($i=0;$i<$num;$i++)
		{
 		 $row = mysql_fetch_array($result);
		 $id = $row['id'];
  		 $bookid = $row['bookid'];
 		 $bookname = $row['bookname'];
		 $amount = $row['amount'];
		 $state = $row['state'];

			echo "<li>";
			echo "<label for='lbookid'>".$bookid."-></label>";
			echo "<label for='lbookid'>".$bookname."-></label>";
			echo "<label for='lbookid'>".$amount."-></label>";
			echo "<label for='lbookid'>".$state."-></label>";
			echo "<label for='lbookid'><a href=mdybook.php?id=".$id.">修改</a>-></label>";
			echo "<label for='lbookid'><a href=delbook.php?id=".$id.">删除</a></label>";
			echo "</li>";


   		}
}
else
{
   echo "没有记录";
}

			echo "</ol>";
			echo "</fieldset>";

// 翻页链接
$page_string = '';
if( $page == 1 ){
   $page_string .= '第一页|上一页|';
}
else{
   $page_string .= '<a href=?page=1>第一页</a>|<a href=?page='.($page-1).'>上一页</a>|';
} 
if( ($page == $page_count) || ($page_count == 0) ){
   $page_string .= '下一页|尾页';
}
else{
   $page_string .= '<a href=?page='.($page+1).'>下一页</a>|<a href=?page='.$page_count.'>尾页</a>';
}

echo "<br>".$page_string;

  echo "</div>";
	echo "</div>";
	echo "<div id='extra'></div>";
echo "</div>";
?>