简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > List of blog posts > PHP网页的登录与注册示例
Blogger Information
Blog 17
fans 1
comment 0
visits 20046
Special Recommendation
More>
Related recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
PHP网页的登录与注册示例
大A
Original
2242 people have browsed it

示例介绍

一个简单的注册登录验证页面
用户名,邮箱,电话是不可重复注册的

源码

数据库操作与验证部分

db.php

  1. <?php
  2. /*
  3.  * 创建sql表
  4.  * CREATE TABLE `usertab` (
  5.   `id` int(3) NOT NULL AUTO_INCREMENT COMMENT '主键',
  6.   `name` varchar(30) CHARACTER SET utf8 NOT NULL COMMENT '用户名',
  7.   `password` varchar(40) CHARACTER SET utf8 NOT NULL COMMENT '密码',
  8.   `email` varchar(30) CHARACTER SET utf8 NOT NULL COMMENT '邮箱',
  9.   `tel` varchar(30) CHARACTER SET utf8 NOT NULL COMMENT '电话',
  10.   `time` int(10) unsigned NOT NULL COMMENT '注册时间',
  11.   UNIQUE KEY (`name`),
  12.   UNIQUE KEY (`email`),
  13.   UNIQUE KEY (`tel`),
  14.   PRIMARY KEY (`id`))
  15.  */
  16. /*
  17.  * @Author: 数据库类
  18.  * @Date: 2020-05-08 14:04:42
  19.  * @LastEditTime: 2020-05-09 18:04:54
  20.  * @LastEditors: Please set LastEditors
  21.  * @Description: In User Settings Edit
  22.  * @FilePath: \test\db.php
  23.  */
  24. class Darabase
  25. {
  26.     private $config =
  27.     [
  28.         'host' => 'mysql:host=localhost;dbname=phpedu;',
  29.         'username' => 'root',
  30.         'password' => 'root'
  31.     ];
  33.     private $pdo_obj;
  35.     public function __construct()
  36.     {
  37.         $this->pdo_obj = new PDO(
  38.             $this->config['host'],
  39.             $this->config['username'],
  40.             $this->config['password'],
  41.         );
  42.     }
  44.     /**
  45.      * 注册新用户,成功返回true,失败返回false
  46.      *
  47.      * @param [type] $name 用户名
  48.      * @param [type] $pass  密码
  49.      * @param [type] $email 邮箱
  50.      * @param [type] $tel   电话
  51.      * @param [type] $time  注册时间
  52.      * @return bool
  53.      * 
  54.      */
  55.     public function reguser($name, $pass, $email, $tel, $time)
  56.     {
  57.         $pass = sha1($pass);
  58.         $sql = "INSERT `usertab` SET 
  59.         `name`='$name',
  60.         `password`='$pass',
  61.         email='$email',
  62.         tel='$tel',
  63.         `time`=$time";
  64.         $obj = $this->pdo_obj->prepare($sql);
  65.         $obj->execute();
  66.         if ($obj->rowCount() > 0) :
  67.             return true;
  68.         else :
  69.             return false;
  70.         endif;
  71.     }
  72.     /**
  73.      * 数据库查询,返回查询的结果或false
  74.      *
  75.      * @param [string] $result 要求返回的查询结果
  76.      * @param [string] $field  要查询的字段
  77.      * @param [string] $value  查询的字段的值
  78.      * @return mixed
  79.      */
  80.     public function search($result, $field, $value)
  81.     {
  82.         $sql = "SELECT `$result` FROM `usertab` WHERE `$field`='$value'";
  83.         $obj = $this->pdo_obj->prepare($sql);
  84.         $obj->execute();
  85.         $result = $obj->fetch()[0];
  86.         return $result ? $result : false;
  87.     }
  90.     /**
  91.      * 查询用户是否存在,存在返回true,不存在返回false
  92.      *
  93.      * @param [string] $name 用户名
  94.      * @param [string] $pass 用于接收密码的变量
  95.      * @return bool
  96.      */
  97.     public function searchName($name, &$pass = null)
  98.     {
  99.         $pass = $this->search('password', 'name', $name);
  100.         var_dump($pass);
  101.         return $pass ? true : false;
  102.     }
  104.     /**
  105.      * 登录验证,成功返回true,失败返回false
  106.      *
  107.      * @param [string] $name 用户名
  108.      * @param [string] $pass 密码
  109.      * @return bool
  110.      */
  111.     public function login($name, $pass)
  112.     {
  113.         $pass = sha1($pass);
  114.         return $this->searchName($name, $rpass) ?
  115.             $pass === $rpass ? true : false
  116.             :
  117.             false;
  118.     }
  119. }

handle.php

  1. <?php
  2. require('db.php');
  3. $action = filter_input(INPUT_GET, 'action');
  4. if ($action === null) die('参数非法');
  5. //var_dump($_POST, $action);
  7. switch ($action) {
  8.     case 'reg':
  9.         if (!$_POST) die('参数非法');
  10.         $data = new Darabase();
  11.         if ($data->search('name', 'name', $_POST['name'])) header('Location:reg.php?message=用户名已存在');
  12.         if ($data->search('email', 'email', $_POST['email'])) header('Location:reg.php?message=邮箱已注册');
  13.         if ($data->search('tel', 'tel', $_POST['tel'])) header('Location:reg.php?message=手机号已注册');
  14.         if ($data->reguser(
  15.             $_POST['name'],
  16.             $_POST['password'],
  17.             $_POST['email'],
  18.             $_POST['tel'],
  19.             (string) time()
  20.         )) :
  21.             echo '注册成功!<br><a href="login.php">>>>登录</a>';
  22.         else :
  23.             echo '注册失败';
  24.         endif;
  25.         break;
  26.     case 'login':
  27.         if (!$_POST) die('参数非法');
  28.         $data = new Darabase();
  29.         if ($data->login($_POST['name'], $_POST['password'])) :
  30.             session_start();
  31.             $pass = sha1($_POST['password']);
  32.             $_SESSION['name'] = $_POST['name'];
  33.             $_SESSION['password'] = $pass;
  34.             setcookie('name', $_POST['name'], (time() + 360 * 24));
  35.             setcookie('pass', $pass, (time() + 360 * 24));
  36.             header('location:index.php');
  37.         else :
  38.             header('Location:login.php?message=账号或密码错误');
  39.         endif;
  41.         break;
  42.     case 'out':
  43.         session_start();
  44.         session_destroy();
  45.         setcookie('name', null, 0);
  46.         header('location:index.php');
  47.         break;
  48.     default:
  49.         echo '参数非法';
  50.         break;
  51. }

HTML部分

index.php

  1. <?php
  2. if ($_COOKIE['name'])
  3.     session_start();
  4. ?>
  5. <!DOCTYPE html>
  6. <html lang="en">
  8. <head>
  9.     <meta charset="UTF-8">
  10.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  11.     <link rel="stylesheet" href="index.css">
  12.     <title>首页</title>
  13. </head>
  15. <body>
  16.     <section>
  17.         <ul class="nav black">
  18.             <li><a href="">主页</a></li>
  19.             <li><a href=""></a></li>
  20.             <li><a href=""></a></li>
  21.             <li><a href=""></a></li>
  22.             <li><a href=""></a></li>
  23.             <?php if (
  24.                 $_COOKIE['name'] . $_COOKIE['pass'] === $_SESSION['name'] . $_SESSION['password']
  25.                 && $_COOKIE['name']
  26.             ) : ?>
  27.                 <li><a href="handle.php?action=out">退出</a></li>
  28.             <? else : ?>
  29.                 <li><a href="login.php">登录</a></li>
  30.             <? endif; ?>
  31.         </ul>
  32.     </section>
  34. </body>
  36. </html>

login.php

  1. <?php $mess = filter_input(INPUT_GET, 'message'); ?>
  2. <!DOCTYPE html>
  3. <html lang="en">
  5. <head>
  6.     <meta charset="UTF-8">
  7.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  8.     <link rel="stylesheet" href="style.css">
  9.     <title>首页</title>
  10. </head>
  12. <body>
  13.     <div class='login'>
  14.         <h2 style='text-align: center;padding-top:20px'>用户登录</h3>
  15.             <form action="handle.php?action=login" method="post">
  16.                 <div>
  17.                     <label for="input_name" class=lab>用户名:</label>
  18.                     <input type="text" name="name" id="input_name">
  19.                 </div>
  20.                 <div>
  21.                     <label for="input_pass" class=lab>密码:</label>
  22.                     <input type="password" name="password" id="input_pass">
  23.                 </div>
  25.                 <div>
  26.                     <input type="submit" value="登录" id=sub>
  27.                 </div>
  28.                 <div>
  29.                     <?php echo "<font style='color:#FF0000;'>" . $mess . '</font>'; ?> <a style='padding-left: 30%;' href="reg.php">注册>>></a>
  30.                 </div>
  31.             </form>
  32.     </div>
  33. </body>
  35. </html>

reg.php

  1. <!DOCTYPE html>
  2. <html lang="en">
  4. <head>
  5.     <meta charset="UTF-8">
  6.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  7.     <link rel="stylesheet" href="style.css">
  8.     <title>首页</title>
  9. </head>
  11. <body>
  12.     <?php $mess = filter_input(INPUT_GET, 'message'); ?>
  13.     <div class='login' style='height:460px;'>
  14.         <h2 style='text-align: center;padding-top:20px'>用户注册</h2>
  18.         <form action="handle.php?action=reg" method="post">
  19.             <div>
  20.                 <label for="input_name" class=lab>用户名:</label>
  21.                 <input type="text" name="name" id="input_name">
  22.             </div>
  23.             <div>
  24.                 <label for="input_pass" class=lab>密码:</label>
  25.                 <input type="password" name="password" id="input_pass">
  26.             </div>
  27.             <div>
  28.                 <label for="input_pass1" class=lab>重复密码:</label>
  29.                 <input type="password" name="" id="input_pass1">
  30.             </div>
  31.             <div>
  32.                 <label for="input_email" class=lab>邮箱:</label>
  33.                 <input type="email" name="email" id="input_email">
  34.             </div>
  35.             <div>
  36.                 <label for="input_tel" class=lab>手机号:</label>
  37.                 <input type="text" name="tel" id="input_tel">
  38.             </div>
  39.             <div>
  40.                 <input type="submit" value="注册" id=sub>
  41.             </div>
  44.         </form>
  45.         <?php echo "<h4 style='text-align:center;color:#FF0000;'>" . $mess . '</h4>'; ?>
  46.     </div>
  47. </body>
  49. </html>

css样式部分

index.css

  1. * {
  2.     margin         : 0;
  3.     padding        : 0;
  4.     list-style-type: none;
  5. }
  7. .nav a {
  8.     display           : inline-block;
  9.     -webkit-transition: all 0.2s ease-in;
  10.     -moz-transition   : all 0.2s ease-in;
  11.     -o-transition     : all 0.2s ease-in;
  12.     -ms-transition    : all 0.2s ease-in;
  13.     transition        : all 0.2s ease-in;
  14. }
  16. .black {
  17.     background: #2c2c2c;
  18.     box-shadow: 0 7px 0 #0b0b0b;
  19. }
  21. .black li::before {
  22.     left      : 0;
  23.     background: -moz-linear-gradient(top, #2c2c2c, #000 50%, #2c2c2c);
  24.     background: -webkit-linear-gradient(top, #2c2c2c, #000 50%, #2c2c2c);
  25.     background: -o-linear-gradient(top, #2c2c2c, #000 50%, #2c2c2c);
  26.     background: -ms-linear-gradient(top, #2c2c2c, #000 50%, #2c2c2c);
  27.     background: linear-gradient(top, #2c2c2c, #000 50%, #2c2c2c);
  28. }
  30. body {
  31.     background: #ebebeb;
  32. }
  34. .nav {
  35.     width        : 100%;
  36.     height       : 50px;
  37.     font         : bold 0/50px Arial;
  38.     text-align   : center;
  39.     margin       : 40px auto 0;
  40.     border-radius: 8px;
  41. }
  43. .nav a:hover {
  44.     -webkit-transform: rotate(10deg);
  45.     -moz-transform   : rotate(10deg);
  46.     -o-transform     : rotate(10deg);
  47.     -ms-transform    : rotate(10deg);
  48.     transform        : rotate(10deg);
  49. }
  51. .nav li {
  52.     position   : relative;
  53.     display    : inline-block;
  54.     padding    : 0 16px;
  55.     font-size  : 13px;
  56.     text-shadow: 1px 2px 4px rgba(0, 0, 0, .5);
  57.     list-style : none outside none;
  58. }
  60. .nav a,
  61. .nav a:hover {
  62.     color          : #fff;
  63.     text-decoration: none;
  64. }

style.css

  1. div.login {
  2.     margin          : auto;
  3.     background-color: cornflowerblue;
  4.     height          : 310px;
  5.     width           : 300px;
  6.     line-height     : 50px;
  7.     position        : relative;
  8. }
  10. label.lab {
  11.     padding-inline-start: 25px;
  12.     display             : block;
  13.     width               : 70px;
  14.     display             : inline-block;
  16. }
  18. #sub {
  19.     background-color: honeydew;
  20.     height          : 30px;
  21.     width           : 250px;
  22.     margin          : auto;
  23.     display         : block;
  24.     margin-top      : 30px;
  27. }

源码下载

https://www.90pan.com/b1872334

Correcting teacher：天蓬老师天蓬老师

Correction status：qualified

Teacher's comments：规范的做法, 应该是将数据库连接参数通过构造方法传入, 试试看
Statement of this Website
The copyright of this blog article belongs to the blogger. Please specify the address when reprinting! If there is any infringement or violation of the law, please contact admin@php.cn Report processing!
All comments Speak rationally on civilized internet, please comply with News Comment Service Agreement
0 comments
Author's latest blog post
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！