userfun.inc

图书管理系统

<?php
class useros
{
	
	//用户注销登录
	function logout($tuserid)
	{
		//判断取得的用户信息是否为空
		//如果为空显示错误信息
		if($tuserid == "")
		{
     		echo "<b>本站提示</b>";
	 		echo "<hr>";
	 		echo "你还没有进行登录，所以不能执行此操作，请先登录！";
	 		echo "<br>";
	 		echo "<a href='index.php' >我要登录</a>";
		}
		else
    	{
	  		//如果用户信息不为空,注销当前用户
	  		echo "<hr>";
	  		echo "<b>注 销 用 户</b><br>";
	  		echo "用户ID：[";
	 		echo $tuserid; 
	  		$_SESSION['userid'] = "";
			$_SESSION['name'] = "";
	  		echo "]<br><b>操作结果：</b>注销登录成功！";
	  		echo "<br>我要转到：";
	  		echo "<a href='index.php'>重新登录</a><br>";
		}
	}
	
	//用户登录检查
	function loginchk($tuserid,$tpwd,$user)
	{
		$query = "select * from $user where userid = '$tuserid'";
		//处理中文乱码
		mysql_query("set names gb2312");
		$result = mysql_query($query);
		$num = mysql_num_rows($result);
		//判断是否存在当前会员
		if($num>0)
		{
  			$row = mysql_fetch_array($result);
 			$id = $row['id'];
  			$userid = $row['userid'];
			$name = $row['name'];
  			$pass = $row['pass'];

   			if ($pass==$tpwd)
    		{
	   			$_SESSION['userid'] = $userid;
			    $_SESSION['name'] = $name;
	   			echo "用户登录成功！<hr><p>";
       			echo "登录用户是：".$_SESSION['name']."<p>";
	   			echo "现在你可以<a href='index.php'>回到首页</a>";
	 		}
			else
			{
	    		echo "用户登录失败！<hr><p>";
         		echo "用户密码不正确！"; 
		 		echo "<br><a href='index.php'>请重新登录</a>";
			}

 		}
		else
 		{
	     	echo "用户登录失败！<hr><p>";
         	echo "当前用户不存在！"; 
		 	echo "<br><a href='#'>请进行注册！</a>";
		}
	}
	
	
	//查看所有图书
	function allbook($page,$psize)
	{
		echo "<div id='main'>";
		echo "<div class='hr'><hr /></div>";
		echo "<div id='example'>";

		// 建立数据库连接
		require "conn.php";
		// 获取当前页数

		// 每页数量
		$page_size = $psize; 
		// 获取总数据量
		$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 "<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'];
		 $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>";

		// 翻页链接
		$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 searchbook($tbookid,$tbookname,$tbookauthor,$tpublish,$book)
	{
		echo "<div id='main'>";
		echo "<div class='hr'><hr /></div>";
		echo "<div id='example'>";
		// 建立数据库连接
		require "conn.php";
		global $sql1;
		global $sql2;
		//根据条件设计查询语句
		$sql1 = "SELECT count(*)  FROM $book  WHERE ";
		$sql2 = "select * from $book WHERE ";
		if($tbookid != "")
		{
			$sql1 = $sql1." bookid = '$tbookid'";
			$sql2 = $sql2." bookid = '$tbookid'";
		}
	
		if(($tbookname != "") && ($tbookid != ""))
		{
			$sql1 = $sql1." and bookname = '$tbookname '";
			$sql2 = $sql2." and bookname = '$tbookname '";
		}
		elseif (($tbookname != "") && ($tbookid == ""))
		{
			$sql1 = $sql1."  bookname = '$tbookname '";
			$sql2 = $sql2."  bookname = '$tbookname '";
		}
	
		if(($tbookauthor != "") && (($tbookid != "") || ($tbookname != "")))
		{
			$sql1 = $sql1." and author = '$tbookauthor '";
			$sql2 = $sql2." and author = '$tbookauthor '";
		}
		elseif ($tbookauthor != "")
		{
			$sql1 = $sql1." author = '$tbookauthor '";
			$sql2 = $sql2." author = '$tbookauthor '";
		}	
	
		if(($tpublish != "") && (($tbookid != "") || ($tbookname != "") || ($tbookauthor != "")))
		{
			$sql1 = $sql1." and publish = '$tpublish '";
			$sql2 = $sql2." and publish = '$tpublish '";
		}
		elseif ($tpublish != "")
		{
			$sql1 = $sql1." publish = '$tpublish '";
			$sql2 = $sql2." publish = '$tpublish '";
		}
		
		// 获取当前页数
		if( isset($_GET['page']) )
		{
		   $page = intval( $_GET['page'] );
		}
		else
		{
		   $page = 1;
		} 
		// 每页数量
		$page_size = $psize; 
		
		// 获取总数据量
		$result = mysql_query($sql1);
		$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