userfun.inc

图书管理系统

		   {
			   //如果没有余数，则页数等于总数据量除以每页数的结果
			   $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 "<label for='lbookid'>图书数量-></label>";
					echo "<label for='lbookid'>当前状态-></label>";
					echo "<label for='lbookid'>图书简介</label>";
					echo "</li>";
					echo "</ul>";
					echo "<ol>";
		
		// 获取数据，以二维数组格式返回结果
		if( $amount )
		{
		   $sql2 = $sql2." order by id desc limit ". ($page-1)*$page_size .", $page_size";
		   $result = mysql_query($sql2);
		   $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'];
					 $author = $row['author'];
					 $publish = $row['publish'];
					 $pdate = $row['pdate'];
					 $price = $row['price'];
					 $amount = $row['amount'];
					 $state = $row['state'];
					 $memo = $row['memo'];
					 
						echo "<li>";
						echo "<label for='lbookid'>".$bookid."-></label>";
						echo "<label for='lbookid'>".$bookname."-></label>";
						echo "<label for='lbookid'>".$author."-></label>";
						echo "<label for='lbookid'>".$publish."-></label>";
						echo "<label for='lbookid'>".$pdate."-></label>";
						echo "<label for='lbookid'>".$price."-></label>";
						echo "<label for='lbookid'>".$amount."-></label>";
						echo "<label for='lbookid'>".$state."-></label>";
						echo "<marquee direction='left'>";
						echo "<label for='lbookid'>".$memo."</label>";
						echo "</marquee>";
						echo "</li>";
					}
			}
			else
			{
			   echo "没有记录";
			}
			
						echo "</ol>";
						echo "</fieldset>";
			
			// 翻页链接
			$cx = 'bookid='.$tbookid.'&&bookname='.$tbookname.'&&bookauthor='.$tbookauthor.'&&publish='.$tpublish;
			$page_string = '';
			if( $page == 1 )
			{
			   $page_string .= '第一页|上一页|';
			}
			else
			{
			  // echo $cx;
			   $page_string .= '<a href=?'.$cx.'&&page=1>第一页</a>|
			   <a href=?'.$cx.'&&page='.($page-1).'>上一页</a>|';
			} 
			if( ($page == $page_count) || ($page_count == 0) )
			{
			   $page_string .= '下一页|尾页';
			}
			else
			{
			   $page_string .= '<a href=?'.$cx.'&&page='.($page+1).'>下一页</a>|
			   <a href=?'.$cx.'&&page='.$page_count.'>尾页</a>';
			}
			echo "<br>".$page_string;
			
			echo "</div>";
			echo "</div>";
			echo "<div id='extra'></div>";
			echo "</div>";
	}
	
	//用户查看自己的借阅信息
	function loanbook()
	{
		echo "<div id='main'>";
		echo "<div class='hr'><hr /></div>";
		echo "<div id='example'>";
		
		$tuserid = $_SESSION['userid'];
		// 建立数据库连接
		require "conn.php";
		// 获取当前页数
		if( isset($_GET['page']) )
		{
		   $page = intval( $_GET['page'] );
		}
		else
		{
		   $page = 1;
		} 
		// 每页数量
		$page_size = $psize; 
		// 获取总数据量
		$sql = "select count(*)  from $loan where userid= '$tuserid'";
		$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'>用户ID-></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 $loan where userid= '$tuserid' 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'];
				 $userid = $row['userid'];
				 $bookid = $row['bookid'];
				 $loandate = $row['loandate'];
				 $givebackdate = $row['givebackdate'];
				 $state = $row['state'];
				 $memo = $row['memo'];
		
					echo "<li>";
					echo "<label for='lbookid'>".$userid."-></label>";
					echo "<label for='lbookid'>".$bookid."-></label>";
					echo "<label for='lbookid'>".$loandate."-></label>";
					echo "<label for='lbookid'>".$state."-></label>";
					echo "<label for='lbookid'>".$memo."</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>";
	}
	
	//显示首页最新信息
	function newbob($book,$loan)
	{
			echo "<h2>最 新 图 书</h2>";
			echo "<ol>";
		
		$query = "select * from $book order by id desc limit 0,5";
		$result = mysql_query($query);
		$num = mysql_num_rows($result);
		if($num>0)
		{
			for($i=0;$i<$num;$i++)
			{
				$row = mysql_fetch_array($result);
				$id = $row['id'];
				$bookid = $row['bookid'];
				$bookname = $row['bookname'];

				echo "<li>".$bookname."[".$bookid."]</li>";
			}
		}
		else
		{
			echo "对不起，暂无新书入库";
		}

			echo "</ol>";

			echo "<h3>最 新 借 出 </h3>";
			echo "<ol>";

		$query = "select * from $loan order by id desc limit 0,5";
		$result = mysql_query($query);
		$num = mysql_num_rows($result);
		if($num>0)
		{
			for($i=0;$i<$num;$i++)
			{
				$row = mysql_fetch_array($result);
				$id = $row['id'];
				$userid = $row['userid'];
				$bookid = $row['bookid'];
			
				echo "<li>".$bookid."[".$userid."]</li>";

			}
		}
		else
		{
			echo "对不起，暂无用户借阅!";
		}
		
			echo "</ol>";
	}

}
?>