list_user.php

蓝芒图书管理系统 蓝芒图书管理系统 蓝芒图书管理系统

<?php
include("header.php");
include("checking.php");
?>
<script language="javascript">
<!--
function delete_user(ids,posts)
{
	if(confirm("此用户还有借书记录，你真的要删除吗！"))
		self.location.href="delete_user.php?userid="+ids+"&postword="+posts;
}
-->
</script>
<?php
if($pager=="")
	$pagenum=0;
else
	$pagenum=(int)$pager;
if($search=="yes")
{
	if((trim($name)=="") && (trim($editor))=="" )
	{
		echo "<p align=center>查询格件必须有一个要为真<br><a href=\"javascript:history.go(-1)\">返回</a>";
		exit();
	}
	if($modes=="yes")
	{
		if($name!="")
		{
			$sql="select * from user where name='".$name."' order by editor ";
			$postword="search=yes&name=".$name."&modes=yes";
		}
		else
		{
			$sql="select * from user where editor='".$editor."' order by editor ";
			$postword="search=yes&editor=".$editor."&modes=yes";
		}
	}
	else
		if($name!="")
		{
			$sql="select * from user where name like '%".$name."%' order by editor ";
			$postword="search=yes&name=".$name."&modes=no";
		}
		else
		{
			$sql="select * from user where editor like '%".$editor."%' order by editor ";
			$postword="search=yes&editor=".$editor."&modes=no";
		}
}
else
{
	$sql="select * from user order by editor ";
	$postword="kdsfsda=lksadjfs";
}
$sql.="limit ".($pagenum * $userlenth).",".(($pagenum+1) * $userlenth);
//echo $sql;
$rs=mysql_query($sql,$conn);
if(mysql_num_rows($rs)==0)
{
	if($pagenum==0)
		echo "<p align=center>没有找到符合要求的记录";
	else
		echo "<p align=center>数据库已经到底";
	echo "<br><a href=\"javascript:history.go(-1)\">返回</a>";
}
else
{
?>
<p align="center" class="1">用户资料列表</p>
<?php
if($pagenum!=0)
	echo "<p align=\"left\">&nbsp; <a href=\"list_user.php?".$postword."&pager=".($pagenum-1)."\">上页</a></p>"
?>
<table border="1" width="100%" bordercolor="#008000" cellspacing="0" cellpadding="0">
  <tr>
    <td width="10%" align="center" height="20">用户名</td>
    <td width="19%" align="center" height="20">证件号码</td>
    <td width="13%" align="center" height="20">编号</td>
    <td width="13%" align="center" height="20">电话</td>
    <td width="13%" align="center" height="20">住址</td>
    <td width="11%" align="center" height="20">EMAIL</td>
    <td width="9%" align="center" height="20">密码</td>
    <td width="6%" align="center" height="20">修改</td>
    <td width="6%" align="center" height="20">删除</td>
  </tr>
<?php
$nums=0;
while($lists=mysql_fetch_array($rs))
{
	echo "<tr>";
	echo "<td width=\"10%\" height=\"20\">";
	echo $lists[name];
	echo "</td>";
	
	echo "<td width=\"19%\" height=\"20\">";
	echo $lists[document];
	echo "</td>";
	
	echo "<td width=\"13%\" height=\"20\">";
	echo $lists[editor];
	echo "</td>";
	
	echo "<td width=\"13%\" height=\"20\">";
	echo $lists[phone];
	echo "</td>";
	
	echo "<td width=\"13%\" height=\"20\">";
	echo $lists[dress];
	echo "</td>";
    
    echo "<td width=\"11%\" height=\"20\">";
	echo $lists[eamil];
	echo "</td>";
	
	echo "<td width=\"9%\" height=\"20\">";
	echo $lists[password];
	echo "</td>";
    
    echo "<td width=\"6%\" height=\"20\">";
    echo "<a href=\"modify_user.php?userid=".$lists[id]."&postword=".urlencode($postword."&pager=".$pagenum)."\">修改</a>";
    echo "</td>";
    
    echo "<td width=\"6%\" height=\"20\">";
    if($lists[prepare_number]>0)
    	echo "<a href=# Onclick=\"alert('<p align=center>此用户还有预借记录没有删除，请先删除预借记录')\">删除</a>";
    else
    { 
    	if($lists[lend_number]>0)
    		echo "<button  Onclick=\"delete_user(".$lists[id]."')\">删除</button>";
    	else
    		echo "<a href=\"delete_user.php?userid=".$lists[id]."\">删除</a>";
    }
    echo "</td>";
    
    echo "</tr>";
	$nums+=1;
}    
echo "</table>";
if($nums==$userlenth)
	echo "<p align=\"right\"><a href=\"list_user.php?".$postword."&pager=".($pagenum+1)."\">下页</a>&nbsp;&nbsp;&nbsp; </p>";
}
mysql_close($conn);
?>

<form method="POST" action="list_user.php?search=yes">
  <p align="center">用户查找</p>
  <p align="center">姓名：<input type="text" name="name" size="19"><br>
  <p align="center">编号：<input type="text" name="editor" size="19"><br>
  
  精确匹配:<input type="radio" value="yes" name="modes" checked >&nbsp; 模糊匹配<input type="radio" value="no" name="modes"><br>
  <input type="submit" value="查找" name="B1"></p>
</form>

</body>

</html>