简单请求分发器的注册与退出登录

  • 1.建立数据库配置文件database.php
  1. <?php
  2. return [
  3.     'type' => $type ?? 'mysql',
  4.     'username' => $username ?? 'root',
  5.     'password' => $password ?? '',
  6.     'host' => $host ?? 'localhost',
  7.     'port' => $port ?? '3306',
  8.     'charset' => $charset ?? 'utf8',
  9.     'dbname' => 'user'
  10. ];
  • 2.建立connet.php连接数据库
  1. // 1. 把数据库连接配置文件引过来
  2. $config = require_once __DIR__ . DIRECTORY_SEPARATOR . 'config' . DIRECTORY_SEPARATOR . 'database.php';
  3. extract($config);
  5. // 2. 数据库的连接
  7. $dsn = sprintf('%s:host=%s;port=%s;charset=%s;dbname=%s', $type, $host, $port, $charset, $dbname);
  8. try {
  9.     $pdo = new PDO($dsn, $username, $password);
  10.     // var_dump($pdo);
  11. } catch (PDOException $e) {
  12.     die('Connection error : ' . $e->getMessage());
  13. }
  • 3.建立,dosubmit.php对前端请求,进行分发处理。
  1. <?php
  2. // 控制器文件
  3. require 'common.php';
  5. // 后端可接受前端传过来的参数
  6. $name = isset($_POST['uname']) ? $_POST['uname'] : null;
  7. $pwd = isset($_POST['pwd']) ? $_POST['pwd'] : null;
  8. $type = strtolower($_GET['type']);
  9. var_dump($name, $pwd, $type);
  11. // 请求分发器  注册 登录 退出登录
  12. switch ($type) {
  13.     case 'login':
  14.         $res = checkName($name, $pwd);
  16.         if ($res) {
  17.             echo json_encode(['status' => 1, 'msg' => '登录成功'], 320);
  18.             exit;
  19.         }
  20.         echo json_encode(['status' => 0, 'msg' => '用户名或密码错误'], 320);
  21.         break;
  22.     case 'logout':
  23.         echo json_encode(['status' => 0, 'msg' => '退出登录'], 320);
  24.         header("location:./2-login.php");
  25.         session_destroy();
  26.         break;
  28.     case 'reg':
  29.         $res = regusername($name, $pwd);
  30.         if ($res) {
  31.             echo json_encode(['status' => 1, 'msg' => '注册成功'], 320);
  32.             exit;
  33.         }
  34.         echo json_encode(['status' => 0, 'msg' => '注册失败'], 320);
  35.         break;
  42.         //     // 插入
  44.         // case :'logout':
  46. }
  • 4.建立common.php文件，定义处理函数 
  1. <?php
  2. session_start();
  3. // 模型文件 model
  4. //连接数据库
  5. require '1-connect.php';
  7. function checkName($name, $pwd)
  8. {
  9.     $sql = "SELECT `username`,`password` FROM `user` WHERE `username` = ? AND `password` = ? ";
  10.     // prepare准备阶段
  11.     global $pdo;
  13.     $stmt = $pdo->prepare($sql);
  14.     $res = $stmt->execute([$name, $pwd]);
  15.     if ($res) {
  16.         $res = $stmt->fetch(PDO::FETCH_ASSOC);
  17.         // 验证通过
  18.         if ($res) {
  19.             $_SESSION['username'] = $res['username'];
  20.             return true;
  21.         } else {
  22.             return false;
  23.         }
  24.     }
  25. }
  28. function regusername($name, $pwd)
  29. {
  31.     $sql = "SELECT `username`,`password` FROM `user` WHERE `username` = ?";
  32.     $sql_reg="INSERT INTO 'user'('username','password') VALUES (?,?)";
  38.     global $pdo;
  39.     $stmt = $pdo->prepare($sql);
  43.     $res = $stmt->execute([$name]);
  45.     if ($res) {
  48.         $res = $stmt->fetch(PDO::FETCH_ASSOC);
  50.         if ($res) {
  51.           //已存在用户 返回注册失败
  52.             return false;
  53.         } else {
  55.             $stmt = $pdo->prepare($sql_reg);
  57.             $stmt->debugDumpParams($sql_reg);
  59.             $res = $stmt->execute([$name,$pwd]);
  61.             if ($res) {
  63.                 $res = $stmt->fetch(PDO::FETCH_ASSOC);
  64.                 if ($res) {
  66.                     return true;
  67.                 }
  68.                 else
  69.                 {
  70.                     var_dump("注册失败1");
  71.                     return false;
  72.                 }
  74.             }
  75.             var_dump("注册失败2");
  76.             return false;
  77.         }
  79.     }
  81. }