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>
<?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>
<?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");
PDO in PHPData accessAbstraction layer
About PDOData AccessIntroduction to the functional operations of the abstraction layer in PHP
About PDOData Access## in PHP #Operation of abstraction layer
The above is the detailed content of Analysis of key points in PHP registration review-detailed explanation of data access. For more information, please follow other related articles on the PHP Chinese website!