php注册审核重点解析（数据访问）
2018-10-15 17:59
阅读：482
关于审核，如发表文章的审核、员工请假的审核、药品申请的审核等等，代码大同小异。
一.注册功能（zhece.php chuli.php）
1.zhece.php
2.chuli.php
<?php $users = $_POST[users]; $pwd = $_POST[pwd]; $name= $_POST[name]; $sex = $_POST[sex]; $birthday = $_POST[birthday]; require DBDA.class.php; $db = new DBDA(); $sql = insert into users values ({$users},{$pwd},{$name},{$sex},{$birthday},0); if($db->query($sql,0)){ header(location:zhuce.php); } ?>二.登录功能（denglu.php login.php ）
1.denglu.php
<!DOCTYPE html> <html> <head> <meta charset=UTF-8> <title></title> </head> <body> <form method=post action=login.php> <div style=margin:100px 500px> <h2 > 登录页面</h2> <div>用户名：<input type=text name=users/></div><br /> <div>密码：<input type=text name=pwd/></div><br /> <input type=submit value=登录 /> <a href=zhuce.php rel=external nofollow >没有账号，立即注册</a> </div> </form> </body> </html>2.login.php
<?php $users = $_POST[users]; $pwd = $_POST[pwd]; require DBDA.class1.php; $db = new DBDA(); $sql = select * from users where users = {$users}; $arr = $db->query($sql); //$arr[0][1] 密码 //$arr[0][5] 审核状态 if($arr[0][1] == $pwd && !empty($pwd)) { if($arr[0][5]) { echo 登录成功！; } else{ echo 审核未通过！; } } else{ echo 用户名或密码错误！; } ?>三.管理员的审核功能（guanliyuan.php tongguo.php chexiao.php）
1.guanliyuan.php
<!DOCTYPE html> <html> <head> <meta charset=UTF-8> <title></title> </head> <body> <h1>管理员审核</h1> <table width=100% border=1 cellpadding=0 cellspacing=0> <tr> <td>用户名</td> <td>密码</td> <td>姓名</td> <td>性别</td> <td>生日</td> <td>操作</td> </tr> <?php requireDBDA.class1.php; $db = new DBDA(); $sql = select * from users; $arr = $db->query($sql); foreach($arr as $v) { $str = ; if($v[5]) { $str = <span style=color:green>已通过</span> <a href=chexiao.php?uid={$v[0]}>撤销</a>; } else { $str = <a href=tongguo.php?uid={$v[0]}>通过</a>; } echo <tr> <td>{$v[0]}</td> <td>{$v[1]}</td> <td>{$v[2]}</td> <td>{$v[3]}</td> <td>{$v[4]}</td> <td>{$str}</td> </tr>; } ?> </table> </body> </html>2.tongguo.php
<?php $uid = $_GET[uid]; require DBDA.class.php; $db = new DBDA(); $sql = update users set isok=1 where uid={$uid}; $db->query($sql,0); header(location:guanliyuan.php);3.chexiao.php
<?php $uid = $_GET[uid]; require DBDA.class.php; $db = new DBDA(); $sql = update users set isok=0 where uid={$uid}; $db->query($sql,0); header(location:guanliyuan.php);以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持脚本之家。
评论
亲，登录后才可以留言！