This article mainly analyzes the key points of PHP registration review and data access, which has a certain reference value. Interested friends can refer to
About review, such as review of published articles, The codes for reviewing employee leave requests, reviewing drug applications, etc. are similar.
1. Registration function(zhece.php chuli.php)
1.zhece.php
<!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title></title> </head> <form method="post" action="chuli.php"> <p style="margin:10px 500px"> <h2 > 注册页面</h2> <p>用户名:<input type="text" name="users"/></p><br /> <p>密码:<input type="text" name="pwd"/></p><br /> <p>姓名:<input type="text" name="name"/></p><br /> <p>性别:<input type="text" name="sex"/></p><br /> <p>生日:<input type="text" name="birthday"/></p><br /> <input type="submit" value="注册" /> <a href="denglu.php" rel="external nofollow" >已有账号,立即登录</a> </p> </form> <body> </body> </html>
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"); } ?>
2. Login function(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"> <p style="margin:100px 500px"> <h2 > 登录页面</h2> <p>用户名:<input type="text" name="users"/></p><br /> <p>密码:<input type="text" name="pwd"/></p><br /> <input type="submit" value="登录" /> <a href="zhuce.php" rel="external nofollow" >没有账号,立即注册</a> </p> </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 "用户名或密码错误!"; } ?>
3. Administrator’s audit function(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 require"DBDA.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");
<?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");
The above is the detailed content of Introduction to php registration audit function. For more information, please follow other related articles on the PHP Chinese website!