adminfun.inc

图书管理系统

<?php
class adminos
{
	
	//管理员注销登录
	function logout($tadmin)
	{
		//判断取得的用户信息是否为空
		//如果为空显示错误信息
		if($tadmin == "")
		{
     		echo "<b>本站提示</b>";
	 		echo "<hr>";
	 		echo "你还没有进行登录，所以不能执行此操作，请先登录！";
	 		echo "<br>";
	 		echo "<a href='index.php' >我要登录</a>";
	 		echo "<br>";
	 		echo "<a href='../index.php' >返回首页</a>";
		}
		else
    	{
	  		//如果用户信息不为空,注销当前用户
	  		echo "<hr>";
	  		echo "<b>注 销 用 户</b><br>";
	  		echo "会员ID：[";
	 		echo $tadmin; 
	  		$_SESSION['admin'] = "";
	  		echo "]<br><b>操作结果：</b>注销登录成功！";
	  		echo "<br>我要转到：";
	  		echo "<a href='index.php'>重新登录</a><br>";
	  		echo "<a href='../index.php'>返回首页</a>";
		}
	}
	
	//管理员登录检查
	function loginchk($tadmin,$tpwd,$admin)
	{
		$query = "select * from $admin where adminid = '$tadmin'";
		//处理中文乱码
		//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'];
  			$admin = $row['adminid'];
  			$pwd = $row['adminpwd'];

   			if ($pwd==$tpwd)
    		{
	   			$_SESSION['admin'] = $admin;
	   
	   			echo "管理员登录成功！<hr><p>";
       			echo "登录管理员是：".$_SESSION['admin']."<p>";
	   			echo "现在你可以<a href='index.php'>回到管理首页</a>";
	   			echo "<br>或转到本站首页<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='../index.php'>请不要尝试登录！</a>";
		}
	}
	
	//添加新书
	function addbook($tbookid,$tbookname,$tauthor,$tpublish,$tpdate,$tprice,$tamount,$tstate,$tmemo,$book)
	{
		
		if(($tbookid=="") or ($tbookname=="") or ($tauthor=="") or ($tpublish=="") or ($tpdate=="") or ($tprice=="") or 		($tamount=="") or ($tstate=="") or ($tmemo==""))
		{
			echo "<script language=javascript>alert('带＊号的选项必须填写全！');history.go(-1)</script>";
			exit;
		}
		if(substr_count("$tbookid", " ")>0 or substr_count("$tbookid", "　")>0 )
		{
			echo "<script language=javascript>alert('图书编号不能有空格');history.go(-1)</script>";
			exit;
		}
		if (!ereg("^[_a-z0-9A-Z-]",$tbookid))
		{
			echo "<script language=javascript>alert('图书编号的格式不对，只能是英文或者数字');history.go(-1)</script>";
			exit;
		}
		if (!ereg("^[0-9-]",$tpdate))
		{
			echo "<script language=javascript>alert('出版日期只能用数字，中间加下画线表示');history.go(-1)</script>";
			exit;
		}
		if (!ereg("^[0-9]",$tamount))
		{
			echo "<script language=javascript>alert('图书数量只能是数字');history.go(-1)</script>";
			exit;
		}
		if (!ereg("^[0-9]",$tstate))
		{
			echo "<script language=javascript>alert('当前图书数量只能是数字');history.go(-1)</script>";
			exit;
		}

		$sql="SELECT bookid FROM $book where bookid='$tbookid'";
		$result=mysql_query($sql);
		if($myrow=mysql_fetch_row($result))
		{
			echo "<script language=javascript>alert('此图书编号已经使用，请重新填写，或修改现有图书信息!');history.go(-1)</script>";
			exit;
			}	

		$query = "INSERT INTO $book(bookid,bookname,author,publish,pdate,price,amount,state,memo)"
			."VALUES('$tbookid','$tbookname','$tauthor','$tpublish','$tpdate','$tprice',"
			."'$tamount','$tstate','$tmemo')";
			
		
		$result = mysql_query($query)
			or die("插入出现错误: " . mysql_error());
		$rowid = mysql_insert_id();
 		if ($rowid>0)
    	{
       		echo "新书入库成功！<hr><p>";
       		echo "新入库的新书是：".$tbookname."<p>";
	   		echo "<br><a href='index.php'>继续添加</a>";
		 }
		else
		{
	    	 echo "新书入库失败！<hr><p>";
         	echo "新书：[".$tbookname."]"; 
         	echo "入库失败！";
		 	echo "<br><a href='index.php'>重新添加</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 "</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=delbookok.php?id=".$id."&&bookname=".$bookname.">删除</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>";
	}
	
	//修改图书信息
	function mdybook($tid,$tbookid,$tbookname,$tauthor,$tpublish,$tpdate,$tprice,$tamount,$tstate,$tmemo,$book)
	{
		
		if(($tbookid=="") or ($tbookname=="") or ($tauthor=="") or ($tpublish=="") or ($tpdate=="") or ($tprice=="") or 		($tamount=="") or ($tstate=="") or ($tmemo==""))
		{
			echo "<script language=javascript>alert('带＊号的选项必须填写全！');history.go(-1)</script>";
			exit;
		}
		if(substr_count("$tbookid", " ")>0 or substr_count("$tbookid", "　")>0 )
		{
			echo "<script language=javascript>alert('图书编号不能有空格');history.go(-1)</script>";
			exit;
		}
		if (!ereg("^[_a-z0-9A-Z-]",$tbookid))
		{
			echo "<script language=javascript>alert('图书编号的格式不对，只能是英文或者数字');history.go(-1)</script>";
			exit;
		}
		if (!ereg("^[0-9-]",$tpdate))
		{
			echo "<script language=javascript>alert('出版日期只能用数字，中间加下画线表示');history.go(-1)</script>";
			exit;
		}
		if (!ereg("^[0-9]",$tamount))
		{
			echo "<script language=javascript>alert('图书数量只能是数字');history.go(-1)</script>";
			exit;
		}
		if (!ereg("^[0-9]",$tstate))
		{
			echo "<script language=javascript>alert('当前图书数量只能是数字');history.go(-1)</script>";
			exit;
		}

		$sql="SELECT * FROM $book where bookid='$tbookid' && id!='$tid'";