yonghuzhuce_list.php

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?php
include_once 'conn.php';

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>用户注册</title><link rel="stylesheet" href="css.css" type="text/css">
</head>

<body>

<p>已有普通用户列表：</p>
<form id="form1" name="form1" method="post" action="">
  搜索:账号:
  <input name="bh" type="text" id="bh" />
  姓名:
  <input name="mc" type="text" id="mc" />
  <input type="submit" name="Submit" value="查找" />
</form>
<table width="98%" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="#f0f0f0" style="border-collapse:collapse">  
  <tr>
    <td  bgcolor="#EBE2FE">序号</td>
    <td width="94" bgcolor='#EBE2FE'>账号</td>
    <td width="94" bgcolor='#EBE2FE'>密码</td>
    <td width="94" bgcolor='#EBE2FE'>姓名</td>
    <td width="94" bgcolor='#EBE2FE'>性别</td>
    <td width="167" bgcolor='#EBE2FE'>地区</td>
    <td width="204" bgcolor='#EBE2FE'>Email</td>
    <td width="86" bgcolor='#EBE2FE'>照片</td>
    <td width="120" align="center" bgcolor="#EBE2FE">添加时间</td>
    <td  align="center" bgcolor="#EBE2FE">操作</td>
  </tr>
  <?php
$sql = "select * from yonghuzhuce where 1=1";
if ($_POST["bh"] != "") {
    $nreqbh = $_POST["bh"];
    $sql    = $sql . " and zhanghao like '%$nreqbh%'";
}
if ($_POST["mc"] != "") {
    $nreqmc = $_POST["mc"];
    $sql    = $sql . " and xingming like '%$nreqmc%'";
}
$sql = $sql . " order by id desc";

$query     = mysql_query($sql);
$rowscount = mysql_num_rows($query);
if ($rowscount == 0) {
} else {
    $pagelarge   = 10; //每页行数；
    $pagecurrent = $_GET["pagecurrent"];
    if ($rowscount % $pagelarge == 0) {
        $pagecount = $rowscount / $pagelarge;
    } else {
        $pagecount = intval($rowscount / $pagelarge) + 1;
    }
    if ($pagecurrent == "" || $pagecurrent <= 0) {
        $pagecurrent = 1;
    }