利用PHP连接数据库操作用户注册、审核与登录页面

注册页面

注册页面

注册处理页面

<?php

$uid = $_POST[“uid”];

$pwd = $_POST[“pwd”];

$name = $_POST[“name”];

$sex = $_POST[“sex”];

$birthday = $_POST[“birthday”];

include (“LZY.class.php”);

$db = new LZY();

$sql = “insert into zhuce VALUES (‘{$uid}’,'{$pwd}’,'{$name}’,'{$sex}’,'{$birthday}’,0)”;

if($db->query($sql,0))

{

header(“location:zhuceyemiandenglu.php”);

}

else

{

echo “注册失败！”;

}

登录页面

页面登录

注册登录处理页面

<?php

$uid = $_POST[“uid”];

$pwd = $_POST[“pwd”];

include (“LZY.class.php”);

$db = new LZY();

$sql = “select * from zhuce where uid='{$uid}'”;

$arr = $db->Query($sql);

if($arr[0][1] == $pwd && !empty($pwd))

{

if($arr[0][5])

{

header(“location:zcmain.php”);

}

else

{

echo “该用户尚未通过审核！”;

}

}

else

{

echo “登录失败！”;

}

注册主界面

用户审核

<?php

include(“LZY.class.php”);

$db = new LZY();

$sql = “select * from zhuce”;

$arr = $db->Query($sql);

foreach($arr as $v)

{

$str = $v[5]?”已通过”:”通过”;

echo “

}

?>

审核通过代码

<?php

$uid = $_GET[“uid”];

include(“LZY.class.php”);

$db = new LZY();

$sql = “update zhuce set isok=1 where uid='{$uid}'”;

if($db->Query($sql,0))

{

header(“location:zcmain.php”);

}

else

{

echo “通过失败！”;

}