亚洲国产日韩欧美一区二区三区,精品亚洲国产成人av在线,国产99视频精品免视看7,99国产精品久久久久久久成人热,欧美日韩亚洲国产综合乱

搜索
博主信息
博文 47
粉絲 3
評論 0
訪問量 49461
最新下載
更多>
網站特效
網站源碼
網站素材
前端模板
用戶管理加登錄驗證、注冊、管理權限
吳
原創(chuàng)
3494人瀏覽過
  • 注冊新用戶

  • 登錄跳轉

  • 普通用戶無編輯刪除權限

1.前端渲染頁：index.php

  1. <?php
  2. session_start();
  3. ?>
  4. <!DOCTYPE html>
  5. <html lang="en">
  7. <head>
  8.     <meta charset="UTF-8">
  9.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
  10.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  11.     <title>用戶管理系統</title>
  12.     <link rel="stylesheet" href="style.css">
  13.     <style>
  14.         header {
  15.             display: flex;
  16.             background-color: #333;
  17.             padding: 0.5em 1em;
  18.             width: 100%;
  19.         }
  21.         a {
  22.             color: #bbb;
  23.             text-decoration: none;
  24.         }
  26.         a:hover {
  27.             color: white;
  28.         }
  30.         header nav {
  31.             margin-left: auto;
  32.         }
  33.     </style>
  34. </head>
  36. <body>
  37.     <header>
  38.         <a href="#">首頁</a>
  39.         <nav>
  40.             <?php if (!isset($_SESSION['email'])) : ?>
  41.                 <script>
  42.                     alert('請登錄后再操作!');
  43.                     location.href = "login.php";
  44.                 </script>
  45.             <?php else : ?>
  46.                 <a href="#" class="ses"><?= $_SESSION['email'] ?></a>
  47.                 <a href="handle.php?action=logout">退出</a>
  48.             <?php endif ?>
  49.         </nav>
  50.     </header>
  52.     <table>
  53.         <caption>用戶管理 <span class="tips" style="color:red;font-size:10px;"></span></caption>
  55.         <thead>
  56.             <tr>
  57.                 <td>UID</td>
  58.                 <td>用戶名</td>
  59.                 <td>郵箱</td>
  60.                 <td>注冊時間</td>
  61.                 <?php if ($_SESSION['email'] === 'guest1@php.cn') : ?>
  62.                 <td>操作</td>
  63.                 <? endif ?>
  64.             </tr>
  65.         </thead>
  66.         <!-- 列表渲染 -->
  67.         <tbody></tbody>
  68.     </table>
  69.     <!-- 分頁渲染 -->
  70.     <p></p>
  72.     <!-- 模態(tài)框編輯 -->
  73.     <div class="md">
  74.         <div class="md-drop"></div>
  75.         <div class="md-body">
  76.             <button class="close">關閉</button>
  77.             <form action="" name="editform">
  78.                 <h2>編輯用戶</h2>
  79.                 <div class="md-login">
  80.                     <label for="name">姓名：</label>
  81.                     <input type="text" name="name" id="name" value="">
  82.                     <label for="email">郵箱：</label>
  83.                     <input type="email" name="email" id="email" value="">
  84.                     <button class="save">保存</button>
  85.                 </div>
  86.             </form>
  87.         </div>
  88.     </div>
  89.     <!-- 模態(tài)框樣式 -->
  90.     <style>
  91.         /* 模態(tài)框初始化隱藏 */
  92.         .md {
  93.             display: none;
  94.         }
  96.         /* 遮罩層 */
  97.         .md .md-drop {
  98.             position: fixed;
  99.             background-color: rgb(0, 0, 0, .5);
  100.             top: 0;
  101.             left: 0;
  102.             right: 0;
  103.             bottom: 0;
  104.         }
  106.         .md .md-body {
  107.             position: fixed;
  108.             background-color: lightcyan;
  109.             padding: 1em;
  110.             overflow: hidden;
  111.             max-width: 25em;
  112.             max-height: 20em;
  113.             /* 水平垂直居中 */
  114.             top: 0;
  115.             left: 0;
  116.             right: 0;
  117.             bottom: 0;
  118.             margin: auto;
  119.             border-radius: 10px;
  120.         }
  122.         /* 關閉按鈕 */
  123.         .md .md-body .close {
  124.             float: right;
  125.             height: 2.5em;
  126.             width: 3em;
  127.             border: 0;
  128.             border-radius: 0.5em;
  129.             outline: none;
  130.             background-color: rgb(1, 231, 135);
  131.         }
  133.         .md .md-login {
  134.             display: grid;
  135.             gap: 1em;
  136.             margin-top: 20px;
  137.         }
  138.     </style>
  139.     <script src="ajax.js"></script>
  140. </body>
  142. </html>

2. 登錄頁：login.php

  1. <?php
  2. session_start();
  3. if(isset($_SESSION['email'])) {
  4.     echo '<script>alert("請不要重復登錄");location.href="index.php";</script>';
  5. }
  6. ?>
  7. <!DOCTYPE html>
  8. <html lang="en">
  9. <head>
  10.     <meta charset="UTF-8">
  11.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
  12.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  13.     <title>登錄</title>
  14.     <style>
  15.         form {
  16.             display: grid;
  17.             gap: .5em;
  18.             width: 15em;
  19.             margin: 2em auto;
  20.             border: 1px solid #eee;
  21.             padding: 1em 2em;
  22.             background-color: lightskyblue;
  23.             border-radius: 0.5em;
  24.         }
  25.     </style>
  26. </head>
  27. <body>
  28.     <form name="login">
  29.         <span>用戶登錄</span>
  30.         <input type="email" name="email" placeholder="請輸入登錄郵箱">
  31.         <input type="password" name="password" placeholder="請輸入登錄密碼">
  32.         <!-- 此處給button類型防止默認提交 -->
  33.         <button type="button" name="submit">立即登錄</button>
  34.         <button type="button" name="registers">新用戶注冊</button>
  35.         <span class="tips"></span>
  36.     </form>
  38.     <script>
  39.         const form = document.forms.login;
  40.         const email = form.email;
  41.         const psw = form.password;
  42.         const submitBtn = form.submit;
  43.         const xhr = new XMLHttpRequest;
  44.         const tips = document.querySelector('.tips');
  45.         const regis = form.registers;
  47.         regis.onclick = (ev) => {
  48.             location.href = 'register.php';
  49.         }
  51.         submitBtn.onclick = (ev) => {
  52.             // 非空判斷
  53.             if (email.value.trim().length > 0 && psw.value.trim().length >0) {
  54.                 // 請求參數
  55.                 xhr.open('post','handle.php?action=login');
  56.                 // 響應類型
  57.                 // 設置類型為json，返回結果自動解析為js對象
  58.                 xhr.responseType = 'json';
  59.                 // 成功回調
  60.                 xhr.onload = () => {
  61.                     console.log(xhr.response);
  62.                     tips.innerHTML = xhr.response.msg;
  63.                     if (xhr.response.status === 1 ) {
  64.                         // 登錄成功進入用戶管理頁
  65.                         setTimeout(() => location.href = 'index.php',3000);
  66.                     }
  67.                 }
  68.                 // 失敗回調
  69.                 xhr.onerror = () => console.log('error!');
  70.                 // 發(fā)送請求
  71.                 xhr.send(new FormData(form));
  72.             } else {
  73.                 tips.innerHTML = '賬戶信息不能為空！';
  74.                 email.focus();
  75.             }
  76.         }
  77.         // 清空提示
  78.         [email,psw].forEach((item)=>item.oninput = () => tips.innerHTML = null);
  79.     </script>
  80. </body>
  81. </html>

3. 注冊頁：register.php

  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
  6.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  7.     <title>新用戶注冊</title>
  8.     <style>
  9.         form {
  10.             display: grid;
  11.             gap: .5em;
  12.             width: 15em;
  13.             margin: 2em auto;
  14.             border: 1px solid #eee;
  15.             padding: 1em 2em;
  16.             background-color: lightskyblue;
  17.             border-radius: 0.5em;
  18.         }
  19.     </style>
  20. </head>
  21. <body>
  22.     <form name="register">
  23.         <span>新用戶注冊</span>
  24.         <input type="text" name="name" placeholder="請輸入用戶名">
  25.         <input type="email" name="email" placeholder="請輸入登錄郵箱">
  26.         <input type="password" name="password1" placeholder="請輸入登錄密碼">
  27.         <input type="password" name="password2" placeholder="確認登錄密碼">
  28.         <!-- 此處給button類型防止默認提交 -->
  29.         <button type="button" name="submit">立即注冊</button>
  30.         <span class="tips"></span>
  31.     </form>
  33.     <script>
  34.         const form = document.forms.register;
  35.         const name = form.name;
  36.         const email = form.email;
  37.         const psw1 = form.password1;
  38.         const psw2 = form.password2;
  39.         const submitBtn = form.submit;
  40.         const xhr = new XMLHttpRequest;
  41.         const tips = document.querySelector('.tips');
  43.         submitBtn.onclick = (ev) => {
  44.             // 非空判斷
  45.             if (name.value.trim().length > 0 && email.value.trim().length > 0 && psw1.value.trim().length >0) {
  47.                 if (psw1.value !== psw2.value) {
  48.                     tips.innerHTML = '確認密碼輸入不一致!';
  49.                     psw1.focus();
  50.                 } else {
  51.                 // 請求參數
  52.                 xhr.open('post','handle.php?action=register');
  53.                 // 響應類型
  54.                 // 設置類型為json，返回結果自動解析為js對象
  55.                 xhr.responseType = 'json';
  56.                 // 成功回調
  57.                 xhr.onload = () => {
  58.                     console.log(xhr.response);
  59.                     tips.innerHTML = xhr.response.msg;
  60.                     if (xhr.response.status === 1 ) {
  61.                         // 注冊成功進入用戶管理頁
  62.                         setTimeout(() => location.href = 'index.php',3000);
  63.                     }
  64.                 }
  65.                 // 失敗回調
  66.                 xhr.onerror = () => console.log('error!');
  67.                 // 確認密碼不需要發(fā)送
  68.                 const data = new FormData(form);
  69.                 data.delete('password2');
  70.                 // 發(fā)送請求
  71.                 xhr.send(data);
  72.                 }
  74.             } else {
  75.                 tips.innerHTML = '賬戶信息不能為空！';
  76.                 name.focus();
  77.             }
  78.         }
  79.         // 清空提示
  80.         [name,email,psw1,psw2].forEach((item)=>item.oninput = () => tips.innerHTML = null);
  81.     </script>
  82. </body>
  83. </html>

4. css樣式表：style.css

  1. * {
  2.   margin: 0;
  3.   padding: 0;
  4.   box-sizing: border-box;
  5.   color: #555;
  6. }
  8. body {
  9.   display: flex;
  10.   flex-direction: column;
  11.   align-items: center;
  12. }
  14. /*表格樣式*/
  15. table {
  16.   width: 90%;
  17.   border: 1px solid;
  18.   border-collapse: collapse;
  19.   text-align: center;
  20. }
  22. table caption {
  23.   font-size: 1.2rem;
  24.   margin: 10px;
  25. }
  26. table td,
  27. table th {
  28.   border: 1px solid;
  29.   padding: 5px;
  30. }
  32. table tr:hover {
  33.   background-color: #eee;
  34. }
  36. table thead tr:only-of-type {
  37.   background-color: lightcyan;
  38. }
  40. table button {
  41.   width: 56px;
  42.   height: 26px;
  43. }
  44. table button:last-of-type {
  45.   color: red;
  46. }
  47. table button {
  48.   cursor: pointer;
  49.   margin: 0 3px;
  50. }
  51. /*分頁條樣式*/
  52. body > p {
  53.   display: flex;
  54. }
  56. p > a {
  57.   text-decoration: none;
  58.   color: #555;
  59.   border: 1px solid #888;
  60.   padding: 5px 10px;
  61.   margin: 10px 2px;
  62. }
  64. .active {
  65.   background-color: seagreen;
  66.   color: white;
  67.   border: 1px solid seagreen;
  68. }

5. js文件：ajax.js

  1. // 頁面載入完成時渲染第一頁數據
  2. window.onload = function () {
  3.     select(1);
  4. };
  7. // 編輯
  8. document.querySelector('table:first-of-type tbody').addEventListener('click' , ev => {
  9.     // 獲取記錄id
  10.     const sid = ev.target.parentNode.parentNode.querySelector('td').textContent * 1;
  11.     const tips = document.querySelector('.tips');
  12.     // 操作類型
  13.     switch (ev.target.textContent) {
  14.         case '編輯':
  15.             // 顯示模態(tài)框
  16.             document.querySelector('.md').style.display = 'block';
  17.             // 點擊關閉按鈕
  18.             document.querySelector('.md .close').addEventListener('click',(eve) => {
  19.                 document.querySelector('.md').style.display = 'none';
  20.             });
  21.             // 點擊模態(tài)框之外區(qū)域
  22.             document.querySelector('.md .md-drop').addEventListener('click',(eve) => {
  23.                 document.querySelector('.md').style.display = 'none';
  24.             });
  26.             // 獲取數據
  27.             let name = ev.target.parentNode.parentNode.querySelector('td:nth-of-type(2)').textContent;
  28.             let email = ev.target.parentNode.parentNode.querySelector('td:nth-of-type(3)').textContent;
  30.             // 渲染到模態(tài)框
  31.             document.getElementById('name').value = name;
  32.             document.getElementById('email').value = email;
  34.             // 編輯事件
  35.             document.querySelector('.md .save').addEventListener('click',(eve) => {
  36.                 // 禁止默認提交
  37.                 eve.preventDefault();
  38.                 // 獲取模態(tài)框數據
  39.                 name = document.getElementById('name').value;
  40.                 email = document.getElementById('email').value;
  42.                 // 創(chuàng)建對象
  43.                 let xhr = new XMLHttpRequest();
  44.                 // 配置參數
  45.                 xhr.open('post','api.php?action=update&sid=' + sid);
  46.                 xhr.responseType = 'json';
  47.                 // 處理請求
  48.                 xhr.onload = () => {
  49.                     // 更新數據寫會頁面
  50.                     tips.innerHTML = xhr.response.msg;
  51.                     if (xhr.response.status === 1 ) {
  52.                         document.querySelector('.md').style.display = 'none';
  53.                         ev.target.parentNode.parentNode.querySelector('td:nth-of-type(2)').textContent = name;
  54.                         ev.target.parentNode.parentNode.querySelector('td:nth-of-type(3)').textContent = email;
  55.                         setTimeout(() => tips.innerHTML = null,2000);
  56.                     }
  57.                 };
  58.                 xhr.send(new FormData(document.forms.namedItem('editform')));
  59.             });
  60.             break;
  61.         case '刪除':
  62.             if (confirm('確認刪除UID：' + sid + '用戶？')) {
  63.                 // 創(chuàng)建對象
  64.                 let xhr = new XMLHttpRequest();
  65.                 // 配置參數
  66.                 xhr.open('get','api.php?action=delete&sid=' + sid);
  67.                 xhr.responseType = 'json';
  68.                 // 處理請求
  69.                 xhr.onload = () => {
  70.                     tips.innerHTML = xhr.response.msg;
  71.                     if (xhr.response.status === 1) {
  72.                     // 刪除節(jié)點
  73.                     ev.target.parentNode.parentNode.remove();
  74.                     setTimeout(() => tips.innerHTML = null,2000);
  75.                     }
  77.                 };
  78.                 // 發(fā)送請求
  79.                 xhr.send(null);
  80.             }
  81.             break;
  82.    }
  83. })
  85. function select(page = 1) {
  86.     // 創(chuàng)建對象
  87.     const xhr = new XMLHttpRequest();
  88.     // 配置參數
  89.     xhr.open('get', 'api.php?action=select&page=' + page);
  90.     // 處理請求
  91.     xhr.onload = () => {
  92.         // console.log(xhr.response);
  93.         let res = JSON.parse(xhr.response);
  94.         let pages = res.pages;
  95.         let users = res.users;
  96.         // 渲染數據
  97.         document.querySelector('table:first-of-type tbody').innerHTML = get_datas(users);
  98.         // 渲染分頁
  99.         document.querySelector('p:first-of-type').innerHTML = pags(page,pages);
  100.     }
  101.     // 發(fā)送請求
  102.     xhr.send(null);
  103. }
  105. // 渲染數據
  106. function get_datas(datas) {
  107.     const ses = document.querySelector('.ses').innerText;
  108.     let str = '';
  109.     for (let i = 0; i < datas.length; i++) {
  110.         str += '<tr>';
  111.         str += '<td>' + datas[i]['sid'] + '</td>';
  112.         str += '<td>' + datas[i]['name'] + '</td>';
  113.         str += '<td>' + datas[i]['email'] + '</td>';
  114.         str += '<td>' + datas[i]['create_at'] + '</td>';
  115.         if (ses=== 'guest1@php.cn') {
  116.             str += '<td><button>編輯</button><button>刪除</button></td>';
  117.         }
  118.         str += '</tr>';
  119.     }
  120.     return str;
  121. }
  123. // 無刷新分頁
  124. document.querySelector('p:first-of-type').addEventListener('click',ev => {
  125.     // 禁用默認跳轉
  126.     ev.preventDefault();
  127.     // 點擊當前激活頁，無效點擊
  128.     if (ev.target.classList.contains('active')) return;
  129.     // 去掉激活樣式
  130.     [...ev.currentTarget.children].forEach(ele => ele.classList.remove('active'));
  131.     // 當前頁添加激活樣式
  132.     ev.target.classList.add('active');
  133.     let url = ev.target.href,page;
  134.     // 獲取頁碼
  135.     if (url.indexOf('?') !== -1) {
  136.         page = url.split('=')[1];
  137.     } else {
  138.         page = 1;
  139.     }
  140.     select(page);
  141. })
  145. // 分頁數據
  146. function pags (page = 1,pages) {
  147.     let pag = '';
  148.     let active = '';
  149.     // 首頁和上一頁
  150.     if (page <= 1) page =1;
  151.     if (page != 1) {
  152.         pag += '<a href="'+ document.URL + '?p=1">首頁</a>';
  153.         pag += '<a href="'+ document.URL + '?p=' + Math.max(1,page - 1) +'">上一頁</a>';
  154.     }
  155.     // 高亮分頁
  156.     for (i = 1; i <= pages; i++ ) {
  157.         active = '';
  158.         if (page == i) active = 'class="active"';
  159.         pag += '<a href="' + document.URL + '?p=' + i + '"' + active + '>' + i + '</a>';
  160.     }
  162.     // 下一頁和尾頁
  163.     if (page >= pages) page = pages;
  164.     if (page !== pages) {
  165.         pag += '<a href="' + document.URL + '?p=' + Math.min(page + 1,pages) + '">下一頁</a>'
  166.         pag += '<a href="' + document.URL + '?p=' + pages +'">尾頁</a>'
  167.     }
  169.     return pag;
  170. }

6. 文件：api.php

  1. $config = [
  2.     'type' => 'mysql',
  3.     'host' => '127.0.0.1',
  4.     'dbname' => 'phpedu',
  5.     'username' => 'root',
  6.     'password' => '123456',
  7. ];
  8. extract($config);
  9. $dsn = sprintf('%s:host=%s;dbname=%s;',$type,$host,$dbname);
  10. try {
  11.     $pdo = new PDO($dsn,$username,$password);
  12.     // 設置結果集返回類型
  13.     $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE,PDO::FETCH_ASSOC);
  14.     // var_dump($pdo,'連接成功');
  15. } catch (PDOException $e){
  16.     die('連接失敗:'. $e->getMessage());
  17. }
  19. // 頁碼通過get請求
  20. $page = $_GET['page'] ?? 1;
  21. $action = $_GET['action'] ?? 'select';
  23. switch ($action) {
  24.     // 查詢
  25.     case 'select':
  26.         die(get_datas($pdo,$page));
  27.         break;
  28.     // 刪
  29.     case 'delete':
  30.         die(del_data($pdo,$_GET['sid'] ?? 0));
  31.         break;
  32.     // 更新
  33.     case 'update':
  34.         $sid = $_GET['sid'] ?? 0;
  35.         $name = $_POST['name'];
  36.         $email = $_POST['email'];
  37.         die(update_data($pdo,$sid,$name,$email));
  38.         break;
  40. }
  42. // 更新
  43. function update_data($pdo,$sid,$name,$email) {
  44.     if ($sid) {
  45.         $sql = "UPDATE users SET name=:name, email=:email WHERE sid = :sid;";
  46.         $stmt = $pdo->prepare($sql);
  47.         $stmt->bindParam(':sid',$sid,PDO::PARAM_INT);
  48.         $stmt->bindParam(':name',$name,PDO::PARAM_STR);
  49.         $stmt->bindParam(':email',$email,PDO::PARAM_STR);
  50.         $stmt->execute();
  51.         if($stmt->rowCount() > 0) {
  52.             return json_encode(['status' => 1,'msg' => '更新成功!']);
  53.         }
  54.     }
  55.     return json_encode(['status' => 0,'msg' => '未知錯誤!']);
  56. }
  58. // 刪除
  59. function del_data($pdo,$sid = 0) {
  60.     if ($sid) {
  61.         $sql = "DELETE FROM users WHERE sid = :sid;";
  62.         $stmt = $pdo->prepare($sql);
  63.         $stmt->bindParam(':sid',$sid,PDO::PARAM_INT);
  64.         $stmt->execute();
  65.         if ($stmt->rowCount() > 0) {
  66.             return json_encode(['status' => 1,'msg' => '刪除成功!']);
  67.         }
  68.     }
  69.     return json_encode(['status' => 0,'msg' => '未知錯誤!']);
  70. }
  72. // 獲取總頁數
  73. function get_pages($pdo,$page = 1,$num = 5) {
  74.     // 總頁數
  75.     $num = 5;
  76.     $offset = ($page - 1 ) * $num;
  77.     $sql = "SELECT CEIL(COUNT(1)/{$num}) total FROM users";
  78.     $pages = $pdo->query($sql)->fetch()['total'];
  79.     return $pages;
  80. }
  82. function get_datas($pdo,$page = 1, $num = 5) {
  83.     // 獲取總頁數
  84.     $pages = get_pages($pdo);
  85.     // 每頁顯示數據
  86.     $offset = ($page - 1) * $num;
  87.     $sql = "SELECT * FROM `users` LIMIT {$offset},{$num}";
  88.     $stmt = $pdo->prepare($sql);
  89.     $stmt->execute();
  90.     $users = $stmt->fetchAll();
  91.     $users = $pdo->query($sql)->fetchall();
  92.     return json_encode(['pages' => $pages, 'users' => $users]);
  93. }

7.登錄驗證：login.php

  2. // 開啟session會話
  3. session_start();
  5. // 白名單
  6. $allurls = [
  7.     'index.php',
  8.     'login.php',
  9.     'register.php',
  10.     'api.php'
  11. ];
  13. $requrl = basename($_SERVER['HTTP_REFERER']);
  14. if(!isset($_SERVER['HTTP_REFERER']) || !in_array($requrl,$allurls)) {
  15.     die('<script>alert("非法訪問");location.href="index.php";</script>');
  16. }
  18. // 連接數據庫
  19. $pdo = new PDO('mysql:dbname=phpedu','root','123456');
  20. $action = strtolower($_GET['action']);
  22. switch ($action) {
  23.     // 登錄
  24.     case 'login':
  25.         $sql = 'SELECT * FROM user WHERE email=:email AND password=md5(:password)';
  26.         $stmt = $pdo->prepare($sql);
  27.         if ($stmt->execute($_POST)) {
  28.             if ($stmt->fetch()) {
  29.                 // 登錄成功就將用戶信息寫入session
  30.                 $_SESSION['email'] = $_POST['email'];
  31.                 echo json_encode(['status' => 1, 'msg' => '登錄成功，3秒后跳轉...']);
  32.             } else {
  33.                 echo json_encode(['status' => 0, 'msg' => '賬號或密碼錯誤!']);
  34.             }
  35.         } else {
  36.             print_r($stmt->errorInfo());
  37.         }
  38.         break;
  39.     // 注冊
  40.     case 'register':
  41.         // 確保郵箱的唯一性，在后端做判斷，不依賴數據庫索引
  42.         // 獲取標中所有郵箱返回一個數組
  43.         $stmt = $pdo->prepare('SELECT email FROM user');
  44.         $stmt->bindColumn('email',$email);
  45.         $stmt->execute();
  46.         $emails = [];
  47.         while ($stmt->fetch(PDO::FETCH_BOUND)) {
  48.             $emails[] = $email;
  49.         }
  50.         // echo json_encode($emails);
  51.         if (in_array($_POST['email'], $emails)) {
  52.             echo json_encode(['status' => -1, 'msg' => '郵箱名已被占用請更換!']);
  53.         } else {
  54.             // 郵箱可用，執(zhí)行插入操作
  55.             $sql = 'INSERT user SET name=:name,email=:email,password=md5(:password1)';
  56.             $stmt = $pdo->prepare($sql);
  57.             if ($stmt->execute($_POST)) {
  58.                 if ($stmt->rowCount()==1) {
  59.                     // 實現注冊后自動登錄
  60.                     $_SESSION['email'] = $_POST['email'];
  61.                     echo json_encode(['status' => 1, 'msg' => '注冊成功,自動登錄中...']);
  62.                 } else {
  63.                     echo json_encode(['status' => 1, 'msg' => '注冊異常,請聯系管理員!']);
  64.                 }
  65.             } else {
  66.                 print_r($stmt->errorInfo());
  67.             }
  68.         }
  69.         break;
  70.     // 退出登錄
  71.     case 'logout':
  72.         // 1.清空session變量
  73.         session_unset();
  74.         // 2.刪除session文件
  75.         session_destroy();
  76.         echo '<script>alert("退出成功");location.href="index.php";</script>';
  77.         break;
  78.     default:
  79.     exit('非法操作');
  82. }
批改老師：天蓬老師天蓬老師

批改狀態(tài)：合格

老師批語：作業(yè)寫得這么好， 為什么不寫點總結，心得呢？這樣可幫到更多的人
本博文版權歸博主所有，轉載請注明地址！如有侵權、違法，請聯系admin@php.cn舉報處理！
全部評論 文明上網理性發(fā)言，請遵守新聞評論服務協議
0條評論
關于我們 免責申明 意見反饋 講師合作 廣告合作 最新更新
php中文網：公益在線php培訓，幫助PHP學習者快速成長！
關注服務號 技術交流群
PHP中文網訂閱號
每天精選資源文章推送
PHP中文網APP
隨時隨地碎片化學習
PHP中文網抖音號
發(fā)現有趣的

Copyright 2014-2025 http://ipnx.cn/ All Rights Reserved | php.cn | 湘ICP備2023035733號

    • 登錄PHP中文網，和優(yōu)秀的人一起學習！
    全站2000+教程免費學