注册审核

主页面

<?php
session_start();
include("../DBDA.class.php");
$db=new DBDA();
if(empty($_SESSION["uid"]))
{
header("location:login.php");
exit;
}
?>
<h1>审核页面</h1>
<table>
<tr>
<td>代号</td>
<td>姓名</td>
<td>性别</td>
<td>生日</td>
<td>操作</td>
</tr>
<?php
$sql="select * from user";
$attr=$db->Query($sql);
foreach($attr as $v)
{
$sex=$v[3]?"男":"女";
$caozuo=$v[5]?"<span style='background-color:green'>已通过</span>":"<a href='shenhe.php?uid={$v[0]}'>审核</a>";
echo"<tr>
<td>{$v[0]}</td>
<td>{$v[3]}</td>
<td>{$sex}</td>
<td>{$v[4]}</td>
<td>{$caozuo}</td>
</tr>";
}
?>

审核通过的处理页面

<?php
include("../DBDA.class.php");
$db=new DBDA();
$uid=$_GET["uid"];
$sql="update user set IsOk=true where Uid='{$uid}'";
$db->Query($sql,0);
header("location:main.php");

登录处理页面

<?php
session_start();
include("../DBDA.class.php");
$db=new DBDA();
$uid=$_POST["uid"];
$pwd=$_POST["pwd"];
$sql="select Pwd from user where Uid='{$uid}'";
$mima=$db->StrQuery($sql);
$ssh="select IsOk from user where Uid='{$uid}'";
$sshen=$db->StrQuery($ssh);
if($uid!="" && $pwd!="")
{
if($mima==$pwd && $sshen==1)
{
$_SESSION["uid"]=$uid;
header("location:main.php");
}
else
{
echo "用户名或密码错误或未审核";
}
}
else
{
echo"用户名或密码错误或未审核";
}