{"id":50847,"date":"2025-08-10T12:45:34","date_gmt":"2025-08-10T04:45:34","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/50847.html"},"modified":"2025-08-10T12:45:34","modified_gmt":"2025-08-10T04:45:34","slug":"phpmysql-%e5%ae%9e%e6%88%98%ef%bc%9a%e4%bb%8e%e9%9b%b6%e6%90%ad%e5%bb%ba%e5%91%98%e5%b7%a5%e7%ae%a1%e7%90%86%e7%b3%bb%e7%bb%9f-crud-%e5%85%a8%e6%b5%81%e7%a8%8b%e8%af%a6%e8%a7%a3","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/50847.html","title":{"rendered":"PHP+MySQL \u5b9e\u6218\uff1a\u4ece\u96f6\u642d\u5efa\u5458\u5de5\u7ba1\u7406\u7cfb\u7edf CRUD \u5168\u6d41\u7a0b\u8be6\u89e3"},"content":{"rendered":"

PHP+MySQL \u5b9e\u6218：\u4ece\u96f6\u642d\u5efa\u5458\u5de5\u7ba1\u7406\u7cfb\u7edf CRUD \u5168\u6d41\u7a0b\u8be6\u89e3<\/h2>\n
\n

\u524d\u8a00<\/h3>\n

\u5728 Web \u5f00\u53d1\u9886\u57df，CRUD（\u521b\u5efa\u3001\u8bfb\u53d6\u3001\u66f4\u65b0\u3001\u5220\u9664）\u4f5c\u4e3a\u6570\u636e\u4ea4\u4e92\u7684\u6838\u5fc3\u64cd\u4f5c，\u662f\u6bcf\u4e2a\u5f00\u53d1\u8005\u5fc5\u987b\u638c\u63e1\u7684\u57fa\u7840\u6280\u80fd\u3002\u65e0\u8bba\u662f\u4f01\u4e1a\u7ea7\u5e94\u7528\u8fd8\u662f\u5c0f\u578b\u7ba1\u7406\u7cfb\u7edf，CRUD \u90fd\u662f\u6784\u5efa\u6570\u636e\u4ea4\u4e92\u529f\u80fd\u7684 \u201c\u9aa8\u67b6\u201d\u3002\u800c PHP \u4f5c\u4e3a\u7ecf\u5178\u7684\u670d\u52a1\u5668\u7aef\u811a\u672c\u8bed\u8a00，\u7ed3\u5408 MySQL \u6570\u636e\u5e93，\u56e0\u5176\u7b80\u5355\u6613\u7528\u3001\u90e8\u7f72\u7075\u6d3b\u7684\u7279\u70b9，\u6210\u4e3a\u5feb\u901f\u5f00\u53d1\u4e2d\u5c0f\u578b Web \u7cfb\u7edf\u7684\u9996\u9009\u6280\u672f\u6808\u3002 \u672c\u6587\u5c06\u4ee5 \u201c\u5458\u5de5\u7ba1\u7406\u7cfb\u7edf\u201d \u4e3a\u6848\u4f8b，\u5e26\u5927\u5bb6\u4ece\u96f6\u5f00\u59cb\u5b9e\u73b0\u4e00\u5957\u5b8c\u6574\u7684 CRUD \u529f\u80fd\u3002\u4ece\u6570\u636e\u5e93\u8bbe\u8ba1\u3001\u73af\u5883\u914d\u7f6e\u5230\u6838\u5fc3\u529f\u80fd\u7f16\u7801，\u5168\u7a0b\u6db5\u76d6\u5b9e\u6218\u7ec6\u8282：\u5305\u62ec\u5982\u4f55\u901a\u8fc7\u9884\u5904\u7406\u8bed\u53e5\u9632\u6b62 SQL \u6ce8\u5165，\u5982\u4f55\u901a\u8fc7\u8f93\u5165\u9a8c\u8bc1\u63d0\u5347\u6570\u636e\u5b89\u5168\u6027，\u5982\u4f55\u7ed3\u5408 Bootstrap \u548c Font Awesome \u4f18\u5316\u524d\u7aef\u4ea4\u4e92\u4f53\u9a8c，\u4ee5\u53ca\u5982\u4f55\u901a\u8fc7\u9762\u5411\u5bf9\u8c61\u601d\u60f3\u5c01\u88c5\u6570\u636e\u5e93\u64cd\u4f5c\u903b\u8f91\u3002\u65e0\u8bba\u4f60\u662f PHP \u521d\u5b66\u8005\u60f3\u5165\u95e8\u5b9e\u6218，\u8fd8\u662f\u9700\u8981\u53c2\u8003 CRUD \u6807\u51c6\u5b9e\u73b0\u7684\u5f00\u53d1\u8005，\u672c\u6587\u90fd\u5c06\u4e3a\u4f60\u63d0\u4f9b\u6e05\u6670\u7684\u6280\u672f\u8def\u5f84\u548c\u53ef\u76f4\u63a5\u590d\u7528\u7684\u4ee3\u7801\u793a\u4f8b，\u5e2e\u52a9\u4f60\u5728\u5b9e\u8df5\u4e2d\u638c\u63e1 PHP \u4e0e MySQL \u7684\u534f\u540c\u5f00\u53d1\u6280\u5de7\u3002<\/p>\n

\n

PHP\u4e0eMySQL\u5b9e\u4f8b<\/h3>\n

CRUD\u6848\u4f8b<\/h4>\n

\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n

\u4e00\u3001\u73af\u5883\u51c6\u5907\u4e0e\u6570\u636e\u5e93\u8bbe\u8ba1<\/h5>\n
1. \u6570\u636e\u5e93\u8868\u521b\u5efa\u8bed\u53e5<\/h6>\n

\u9996\u5148\u5728 MySQL \u4e2d\u521b\u5efaemployees\u8868，\u7528\u4e8e\u5b58\u50a8\u5458\u5de5\u6570\u636e：<\/p>\n

CREATE<\/span> TABLE<\/span> employees (<\/span>
\n id INT<\/span> NOT<\/span> NULL<\/span> PRIMARY<\/span> KEY<\/span> AUTO_INCREMENT<\/span>,<\/span>
\n name VARCHAR<\/span>(<\/span>100<\/span>)<\/span> NOT<\/span> NULL<\/span>,<\/span>
\n address VARCHAR<\/span>(<\/span>255<\/span>)<\/span> NOT<\/span> NULL<\/span>,<\/span>
\n salary INT<\/span>(<\/span>10<\/span>)<\/span> NOT<\/span> NULL<\/span>,<\/span>
\n created_at TIMESTAMP<\/span> DEFAULT<\/span> CURRENT_TIMESTAMP<\/span>
\n)<\/span>;<\/span><\/p>\n

\u4e8c\u3001\u6838\u5fc3\u914d\u7f6e\u6587\u4ef6<\/h5>\n

\u4f18\u5316\u6570\u636e\u5e93\u8fde\u63a5，\u542f\u7528\u5f02\u5e38\u6a21\u5f0f\u548c UTF-8 \u7f16\u7801：<\/p>\n

1.config.php<\/h6>\n

<?php<\/span>
\n\/* \u6570\u636e\u5e93\u914d\u7f6e\u5e38\u91cf *\/<\/span>
\ndefine<\/span>(<\/span>'DB_SERVER'<\/span>,<\/span> 'localhost'<\/span>)<\/span>;<\/span>
\ndefine<\/span>(<\/span>'DB_USERNAME'<\/span>,<\/span> 'root'<\/span>)<\/span>;<\/span>
\ndefine<\/span>(<\/span>'DB_PASSWORD'<\/span>,<\/span> ''<\/span>)<\/span>;<\/span> \/\/ \u8bf7\u4fee\u6539\u4e3a\u60a8\u7684\u6570\u636e\u5e93\u5bc6\u7801<\/span>
\ndefine<\/span>(<\/span>'DB_NAME'<\/span>,<\/span> 'demo'<\/span>)<\/span>;<\/span>
\ndefine<\/span>(<\/span>'DB_CHARSET'<\/span>,<\/span> 'utf8mb4'<\/span>)<\/span>;<\/span> \/\/ \u652f\u6301\u4e2d\u6587\u548cemoji<\/span><\/p>\n

try<\/span> {<\/span>
\n \/\/ \u5efa\u7acbMySQLi\u8fde\u63a5\u5e76\u542f\u7528\u5f02\u5e38\u6a21\u5f0f<\/span>
\n $link<\/span> =<\/span> new<\/span> mysqli<\/span>(<\/span>DB_SERVER<\/span>,<\/span> DB_USERNAME<\/span>,<\/span> DB_PASSWORD<\/span>,<\/span> DB_NAME<\/span>)<\/span>;<\/span>
\n if<\/span> (<\/span>$link<\/span>-><\/span>connect_error<\/span>)<\/span> {<\/span>
\n throw<\/span> new<\/span> mysqli_sql_exception<\/span>(<\/span>"\u8fde\u63a5\u5931\u8d25: "<\/span> .<\/span> $link<\/span>-><\/span>connect_error<\/span>)<\/span>;<\/span>
\n }<\/span>
\n \/\/ \u8bbe\u7f6e\u5b57\u7b26\u7f16\u7801<\/span>
\n $link<\/span>-><\/span>set_charset<\/span>(<\/span>DB_CHARSET<\/span>)<\/span>;<\/span>
\n}<\/span> catch<\/span> (<\/span>mysqli_sql_exception<\/span> $e<\/span>)<\/span> {<\/span>
\n \/\/ \u8fde\u63a5\u5931\u8d25\u65f6\u4e0d\u76f4\u63a5die，\u8ba9\u8c03\u7528\u8005\u5904\u7406<\/span>
\n $link<\/span> =<\/span> null<\/span>;<\/span>
\n}<\/span>
\n?<\/span>><\/span><\/p>\n

2.create_database.php<\/h6>\n

<?php<\/span>
\n\/\/ \u6570\u636e\u5e93\u914d\u7f6e（\u4e0econfig.php\u4fdd\u6301\u4e00\u81f4）<\/span>
\ndefine<\/span>(<\/span>'DB_SERVER'<\/span>,<\/span> 'localhost'<\/span>)<\/span>;<\/span>
\ndefine<\/span>(<\/span>'DB_USERNAME'<\/span>,<\/span> 'root'<\/span>)<\/span>;<\/span>
\ndefine<\/span>(<\/span>'DB_PASSWORD'<\/span>,<\/span> ''<\/span>)<\/span>;<\/span> \/\/ \u8bf7\u4fee\u6539\u4e3a\u60a8\u7684\u6570\u636e\u5e93\u5bc6\u7801<\/span>
\ndefine<\/span>(<\/span>'DB_NAME'<\/span>,<\/span> 'demo'<\/span>)<\/span>;<\/span>
\ndefine<\/span>(<\/span>'DB_CHARSET'<\/span>,<\/span> 'utf8mb4'<\/span>)<\/span>;<\/span><\/p>\n

try<\/span> {<\/span>
\n \/\/ \u8fde\u63a5\u5230MySQL\u670d\u52a1\u5668（\u4e0d\u6307\u5b9a\u6570\u636e\u5e93）<\/span>
\n $link<\/span> =<\/span> new<\/span> mysqli<\/span>(<\/span>DB_SERVER<\/span>,<\/span> DB_USERNAME<\/span>,<\/span> DB_PASSWORD<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u68c0\u67e5\u8fde\u63a5<\/span>
\n if<\/span> (<\/span>$link<\/span>-><\/span>connect_error<\/span>)<\/span> {<\/span>
\n throw<\/span> new<\/span> Exception<\/span>(<\/span>"\u6570\u636e\u5e93\u670d\u52a1\u5668\u8fde\u63a5\u5931\u8d25: "<\/span> .<\/span> $link<\/span>-><\/span>connect_error<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

\/\/ 1. \u521b\u5efa\u6570\u636e\u5e93（\u5982\u679c\u5df2\u5b58\u5728）<\/span>
\n $sql<\/span> =<\/span> "CREATE DATABASE IF NOT EXISTS "<\/span> .<\/span> DB_NAME<\/span>;<\/span>
\n if<\/span> (<\/span>!<\/span>$link<\/span>-><\/span>query<\/span>(<\/span>$sql<\/span>)<\/span>)<\/span> {<\/span>
\n throw<\/span> new<\/span> Exception<\/span>(<\/span>"\u521b\u5efa\u6570\u636e\u5e93\u5931\u8d25: "<\/span> .<\/span> $link<\/span>-><\/span>error<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

\/\/ 2. \u9009\u62e9\u6570\u636e\u5e93<\/span>
\n if<\/span> (<\/span>!<\/span>$link<\/span>-><\/span>select_db<\/span>(<\/span>DB_NAME<\/span>)<\/span>)<\/span> {<\/span>
\n throw<\/span> new<\/span> Exception<\/span>(<\/span>"\u9009\u62e9\u6570\u636e\u5e93\u5931\u8d25: "<\/span> .<\/span> $link<\/span>-><\/span>error<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

\/\/ 3. \u521b\u5efa\u5458\u5de5\u8868（\u5982\u679c\u4e0d\u5b58\u5728）<\/span>
\n $sql<\/span> =<\/span> "CREATE TABLE IF NOT EXISTS employees (
\n id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
\n name VARCHAR(100) NOT NULL,
\n address VARCHAR(255) NOT NULL,
\n salary INT(10) NOT NULL,
\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
\n ) ENGINE=InnoDB DEFAULT CHARSET="<\/span> .<\/span> DB_CHARSET<\/span>;<\/span><\/p>\n

if<\/span> (<\/span>!<\/span>$link<\/span>-><\/span>query<\/span>(<\/span>$sql<\/span>)<\/span>)<\/span> {<\/span>
\n throw<\/span> new<\/span> Exception<\/span>(<\/span>"\u521b\u5efa\u8868\u5931\u8d25: "<\/span> .<\/span> $link<\/span>-><\/span>error<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

\/\/ \u64cd\u4f5c\u6210\u529f<\/span>
\n $msg<\/span> =<\/span> "\u6570\u636e\u5e93\u548c\u8868\u521b\u5efa\u6210\u529f！"<\/span>;<\/span>
\n $link<\/span>-><\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n}<\/span> catch<\/span> (<\/span>Exception<\/span> $e<\/span>)<\/span> {<\/span>
\n $msg<\/span> =<\/span> "\u64cd\u4f5c\u5931\u8d25: "<\/span> .<\/span> $e<\/span>-><\/span>getMessage<\/span>(<\/span>)<\/span>;<\/span>
\n}<\/span><\/p>\n

\/\/ \u91cd\u5b9a\u5411\u56de\u9996\u9875\u5e76\u663e\u793a\u6d88\u606f<\/span>
\nheader<\/span>(<\/span>"location: index.php?msg="<\/span> .<\/span> urlencode<\/span>(<\/span>$msg<\/span>)<\/span>)<\/span>;<\/span>
\nexit<\/span>(<\/span>)<\/span>;<\/span>
\n?<\/span>><\/span><\/p>\n

\u4e09\u3001CRUD \u6838\u5fc3\u529f\u80fd\u5b9e\u73b0<\/h5>\n
1. \u9996\u9875\u6570\u636e\u5217\u8868（index.php）<\/h6>\n

\u5c55\u793a\u5458\u5de5\u5217\u8868，\u63d0\u4f9b\u65b0\u589e\u3001\u67e5\u770b\u3001\u7f16\u8f91\u3001\u5220\u9664\u5165\u53e3：<\/p>\n

<<\/span>!<\/span>DOCTYPE<\/span> html><\/span>
\n<<\/span>html lang=<\/span>"zh-CN"<\/span>><\/span>
\n<<\/span>head><\/span>
\n <<\/span>meta charset=<\/span>"UTF-8"<\/span>><\/span>
\n <<\/span>meta name=<\/span>"viewport"<\/span> content=<\/span>"width=device-width, initial-scale=1.0"<\/span>><\/span>
\n <<\/span>title><\/span>\u5458\u5de5\u7ba1\u7406\u7cfb\u7edf<<\/span>\/<\/span>title><\/span>
\n <<\/span>link href=<\/span>"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.3.0-alpha1\/dist\/css\/bootstrap.min.css"<\/span> rel=<\/span>"stylesheet"<\/span>><\/span>
\n <<\/span>link rel=<\/span>"stylesheet"<\/span> href=<\/span>"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/font-awesome\/6.0.0\/css\/all.min.css"<\/span>><\/span>
\n <<\/span>style><\/span>
\n :<\/span>root {<\/span>
\n —<\/span>primary–<\/span>color<\/span>:<\/span> #2563eb;<\/span>
\n —<\/span>secondary–<\/span>color<\/span>:<\/span> #4f46e5;<\/span>
\n —<\/span>accent–<\/span>color<\/span>:<\/span> #f59e0b;<\/span>
\n —<\/span>light–<\/span>color<\/span>:<\/span> #f3f4f6;<\/span>
\n —<\/span>dark–<\/span>color<\/span>:<\/span> #1f2937;<\/span>
\n }<\/span><\/p>\n

body {<\/span>
\n font–<\/span>family<\/span>:<\/span> 'Segoe UI'<\/span>,<\/span> Tahoma,<\/span> Geneva,<\/span> Verdana,<\/span> sans–<\/span>serif;<\/span>
\n background–<\/span>color<\/span>:<\/span> #f8fafc;<\/span>
\n color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>dark–<\/span>color)<\/span>;<\/span>
\n line–<\/span>height<\/span>:<\/span> 1.6<\/span>;<\/span>
\n min–<\/span>height<\/span>:<\/span> 100<\/span>vh;<\/span>
\n display<\/span>:<\/span> flex;<\/span>
\n flex–<\/span>direction<\/span>:<\/span> column;<\/span>
\n }<\/span><\/p>\n

.<\/span>navbar {<\/span>
\n background–<\/span>color<\/span>:<\/span> white;<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 2<\/span>px 10<\/span>px rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.05<\/span>)<\/span>;<\/span>
\n transition<\/span>:<\/span> all 0.3<\/span>s ease;<\/span>
\n }<\/span><\/p>\n

.<\/span>navbar<\/span>:<\/span>hover {<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 4<\/span>px 15<\/span>px rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.08<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>navbar–<\/span>brand {<\/span>
\n font–<\/span>weight<\/span>:<\/span> 700<\/span>;<\/span>
\n color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>primary–<\/span>color)<\/span>;<\/span>
\n font–<\/span>size<\/span>:<\/span> 1.5<\/span>rem;<\/span>
\n display<\/span>:<\/span> flex;<\/span>
\n align–<\/span>items<\/span>:<\/span> center;<\/span>
\n gap<\/span>:<\/span> 8<\/span>px;<\/span>
\n }<\/span><\/p>\n

.<\/span>navbar–<\/span>brand i {<\/span>
\n font–<\/span>size<\/span>:<\/span> 1.8<\/span>rem;<\/span>
\n }<\/span><\/p>\n

.<\/span>container {<\/span>
\n max–<\/span>width<\/span>:<\/span> 1200<\/span>px;<\/span>
\n margin<\/span>:<\/span> 0<\/span> auto;<\/span>
\n padding<\/span>:<\/span> 2<\/span>rem 1<\/span>rem;<\/span>
\n flex<\/span>:<\/span> 1<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>page–<\/span>header {<\/span>
\n margin–<\/span>bottom<\/span>:<\/span> 2<\/span>rem;<\/span>
\n padding–<\/span>bottom<\/span>:<\/span> 1<\/span>rem;<\/span>
\n border–<\/span>bottom<\/span>:<\/span> 1<\/span>px solid #e5e7eb;<\/span>
\n display<\/span>:<\/span> flex;<\/span>
\n flex–<\/span>wrap<\/span>:<\/span> wrap;<\/span>
\n justify–<\/span>content<\/span>:<\/span> space–<\/span>between;<\/span>
\n align–<\/span>items<\/span>:<\/span> center;<\/span>
\n }<\/span><\/p>\n

.<\/span>page–<\/span>header h2 {<\/span>
\n margin<\/span>:<\/span> 0<\/span>;<\/span>
\n font–<\/span>weight<\/span>:<\/span> 700<\/span>;<\/span>
\n color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>dark–<\/span>color)<\/span>;<\/span>
\n position<\/span>:<\/span> relative;<\/span>
\n padding–<\/span>bottom<\/span>:<\/span> 0.5<\/span>rem;<\/span>
\n }<\/span><\/p>\n

.<\/span>page–<\/span>header h2<\/span>::<\/span>after {<\/span>
\n content<\/span>:<\/span> ''<\/span>;<\/span>
\n position<\/span>:<\/span> absolute;<\/span>
\n bottom<\/span>:<\/span> 0<\/span>;<\/span>
\n left<\/span>:<\/span> 0<\/span>;<\/span>
\n width<\/span>:<\/span> 50<\/span>px;<\/span>
\n height<\/span>:<\/span> 3<\/span>px;<\/span>
\n background–<\/span>color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>primary–<\/span>color)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn {<\/span>
\n transition<\/span>:<\/span> all 0.3<\/span>s ease;<\/span>
\n font–<\/span>weight<\/span>:<\/span> 500<\/span>;<\/span>
\n padding<\/span>:<\/span> 0.5<\/span>rem 1.25<\/span>rem;<\/span>
\n border–<\/span>radius<\/span>:<\/span> 6<\/span>px;<\/span>
\n display<\/span>:<\/span> inline–<\/span>flex;<\/span>
\n align–<\/span>items<\/span>:<\/span> center;<\/span>
\n gap<\/span>:<\/span> 6<\/span>px;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn–<\/span>warning {<\/span>
\n background–<\/span>color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>accent–<\/span>color)<\/span>;<\/span>
\n border–<\/span>color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>accent–<\/span>color)<\/span>;<\/span>
\n color<\/span>:<\/span> white;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn–<\/span>warning<\/span>:<\/span>hover {<\/span>
\n background–<\/span>color<\/span>:<\/span> #d97706;<\/span>
\n border–<\/span>color<\/span>:<\/span> #d97706;<\/span>
\n transform<\/span>:<\/span> translateY<\/span>(<\/span>–<\/span>2<\/span>px)<\/span>;<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 4<\/span>px 12<\/span>px rgba<\/span>(<\/span>245<\/span>,<\/span> 158<\/span>,<\/span> 11<\/span>,<\/span> 0.3<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn–<\/span>success {<\/span>
\n background–<\/span>color<\/span>:<\/span> #10b981;<\/span>
\n border–<\/span>color<\/span>:<\/span> #10b981;<\/span>
\n color<\/span>:<\/span> white;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn–<\/span>success<\/span>:<\/span>hover {<\/span>
\n background–<\/span>color<\/span>:<\/span> #059669;<\/span>
\n border–<\/span>color<\/span>:<\/span> #059669;<\/span>
\n transform<\/span>:<\/span> translateY<\/span>(<\/span>–<\/span>2<\/span>px)<\/span>;<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 4<\/span>px 12<\/span>px rgba<\/span>(<\/span>16<\/span>,<\/span> 185<\/span>,<\/span> 129<\/span>,<\/span> 0.3<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>table {<\/span>
\n background–<\/span>color<\/span>:<\/span> white;<\/span>
\n border–<\/span>radius<\/span>:<\/span> 8<\/span>px;<\/span>
\n overflow<\/span>:<\/span> hidden;<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 4<\/span>px 6<\/span>px –<\/span>1<\/span>px rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.1<\/span>)<\/span>,<\/span> 0<\/span> 2<\/span>px 4<\/span>px –<\/span>1<\/span>px rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.06<\/span>)<\/span>;<\/span>
\n transition<\/span>:<\/span> all 0.3<\/span>s ease;<\/span>
\n }<\/span><\/p>\n

.<\/span>table<\/span>:<\/span>hover {<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 10<\/span>px 15<\/span>px –<\/span>3<\/span>px rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.1<\/span>)<\/span>,<\/span> 0<\/span> 4<\/span>px 6<\/span>px –<\/span>2<\/span>px rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.05<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>table thead {<\/span>
\n background–<\/span>color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>light–<\/span>color)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>table th,<\/span> .<\/span>table td {<\/span>
\n padding<\/span>:<\/span> 1<\/span>rem;<\/span>
\n vertical–<\/span>align<\/span>:<\/span> middle;<\/span>
\n }<\/span><\/p>\n

.<\/span>table th {<\/span>
\n font–<\/span>weight<\/span>:<\/span> 600<\/span>;<\/span>
\n color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>dark–<\/span>color)<\/span>;<\/span>
\n border–<\/span>bottom<\/span>:<\/span> 2<\/span>px solid #e5e7eb;<\/span>
\n }<\/span><\/p>\n

.<\/span>table tr {<\/span>
\n transition<\/span>:<\/span> background–<\/span>color 0.2<\/span>s ease;<\/span>
\n }<\/span><\/p>\n

.<\/span>table tr<\/span>:<\/span>hover {<\/span>
\n background–<\/span>color<\/span>:<\/span> rgba<\/span>(<\/span>37<\/span>,<\/span> 99<\/span>,<\/span> 235<\/span>,<\/span> 0.03<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>table tr td<\/span>:<\/span>last–<\/span>child {<\/span>
\n white–<\/span>space<\/span>:<\/span> nowrap;<\/span>
\n }<\/span><\/p>\n

.<\/span>table a {<\/span>
\n color<\/span>:<\/span> #6b7280;<\/span>
\n margin–<\/span>right<\/span>:<\/span> 15<\/span>px;<\/span>
\n transition<\/span>:<\/span> all 0.2<\/span>s ease;<\/span>
\n padding<\/span>:<\/span> 4<\/span>px 8<\/span>px;<\/span>
\n border–<\/span>radius<\/span>:<\/span> 4<\/span>px;<\/span>
\n }<\/span><\/p>\n

.<\/span>table a<\/span>:<\/span>hover {<\/span>
\n text–<\/span>decoration<\/span>:<\/span> none;<\/span>
\n transform<\/span>:<\/span> translateY<\/span>(<\/span>–<\/span>2<\/span>px)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>table a[<\/span>title=<\/span>"\u67e5\u770b"<\/span>]<\/span>:<\/span>hover {<\/span>
\n color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>primary–<\/span>color)<\/span>;<\/span>
\n background–<\/span>color<\/span>:<\/span> rgba<\/span>(<\/span>37<\/span>,<\/span> 99<\/span>,<\/span> 235<\/span>,<\/span> 0.1<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>table a[<\/span>title=<\/span>"\u7f16\u8f91"<\/span>]<\/span>:<\/span>hover {<\/span>
\n color<\/span>:<\/span> #10b981;<\/span>
\n background–<\/span>color<\/span>:<\/span> rgba<\/span>(<\/span>16<\/span>,<\/span> 185<\/span>,<\/span> 129<\/span>,<\/span> 0.1<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>table a[<\/span>title=<\/span>"\u5220\u9664"<\/span>]<\/span>:<\/span>hover {<\/span>
\n color<\/span>:<\/span> #ef4444;<\/span>
\n background–<\/span>color<\/span>:<\/span> rgba<\/span>(<\/span>239<\/span>,<\/span> 68<\/span>,<\/span> 68<\/span>,<\/span> 0.1<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>alert {<\/span>
\n border–<\/span>radius<\/span>:<\/span> 8<\/span>px;<\/span>
\n padding<\/span>:<\/span> 1<\/span>rem;<\/span>
\n margin–<\/span>bottom<\/span>:<\/span> 1.5<\/span>rem;<\/span>
\n border<\/span>:<\/span> none;<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 1<\/span>px 3<\/span>px 0<\/span> rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.1<\/span>)<\/span>,<\/span> 0<\/span> 1<\/span>px 2<\/span>px 0<\/span> rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.06<\/span>)<\/span>;<\/span>
\n transition<\/span>:<\/span> all 0.3<\/span>s ease;<\/span>
\n }<\/span><\/p>\n

.<\/span>alert<\/span>:<\/span>hover {<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 4<\/span>px 6<\/span>px –<\/span>1<\/span>px rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.1<\/span>)<\/span>,<\/span> 0<\/span> 2<\/span>px 4<\/span>px –<\/span>1<\/span>px rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.06<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>alert–<\/span>success {<\/span>
\n background–<\/span>color<\/span>:<\/span> rgba<\/span>(<\/span>16<\/span>,<\/span> 185<\/span>,<\/span> 129<\/span>,<\/span> 0.1<\/span>)<\/span>;<\/span>
\n color<\/span>:<\/span> #059669;<\/span>
\n }<\/span><\/p>\n

.<\/span>alert–<\/span>danger {<\/span>
\n background–<\/span>color<\/span>:<\/span> rgba<\/span>(<\/span>239<\/span>,<\/span> 68<\/span>,<\/span> 68<\/span>,<\/span> 0.1<\/span>)<\/span>;<\/span>
\n color<\/span>:<\/span> #dc2626;<\/span>
\n }<\/span><\/p>\n

.<\/span>alert–<\/span>info {<\/span>
\n background–<\/span>color<\/span>:<\/span> rgba<\/span>(<\/span>37<\/span>,<\/span> 99<\/span>,<\/span> 235<\/span>,<\/span> 0.1<\/span>)<\/span>;<\/span>
\n color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>primary–<\/span>color)<\/span>;<\/span>
\n }<\/span><\/p>\n

@media <\/span>(<\/span>max–<\/span>width<\/span>:<\/span> 768<\/span>px)<\/span> {<\/span>
\n .<\/span>page–<\/span>header {<\/span>
\n flex–<\/span>direction<\/span>:<\/span> column;<\/span>
\n align–<\/span>items<\/span>:<\/span> flex–<\/span>start;<\/span>
\n gap<\/span>:<\/span> 1<\/span>rem;<\/span>
\n }<\/span><\/p>\n

.<\/span>page–<\/span>header .<\/span>btn–<\/span>group {<\/span>
\n width<\/span>:<\/span> 100<\/span>%<\/span>;<\/span>
\n display<\/span>:<\/span> flex;<\/span>
\n gap<\/span>:<\/span> 0.5<\/span>rem;<\/span>
\n }<\/span><\/p>\n

.<\/span>page–<\/span>header .<\/span>btn {<\/span>
\n flex<\/span>:<\/span> 1<\/span>;<\/span>
\n justify–<\/span>content<\/span>:<\/span> center;<\/span>
\n }<\/span><\/p>\n

.<\/span>table–<\/span>responsive {<\/span>
\n overflow–<\/span>x<\/span>:<\/span> auto;<\/span>
\n }<\/span>
\n }<\/span><\/p>\n

.<\/span>empty<\/span>–<\/span>state {<\/span>
\n text–<\/span>align<\/span>:<\/span> center;<\/span>
\n padding<\/span>:<\/span> 3<\/span>rem 1<\/span>rem;<\/span>
\n background–<\/span>color<\/span>:<\/span> white;<\/span>
\n border–<\/span>radius<\/span>:<\/span> 8<\/span>px;<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 4<\/span>px 6<\/span>px –<\/span>1<\/span>px rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.1<\/span>)<\/span>;<\/span>
\n color<\/span>:<\/span> #6b7280;<\/span>
\n }<\/span><\/p>\n

.<\/span>empty<\/span>–<\/span>state i {<\/span>
\n font–<\/span>size<\/span>:<\/span> 3<\/span>rem;<\/span>
\n margin–<\/span>bottom<\/span>:<\/span> 1<\/span>rem;<\/span>
\n color<\/span>:<\/span> #d1d5db;<\/span>
\n }<\/span><\/p>\n

footer {<\/span>
\n text–<\/span>align<\/span>:<\/span> center;<\/span>
\n padding<\/span>:<\/span> 2<\/span>rem 1<\/span>rem;<\/span>
\n margin–<\/span>top<\/span>:<\/span> 3<\/span>rem;<\/span>
\n color<\/span>:<\/span> #6b7280;<\/span>
\n border–<\/span>top<\/span>:<\/span> 1<\/span>px solid #e5e7eb;<\/span>
\n }<\/span><\/p>\n

.<\/span>loading {<\/span>
\n display<\/span>:<\/span> inline–<\/span>block;<\/span>
\n width<\/span>:<\/span> 20<\/span>px;<\/span>
\n height<\/span>:<\/span> 20<\/span>px;<\/span>
\n border<\/span>:<\/span> 3<\/span>px solid rgba<\/span>(<\/span>255<\/span>,<\/span>255<\/span>,<\/span>255<\/span>,<\/span>.3<\/span>)<\/span>;<\/span>
\n border–<\/span>radius<\/span>:<\/span> 50<\/span>%<\/span>;<\/span>
\n border–<\/span>top–<\/span>color<\/span>:<\/span> white;<\/span>
\n animation<\/span>:<\/span> spin 1<\/span>s ease–<\/span>in–<\/span>out infinite;<\/span>
\n }<\/span><\/p>\n

@keyframes spin {<\/span>
\n to {<\/span> transform<\/span>:<\/span> rotate<\/span>(<\/span>360<\/span>deg)<\/span>;<\/span> }<\/span>
\n }<\/span>
\n <<\/span>\/<\/span>style><\/span>
\n<<\/span>\/<\/span>head><\/span>
\n<<\/span>body><\/span>
\n <<\/span>!<\/span>—<\/span> \u5bfc\u822a\u680f —<\/span>><\/span>
\n <<\/span>nav class<\/span>=<\/span>"navbar navbar-expand-lg"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"container"<\/span>><\/span>
\n <<\/span>a class<\/span>=<\/span>"navbar-brand"<\/span> href=<\/span>"#"<\/span>><\/span>
\n <<\/span>i class<\/span>=<\/span>"fas fa-users"<\/span>><\/span><<\/span>\/<\/span>i><\/span>
\n \u5458\u5de5\u7ba1\u7406\u7cfb\u7edf
\n <<\/span>\/<\/span>a><\/span>
\n <<\/span>button class<\/span>=<\/span>"navbar-toggler"<\/span> type=<\/span>"button"<\/span> data–<\/span>bs–<\/span>toggle=<\/span>"collapse"<\/span> data–<\/span>bs bs–<\/span>target=<\/span>"navbarNav"<\/span>><\/span>
\n <<\/span>span class<\/span>=<\/span>"navbar-toggler-icon"<\/span>><\/span><<\/span>\/<\/span>span><\/span>
\n <<\/span>\/<\/span>button><\/span>
\n <<\/span>div class<\/span>=<\/span>"collapse navbar-collapse"<\/span> id=<\/span>"navbarNav"<\/span>><\/span>
\n <<\/span>ul class<\/span>=<\/span>"navbar-nav-nav ms-auto"<\/span>><\/span>
\n <<\/span>li class<\/span>=<\/span>"nav-item"<\/span>><\/span>
\n <<\/span>a class<\/span>=<\/span>"nav-link active"<\/span> href=<\/span>"#"<\/span> aria–<\/span>current=<\/span>"page"<\/span>><\/span>\u5458\u5de5\u5217\u8868<<\/span>\/<\/span>a><\/span>
\n <<\/span>\/<\/span>li><\/span>
\n <<\/span>li class<\/span>=<\/span>"nav-item"<\/span>><\/span>
\n <<\/span>a class<\/span>=<\/span>"nav-link"<\/span> href=<\/span>"#"<\/span>><\/span>\u7cfb\u7edf\u8bbe\u7f6e<<\/span>\/<\/span>a><\/span>
\n <<\/span>\/<\/span>li><\/span>
\n <<\/span>li class<\/span>=<\/span>"nav-item"<\/span>><\/span>
\n <<\/span>a class<\/span>=<\/span>"nav-link"<\/span> href=<\/span>"#"<\/span>><\/span>\u5e2e\u52a9\u4e2d\u5fc3<<\/span>\/<\/span>a><\/span>
\n <<\/span>\/<\/span>li><\/span>
\n <<\/span>\/<\/span>ul><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>nav><\/span><\/p>\n

<<\/span>div class<\/span>=<\/span>"container"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"row"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"col-md-12"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"page-header"<\/span>><\/span>
\n <<\/span>h2><\/span>\u5458\u5de5\u5217\u8868<<\/span>\/<\/span>h2><\/span>
\n <<\/span>div class<\/span>=<\/span>"btn-group"<\/span>><\/span>
\n <<\/span>a href=<\/span>"create_database.php"<\/span> class<\/span>=<\/span>"btn btn-warning"<\/span>><\/span>
\n <<\/span>i class<\/span>=<\/span>"fas fa-database"<\/span>><\/span><<\/span>\/<\/span>i><\/span> \u521b\u5efa\u6570\u636e\u5e93\u548c\u8868
\n <<\/span>\/<\/span>a><\/span>
\n <<\/span>a href=<\/span>"create.php"<\/span> class<\/span>=<\/span>"btn btn-success"<\/span>><\/span>
\n <<\/span>i class<\/span>=<\/span>"fas fa-plus"<\/span>><\/span><<\/span>\/<\/span>i><\/span> \u6dfb\u52a0\u65b0\u5458\u5de5
\n <<\/span>\/<\/span>a><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span><\/p>\n

<<\/span>?<\/span>php
\n \/\/ \u9519\u8bef\u62a5\u544a\u8bbe\u7f6e – \u751f\u4ea7\u73af\u5883\u5e94\u5173\u95ed<\/span>
\n \/\/ error_reporting(E_ALL);<\/span>
\n \/\/ ini_set('display_errors', 1);<\/span><\/p>\n

\/\/ \u6570\u636e\u5e93\u64cd\u4f5c\u7c7b<\/span>
\n class<\/span> EmployeeDB<\/span> {<\/span>
\n private<\/span> $conn<\/span>;<\/span>
\n private<\/span> $dbHost<\/span>;<\/span>
\n private<\/span> $dbUser<\/span>;<\/span>
\n private<\/span> $dbPass<\/span>;<\/span>
\n private<\/span> $dbName<\/span>;<\/span>
\n private<\/span> $dbCharset<\/span>;<\/span><\/p>\n

public<\/span> function<\/span> __construct<\/span>(<\/span>$host<\/span>,<\/span> $user<\/span>,<\/span> $pass<\/span>,<\/span> $name<\/span>,<\/span> $charset<\/span> =<\/span> 'utf8mb4'<\/span>)<\/span> {<\/span>
\n $this<\/span>-><\/span>dbHost<\/span> =<\/span> $host<\/span>;<\/span>
\n $this<\/span>-><\/span>dbUser<\/span> =<\/span> $user<\/span>;<\/span>
\n $this<\/span>-><\/span>dbPass<\/span> =<\/span> $pass<\/span>;<\/span>
\n $this<\/span>-><\/span>dbName<\/span> =<\/span> $name<\/span>;<\/span>
\n $this<\/span>-><\/span>dbCharset<\/span> =<\/span> $charset<\/span>;<\/span>
\n }<\/span><\/p>\n

\/\/ \u8fde\u63a5\u5230\u6570\u636e\u5e93\u670d\u52a1\u5668<\/span>
\n public<\/span> function<\/span> connectToServer<\/span>(<\/span>)<\/span> {<\/span>
\n try<\/span> {<\/span>
\n $conn<\/span> =<\/span> new<\/span> mysqli<\/span>(<\/span>$this<\/span>-><\/span>dbHost<\/span>,<\/span> $this<\/span>-><\/span>dbUser<\/span>,<\/span> $this<\/span>-><\/span>dbPass<\/span>)<\/span>;<\/span><\/p>\n

if<\/span> (<\/span>$conn<\/span>-><\/span>connect_error<\/span>)<\/span> {<\/span>
\n throw<\/span> new<\/span> Exception<\/span>(<\/span>"\u6570\u636e\u5e93\u670d\u52a1\u5668\u8fde\u63a5\u5931\u8d25: "<\/span> .<\/span> $conn<\/span>-><\/span>connect_error<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

return<\/span> $conn<\/span>;<\/span>
\n }<\/span> catch<\/span> (<\/span>Exception<\/span> $e<\/span>)<\/span> {<\/span>
\n throw<\/span> $e<\/span>;<\/span>
\n }<\/span>
\n }<\/span><\/p>\n

\/\/ \u8fde\u63a5\u5230\u6307\u5b9a\u6570\u636e\u5e93<\/span>
\n public<\/span> function<\/span> connect<\/span>(<\/span>)<\/span> {<\/span>
\n try<\/span> {<\/span>
\n $this<\/span>-><\/span>conn<\/span> =<\/span> new<\/span> mysqli<\/span>(<\/span>$this<\/span>-><\/span>dbHost<\/span>,<\/span> $this<\/span>-><\/span>dbUser<\/span>,<\/span> $this<\/span>-><\/span>dbPass<\/span>,<\/span> $this<\/span>-><\/span>dbName<\/span>)<\/span>;<\/span><\/p>\n

if<\/span> (<\/span>$this<\/span>-><\/span>conn<\/span>-><\/span>connect_error<\/span>)<\/span> {<\/span>
\n throw<\/span> new<\/span> Exception<\/span>(<\/span>"\u6570\u636e\u5e93\u8fde\u63a5\u5931\u8d25: "<\/span> .<\/span> $this<\/span>-><\/span>conn<\/span>-><\/span>connect_error<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

$this<\/span>-><\/span>conn<\/span>-><\/span>set_charset<\/span>(<\/span>$this<\/span>-><\/span>dbCharset<\/span>)<\/span>;<\/span>
\n return<\/span> $this<\/span>-><\/span>conn<\/span>;<\/span>
\n }<\/span> catch<\/span> (<\/span>Exception<\/span> $e<\/span>)<\/span> {<\/span>
\n throw<\/span> $e<\/span>;<\/span>
\n }<\/span>
\n }<\/span><\/p>\n

\/\/ \u68c0\u67e5\u6570\u636e\u5e93\u662f\u5426\u5b58\u5728<\/span>
\n public<\/span> function<\/span> databaseExists<\/span>(<\/span>)<\/span> {<\/span>
\n try<\/span> {<\/span>
\n $serverConn<\/span> =<\/span> $this<\/span>-><\/span>connectToServer<\/span>(<\/span>)<\/span>;<\/span>
\n $dbName<\/span> =<\/span> $serverConn<\/span>-><\/span>real_escape_string<\/span>(<\/span>$this<\/span>-><\/span>dbName<\/span>)<\/span>;<\/span><\/p>\n

$result<\/span> =<\/span> $serverConn<\/span>-><\/span>query<\/span>(<\/span>"SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = '$dbName<\/span><\/span>'"<\/span>)<\/span>;<\/span>
\n $exists<\/span> =<\/span> $result<\/span>-><\/span>num_rows<\/span> ><\/span> 0<\/span>;<\/span><\/p>\n

$serverConn<\/span>-><\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n return<\/span> $exists<\/span>;<\/span>
\n }<\/span> catch<\/span> (<\/span>Exception<\/span> $e<\/span>)<\/span> {<\/span>
\n throw<\/span> $e<\/span>;<\/span>
\n }<\/span>
\n }<\/span><\/p>\n

\/\/ \u83b7\u53d6\u6240\u6709\u5458\u5de5<\/span>
\n public<\/span> function<\/span> getAllEmployees<\/span>(<\/span>)<\/span> {<\/span>
\n try<\/span> {<\/span>
\n $this<\/span>-><\/span>connect<\/span>(<\/span>)<\/span>;<\/span>
\n $sql<\/span> =<\/span> "SELECT * FROM employees ORDER BY id DESC"<\/span>;<\/span>
\n $result<\/span> =<\/span> $this<\/span>-><\/span>conn<\/span>-><\/span>query<\/span>(<\/span>$sql<\/span>)<\/span>;<\/span><\/p>\n

$employees<\/span> =<\/span> [<\/span>]<\/span>;<\/span>
\n if<\/span> (<\/span>$result<\/span>-><\/span>num_rows<\/span> ><\/span> 0<\/span>)<\/span> {<\/span>
\n while<\/span> (<\/span>$row<\/span> =<\/span> $result<\/span>-><\/span>fetch_assoc<\/span>(<\/span>)<\/span>)<\/span> {<\/span>
\n $employees<\/span>[<\/span>]<\/span> =<\/span> $row<\/span>;<\/span>
\n }<\/span>
\n }<\/span><\/p>\n

$result<\/span>-><\/span>free<\/span>(<\/span>)<\/span>;<\/span>
\n $this<\/span>-><\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n return<\/span> $employees<\/span>;<\/span>
\n }<\/span> catch<\/span> (<\/span>Exception<\/span> $e<\/span>)<\/span> {<\/span>
\n $this<\/span>-><\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n throw<\/span> $e<\/span>;<\/span>
\n }<\/span>
\n }<\/span><\/p>\n

\/\/ \u5173\u95ed\u8fde\u63a5<\/span>
\n public<\/span> function<\/span> close<\/span>(<\/span>)<\/span> {<\/span>
\n if<\/span> (<\/span>$this<\/span>-><\/span>conn<\/span>)<\/span> {<\/span>
\n $this<\/span>-><\/span>conn<\/span>-><\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span>
\n }<\/span>
\n }<\/span><\/p>\n

\/\/ \u4e3b\u7a0b\u5e8f\u903b\u8f91<\/span>
\n try<\/span> {<\/span>
\n \/\/ \u68c0\u67e5\u914d\u7f6e\u6587\u4ef6\u662f\u5426\u5b58\u5728<\/span>
\n if<\/span> (<\/span>!<\/span>file_exists<\/span>(<\/span>'config.php'<\/span>)<\/span>)<\/span> {<\/span>
\n throw<\/span> new<\/span> Exception<\/span>(<\/span>"\u914d\u7f6e\u6587\u4ef6 config.php \u4e0d\u5b58\u5728，\u8bf7\u5148\u521b\u5efa\u914d\u7f6e\u6587\u4ef6\u3002"<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

\/\/ \u5f15\u5165\u914d\u7f6e\u6587\u4ef6<\/span>
\n require_once<\/span> 'config.php'<\/span>;<\/span><\/p>\n

\/\/ \u9a8c\u8bc1\u914d\u7f6e\u662f\u5426\u5b8c\u6574<\/span>
\n $requiredConfig<\/span> =<\/span> [<\/span>'DB_SERVER'<\/span>,<\/span> 'DB_USERNAME'<\/span>,<\/span> 'DB_PASSWORD'<\/span>,<\/span> 'DB_NAME'<\/span>]<\/span>;<\/span>
\n foreach<\/span> (<\/span>$requiredConfig<\/span> as<\/span> $config<\/span>)<\/span> {<\/span>
\n if<\/span> (<\/span>!<\/span>defined<\/span>(<\/span>$config<\/span>)<\/span>)<\/span> {<\/span>
\n throw<\/span> new<\/span> Exception<\/span>(<\/span>"\u914d\u7f6e\u6587\u4ef6\u4e2d\u7f3a\u5c11\u5fc5\u8981\u7684\u53c2\u6570: $config<\/span><\/span>"<\/span>)<\/span>;<\/span>
\n }<\/span>
\n }<\/span><\/p>\n

\/\/ \u663e\u793a\u64cd\u4f5c\u6d88\u606f<\/span>
\n if<\/span> (<\/span>isset<\/span>(<\/span>$_GET<\/span>[<\/span>'msg'<\/span>]<\/span>)<\/span>)<\/span> {<\/span>
\n \/\/ \u8fc7\u6ee4\u8f93\u5165\u9632\u6b62XSS\u653b\u51fb<\/span>
\n $msg<\/span> =<\/span> htmlspecialchars<\/span>(<\/span>$_GET<\/span>[<\/span>'msg'<\/span>]<\/span>,<\/span> ENT_QUOTES<\/span>,<\/span> 'UTF-8'<\/span>)<\/span>;<\/span>
\n $alertClass<\/span> =<\/span> strpos<\/span>(<\/span>$msg<\/span>,<\/span> '\u6210\u529f'<\/span>)<\/span> !==<\/span> false<\/span> ?<\/span> 'alert-success'<\/span> :<\/span> 'alert-danger'<\/span>;<\/span>
\n echo<\/span> "<div class='alert $alertClass<\/span><\/span>'>$msg<\/span><\/span><\/div>"<\/span>;<\/span>
\n }<\/span><\/p>\n

\/\/ \u521d\u59cb\u5316\u6570\u636e\u5e93\u8fde\u63a5<\/span>
\n $db<\/span> =<\/span> new<\/span> EmployeeDB<\/span>(<\/span>DB_SERVER<\/span>,<\/span> DB_USERNAME<\/span>,<\/span> DB_PASSWORD<\/span>,<\/span> DB_NAME<\/span>)<\/span>;<\/span>
\n $dbExists<\/span> =<\/span> $db<\/span>-><\/span>databaseExists<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

if<\/span> (<\/span>!<\/span>$dbExists<\/span>)<\/span> {<\/span>
\n echo<\/span> "<div class='alert alert-info'>\u6570\u636e\u5e93\u4e0d\u5b58\u5728，\u8bf7\u70b9\u51fb\u4e0a\u65b9\u6309\u94ae\u521b\u5efa\u6570\u636e\u5e93\u548c\u8868<\/div>"<\/span>;<\/span>
\n }<\/span> else<\/span> {<\/span>
\n \/\/ \u83b7\u53d6\u5458\u5de5\u5217\u8868<\/span>
\n $employees<\/span> =<\/span> $db<\/span>-><\/span>getAllEmployees<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

if<\/span> (<\/span>!<\/span>empty<\/span>(<\/span>$employees<\/span>)<\/span>)<\/span> {<\/span>
\n echo<\/span> "<div class='table-responsive'>"<\/span>;<\/span>
\n echo<\/span> "<table class='table table-bordered'>"<\/span>;<\/span>
\n echo<\/span> "<thead><tr>"<\/span>;<\/span>
\n echo<\/span> "<th>\u5e8f\u53f7<\/th><th>\u59d3\u540d<\/th><th>\u5730\u5740<\/th><th>\u85aa\u8d44<\/th><th>\u64cd\u4f5c<\/th>"<\/span>;<\/span>
\n echo<\/span> "<\/tr><\/thead><tbody>"<\/span>;<\/span>
\n foreach<\/span> (<\/span>$employees<\/span> as<\/span> $row<\/span>)<\/span> {<\/span>
\n \/\/ \u8f93\u51fa\u524d\u8f6c\u4e49\u6570\u636e\u9632\u6b62XSS\u653b\u51fb<\/span>
\n $id<\/span> =<\/span> htmlspecialchars<\/span>(<\/span>$row<\/span>[<\/span>'id'<\/span>]<\/span>,<\/span> ENT_QUOTES<\/span>,<\/span> 'UTF-8'<\/span>)<\/span>;<\/span>
\n $name<\/span> =<\/span> htmlspecialchars<\/span>(<\/span>$row<\/span>[<\/span>'name'<\/span>]<\/span>,<\/span> ENT_QUOTES<\/span>,<\/span> 'UTF-8'<\/span>)<\/span>;<\/span>
\n $address<\/span> =<\/span> htmlspecialchars<\/span>(<\/span>$row<\/span>[<\/span>'address'<\/span>]<\/span>,<\/span> ENT_QUOTES<\/span>,<\/span> 'UTF-8'<\/span>)<\/span>;<\/span>
\n $salary<\/span> =<\/span> number_format<\/span>(<\/span>(<\/span>float<\/span>)<\/span>$row<\/span>[<\/span>'salary'<\/span>]<\/span>,<\/span> 2<\/span>)<\/span>;<\/span><\/p>\n

echo<\/span> "<tr>"<\/span>;<\/span>
\n echo<\/span> "<td>{<\/span>$id<\/span>}<\/span><\/span><\/td>"<\/span>;<\/span>
\n echo<\/span> "<td>{<\/span>$name<\/span>}<\/span><\/span><\/td>"<\/span>;<\/span>
\n echo<\/span> "<td>{<\/span>$address<\/span>}<\/span><\/span><\/td>"<\/span>;<\/span>
\n echo<\/span> "<td>{<\/span>$salary<\/span>}<\/span><\/span><\/td>"<\/span>;<\/span>
\n echo<\/span> "<td>"<\/span>;<\/span>
\n echo<\/span> "<a href='read.php?id={<\/span>$id<\/span>}<\/span><\/span>' title='\u67e5\u770b' data-bs-toggle='tooltip'><i class='fas fa-eye'><\/i><\/a>"<\/span>;<\/span>
\n echo<\/span> "<a href='update.php?id={<\/span>$id<\/span>}<\/span><\/span>' title='\u7f16\u8f91' data-bs-toggle='tooltip'><i class='fas fa-pencil'><\/i><\/a>"<\/span>;<\/span>
\n echo<\/span> "<a href='delete.php?id={<\/span>$id<\/span>}<\/span><\/span>' title='\u5220\u9664' data-bs-toggle='tooltip'><i class='fas fa-trash'><\/i><\/a>"<\/span>;<\/span>
\n echo<\/span> "<\/td>"<\/span>;<\/span>
\n echo<\/span> "<\/tr>"<\/span>;<\/span>
\n }<\/span>
\n echo<\/span> "<\/tbody><\/table>"<\/span>;<\/span>
\n echo<\/span> "<\/div>"<\/span>;<\/span>
\n }<\/span> else<\/span> {<\/span>
\n echo<\/span> "<div class='empty-state'>"<\/span>;<\/span>
\n echo<\/span> "<i class='fas fa-user-slash'><\/i>"<\/span>;<\/span>
\n echo<\/span> "<h3>\u6682\u65e0\u5458\u5de5\u8bb0\u5f55<\/h3>"<\/span>;<\/span>
\n echo<\/span> "<p>\u8bf7\u70b9\u51fb\u4e0a\u65b9\u7684\\\\"\u6dfb\u52a0\u65b0\u5458\u5de5\\\\"\u6309\u94ae\u5f00\u59cb\u6dfb\u52a0\u8bb0\u5f55<\/p>"<\/span>;<\/span>
\n echo<\/span> "<\/div>"<\/span>;<\/span>
\n }<\/span>
\n }<\/span>
\n }<\/span> catch<\/span> (<\/span>Exception<\/span> $e<\/span>)<\/span> {<\/span>
\n echo<\/span> "<div class='alert alert-danger'>"<\/span> .<\/span> htmlspecialchars<\/span>(<\/span>$e<\/span>-><\/span>getMessage<\/span>(<\/span>)<\/span>,<\/span> ENT_QUOTES<\/span>,<\/span> 'UTF-8'<\/span>)<\/span> .<\/span> "<\/div>"<\/span>;<\/span>
\n }<\/span>
\n ?<\/span>><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span><\/p>\n

<<\/span>!<\/span>—<\/span> \u9875\u811a —<\/span>><\/span>
\n <<\/span>footer><\/span>
\n <<\/span>div class<\/span>=<\/span>"container"<\/span>><\/span>
\n <<\/span>p><\/span>&<\/span>copy;<\/span> <<\/span>?<\/span>php echo<\/span> date<\/span>(<\/span>"Y"<\/span>)<\/span>;<\/span> ?<\/span>><\/span> \u5458\u5de5\u7ba1\u7406\u7cfb\u7edf –<\/span> \u7248\u6743\u6240\u6709<<\/span>\/<\/span>p><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>footer><\/span><\/p>\n

<<\/span>script src=<\/span>"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.3.0-alpha1\/dist\/js\/bootstrap.bundle.min.js"<\/span>><\/span><<\/span>\/<\/span>script><\/span>
\n <<\/span>script><\/span>
\n document.<\/span>addEventListener<\/span>(<\/span>'DOMContentLoaded'<\/span>,<\/span> function<\/span>(<\/span>)<\/span> {<\/span>
\n \/\/ \u521d\u59cb\u5316tooltip<\/span>
\n var<\/span> tooltipTriggerList =<\/span> [<\/span>]<\/span>.<\/span>slice.<\/span>call<\/span>(<\/span>document.<\/span>querySelectorAll<\/span>(<\/span>'[data-bs-toggle="tooltip"]'<\/span>)<\/span>)<\/span>;<\/span>
\n var<\/span> tooltipList =<\/span> tooltipTriggerList.<\/span>map<\/span>(<\/span>function<\/span> (<\/span>tooltipTriggerEl)<\/span> {<\/span>
\n return<\/span> new<\/span> bootstrap<\/span>.<\/span>Tooltip<\/span>(<\/span>tooltipTriggerEl)<\/span>;<\/span>
\n }<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u6dfb\u52a0\u8868\u683c\u884c\u70b9\u51fb\u6548\u679c<\/span>
\n const<\/span> tableRows =<\/span> document.<\/span>querySelectorAll<\/span>(<\/span>'.table tbody tr'<\/span>)<\/span>;<\/span>
\n tableRows.<\/span>forEach<\/span>(<\/span>row =><\/span> {<\/span>
\n row.<\/span>addEventListener<\/span>(<\/span>'click'<\/span>,<\/span> function<\/span>(<\/span>e)<\/span> {<\/span>
\n \/\/ \u5982\u679c\u70b9\u51fb\u7684\u662f\u64cd\u4f5c\u6309\u94ae，\u5219\u4e0d\u89e6\u53d1\u884c\u70b9\u51fb\u4e8b\u4ef6<\/span>
\n if<\/span> (<\/span>!<\/span>e.<\/span>target.<\/span>closest<\/span>(<\/span>'a'<\/span>)<\/span>)<\/span> {<\/span>
\n const<\/span> id =<\/span> this.<\/span>querySelector<\/span>(<\/span>'td:first-child'<\/span>)<\/span>.<\/span>textContent;<\/span>
\n window.<\/span>location.<\/span>href =<\/span> 'read.php?id='<\/span> +<\/span> id;<\/span>
\n }<\/span>
\n }<\/span>)<\/span>;<\/span>
\n }<\/span>)<\/span>;<\/span>
\n }<\/span>)<\/span>;<\/span>
\n <<\/span>\/<\/span>script><\/span>
\n<<\/span>\/<\/span>body><\/span>
\n<<\/span>\/<\/span>html><\/span><\/p>\n

2. \u65b0\u589e\u5458\u5de5（create.php）<\/h6>\n

\u63d0\u4f9b\u8868\u5355\u5f55\u5165\u65b0\u5458\u5de5\u6570\u636e，\u5305\u542b\u8f93\u5165\u9a8c\u8bc1\u548c\u9884\u5904\u7406\u63d2\u5165：<\/p>\n

<?php<\/span>
\nrequire_once<\/span> "config.php"<\/span>;<\/span><\/p>\n

\/\/ \u521d\u59cb\u5316\u53d8\u91cf\u548c\u9519\u8bef\u4fe1\u606f<\/span>
\n$name<\/span> =<\/span> $address<\/span> =<\/span> $salary<\/span> =<\/span> ""<\/span>;<\/span>
\n$name_err<\/span> =<\/span> $address_err<\/span> =<\/span> $salary_err<\/span> =<\/span> ""<\/span>;<\/span><\/p>\n

\/\/ \u5904\u7406\u8868\u5355\u63d0\u4ea4<\/span>
\nif<\/span> (<\/span>$_SERVER<\/span>[<\/span>"REQUEST_METHOD"<\/span>]<\/span> ===<\/span> "POST"<\/span>)<\/span> {<\/span>
\n \/\/ \u9a8c\u8bc1\u59d3\u540d（\u652f\u6301\u4e2d\u82f1\u6587）<\/span>
\n $input_name<\/span> =<\/span> trim<\/span>(<\/span>$_POST<\/span>[<\/span>"name"<\/span>]<\/span>)<\/span>;<\/span>
\n if<\/span> (<\/span>empty<\/span>(<\/span>$input_name<\/span>)<\/span>)<\/span> {<\/span>
\n $name_err<\/span> =<\/span> "\u8bf7\u8f93\u5165\u59d3\u540d"<\/span>;<\/span>
\n }<\/span> elseif<\/span> (<\/span>!<\/span>preg_match<\/span>(<\/span>"\/^[a-zA-Z\\\\s\\\\x{4e00}-\\\\x{9fa5}]+$\/u"<\/span>,<\/span> $input_name<\/span>)<\/span>)<\/span> {<\/span>
\n $name_err<\/span> =<\/span> "\u59d3\u540d\u53ea\u80fd\u5305\u542b\u5b57\u6bcd\u3001\u6c49\u5b57\u548c\u7a7a\u683c"<\/span>;<\/span>
\n }<\/span> else<\/span> {<\/span>
\n $name<\/span> =<\/span> $input_name<\/span>;<\/span>
\n }<\/span><\/p>\n

\/\/ \u9a8c\u8bc1\u5730\u5740<\/span>
\n $input_address<\/span> =<\/span> trim<\/span>(<\/span>$_POST<\/span>[<\/span>"address"<\/span>]<\/span>)<\/span>;<\/span>
\n if<\/span> (<\/span>empty<\/span>(<\/span>$input_address<\/span>)<\/span>)<\/span> {<\/span>
\n $address_err<\/span> =<\/span> "\u8bf7\u8f93\u5165\u5730\u5740"<\/span>;<\/span>
\n }<\/span> else<\/span> {<\/span>
\n $address<\/span> =<\/span> $input_address<\/span>;<\/span>
\n }<\/span><\/p>\n

\/\/ \u9a8c\u8bc1\u85aa\u8d44（\u6b63\u6574\u6570）<\/span>
\n $input_salary<\/span> =<\/span> trim<\/span>(<\/span>$_POST<\/span>[<\/span>"salary"<\/span>]<\/span>)<\/span>;<\/span>
\n if<\/span> (<\/span>empty<\/span>(<\/span>$input_salary<\/span>)<\/span>)<\/span> {<\/span>
\n $salary_err<\/span> =<\/span> "\u8bf7\u8f93\u5165\u85aa\u8d44"<\/span>;<\/span>
\n }<\/span> elseif<\/span> (<\/span>!<\/span>filter_var<\/span>(<\/span>$input_salary<\/span>,<\/span> FILTER_VALIDATE_INT<\/span>,<\/span> [<\/span>"options"<\/span> =><\/span> [<\/span>"min_range"<\/span> =><\/span> 1<\/span>]<\/span>]<\/span>)<\/span>)<\/span> {<\/span>
\n $salary_err<\/span> =<\/span> "\u85aa\u8d44\u5fc5\u987b\u662f\u6b63\u6574\u6570"<\/span>;<\/span>
\n }<\/span> else<\/span> {<\/span>
\n $salary<\/span> =<\/span> $input_salary<\/span>;<\/span>
\n }<\/span><\/p>\n

\/\/ \u65e0\u9519\u8bef\u5219\u63d2\u5165\u6570\u636e\u5e93<\/span>
\n if<\/span> (<\/span>empty<\/span>(<\/span>$name_err<\/span>)<\/span> &&<\/span> empty<\/span>(<\/span>$address_err<\/span>)<\/span> &&<\/span> empty<\/span>(<\/span>$salary_err<\/span>)<\/span>)<\/span> {<\/span>
\n try<\/span> {<\/span>
\n \/\/ \u9884\u5904\u7406\u63d2\u5165（\u9632SQL\u6ce8\u5165）<\/span>
\n $sql<\/span> =<\/span> "INSERT INTO employees (name, address, salary) VALUES (?, ?, ?)"<\/span>;<\/span>
\n $stmt<\/span> =<\/span> $link<\/span>-><\/span>prepare<\/span>(<\/span>$sql<\/span>)<\/span>;<\/span>
\n $stmt<\/span>-><\/span>bind_param<\/span>(<\/span>"ssi"<\/span>,<\/span> $name<\/span>,<\/span> $address<\/span>,<\/span> $salary<\/span>)<\/span>;<\/span> \/\/ s=\u5b57\u7b26\u4e32, i=\u6574\u6570<\/span><\/p>\n

if<\/span> (<\/span>$stmt<\/span>-><\/span>execute<\/span>(<\/span>)<\/span>)<\/span> {<\/span>
\n header<\/span>(<\/span>"location: index.php?msg=\u5458\u5de5\u6dfb\u52a0\u6210\u529f"<\/span>)<\/span>;<\/span> \/\/ \u6210\u529f\u540e\u8df3\u8f6c\u5230\u5217\u8868\u9875\u5e76\u663e\u793a\u6d88\u606f<\/span>
\n exit<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span> else<\/span> {<\/span>
\n throw<\/span> new<\/span> mysqli_sql_exception<\/span>(<\/span>"\u6267\u884c\u5931\u8d25: "<\/span> .<\/span> $stmt<\/span>-><\/span>error<\/span>)<\/span>;<\/span>
\n }<\/span>
\n }<\/span> catch<\/span> (<\/span>mysqli_sql_exception<\/span> $e<\/span>)<\/span> {<\/span>
\n echo<\/span> "\u9519\u8bef: "<\/span> .<\/span> $e<\/span>-><\/span>getMessage<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span> finally<\/span> {<\/span>
\n if<\/span> (<\/span>isset<\/span>(<\/span>$stmt<\/span>)<\/span>)<\/span> $stmt<\/span>-><\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n if<\/span> (<\/span>isset<\/span>(<\/span>$link<\/span>)<\/span>)<\/span> $link<\/span>-><\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span>
\n }<\/span>
\n}<\/span>
\n?<\/span>><\/span><\/p>\n

<<\/span>!<\/span>DOCTYPE<\/span> html><\/span>
\n<<\/span>html lang=<\/span>"zh-CN"<\/span>><\/span>
\n<<\/span>head><\/span>
\n <<\/span>meta charset=<\/span>"UTF-8"<\/span>><\/span>
\n <<\/span>meta name=<\/span>"viewport"<\/span> content=<\/span>"width=device-width, initial-scale=1.0"<\/span>><\/span>
\n <<\/span>title><\/span>\u6dfb\u52a0\u5458\u5de5 –<\/span> \u5458\u5de5\u7ba1\u7406\u7cfb\u7edf<<\/span>\/<\/span>title><\/span>
\n <<\/span>link href=<\/span>"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.3.0-alpha1\/dist\/css\/bootstrap.min.css"<\/span> rel=<\/span>"stylesheet"<\/span>><\/span>
\n <<\/span>link rel=<\/span>"stylesheet"<\/span> href=<\/span>"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/font-awesome\/6.0.0\/css\/all.min.css"<\/span>><\/span>
\n <<\/span>style><\/span>
\n :<\/span>root {<\/span>
\n —<\/span>primary–<\/span>color<\/span>:<\/span> #2563eb;<\/span>
\n —<\/span>secondary–<\/span>color<\/span>:<\/span> #4f46e5;<\/span>
\n —<\/span>accent–<\/span>color<\/span>:<\/span> #f59e0b;<\/span>
\n —<\/span>light–<\/span>color<\/span>:<\/span> #f3f4f6;<\/span>
\n —<\/span>dark–<\/span>color<\/span>:<\/span> #1f2937;<\/span>
\n }<\/span><\/p>\n

body {<\/span>
\n font–<\/span>family<\/span>:<\/span> 'Segoe UI'<\/span>,<\/span> Tahoma,<\/span> Geneva,<\/span> Verdana,<\/span> sans–<\/span>serif;<\/span>
\n background–<\/span>color<\/span>:<\/span> #f8fafc;<\/span>
\n color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>dark–<\/span>color)<\/span>;<\/span>
\n line–<\/span>height<\/span>:<\/span> 1.6<\/span>;<\/span>
\n min–<\/span>height<\/span>:<\/span> 100<\/span>vh;<\/span>
\n display<\/span>:<\/span> flex;<\/span>
\n flex–<\/span>direction<\/span>:<\/span> column;<\/span>
\n }<\/span><\/p>\n

.<\/span>navbar {<\/span>
\n background–<\/span>color<\/span>:<\/span> white;<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 2<\/span>px 10<\/span>px rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.05<\/span>)<\/span>;<\/span>
\n transition<\/span>:<\/span> all 0.3<\/span>s ease;<\/span>
\n }<\/span><\/p>\n

.<\/span>navbar<\/span>:<\/span>hover {<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 4<\/span>px 15<\/span>px rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.08<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>navbar–<\/span>brand {<\/span>
\n font–<\/span>weight<\/span>:<\/span> 700<\/span>;<\/span>
\n color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>primary–<\/span>color)<\/span>;<\/span>
\n font–<\/span>size<\/span>:<\/span> 1.5<\/span>rem;<\/span>
\n display<\/span>:<\/span> flex;<\/span>
\n align–<\/span>items<\/span>:<\/span> center;<\/span>
\n gap<\/span>:<\/span> 8<\/span>px;<\/span>
\n }<\/span><\/p>\n

.<\/span>navbar–<\/span>brand i {<\/span>
\n font–<\/span>size<\/span>:<\/span> 1.8<\/span>rem;<\/span>
\n }<\/span><\/p>\n

.<\/span>container {<\/span>
\n max–<\/span>width<\/span>:<\/span> 1200<\/span>px;<\/span>
\n margin<\/span>:<\/span> 0<\/span> auto;<\/span>
\n padding<\/span>:<\/span> 2<\/span>rem 1<\/span>rem;<\/span>
\n flex<\/span>:<\/span> 1<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>page–<\/span>header {<\/span>
\n margin–<\/span>bottom<\/span>:<\/span> 2<\/span>rem;<\/span>
\n padding–<\/span>bottom<\/span>:<\/span> 1<\/span>rem;<\/span>
\n border–<\/span>bottom<\/span>:<\/span> 1<\/span>px solid #e5e7eb;<\/span>
\n display<\/span>:<\/span> flex;<\/span>
\n flex–<\/span>wrap<\/span>:<\/span> wrap;<\/span>
\n justify–<\/span>content<\/span>:<\/span> space–<\/span>between;<\/span>
\n align–<\/span>items<\/span>:<\/span> center;<\/span>
\n }<\/span><\/p>\n

.<\/span>page–<\/span>header h2 {<\/span>
\n margin<\/span>:<\/span> 0<\/span>;<\/span>
\n font–<\/span>weight<\/span>:<\/span> 700<\/span>;<\/span>
\n color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>dark–<\/span>color)<\/span>;<\/span>
\n position<\/span>:<\/span> relative;<\/span>
\n padding–<\/span>bottom<\/span>:<\/span> 0.5<\/span>rem;<\/span>
\n }<\/span><\/p>\n

.<\/span>page–<\/span>header h2<\/span>::<\/span>after {<\/span>
\n content<\/span>:<\/span> ''<\/span>;<\/span>
\n position<\/span>:<\/span> absolute;<\/span>
\n bottom<\/span>:<\/span> 0<\/span>;<\/span>
\n left<\/span>:<\/span> 0<\/span>;<\/span>
\n width<\/span>:<\/span> 50<\/span>px;<\/span>
\n height<\/span>:<\/span> 3<\/span>px;<\/span>
\n background–<\/span>color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>primary–<\/span>color)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn {<\/span>
\n transition<\/span>:<\/span> all 0.3<\/span>s ease;<\/span>
\n font–<\/span>weight<\/span>:<\/span> 500<\/span>;<\/span>
\n padding<\/span>:<\/span> 0.5<\/span>rem 1.25<\/span>rem;<\/span>
\n border–<\/span>radius<\/span>:<\/span> 6<\/span>px;<\/span>
\n display<\/span>:<\/span> inline–<\/span>flex;<\/span>
\n align–<\/span>items<\/span>:<\/span> center;<\/span>
\n gap<\/span>:<\/span> 6<\/span>px;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn–<\/span>success {<\/span>
\n background–<\/span>color<\/span>:<\/span> #10b981;<\/span>
\n border–<\/span>color<\/span>:<\/span> #10b981;<\/span>
\n color<\/span>:<\/span> white;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn–<\/span>success<\/span>:<\/span>hover {<\/span>
\n background–<\/span>color<\/span>:<\/span> #059669;<\/span>
\n border–<\/span>color<\/span>:<\/span> #059669;<\/span>
\n transform<\/span>:<\/span> translateY<\/span>(<\/span>–<\/span>2<\/span>px)<\/span>;<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 4<\/span>px 12<\/span>px rgba<\/span>(<\/span>16<\/span>,<\/span> 185<\/span>,<\/span> 129<\/span>,<\/span> 0.3<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn–<\/span>secondary {<\/span>
\n background–<\/span>color<\/span>:<\/span> #6b7280;<\/span>
\n border–<\/span>color<\/span>:<\/span> #6b7280;<\/span>
\n color<\/span>:<\/span> white;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn–<\/span>secondary<\/span>:<\/span>hover {<\/span>
\n background–<\/span>color<\/span>:<\/span> #4b5563;<\/span>
\n border–<\/span>color<\/span>:<\/span> #4b5563;<\/span>
\n transform<\/span>:<\/span> translateY<\/span>(<\/span>–<\/span>2<\/span>px)<\/span>;<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 4<\/span>px 12<\/span>px rgba<\/span>(<\/span>107<\/span>,<\/span> 114<\/span>,<\/span> 128<\/span>,<\/span> 0.3<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>card {<\/span>
\n background–<\/span>color<\/span>:<\/span> white;<\/span>
\n border–<\/span>radius<\/span>:<\/span> 8<\/span>px;<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 4<\/span>px 6<\/span>px –<\/span>1<\/span>px rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.1<\/span>)<\/span>,<\/span> 0<\/span> 2<\/span>px 4<\/span>px –<\/span>1<\/span>px rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.06<\/span>)<\/span>;<\/span>
\n padding<\/span>:<\/span> 1.5<\/span>rem;<\/span>
\n margin–<\/span>bottom<\/span>:<\/span> 2<\/span>rem;<\/span>
\n }<\/span><\/p>\n

.<\/span>form–<\/span>group {<\/span>
\n margin–<\/span>bottom<\/span>:<\/span> 1.5<\/span>rem;<\/span>
\n }<\/span><\/p>\n

.<\/span>form–<\/span>label {<\/span>
\n font–<\/span>weight<\/span>:<\/span> 500<\/span>;<\/span>
\n margin–<\/span>bottom<\/span>:<\/span> 0.5<\/span>rem;<\/span>
\n display<\/span>:<\/span> block;<\/span>
\n color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>dark–<\/span>color)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>form–<\/span>control {<\/span>
\n width<\/span>:<\/span> 100<\/span>%<\/span>;<\/span>
\n padding<\/span>:<\/span> 0.75<\/span>rem;<\/span>
\n border<\/span>:<\/span> 1<\/span>px solid #d1d5db;<\/span>
\n border–<\/span>radius<\/span>:<\/span> 6<\/span>px;<\/span>
\n transition<\/span>:<\/span> all 0.2<\/span>s ease;<\/span>
\n }<\/span><\/p>\n

.<\/span>form–<\/span>control<\/span>:<\/span>focus {<\/span>
\n outline<\/span>:<\/span> none;<\/span>
\n border–<\/span>color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>primary–<\/span>color)<\/span>;<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 0<\/span> 0<\/span> 3<\/span>px rgba<\/span>(<\/span>37<\/span>,<\/span> 99<\/span>,<\/span> 235<\/span>,<\/span> 0.1<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>has–<\/span>error .<\/span>form–<\/span>control {<\/span>
\n border–<\/span>color<\/span>:<\/span> #ef4444;<\/span>
\n }<\/span><\/p>\n

.<\/span>help–<\/span>block {<\/span>
\n color<\/span>:<\/span> #ef4444;<\/span>
\n font–<\/span>size<\/span>:<\/span> 0.875<\/span>rem;<\/span>
\n margin–<\/span>top<\/span>:<\/span> 0.25<\/span>rem;<\/span>
\n }<\/span><\/p>\n

footer {<\/span>
\n text–<\/span>align<\/span>:<\/span> center;<\/span>
\n padding<\/span>:<\/span> 2<\/span>rem 1<\/span>rem;<\/span>
\n margin–<\/span>top<\/span>:<\/span> 3<\/span>rem;<\/span>
\n color<\/span>:<\/span> #6b7280;<\/span>
\n border–<\/span>top<\/span>:<\/span> 1<\/span>px solid #e5e7eb;<\/span>
\n }<\/span><\/p>\n

@media <\/span>(<\/span>max–<\/span>width<\/span>:<\/span> 768<\/span>px)<\/span> {<\/span>
\n .<\/span>page–<\/span>header {<\/span>
\n flex–<\/span>direction<\/span>:<\/span> column;<\/span>
\n align–<\/span>items<\/span>:<\/span> flex–<\/span>start;<\/span>
\n gap<\/span>:<\/span> 1<\/span>rem;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn–<\/span>group {<\/span>
\n width<\/span>:<\/span> 100<\/span>%<\/span>;<\/span>
\n display<\/span>:<\/span> flex;<\/span>
\n gap<\/span>:<\/span> 0.5<\/span>rem;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn {<\/span>
\n flex<\/span>:<\/span> 1<\/span>;<\/span>
\n justify–<\/span>content<\/span>:<\/span> center;<\/span>
\n }<\/span>
\n }<\/span>
\n <<\/span>\/<\/span>style><\/span>
\n<<\/span>\/<\/span>head><\/span>
\n<<\/span>body><\/span>
\n <<\/span>!<\/span>—<\/span> \u5bfc\u822a\u680f —<\/span>><\/span>
\n <<\/span>nav class<\/span>=<\/span>"navbar navbar-expand-lg"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"container"<\/span>><\/span>
\n <<\/span>a class<\/span>=<\/span>"navbar-brand"<\/span> href=<\/span>"index.php"<\/span>><\/span>
\n <<\/span>i class<\/span>=<\/span>"fas fa-users"<\/span>><\/span><<\/span>\/<\/span>i><\/span>
\n \u5458\u5de5\u7ba1\u7406\u7cfb\u7edf
\n <<\/span>\/<\/span>a><\/span>
\n <<\/span>button class<\/span>=<\/span>"navbar-toggler"<\/span> type=<\/span>"button"<\/span> data–<\/span>bs–<\/span>toggle=<\/span>"collapse"<\/span> data–<\/span>bs–<\/span>target=<\/span>"#navbarNav"<\/span>><\/span>
\n <<\/span>span class<\/span>=<\/span>"navbar-toggler-icon"<\/span>><\/span><<\/span>\/<\/span>span><\/span>
\n <<\/span>\/<\/span>button><\/span>
\n <<\/span>div class<\/span>=<\/span>"collapse navbar-collapse"<\/span> id=<\/span>"navbarNav"<\/span>><\/span>
\n <<\/span>ul class<\/span>=<\/span>"navbar-nav ms-auto"<\/span>><\/span>
\n <<\/span>li class<\/span>=<\/span>"nav-item"<\/span>><\/span>
\n <<\/span>a class<\/span>=<\/span>"nav-link"<\/span> href=<\/span>"index.php"<\/span>><\/span>\u5458\u5de5\u5217\u8868<<\/span>\/<\/span>a><\/span>
\n <<\/span>\/<\/span>li><\/span>
\n <<\/span>li class<\/span>=<\/span>"nav-item"<\/span>><\/span>
\n <<\/span>a class<\/span>=<\/span>"nav-link active"<\/span> href=<\/span>"#"<\/span> aria–<\/span>current=<\/span>"page"<\/span>><\/span>\u6dfb\u52a0\u5458\u5de5<<\/span>\/<\/span>a><\/span>
\n <<\/span>\/<\/span>li><\/span>
\n <<\/span>li class<\/span>=<\/span>"nav-item"<\/span>><\/span>
\n <<\/span>a class<\/span>=<\/span>"nav-link"<\/span> href=<\/span>"#"<\/span>><\/span>\u7cfb\u7edf\u8bbe\u7f6e<<\/span>\/<\/span>a><\/span>
\n <<\/span>\/<\/span>li><\/span>
\n <<\/span>li class<\/span>=<\/span>"nav-item"<\/span>><\/span>
\n <<\/span>a class<\/span>=<\/span>"nav-link"<\/span> href=<\/span>"#"<\/span>><\/span>\u5e2e\u52a9\u4e2d\u5fc3<<\/span>\/<\/span>a><\/span>
\n <<\/span>\/<\/span>li><\/span>
\n <<\/span>\/<\/span>ul><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>nav><\/span><\/p>\n

<<\/span>div class<\/span>=<\/span>"container"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"row"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"col-md-12"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"page-header"<\/span>><\/span>
\n <<\/span>h2><\/span>\u6dfb\u52a0\u5458\u5de5\u8bb0\u5f55<<\/span>\/<\/span>h2><\/span>
\n <<\/span>div class<\/span>=<\/span>"btn-group"<\/span>><\/span>
\n <<\/span>a href=<\/span>"index.php"<\/span> class<\/span>=<\/span>"btn btn-secondary"<\/span>><\/span>
\n <<\/span>i class<\/span>=<\/span>"fas fa-arrow-left"<\/span>><\/span><<\/span>\/<\/span>i><\/span> \u8fd4\u56de\u5217\u8868
\n <<\/span>\/<\/span>a><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span><\/p>\n

<<\/span>div class<\/span>=<\/span>"card"<\/span>><\/span>
\n <<\/span>p><\/span>\u8bf7\u586b\u5199\u8868\u5355\u5e76\u63d0\u4ea4\u4ee5\u6dfb\u52a0\u5458\u5de5\u4fe1\u606f<<\/span>\/<\/span>p><\/span>
\n <<\/span>form action=<\/span>"<?php echo htmlspecialchars($_SERVER<\/span><\/span>["<\/span>PHP_SELF<\/span>"]); ?>"<\/span> method=<\/span>"post"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"form-group <?php echo !empty($name_err<\/span><\/span>) ? 'has-error' : ''; ?>"<\/span>><\/span>
\n <<\/span>label class<\/span>=<\/span>"form-label"<\/span> for<\/span>=<\/span>"name"<\/span>><\/span>\u59d3\u540d<<\/span>\/<\/span>label><\/span>
\n <<\/span>input type=<\/span>"text"<\/span> id=<\/span>"name"<\/span> name=<\/span>"name"<\/span> class<\/span>=<\/span>"form-control"<\/span>
\n value=<\/span>"<?php echo htmlspecialchars($name<\/span><\/span>); ?>"<\/span>><\/span>
\n <<\/span>span class<\/span>=<\/span>"help-block"<\/span>><\/span><<\/span>?<\/span>php echo<\/span> $name_err<\/span>;<\/span> ?<\/span>><\/span><<\/span>\/<\/span>span><\/span>
\n <<\/span>\/<\/span>div><\/span><\/p>\n

<<\/span>div class<\/span>=<\/span>"form-group <?php echo !empty($address_err<\/span><\/span>) ? 'has-error' : ''; ?>"<\/span>><\/span>
\n <<\/span>label class<\/span>=<\/span>"form-label"<\/span> for<\/span>=<\/span>"address"<\/span>><\/span>\u5730\u5740<<\/span>\/<\/span>label><\/span>
\n <<\/span>textarea id=<\/span>"address"<\/span> name=<\/span>"address"<\/span> class<\/span>=<\/span>"form-control"<\/span> rows=<\/span>"3"<\/span>><\/span><<\/span>?<\/span>php echo<\/span> htmlspecialchars<\/span>(<\/span>$address<\/span>)<\/span>;<\/span> ?<\/span>><\/span><<\/span>\/<\/span>textarea><\/span>
\n <<\/span>span class<\/span>=<\/span>"help-block"<\/span>><\/span><<\/span>?<\/span>php echo<\/span> $address_err<\/span>;<\/span> ?<\/span>><\/span><<\/span>\/<\/span>span><\/span>
\n <<\/span>\/<\/span>div><\/span><\/p>\n

<<\/span>div class<\/span>=<\/span>"form-group <?php echo !empty($salary_err<\/span><\/span>) ? 'has-error' : ''; ?>"<\/span>><\/span>
\n <<\/span>label class<\/span>=<\/span>"form-label"<\/span> for<\/span>=<\/span>"salary"<\/span>><\/span>\u85aa\u8d44<<\/span>\/<\/span>label><\/span>
\n <<\/span>input type=<\/span>"text"<\/span> id=<\/span>"salary"<\/span> name=<\/span>"salary"<\/span> class<\/span>=<\/span>"form-control"<\/span>
\n value=<\/span>"<?php echo htmlspecialchars($salary<\/span><\/span>); ?>"<\/span>><\/span>
\n <<\/span>span class<\/span>=<\/span>"help-block"<\/span>><\/span><<\/span>?<\/span>php echo<\/span> $salary_err<\/span>;<\/span> ?<\/span>><\/span><<\/span>\/<\/span>span><\/span>
\n <<\/span>\/<\/span>div><\/span><\/p>\n

<<\/span>div class<\/span>=<\/span>"btn-group"<\/span>><\/span>
\n <<\/span>input type=<\/span>"submit"<\/span> class<\/span>=<\/span>"btn btn-success"<\/span> value=<\/span>"\u63d0\u4ea4\u6dfb\u52a0"<\/span>><\/span>
\n <<\/span>a href=<\/span>"index.php"<\/span> class<\/span>=<\/span>"btn btn-secondary"<\/span>><\/span>\u53d6\u6d88<<\/span>\/<\/span>a><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>form><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span><\/p>\n

<<\/span>!<\/span>—<\/span> \u9875\u811a —<\/span>><\/span>
\n <<\/span>footer><\/span>
\n <<\/span>div class<\/span>=<\/span>"container"<\/span>><\/span>
\n <<\/span>p><\/span>&<\/span>copy;<\/span> <<\/span>?<\/span>php echo<\/span> date<\/span>(<\/span>"Y"<\/span>)<\/span>;<\/span> ?<\/span>><\/span> \u5458\u5de5\u7ba1\u7406\u7cfb\u7edf –<\/span> \u7248\u6743\u6240\u6709<<\/span>\/<\/span>p><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>footer><\/span><\/p>\n

<<\/span>script src=<\/span>"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.3.0-alpha1\/dist\/js\/bootstrap.bundle.min.js"<\/span>><\/span><<\/span>\/<\/span>script><\/span>
\n <<\/span>script><\/span>
\n document.<\/span>addEventListener<\/span>(<\/span>'DOMContentLoaded'<\/span>,<\/span> function<\/span>(<\/span>)<\/span> {<\/span>
\n \/\/ \u8f93\u5165\u6846\u7126\u70b9\u6548\u679c<\/span>
\n const<\/span> formInputs =<\/span> document.<\/span>querySelectorAll<\/span>(<\/span>'.form-control'<\/span>)<\/span>;<\/span>
\n formInputs.<\/span>forEach<\/span>(<\/span>input =><\/span> {<\/span>
\n input.<\/span>addEventListener<\/span>(<\/span>'focus'<\/span>,<\/span> function<\/span>(<\/span>)<\/span> {<\/span>
\n this.<\/span>parentElement.<\/span>classList.<\/span>add<\/span>(<\/span>'focused'<\/span>)<\/span>;<\/span>
\n }<\/span>)<\/span>;<\/span>
\n input.<\/span>addEventListener<\/span>(<\/span>'blur'<\/span>,<\/span> function<\/span>(<\/span>)<\/span> {<\/span>
\n this.<\/span>parentElement.<\/span>classList.<\/span>remove<\/span>(<\/span>'focused'<\/span>)<\/span>;<\/span>
\n }<\/span>)<\/span>;<\/span>
\n }<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u8868\u5355\u9a8c\u8bc1\u589e\u5f3a – \u5b9e\u65f6\u68c0\u67e5\u5fc5\u586b\u9879<\/span>
\n const<\/span> form =<\/span> document.<\/span>querySelector<\/span>(<\/span>'form'<\/span>)<\/span>;<\/span>
\n form.<\/span>addEventListener<\/span>(<\/span>'submit'<\/span>,<\/span> function<\/span>(<\/span>e)<\/span> {<\/span>
\n let isValid =<\/span> true<\/span>;<\/span><\/p>\n

\/\/ \u7b80\u5355\u9a8c\u8bc1\u793a\u4f8b<\/span>
\n if<\/span> (<\/span>!<\/span>document.<\/span>getElementById<\/span>(<\/span>'name'<\/span>)<\/span>.<\/span>value.<\/span>trim<\/span>(<\/span>)<\/span>)<\/span> {<\/span>
\n isValid =<\/span> false<\/span>;<\/span>
\n }<\/span><\/p>\n

if<\/span> (<\/span>!<\/span>isValid)<\/span> {<\/span>
\n e.<\/span>preventDefault<\/span>(<\/span>)<\/span>;<\/span>
\n \/\/ \u53ef\u4ee5\u6dfb\u52a0\u66f4\u53cb\u597d\u7684\u9519\u8bef\u63d0\u793a\u52a8\u753b<\/span>
\n document.<\/span>querySelector<\/span>(<\/span>'.has-error'<\/span>)<\/span>?<\/span>.<\/span>scrollIntoView<\/span>(<\/span>{<\/span> behavior<\/span>:<\/span> 'smooth'<\/span>,<\/span> block<\/span>:<\/span> 'center'<\/span> }<\/span>)<\/span>;<\/span>
\n }<\/span>
\n }<\/span>)<\/span>;<\/span>
\n }<\/span>)<\/span>;<\/span>
\n <<\/span>\/<\/span>script><\/span>
\n<<\/span>\/<\/span>body><\/span>
\n<<\/span>\/<\/span>html><\/span><\/p>\n

3. \u67e5\u770b\u5458\u5de5\u8be6\u60c5（read.php）<\/h6>\n

\u6839\u636e ID \u67e5\u8be2\u5e76\u5c55\u793a\u5355\u4e2a\u5458\u5de5\u7684\u8be6\u7ec6\u4fe1\u606f：<\/p>\n

<<\/span>!<\/span>DOCTYPE<\/span> html><\/span>
\n<<\/span>html lang=<\/span>"zh-CN"<\/span>><\/span>
\n<<\/span>head><\/span>
\n <<\/span>meta charset=<\/span>"UTF-8"<\/span>><\/span>
\n <<\/span>meta name=<\/span>"viewport"<\/span> content=<\/span>"width=device-width, initial-scale=1.0"<\/span>><\/span>
\n <<\/span>title><\/span>\u67e5\u770b\u5458\u5de5\u8be6\u60c5<<\/span>\/<\/span>title><\/span>
\n <<\/span>link href=<\/span>"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.3.0-alpha1\/dist\/css\/bootstrap.min.css"<\/span> rel=<\/span>"stylesheet"<\/span>><\/span>
\n <<\/span>link rel=<\/span>"stylesheet"<\/span> href=<\/span>"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/font-awesome\/6.0.0\/css\/all.min.css"<\/span>><\/span>
\n <<\/span>style><\/span>
\n :<\/span>root {<\/span>
\n —<\/span>primary–<\/span>color<\/span>:<\/span> #2563eb;<\/span>
\n —<\/span>secondary–<\/span>color<\/span>:<\/span> #4f46e5;<\/span>
\n —<\/span>accent–<\/span>color<\/span>:<\/span> #f59e0b;<\/span>
\n —<\/span>light–<\/span>color<\/span>:<\/span> #f3f4f6;<\/span>
\n —<\/span>dark–<\/span>color<\/span>:<\/span> #1f2937;<\/span>
\n }<\/span><\/p>\n

body {<\/span>
\n font–<\/span>family<\/span>:<\/span> 'Segoe UI'<\/span>,<\/span> Tahoma,<\/span> Geneva,<\/span> Verdana,<\/span> sans–<\/span>serif;<\/span>
\n background–<\/span>color<\/span>:<\/span> #f8fafc;<\/span>
\n color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>dark–<\/span>color)<\/span>;<\/span>
\n line–<\/span>height<\/span>:<\/span> 1.6<\/span>;<\/span>
\n min–<\/span>height<\/span>:<\/span> 100<\/span>vh;<\/span>
\n display<\/span>:<\/span> flex;<\/span>
\n flex–<\/span>direction<\/span>:<\/span> column;<\/span>
\n }<\/span><\/p>\n

\/* \u5bfc\u822a\u680f\u6837\u5f0f *\/<\/span>
\n .<\/span>navbar {<\/span>
\n background–<\/span>color<\/span>:<\/span> white;<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 2<\/span>px 10<\/span>px rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.05<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>navbar–<\/span>brand {<\/span>
\n font–<\/span>weight<\/span>:<\/span> 700<\/span>;<\/span>
\n color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>primary–<\/span>color)<\/span>;<\/span>
\n font–<\/span>size<\/span>:<\/span> 1.5<\/span>rem;<\/span>
\n display<\/span>:<\/span> flex;<\/span>
\n align–<\/span>items<\/span>:<\/span> center;<\/span>
\n gap<\/span>:<\/span> 8<\/span>px;<\/span>
\n }<\/span><\/p>\n

.<\/span>navbar–<\/span>brand i {<\/span>
\n font–<\/span>size<\/span>:<\/span> 1.8<\/span>rem;<\/span>
\n }<\/span><\/p>\n

\/* \u4e3b\u5bb9\u5668\u6837\u5f0f *\/<\/span>
\n .<\/span>container {<\/span>
\n max–<\/span>width<\/span>:<\/span> 800<\/span>px;<\/span>
\n margin<\/span>:<\/span> 0<\/span> auto;<\/span>
\n padding<\/span>:<\/span> 2<\/span>rem 1<\/span>rem;<\/span>
\n flex<\/span>:<\/span> 1<\/span>;<\/span>
\n }<\/span><\/p>\n

\/* \u9875\u9762\u5934\u90e8\u6837\u5f0f *\/<\/span>
\n .<\/span>page–<\/span>header {<\/span>
\n margin–<\/span>bottom<\/span>:<\/span> 2<\/span>rem;<\/span>
\n padding–<\/span>bottom<\/span>:<\/span> 1<\/span>rem;<\/span>
\n border–<\/span>bottom<\/span>:<\/span> 1<\/span>px solid #e5e7eb;<\/span>
\n position<\/span>:<\/span> relative;<\/span>
\n }<\/span><\/p>\n

.<\/span>page–<\/span>header h1 {<\/span>
\n margin<\/span>:<\/span> 0<\/span>;<\/span>
\n font–<\/span>weight<\/span>:<\/span> 700<\/span>;<\/span>
\n color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>dark–<\/span>color)<\/span>;<\/span>
\n position<\/span>:<\/span> relative;<\/span>
\n padding–<\/span>bottom<\/span>:<\/span> 0.5<\/span>rem;<\/span>
\n }<\/span><\/p>\n

.<\/span>page–<\/span>header h1<\/span>::<\/span>after {<\/span>
\n content<\/span>:<\/span> ''<\/span>;<\/span>
\n position<\/span>:<\/span> absolute;<\/span>
\n bottom<\/span>:<\/span> 0<\/span>;<\/span>
\n left<\/span>:<\/span> 0<\/span>;<\/span>
\n width<\/span>:<\/span> 50<\/span>px;<\/span>
\n height<\/span>:<\/span> 3<\/span>px;<\/span>
\n background–<\/span>color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>primary–<\/span>color)<\/span>;<\/span>
\n }<\/span><\/p>\n

\/* \u8be6\u60c5\u5361\u7247\u6837\u5f0f *\/<\/span>
\n .<\/span>detail–<\/span>card {<\/span>
\n background–<\/span>color<\/span>:<\/span> white;<\/span>
\n border–<\/span>radius<\/span>:<\/span> 10<\/span>px;<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 4<\/span>px 6<\/span>px –<\/span>1<\/span>px rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.1<\/span>)<\/span>,<\/span> 0<\/span> 2<\/span>px 4<\/span>px –<\/span>1<\/span>px rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.06<\/span>)<\/span>;<\/span>
\n overflow<\/span>:<\/span> hidden;<\/span>
\n transition<\/span>:<\/span> all 0.3<\/span>s ease;<\/span>
\n }<\/span><\/p>\n

.<\/span>detail–<\/span>card<\/span>:<\/span>hover {<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 10<\/span>px 15<\/span>px –<\/span>3<\/span>px rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.1<\/span>)<\/span>,<\/span> 0<\/span> 4<\/span>px 6<\/span>px –<\/span>2<\/span>px rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.05<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>card–<\/span>header {<\/span>
\n background–<\/span>color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>light–<\/span>color)<\/span>;<\/span>
\n padding<\/span>:<\/span> 1.5<\/span>rem;<\/span>
\n border–<\/span>bottom<\/span>:<\/span> 1<\/span>px solid #e5e7eb;<\/span>
\n }<\/span><\/p>\n

.<\/span>card–<\/span>header h2 {<\/span>
\n margin<\/span>:<\/span> 0<\/span>;<\/span>
\n font–<\/span>size<\/span>:<\/span> 1.5<\/span>rem;<\/span>
\n font–<\/span>weight<\/span>:<\/span> 600<\/span>;<\/span>
\n color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>primary–<\/span>color)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>card–<\/span>body {<\/span>
\n padding<\/span>:<\/span> 2<\/span>rem;<\/span>
\n }<\/span><\/p>\n

\/* \u4fe1\u606f\u9879\u6837\u5f0f *\/<\/span>
\n .<\/span>info–<\/span>item {<\/span>
\n margin–<\/span>bottom<\/span>:<\/span> 1.5<\/span>rem;<\/span>
\n padding–<\/span>bottom<\/span>:<\/span> 1.5<\/span>rem;<\/span>
\n border–<\/span>bottom<\/span>:<\/span> 1<\/span>px solid #f1f5f9;<\/span>
\n display<\/span>:<\/span> flex;<\/span>
\n align–<\/span>items<\/span>:<\/span> flex–<\/span>start;<\/span>
\n }<\/span><\/p>\n

.<\/span>info–<\/span>item<\/span>:<\/span>last–<\/span>child {<\/span>
\n border–<\/span>bottom<\/span>:<\/span> none;<\/span>
\n margin–<\/span>bottom<\/span>:<\/span> 0<\/span>;<\/span>
\n padding–<\/span>bottom<\/span>:<\/span> 0<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>info–<\/span>label {<\/span>
\n flex<\/span>:<\/span> 0<\/span> 0<\/span> 120<\/span>px;<\/span>
\n font–<\/span>weight<\/span>:<\/span> 600<\/span>;<\/span>
\n color<\/span>:<\/span> #64748b;<\/span>
\n display<\/span>:<\/span> flex;<\/span>
\n align–<\/span>items<\/span>:<\/span> center;<\/span>
\n gap<\/span>:<\/span> 8<\/span>px;<\/span>
\n }<\/span><\/p>\n

.<\/span>info–<\/span>value {<\/span>
\n flex<\/span>:<\/span> 1<\/span>;<\/span>
\n padding–<\/span>left<\/span>:<\/span> 1<\/span>rem;<\/span>
\n word–<\/span>break<\/span>:<\/span> break<\/span>–<\/span>word;<\/span>
\n }<\/span><\/p>\n

.<\/span>info–<\/span>icon {<\/span>
\n color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>primary–<\/span>color)<\/span>;<\/span>
\n width<\/span>:<\/span> 20<\/span>px;<\/span>
\n text–<\/span>align<\/span>:<\/span> center;<\/span>
\n }<\/span><\/p>\n

\/* \u6309\u94ae\u6837\u5f0f *\/<\/span>
\n .<\/span>btn {<\/span>
\n transition<\/span>:<\/span> all 0.3<\/span>s ease;<\/span>
\n font–<\/span>weight<\/span>:<\/span> 500<\/span>;<\/span>
\n padding<\/span>:<\/span> 0.5<\/span>rem 1.25<\/span>rem;<\/span>
\n border–<\/span>radius<\/span>:<\/span> 6<\/span>px;<\/span>
\n display<\/span>:<\/span> inline–<\/span>flex;<\/span>
\n align–<\/span>items<\/span>:<\/span> center;<\/span>
\n gap<\/span>:<\/span> 6<\/span>px;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn–<\/span>primary {<\/span>
\n background–<\/span>color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>primary–<\/span>color)<\/span>;<\/span>
\n border–<\/span>color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>primary–<\/span>color)<\/span>;<\/span>
\n color<\/span>:<\/span> white;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn–<\/span>primary<\/span>:<\/span>hover {<\/span>
\n background–<\/span>color<\/span>:<\/span> #1d4ed8;<\/span>
\n border–<\/span>color<\/span>:<\/span> #1d4ed8;<\/span>
\n transform<\/span>:<\/span> translateY<\/span>(<\/span>–<\/span>2<\/span>px)<\/span>;<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 4<\/span>px 12<\/span>px rgba<\/span>(<\/span>37<\/span>,<\/span> 99<\/span>,<\/span> 235<\/span>,<\/span> 0.3<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn–<\/span>group {<\/span>
\n margin–<\/span>top<\/span>:<\/span> 2<\/span>rem;<\/span>
\n display<\/span>:<\/span> flex;<\/span>
\n gap<\/span>:<\/span> 1<\/span>rem;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn–<\/span>edit {<\/span>
\n background–<\/span>color<\/span>:<\/span> #10b981;<\/span>
\n border–<\/span>color<\/span>:<\/span> #10b981;<\/span>
\n color<\/span>:<\/span> white;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn–<\/span>edit<\/span>:<\/span>hover {<\/span>
\n background–<\/span>color<\/span>:<\/span> #059669;<\/span>
\n border–<\/span>color<\/span>:<\/span> #059669;<\/span>
\n transform<\/span>:<\/span> translateY<\/span>(<\/span>–<\/span>2<\/span>px)<\/span>;<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 4<\/span>px 12<\/span>px rgba<\/span>(<\/span>16<\/span>,<\/span> 185<\/span>,<\/span> 129<\/span>,<\/span> 0.3<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn–<\/span>delete {<\/span>
\n background–<\/span>color<\/span>:<\/span> #ef4444;<\/span>
\n border–<\/span>color<\/span>:<\/span> #ef4444;<\/span>
\n color<\/span>:<\/span> white;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn–<\/span>delete<\/span>:<\/span>hover {<\/span>
\n background–<\/span>color<\/span>:<\/span> #dc2626;<\/span>
\n border–<\/span>color<\/span>:<\/span> #dc2626;<\/span>
\n transform<\/span>:<\/span> translateY<\/span>(<\/span>–<\/span>2<\/span>px)<\/span>;<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 4<\/span>px 12<\/span>px rgba<\/span>(<\/span>239<\/span>,<\/span> 68<\/span>,<\/span> 68<\/span>,<\/span> 0.3<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

\/* \u9875\u811a\u6837\u5f0f *\/<\/span>
\n footer {<\/span>
\n text–<\/span>align<\/span>:<\/span> center;<\/span>
\n padding<\/span>:<\/span> 2<\/span>rem 1<\/span>rem;<\/span>
\n margin–<\/span>top<\/span>:<\/span> 3<\/span>rem;<\/span>
\n color<\/span>:<\/span> #6b7280;<\/span>
\n border–<\/span>top<\/span>:<\/span> 1<\/span>px solid #e5e7eb;<\/span>
\n }<\/span><\/p>\n

\/* \u54cd\u5e94\u5f0f\u8bbe\u8ba1 *\/<\/span>
\n @media <\/span>(<\/span>max–<\/span>width<\/span>:<\/span> 576<\/span>px)<\/span> {<\/span>
\n .<\/span>info–<\/span>item {<\/span>
\n flex–<\/span>direction<\/span>:<\/span> column;<\/span>
\n }<\/span><\/p>\n

.<\/span>info–<\/span>label {<\/span>
\n margin–<\/span>bottom<\/span>:<\/span> 0.5<\/span>rem;<\/span>
\n }<\/span><\/p>\n

.<\/span>info–<\/span>value {<\/span>
\n padding–<\/span>left<\/span>:<\/span> 0<\/span>;<\/span>
\n padding–<\/span>left<\/span>:<\/span> 28<\/span>px;<\/span> \/* \u4e0e\u56fe\u6807\u5bf9\u9f50 *\/<\/span>
\n }<\/span><\/p>\n

.<\/span>btn–<\/span>group {<\/span>
\n flex–<\/span>direction<\/span>:<\/span> column;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn {<\/span>
\n width<\/span>:<\/span> 100<\/span>%<\/span>;<\/span>
\n justify–<\/span>content<\/span>:<\/span> center;<\/span>
\n }<\/span>
\n }<\/span>
\n <<\/span>\/<\/span>style><\/span>
\n<<\/span>\/<\/span>head><\/span>
\n<<\/span>body><\/span>
\n <<\/span>!<\/span>—<\/span> \u5bfc\u822a\u680f —<\/span>><\/span>
\n <<\/span>nav class<\/span>=<\/span>"navbar navbar-expand-lg"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"container"<\/span>><\/span>
\n <<\/span>a class<\/span>=<\/span>"navbar-brand"<\/span> href=<\/span>"index.php"<\/span>><\/span>
\n <<\/span>i class<\/span>=<\/span>"fas fa-users"<\/span>><\/span><<\/span>\/<\/span>i><\/span>
\n \u5458\u5de5\u7ba1\u7406\u7cfb\u7edf
\n <<\/span>\/<\/span>a><\/span>
\n <<\/span>button class<\/span>=<\/span>"navbar-toggler"<\/span> type=<\/span>"button"<\/span> data–<\/span>bs–<\/span>toggle=<\/span>"collapse"<\/span> data–<\/span>bs–<\/span>target=<\/span>"#navbarNav"<\/span>><\/span>
\n <<\/span>span class<\/span>=<\/span>"navbar-toggler-icon"<\/span>><\/span><<\/span>\/<\/span>span><\/span>
\n <<\/span>\/<\/span>button><\/span>
\n <<\/span>div class<\/span>=<\/span>"collapse navbar-collapse"<\/span> id=<\/span>"navbarNav"<\/span>><\/span>
\n <<\/span>ul class<\/span>=<\/span>"navbar-nav ms-auto"<\/span>><\/span>
\n <<\/span>li class<\/span>=<\/span>"nav-item"<\/span>><\/span>
\n <<\/span>a class<\/span>=<\/span>"nav-link"<\/span> href=<\/span>"index.php"<\/span>><\/span>\u5458\u5de5\u5217\u8868<<\/span>\/<\/span>a><\/span>
\n <<\/span>\/<\/span>li><\/span>
\n <<\/span>li class<\/span>=<\/span>"nav-item"<\/span>><\/span>
\n <<\/span>a class<\/span>=<\/span>"nav-link active"<\/span> href=<\/span>"#"<\/span> aria–<\/span>current=<\/span>"page"<\/span>><\/span>\u5458\u5de5\u8be6\u60c5<<\/span>\/<\/span>a><\/span>
\n <<\/span>\/<\/span>li><\/span>
\n <<\/span>li class<\/span>=<\/span>"nav-item"<\/span>><\/span>
\n <<\/span>a class<\/span>=<\/span>"nav-link"<\/span> href=<\/span>"#"<\/span>><\/span>\u5e2e\u52a9\u4e2d\u5fc3<<\/span>\/<\/span>a><\/span>
\n <<\/span>\/<\/span>li><\/span>
\n <<\/span>\/<\/span>ul><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>nav><\/span><\/p>\n

<<\/span>div class<\/span>=<\/span>"container"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"row"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"col-md-12"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"page-header"<\/span>><\/span>
\n <<\/span>h1><\/span>\u5458\u5de5\u8be6\u60c5<<\/span>\/<\/span>h1><\/span>
\n <<\/span>\/<\/span>div><\/span><\/p>\n

<<\/span>div class<\/span>=<\/span>"detail-card"<\/span>><\/span>
\n <<\/span>?<\/span>php
\n \/\/ \u9a8c\u8bc1ID\u53c2\u6570<\/span>
\n if<\/span> (<\/span>!<\/span>isset<\/span>(<\/span>$_GET<\/span>[<\/span>"id"<\/span>]<\/span>)<\/span> ||<\/span> empty<\/span>(<\/span>trim<\/span>(<\/span>$_GET<\/span>[<\/span>"id"<\/span>]<\/span>)<\/span>)<\/span>)<\/span> {<\/span>
\n header<\/span>(<\/span>"location: error.php"<\/span>)<\/span>;<\/span>
\n exit<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

require_once<\/span> "config.php"<\/span>;<\/span><\/p>\n

$id<\/span> =<\/span> trim<\/span>(<\/span>$_GET<\/span>[<\/span>"id"<\/span>]<\/span>)<\/span>;<\/span>
\n $employee<\/span> =<\/span> null<\/span>;<\/span><\/p>\n

try<\/span> {<\/span>
\n \/\/ \u68c0\u67e5\u6570\u636e\u5e93\u8fde\u63a5<\/span>
\n if<\/span> (<\/span>$link<\/span>-><\/span>connect_error<\/span>)<\/span> {<\/span>
\n throw<\/span> new<\/span> mysqli_sql_exception<\/span>(<\/span>"\u6570\u636e\u5e93\u8fde\u63a5\u5931\u8d25: "<\/span> .<\/span> $link<\/span>-><\/span>connect_error<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

\/\/ \u9884\u5904\u7406\u67e5\u8be2（\u9632\u6ce8\u5165）<\/span>
\n $sql<\/span> =<\/span> "SELECT * FROM employees WHERE id = ?"<\/span>;<\/span>
\n $stmt<\/span> =<\/span> $link<\/span>-><\/span>prepare<\/span>(<\/span>$sql<\/span>)<\/span>;<\/span><\/p>\n

if<\/span> (<\/span>!<\/span>$stmt<\/span>)<\/span> {<\/span>
\n throw<\/span> new<\/span> mysqli_sql_exception<\/span>(<\/span>"\u9884\u5904\u7406\u8bed\u53e5\u51c6\u5907\u5931\u8d25: "<\/span> .<\/span> $link<\/span>-><\/span>error<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

$stmt<\/span>-><\/span>bind_param<\/span>(<\/span>"i"<\/span>,<\/span> $id<\/span>)<\/span>;<\/span>
\n $stmt<\/span>-><\/span>execute<\/span>(<\/span>)<\/span>;<\/span>
\n $result<\/span> =<\/span> $stmt<\/span>-><\/span>get_result<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

if<\/span> (<\/span>$result<\/span>-><\/span>num_rows<\/span> ===<\/span> 1<\/span>)<\/span> {<\/span>
\n $employee<\/span> =<\/span> $result<\/span>-><\/span>fetch_assoc<\/span>(<\/span>)<\/span>;<\/span> \/\/ \u83b7\u53d6\u5458\u5de5\u6570\u636e<\/span>
\n }<\/span> else<\/span> {<\/span>
\n header<\/span>(<\/span>"location: error.php"<\/span>)<\/span>;<\/span> \/\/ \u65e0\u5339\u914d\u8bb0\u5f55<\/span>
\n exit<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span>
\n }<\/span> catch<\/span> (<\/span>mysqli_sql_exception<\/span> $e<\/span>)<\/span> {<\/span>
\n echo<\/span> "<div class='alert alert-danger'>\u67e5\u8be2\u9519\u8bef: "<\/span> .<\/span> htmlspecialchars<\/span>(<\/span>$e<\/span>-><\/span>getMessage<\/span>(<\/span>)<\/span>,<\/span> ENT_QUOTES<\/span>)<\/span> .<\/span> "<\/div>"<\/span>;<\/span>
\n $employee<\/span> =<\/span> null<\/span>;<\/span>
\n }<\/span> finally<\/span> {<\/span>
\n if<\/span> (<\/span>isset<\/span>(<\/span>$stmt<\/span>)<\/span> &&<\/span> $stmt<\/span>)<\/span> {<\/span>
\n $stmt<\/span>-><\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span>
\n if<\/span> (<\/span>isset<\/span>(<\/span>$link<\/span>)<\/span> &&<\/span> $link<\/span>)<\/span> {<\/span>
\n $link<\/span>-><\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span>
\n }<\/span>
\n ?<\/span>><\/span><\/p>\n

<<\/span>?<\/span>php if<\/span> (<\/span>$employee<\/span>)<\/span>:<\/span> ?<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"card-header"<\/span>><\/span>
\n <<\/span>h2><\/span><<\/span>?<\/span>php echo<\/span> htmlspecialchars<\/span>(<\/span>$employee<\/span>[<\/span>'name'<\/span>]<\/span>,<\/span> ENT_QUOTES<\/span>)<\/span>;<\/span> ?<\/span>><\/span> \u7684\u8be6\u7ec6\u4fe1\u606f<<\/span>\/<\/span>h2><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>div class<\/span>=<\/span>"card-body"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"info-item"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"info-label"<\/span>><\/span>
\n <<\/span>i class<\/span>=<\/span>"fas fa-id-card info-icon"<\/span>><\/span><<\/span>\/<\/span>i><\/span>
\n \u5458\u5de5ID<\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>div class<\/span>=<\/span>"info-value"<\/span>><\/span>
\n <<\/span>?<\/span>php echo<\/span> htmlspecialchars<\/span>(<\/span>$employee<\/span>[<\/span>'id'<\/span>]<\/span>,<\/span> ENT_QUOTES<\/span>)<\/span>;<\/span> ?<\/span>><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span><\/p>\n

<<\/span>div class<\/span>=<\/span>"info-item"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"info-label"<\/span>><\/span>
\n <<\/span>i class<\/span>=<\/span>"fas fa-user info-icon"<\/span>><\/span><<\/span>\/<\/span>i><\/span>
\n \u59d3\u540d
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>div class<\/span>=<\/span>"info-value"<\/span>><\/span>
\n <<\/span>?<\/span>php echo<\/span> htmlspecialchars<\/span>(<\/span>$employee<\/span>[<\/span>'name'<\/span>]<\/span>,<\/span> ENT_QUOTES<\/span>)<\/span>;<\/span> ?<\/span>><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span><\/p>\n

<<\/span>div class<\/span>=<\/span>"info-item"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"info-label"<\/span>><\/span>
\n <<\/span>i class<\/span>=<\/span>"fas fa-map-marker-alt info-icon"<\/span>><\/span><<\/span>\/<\/span>i><\/span>
\n \u5730\u5740
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>div class<\/span>=<\/span>"info-value"<\/span>><\/span>
\n <<\/span>?<\/span>php echo<\/span> htmlspecialchars<\/span>(<\/span>$employee<\/span>[<\/span>'address'<\/span>]<\/span>,<\/span> ENT_QUOTES<\/span>)<\/span>;<\/span> ?<\/span>><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span><\/p>\n

<<\/span>div class<\/span>=<\/span>"info-item"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"info-label"<\/span>><\/span>
\n <<\/span>i class<\/span>=<\/span>"fas fa-money info-icon"<\/span>><\/span><<\/span>\/<\/span>i><\/span>
\n \u85aa\u8d44
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>div class<\/span>=<\/span>"info-value"<\/span>><\/span>
\n <<\/span>?<\/span>php echo<\/span> number_format<\/span>(<\/span>(<\/span>float<\/span>)<\/span>$employee<\/span>[<\/span>'salary'<\/span>]<\/span>,<\/span> 2<\/span>)<\/span>;<\/span> ?<\/span>><\/span> \u5143
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span><\/p>\n

<<\/span>div class<\/span>=<\/span>"info-item"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"info-label"<\/span>><\/span>
\n <<\/span>i class<\/span>=<\/span>"fas fa-calendar info-icon"<\/span>><\/span><<\/span>\/<\/span>i><\/span>
\n \u521b\u5efa\u65f6\u95f4
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>div class<\/span>=<\/span>"info-value"<\/span>><\/span>
\n <<\/span>?<\/span>php echo<\/span> htmlspecialchars<\/span>(<\/span>$employee<\/span>[<\/span>'created_at'<\/span>]<\/span>,<\/span> ENT_QUOTES<\/span>)<\/span>;<\/span> ?<\/span>><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span><\/p>\n

<<\/span>div class<\/span>=<\/span>"btn-group"<\/span>><\/span>
\n <<\/span>a href=<\/span>"index.php"<\/span> class<\/span>=<\/span>"btn btn-primary"<\/span>><\/span>
\n <<\/span>i class<\/span>=<\/span>"fas fa-arrow-left"<\/span>><\/span><<\/span>\/<\/span>i><\/span> \u8fd4\u56de\u5217\u8868
\n <<\/span>\/<\/span>a><\/span>
\n <<\/span>a href=<\/span>"update.php?id=<?php echo htmlspecialchars($employee<\/span>[<\/span>'id'<\/span>]<\/span><\/span>, ENT_QUOTES); ?>"<\/span> class<\/span>=<\/span>"btn btn-edit"<\/span>><\/span>
\n <<\/span>i class<\/span>=<\/span>"fas fa-edit"<\/span>><\/span><<\/span>\/<\/span>i><\/span> \u7f16\u8f91\u4fe1\u606f
\n <<\/span>\/<\/span>a><\/span>
\n <<\/span>a href=<\/span>"delete.php?id=<?php echo htmlspecialchars($employee<\/span>[<\/span>'id'<\/span>]<\/span><\/span>, ENT_QUOTES); ?>"<\/span> class<\/span>=<\/span>"btn btn-delete"<\/span> onclick=<\/span>"return confirm('\u786e\u5b9a\u8981\u5220\u9664\u8fd9\u540d\u5458\u5de5\u5417？\u6b64\u64cd\u4f5c\u4e0d\u53ef\u6062\u590d\u3002')"<\/span>><\/span>
\n <<\/span>i class<\/span>=<\/span>"fas fa-trash"<\/span>><\/span><<\/span>\/<\/span>i><\/span> \u5220\u9664\u5458\u5de5
\n <<\/span>\/<\/span>a><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>?<\/span>php else<\/span>:<\/span> ?<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"card-body"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"alert alert-danger"<\/span>><\/span>\u65e0\u6cd5\u52a0\u8f7d\u5458\u5de5\u4fe1\u606f，\u8bf7\u7a0d\u540e\u91cd\u8bd5\u3002<<\/span>\/<\/span>div><\/span>
\n <<\/span>a href=<\/span>"index.php"<\/span> class<\/span>=<\/span>"btn btn-primary"<\/span>><\/span>
\n <<\/span>i class<\/span>=<\/span>"fas fa-arrow-left"<\/span>><\/span><<\/span>\/<\/span>i><\/span> \u8fd4\u56de\u5217\u8868
\n <<\/span>\/<\/span>a><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>?<\/span>php endif<\/span>;<\/span> ?<\/span>><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span><\/p>\n

<<\/span>!<\/span>—<\/span> \u9875\u811a —<\/span>><\/span>
\n <<\/span>footer><\/span>
\n <<\/span>div class<\/span>=<\/span>"container"<\/span>><\/span>
\n <<\/span>p><\/span>&<\/span>copy;<\/span> <<\/span>?<\/span>php echo<\/span> date<\/span>(<\/span>"Y"<\/span>)<\/span>;<\/span> ?<\/span>><\/span> \u5458\u5de5\u7ba1\u7406\u7cfb\u7edf –<\/span> \u7248\u6743\u6240\u6709<<\/span>\/<\/span>p><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>footer><\/span><\/p>\n

<<\/span>script src=<\/span>"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.3.0-alpha1\/dist\/js\/bootstrap.bundle.min.js"<\/span>><\/span><<\/span>\/<\/span>script><\/span>
\n <<\/span>script><\/span>
\n document.<\/span>addEventListener<\/span>(<\/span>'DOMContentLoaded'<\/span>,<\/span> function<\/span>(<\/span>)<\/span> {<\/span>
\n \/\/ \u6dfb\u52a0\u9875\u9762\u52a0\u8f7d\u52a8\u753b\u6548\u679c<\/span>
\n document.<\/span>body.<\/span>classList.<\/span>add<\/span>(<\/span>'loaded'<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u4e3a\u5361\u7247\u6dfb\u52a0\u6de1\u5165\u6548\u679c<\/span>
\n setTimeout<\/span>(<\/span>(<\/span>)<\/span> =><\/span> {<\/span>
\n document.<\/span>querySelector<\/span>(<\/span>'.detail-card'<\/span>)<\/span>.<\/span>style.<\/span>opacity =<\/span> '1'<\/span>;<\/span>
\n document.<\/span>querySelector<\/span>(<\/span>'.detail-card'<\/span>)<\/span>.<\/span>style.<\/span>transform =<\/span> 'translateY(0)'<\/span>;<\/span>
\n }<\/span>,<\/span> 100<\/span>)<\/span>;<\/span>
\n }<\/span>)<\/span>;<\/span>
\n <<\/span>\/<\/span>script><\/span>
\n<<\/span>\/<\/span>body><\/span>
\n<<\/span>\/<\/span>html><\/span><\/p>\n

4. \u66f4\u65b0\u5458\u5de5\u4fe1\u606f（update.php）<\/h6>\n

\u7f16\u8f91\u73b0\u6709\u5458\u5de5\u6570\u636e，\u5305\u542b\u6570\u636e\u56de\u663e\u548c\u9884\u5904\u7406\u66f4\u65b0：<\/p>\n

<?php<\/span>
\nrequire_once<\/span> "config.php"<\/span>;<\/span><\/p>\n

$id<\/span> =<\/span> $name<\/span> =<\/span> $address<\/span> =<\/span> $salary<\/span> =<\/span> ""<\/span>;<\/span>
\n$name_err<\/span> =<\/span> $address_err<\/span> =<\/span> $salary_err<\/span> =<\/span> ""<\/span>;<\/span><\/p>\n

\/\/ \u5904\u7406\u8868\u5355\u63d0\u4ea4<\/span>
\nif<\/span> (<\/span>$_SERVER<\/span>[<\/span>"REQUEST_METHOD"<\/span>]<\/span> ===<\/span> "POST"<\/span>)<\/span> {<\/span>
\n if<\/span> (<\/span>!<\/span>isset<\/span>(<\/span>$_POST<\/span>[<\/span>"id"<\/span>]<\/span>)<\/span> ||<\/span> empty<\/span>(<\/span>trim<\/span>(<\/span>$_POST<\/span>[<\/span>"id"<\/span>]<\/span>)<\/span>)<\/span>)<\/span> {<\/span>
\n header<\/span>(<\/span>"location: error.php"<\/span>)<\/span>;<\/span>
\n exit<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span>
\n $id<\/span> =<\/span> trim<\/span>(<\/span>$_POST<\/span>[<\/span>"id"<\/span>]<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u9a8c\u8bc1\u59d3\u540d<\/span>
\n $input_name<\/span> =<\/span> trim<\/span>(<\/span>$_POST<\/span>[<\/span>"name"<\/span>]<\/span>)<\/span>;<\/span>
\n if<\/span> (<\/span>empty<\/span>(<\/span>$input_name<\/span>)<\/span>)<\/span> {<\/span>
\n $name_err<\/span> =<\/span> "\u8bf7\u8f93\u5165\u59d3\u540d"<\/span>;<\/span>
\n }<\/span> elseif<\/span> (<\/span>!<\/span>preg_match<\/span>(<\/span>"\/^[a-zA-Z\\\\s\\\\x{4e00}-\\\\x{9fa5}]+$\/u"<\/span>,<\/span> $input_name<\/span>)<\/span>)<\/span> {<\/span>
\n $name_err<\/span> =<\/span> "\u59d3\u540d\u53ea\u80fd\u5305\u542b\u5b57\u6bcd\u3001\u6c49\u5b57\u548c\u7a7a\u683c"<\/span>;<\/span>
\n }<\/span> else<\/span> {<\/span>
\n $name<\/span> =<\/span> $input_name<\/span>;<\/span>
\n }<\/span><\/p>\n

\/\/ \u9a8c\u8bc1\u5730\u5740<\/span>
\n $input_address<\/span> =<\/span> trim<\/span>(<\/span>$_POST<\/span>[<\/span>"address"<\/span>]<\/span>)<\/span>;<\/span>
\n if<\/span> (<\/span>empty<\/span>(<\/span>$input_address<\/span>)<\/span>)<\/span> {<\/span>
\n $address_err<\/span> =<\/span> "\u8bf7\u8f93\u5165\u5730\u5740"<\/span>;<\/span>
\n }<\/span> else<\/span> {<\/span>
\n $address<\/span> =<\/span> $input_address<\/span>;<\/span>
\n }<\/span><\/p>\n

\/\/ \u9a8c\u8bc1\u85aa\u8d44<\/span>
\n $input_salary<\/span> =<\/span> trim<\/span>(<\/span>$_POST<\/span>[<\/span>"salary"<\/span>]<\/span>)<\/span>;<\/span>
\n if<\/span> (<\/span>empty<\/span>(<\/span>$input_salary<\/span>)<\/span>)<\/span> {<\/span>
\n $salary_err<\/span> =<\/span> "\u8bf7\u8f93\u5165\u85aa\u8d44"<\/span>;<\/span>
\n }<\/span> elseif<\/span> (<\/span>!<\/span>filter_var<\/span>(<\/span>$input_salary<\/span>,<\/span> FILTER_VALIDATE_INT<\/span>,<\/span> [<\/span>"options"<\/span> =><\/span> [<\/span>"min_range"<\/span> =><\/span> 1<\/span>]<\/span>]<\/span>)<\/span>)<\/span> {<\/span>
\n $salary_err<\/span> =<\/span> "\u85aa\u8d44\u5fc5\u987b\u662f\u6b63\u6574\u6570"<\/span>;<\/span>
\n }<\/span> else<\/span> {<\/span>
\n $salary<\/span> =<\/span> $input_salary<\/span>;<\/span>
\n }<\/span><\/p>\n

\/\/ \u65e0\u9519\u8bef\u5219\u66f4\u65b0<\/span>
\n if<\/span> (<\/span>empty<\/span>(<\/span>$name_err<\/span>)<\/span> &&<\/span> empty<\/span>(<\/span>$address_err<\/span>)<\/span> &&<\/span> empty<\/span>(<\/span>$salary_err<\/span>)<\/span>)<\/span> {<\/span>
\n try<\/span> {<\/span>
\n $sql<\/span> =<\/span> "UPDATE employees SET name=?, address=?, salary=? WHERE id=?"<\/span>;<\/span>
\n $stmt<\/span> =<\/span> $link<\/span>-><\/span>prepare<\/span>(<\/span>$sql<\/span>)<\/span>;<\/span>
\n $stmt<\/span>-><\/span>bind_param<\/span>(<\/span>"ssii"<\/span>,<\/span> $name<\/span>,<\/span> $address<\/span>,<\/span> $salary<\/span>,<\/span> $id<\/span>)<\/span>;<\/span><\/p>\n

if<\/span> (<\/span>$stmt<\/span>-><\/span>execute<\/span>(<\/span>)<\/span>)<\/span> {<\/span>
\n header<\/span>(<\/span>"location: index.php?msg=\u5458\u5de5\u4fe1\u606f\u66f4\u65b0\u6210\u529f"<\/span>)<\/span>;<\/span>
\n exit<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span> else<\/span> {<\/span>
\n throw<\/span> new<\/span> mysqli_sql_exception<\/span>(<\/span>"\u66f4\u65b0\u5931\u8d25: "<\/span> .<\/span> $stmt<\/span>-><\/span>error<\/span>)<\/span>;<\/span>
\n }<\/span>
\n }<\/span> catch<\/span> (<\/span>mysqli_sql_exception<\/span> $e<\/span>)<\/span> {<\/span>
\n echo<\/span> "\u9519\u8bef: "<\/span> .<\/span> $e<\/span>-><\/span>getMessage<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span> finally<\/span> {<\/span>
\n if<\/span> (<\/span>isset<\/span>(<\/span>$stmt<\/span>)<\/span>)<\/span> $stmt<\/span>-><\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n if<\/span> (<\/span>isset<\/span>(<\/span>$link<\/span>)<\/span>)<\/span> $link<\/span>-><\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span>
\n }<\/span>
\n}<\/span> else<\/span> {<\/span>
\n \/\/ \u521d\u59cb\u52a0\u8f7d\u65f6\u83b7\u53d6\u5458\u5de5\u6570\u636e<\/span>
\n if<\/span> (<\/span>!<\/span>isset<\/span>(<\/span>$_GET<\/span>[<\/span>"id"<\/span>]<\/span>)<\/span> ||<\/span> empty<\/span>(<\/span>trim<\/span>(<\/span>$_GET<\/span>[<\/span>"id"<\/span>]<\/span>)<\/span>)<\/span>)<\/span> {<\/span>
\n header<\/span>(<\/span>"location: error.php"<\/span>)<\/span>;<\/span>
\n exit<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span>
\n $id<\/span> =<\/span> trim<\/span>(<\/span>$_GET<\/span>[<\/span>"id"<\/span>]<\/span>)<\/span>;<\/span><\/p>\n

try<\/span> {<\/span>
\n $sql<\/span> =<\/span> "SELECT * FROM employees WHERE id = ?"<\/span>;<\/span>
\n $stmt<\/span> =<\/span> $link<\/span>-><\/span>prepare<\/span>(<\/span>$sql<\/span>)<\/span>;<\/span>
\n $stmt<\/span>-><\/span>bind_param<\/span>(<\/span>"i"<\/span>,<\/span> $id<\/span>)<\/span>;<\/span>
\n $stmt<\/span>-><\/span>execute<\/span>(<\/span>)<\/span>;<\/span>
\n $result<\/span> =<\/span> $stmt<\/span>-><\/span>get_result<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

if<\/span> (<\/span>$result<\/span>-><\/span>num_rows<\/span> ===<\/span> 1<\/span>)<\/span> {<\/span>
\n $row<\/span> =<\/span> $result<\/span>-><\/span>fetch_assoc<\/span>(<\/span>)<\/span>;<\/span>
\n $name<\/span> =<\/span> $row<\/span>[<\/span>"name"<\/span>]<\/span>;<\/span>
\n $address<\/span> =<\/span> $row<\/span>[<\/span>"address"<\/span>]<\/span>;<\/span>
\n $salary<\/span> =<\/span> $row<\/span>[<\/span>"salary"<\/span>]<\/span>;<\/span>
\n }<\/span> else<\/span> {<\/span>
\n header<\/span>(<\/span>"location: error.php"<\/span>)<\/span>;<\/span>
\n exit<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span>
\n }<\/span> catch<\/span> (<\/span>mysqli_sql_exception<\/span> $e<\/span>)<\/span> {<\/span>
\n echo<\/span> "\u67e5\u8be2\u9519\u8bef: "<\/span> .<\/span> $e<\/span>-><\/span>getMessage<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span> finally<\/span> {<\/span>
\n if<\/span> (<\/span>isset<\/span>(<\/span>$stmt<\/span>)<\/span>)<\/span> $stmt<\/span>-><\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n if<\/span> (<\/span>isset<\/span>(<\/span>$link<\/span>)<\/span>)<\/span> $link<\/span>-><\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span>
\n}<\/span>
\n?<\/span>><\/span><\/p>\n

<<\/span>!<\/span>DOCTYPE<\/span> html><\/span>
\n<<\/span>html lang=<\/span>"zh-CN"<\/span>><\/span>
\n<<\/span>head><\/span>
\n <<\/span>meta charset=<\/span>"UTF-8"<\/span>><\/span>
\n <<\/span>meta name=<\/span>"viewport"<\/span> content=<\/span>"width=device-width, initial-scale=1.0"<\/span>><\/span>
\n <<\/span>title><\/span>\u7f16\u8f91\u5458\u5de5 –<\/span> \u5458\u5de5\u7ba1\u7406\u7cfb\u7edf<<\/span>\/<\/span>title><\/span>
\n <<\/span>link href=<\/span>"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.3.0-alpha1\/dist\/css\/bootstrap.min.css"<\/span> rel=<\/span>"stylesheet"<\/span>><\/span>
\n <<\/span>link rel=<\/span>"stylesheet"<\/span> href=<\/span>"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/font-awesome\/6.0.0\/css\/all.min.css"<\/span>><\/span>
\n <<\/span>style><\/span>
\n :<\/span>root {<\/span>
\n —<\/span>primary–<\/span>color<\/span>:<\/span> #2563eb;<\/span>
\n —<\/span>secondary–<\/span>color<\/span>:<\/span> #4f46e5;<\/span>
\n —<\/span>accent–<\/span>color<\/span>:<\/span> #f59e0b;<\/span>
\n —<\/span>light–<\/span>color<\/span>:<\/span> #f3f4f6;<\/span>
\n —<\/span>dark–<\/span>color<\/span>:<\/span> #1f2937;<\/span>
\n }<\/span><\/p>\n

body {<\/span>
\n font–<\/span>family<\/span>:<\/span> 'Segoe UI'<\/span>,<\/span> Tahoma,<\/span> Geneva,<\/span> Verdana,<\/span> sans–<\/span>serif;<\/span>
\n background–<\/span>color<\/span>:<\/span> #f8fafc;<\/span>
\n color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>dark–<\/span>color)<\/span>;<\/span>
\n line–<\/span>height<\/span>:<\/span> 1.6<\/span>;<\/span>
\n min–<\/span>height<\/span>:<\/span> 100<\/span>vh;<\/span>
\n display<\/span>:<\/span> flex;<\/span>
\n flex–<\/span>direction<\/span>:<\/span> column;<\/span>
\n }<\/span><\/p>\n

.<\/span>navbar {<\/span>
\n background–<\/span>color<\/span>:<\/span> white;<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 2<\/span>px 10<\/span>px rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.05<\/span>)<\/span>;<\/span>
\n transition<\/span>:<\/span> all 0.3<\/span>s ease;<\/span>
\n }<\/span><\/p>\n

.<\/span>navbar<\/span>:<\/span>hover {<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 4<\/span>px 15<\/span>px rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.08<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>navbar–<\/span>brand {<\/span>
\n font–<\/span>weight<\/span>:<\/span> 700<\/span>;<\/span>
\n color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>primary–<\/span>color)<\/span>;<\/span>
\n font–<\/span>size<\/span>:<\/span> 1.5<\/span>rem;<\/span>
\n display<\/span>:<\/span> flex;<\/span>
\n align–<\/span>items<\/span>:<\/span> center;<\/span>
\n gap<\/span>:<\/span> 8<\/span>px;<\/span>
\n }<\/span><\/p>\n

.<\/span>navbar–<\/span>brand i {<\/span>
\n font–<\/span>size<\/span>:<\/span> 1.8<\/span>rem;<\/span>
\n }<\/span><\/p>\n

.<\/span>container {<\/span>
\n max–<\/span>width<\/span>:<\/span> 1200<\/span>px;<\/span>
\n margin<\/span>:<\/span> 0<\/span> auto;<\/span>
\n padding<\/span>:<\/span> 2<\/span>rem 1<\/span>rem;<\/span>
\n flex<\/span>:<\/span> 1<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>page–<\/span>header {<\/span>
\n margin–<\/span>bottom<\/span>:<\/span> 2<\/span>rem;<\/span>
\n padding–<\/span>bottom<\/span>:<\/span> 1<\/span>rem;<\/span>
\n border–<\/span>bottom<\/span>:<\/span> 1<\/span>px solid #e5e7eb;<\/span>
\n display<\/span>:<\/span> flex;<\/span>
\n flex–<\/span>wrap<\/span>:<\/span> wrap;<\/span>
\n justify–<\/span>content<\/span>:<\/span> space–<\/span>between;<\/span>
\n align–<\/span>items<\/span>:<\/span> center;<\/span>
\n }<\/span><\/p>\n

.<\/span>page–<\/span>header h2 {<\/span>
\n margin<\/span>:<\/span> 0<\/span>;<\/span>
\n font–<\/span>weight<\/span>:<\/span> 700<\/span>;<\/span>
\n color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>dark–<\/span>color)<\/span>;<\/span>
\n position<\/span>:<\/span> relative;<\/span>
\n padding–<\/span>bottom<\/span>:<\/span> 0.5<\/span>rem;<\/span>
\n }<\/span><\/p>\n

.<\/span>page–<\/span>header h2<\/span>::<\/span>after {<\/span>
\n content<\/span>:<\/span> ''<\/span>;<\/span>
\n position<\/span>:<\/span> absolute;<\/span>
\n bottom<\/span>:<\/span> 0<\/span>;<\/span>
\n left<\/span>:<\/span> 0<\/span>;<\/span>
\n width<\/span>:<\/span> 50<\/span>px;<\/span>
\n height<\/span>:<\/span> 3<\/span>px;<\/span>
\n background–<\/span>color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>primary–<\/span>color)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn {<\/span>
\n transition<\/span>:<\/span> all 0.3<\/span>s ease;<\/span>
\n font–<\/span>weight<\/span>:<\/span> 500<\/span>;<\/span>
\n padding<\/span>:<\/span> 0.5<\/span>rem 1.25<\/span>rem;<\/span>
\n border–<\/span>radius<\/span>:<\/span> 6<\/span>px;<\/span>
\n display<\/span>:<\/span> inline–<\/span>flex;<\/span>
\n align–<\/span>items<\/span>:<\/span> center;<\/span>
\n gap<\/span>:<\/span> 6<\/span>px;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn–<\/span>success {<\/span>
\n background–<\/span>color<\/span>:<\/span> #10b981;<\/span>
\n border–<\/span>color<\/span>:<\/span> #10b981;<\/span>
\n color<\/span>:<\/span> white;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn–<\/span>success<\/span>:<\/span>hover {<\/span>
\n background–<\/span>color<\/span>:<\/span> #059669;<\/span>
\n border–<\/span>color<\/span>:<\/span> #059669;<\/span>
\n transform<\/span>:<\/span> translateY<\/span>(<\/span>–<\/span>2<\/span>px)<\/span>;<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 4<\/span>px 12<\/span>px rgba<\/span>(<\/span>16<\/span>,<\/span> 185<\/span>,<\/span> 129<\/span>,<\/span> 0.3<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn–<\/span>secondary {<\/span>
\n background–<\/span>color<\/span>:<\/span> #6b7280;<\/span>
\n border–<\/span>color<\/span>:<\/span> #6b7280;<\/span>
\n color<\/span>:<\/span> white;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn–<\/span>secondary<\/span>:<\/span>hover {<\/span>
\n background–<\/span>color<\/span>:<\/span> #4b5563;<\/span>
\n border–<\/span>color<\/span>:<\/span> #4b5563;<\/span>
\n transform<\/span>:<\/span> translateY<\/span>(<\/span>–<\/span>2<\/span>px)<\/span>;<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 4<\/span>px 12<\/span>px rgba<\/span>(<\/span>107<\/span>,<\/span> 114<\/span>,<\/span> 128<\/span>,<\/span> 0.3<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>card {<\/span>
\n background–<\/span>color<\/span>:<\/span> white;<\/span>
\n border–<\/span>radius<\/span>:<\/span> 8<\/span>px;<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 4<\/span>px 6<\/span>px –<\/span>1<\/span>px rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.1<\/span>)<\/span>,<\/span> 0<\/span> 2<\/span>px 4<\/span>px –<\/span>1<\/span>px rgba<\/span>(<\/span>0<\/span>,<\/span> 0<\/span>,<\/span> 0<\/span>,<\/span> 0.06<\/span>)<\/span>;<\/span>
\n padding<\/span>:<\/span> 1.5<\/span>rem;<\/span>
\n margin–<\/span>bottom<\/span>:<\/span> 2<\/span>rem;<\/span>
\n }<\/span><\/p>\n

.<\/span>form–<\/span>group {<\/span>
\n margin–<\/span>bottom<\/span>:<\/span> 1.5<\/span>rem;<\/span>
\n }<\/span><\/p>\n

.<\/span>form–<\/span>label {<\/span>
\n font–<\/span>weight<\/span>:<\/span> 500<\/span>;<\/span>
\n margin–<\/span>bottom<\/span>:<\/span> 0.5<\/span>rem;<\/span>
\n display<\/span>:<\/span> block;<\/span>
\n color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>dark–<\/span>color)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>form–<\/span>control {<\/span>
\n width<\/span>:<\/span> 100<\/span>%<\/span>;<\/span>
\n padding<\/span>:<\/span> 0.75<\/span>rem;<\/span>
\n border<\/span>:<\/span> 1<\/span>px solid #d1d5db;<\/span>
\n border–<\/span>radius<\/span>:<\/span> 6<\/span>px;<\/span>
\n transition<\/span>:<\/span> all 0.2<\/span>s ease;<\/span>
\n }<\/span><\/p>\n

.<\/span>form–<\/span>control<\/span>:<\/span>focus {<\/span>
\n outline<\/span>:<\/span> none;<\/span>
\n border–<\/span>color<\/span>:<\/span> var<\/span>(<\/span>—<\/span>primary–<\/span>color)<\/span>;<\/span>
\n box–<\/span>shadow<\/span>:<\/span> 0<\/span> 0<\/span> 0<\/span> 3<\/span>px rgba<\/span>(<\/span>37<\/span>,<\/span> 99<\/span>,<\/span> 235<\/span>,<\/span> 0.1<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

.<\/span>has–<\/span>error .<\/span>form–<\/span>control {<\/span>
\n border–<\/span>color<\/span>:<\/span> #ef4444;<\/span>
\n }<\/span><\/p>\n

.<\/span>help–<\/span>block {<\/span>
\n color<\/span>:<\/span> #ef4444;<\/span>
\n font–<\/span>size<\/span>:<\/span> 0.875<\/span>rem;<\/span>
\n margin–<\/span>top<\/span>:<\/span> 0.25<\/span>rem;<\/span>
\n }<\/span><\/p>\n

footer {<\/span>
\n text–<\/span>align<\/span>:<\/span> center;<\/span>
\n padding<\/span>:<\/span> 2<\/span>rem 1<\/span>rem;<\/span>
\n margin–<\/span>top<\/span>:<\/span> 3<\/span>rem;<\/span>
\n color<\/span>:<\/span> #6b7280;<\/span>
\n border–<\/span>top<\/span>:<\/span> 1<\/span>px solid #e5e7eb;<\/span>
\n }<\/span><\/p>\n

@media <\/span>(<\/span>max–<\/span>width<\/span>:<\/span> 768<\/span>px)<\/span> {<\/span>
\n .<\/span>page–<\/span>header {<\/span>
\n flex–<\/span>direction<\/span>:<\/span> column;<\/span>
\n align–<\/span>items<\/span>:<\/span> flex–<\/span>start;<\/span>
\n gap<\/span>:<\/span> 1<\/span>rem;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn–<\/span>group {<\/span>
\n width<\/span>:<\/span> 100<\/span>%<\/span>;<\/span>
\n display<\/span>:<\/span> flex;<\/span>
\n gap<\/span>:<\/span> 0.5<\/span>rem;<\/span>
\n }<\/span><\/p>\n

.<\/span>btn {<\/span>
\n flex<\/span>:<\/span> 1<\/span>;<\/span>
\n justify–<\/span>content<\/span>:<\/span> center;<\/span>
\n }<\/span>
\n }<\/span>
\n <<\/span>\/<\/span>style><\/span>
\n<<\/span>\/<\/span>head><\/span>
\n<<\/span>body><\/span>
\n <<\/span>!<\/span>—<\/span> \u5bfc\u822a\u680f —<\/span>><\/span>
\n <<\/span>nav class<\/span>=<\/span>"navbar navbar-expand-lg"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"container"<\/span>><\/span>
\n <<\/span>a class<\/span>=<\/span>"navbar-brand"<\/span> href=<\/span>"index.php"<\/span>><\/span>
\n <<\/span>i class<\/span>=<\/span>"fas fa-users"<\/span>><\/span><<\/span>\/<\/span>i><\/span>
\n \u5458\u5de5\u7ba1\u7406\u7cfb\u7edf
\n <<\/span>\/<\/span>a><\/span>
\n <<\/span>button class<\/span>=<\/span>"navbar-toggler"<\/span> type=<\/span>"button"<\/span> data–<\/span>bs–<\/span>toggle=<\/span>"collapse"<\/span> data–<\/span>bs–<\/span>target=<\/span>"#navbarNav"<\/span>><\/span>
\n <<\/span>span class<\/span>=<\/span>"navbar-toggler-icon"<\/span>><\/span><<\/span>\/<\/span>span><\/span>
\n <<\/span>\/<\/span>button><\/span>
\n <<\/span>div class<\/span>=<\/span>"collapse navbar-collapse"<\/span> id=<\/span>"navbarNav"<\/span>><\/span>
\n <<\/span>ul class<\/span>=<\/span>"navbar-nav ms-auto"<\/span>><\/span>
\n <<\/span>li class<\/span>=<\/span>"nav-item"<\/span>><\/span>
\n <<\/span>a class<\/span>=<\/span>"nav-link"<\/span> href=<\/span>"index.php"<\/span>><\/span>\u5458\u5de5\u5217\u8868<<\/span>\/<\/span>a><\/span>
\n <<\/span>\/<\/span>li><\/span>
\n <<\/span>li class<\/span>=<\/span>"nav-item"<\/span>><\/span>
\n <<\/span>a class<\/span>=<\/span>"nav-link active"<\/span> href=<\/span>"#"<\/span> aria–<\/span>current=<\/span>"page"<\/span>><\/span>\u7f16\u8f91\u5458\u5de5<<\/span>\/<\/span>a><\/span>
\n <<\/span>\/<\/span>li><\/span>
\n <<\/span>li class<\/span>=<\/span>"nav-item"<\/span>><\/span>
\n <<\/span>a class<\/span>=<\/span>"nav-link"<\/span> href=<\/span>"#"<\/span>><\/span>\u7cfb\u7edf\u8bbe\u7f6e<<\/span>\/<\/span>a><\/span>
\n <<\/span>\/<\/span>li><\/span>
\n <<\/span>li class<\/span>=<\/span>"nav-item"<\/span>><\/span>
\n <<\/span>a class<\/span>=<\/span>"nav-link"<\/span> href=<\/span>"#"<\/span>><\/span>\u5e2e\u52a9\u4e2d\u5fc3<<\/span>\/<\/span>a><\/span>
\n <<\/span>\/<\/span>li><\/span>
\n <<\/span>\/<\/span>ul><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>nav><\/span><\/p>\n

<<\/span>div class<\/span>=<\/span>"container"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"row"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"col-md-12"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"page-header"<\/span>><\/span>
\n <<\/span>h2><\/span>\u66f4\u65b0\u5458\u5de5\u8bb0\u5f55<<\/span>\/<\/span>h2><\/span>
\n <<\/span>div class<\/span>=<\/span>"btn-group"<\/span>><\/span>
\n <<\/span>a href=<\/span>"index.php"<\/span> class<\/span>=<\/span>"btn btn-secondary"<\/span>><\/span>
\n <<\/span>i class<\/span>=<\/span>"fas fa-arrow-left"<\/span>><\/span><<\/span>\/<\/span>i><\/span> \u8fd4\u56de\u5217\u8868
\n <<\/span>\/<\/span>a><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span><\/p>\n

<<\/span>div class<\/span>=<\/span>"card"<\/span>><\/span>
\n <<\/span>p><\/span>\u8bf7\u7f16\u8f91\u4ee5\u4e0b\u4fe1\u606f\u5e76\u63d0\u4ea4\u66f4\u65b0<<\/span>\/<\/span>p><\/span>
\n <<\/span>form action=<\/span>"<?php echo htmlspecialchars(basename($_SERVER<\/span>[<\/span>'REQUEST_URI'<\/span>]<\/span><\/span>)); ?>"<\/span> method=<\/span>"post"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"form-group <?php echo !empty($name_err<\/span><\/span>) ? 'has-error' : ''; ?>"<\/span>><\/span>
\n <<\/span>label class<\/span>=<\/span>"form-label"<\/span> for<\/span>=<\/span>"name"<\/span>><\/span>\u59d3\u540d<<\/span>\/<\/span>label><\/span>
\n <<\/span>input type=<\/span>"text"<\/span> id=<\/span>"name"<\/span> name=<\/span>"name"<\/span> class<\/span>=<\/span>"form-control"<\/span> value=<\/span>"<?php echo htmlspecialchars($name<\/span><\/span>); ?>"<\/span>><\/span>
\n <<\/span>span class<\/span>=<\/span>"help-block"<\/span>><\/span><<\/span>?<\/span>php echo<\/span> $name_err<\/span>;<\/span> ?<\/span>><\/span><<\/span>\/<\/span>span><\/span>
\n <<\/span>\/<\/span>div><\/span><\/p>\n

<<\/span>div class<\/span>=<\/span>"form-group <?php echo !empty($address_err<\/span><\/span>) ? 'has-error' : ''; ?>"<\/span>><\/span>
\n <<\/span>label class<\/span>=<\/span>"form-label"<\/span> for<\/span>=<\/span>"address"<\/span>><\/span>\u5730\u5740<<\/span>\/<\/span>label><\/span>
\n <<\/span>textarea id=<\/span>"address"<\/span> name=<\/span>"address"<\/span> class<\/span>=<\/span>"form-control"<\/span> rows=<\/span>"3"<\/span>><\/span><<\/span>?<\/span>php echo<\/span> htmlspecialchars<\/span>(<\/span>$address<\/span>)<\/span>;<\/span> ?<\/span>><\/span><<\/span>\/<\/span>textarea><\/span>
\n <<\/span>span class<\/span>=<\/span>"help-block"<\/span>><\/span><<\/span>?<\/span>php echo<\/span> $address_err<\/span>;<\/span> ?<\/span>><\/span><<\/span>\/<\/span>span><\/span>
\n <<\/span>\/<\/span>div><\/span><\/p>\n

<<\/span>div class<\/span>=<\/span>"form-group <?php echo !empty($salary_err<\/span><\/span>) ? 'has-error' : ''; ?>"<\/span>><\/span>
\n <<\/span>label class<\/span>=<\/span>"form-label"<\/span> for<\/span>=<\/span>"salary"<\/span>><\/span>\u85aa\u8d44<<\/span>\/<\/span>label><\/span>
\n <<\/span>input type=<\/span>"text"<\/span> id=<\/span>"salary"<\/span> name=<\/span>"salary"<\/span> class<\/span>=<\/span>"form-control"<\/span> value=<\/span>"<?php echo htmlspecialchars($salary<\/span><\/span>); ?>"<\/span>><\/span>
\n <<\/span>span class<\/span>=<\/span>"help-block"<\/span>><\/span><<\/span>?<\/span>php echo<\/span> $salary_err<\/span>;<\/span> ?<\/span>><\/span><<\/span>\/<\/span>span><\/span>
\n <<\/span>\/<\/span>div><\/span><\/p>\n

<<\/span>input type=<\/span>"hidden"<\/span> name=<\/span>"id"<\/span> value=<\/span>"<?php echo htmlspecialchars($id<\/span><\/span>); ?>"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"btn-group"<\/span>><\/span>
\n <<\/span>input type=<\/span>"submit"<\/span> class<\/span>=<\/span>"btn btn-success"<\/span> value=<\/span>"\u63d0\u4ea4\u66f4\u65b0"<\/span>><\/span>
\n <<\/span>a href=<\/span>"index.php"<\/span> class<\/span>=<\/span>"btn btn-secondary"<\/span>><\/span>\u53d6\u6d88<<\/span>\/<\/span>a><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>form><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span><\/p>\n

<<\/span>!<\/span>—<\/span> \u9875\u811a —<\/span>><\/span>
\n <<\/span>footer><\/span>
\n <<\/span>div class<\/span>=<\/span>"container"<\/span>><\/span>
\n <<\/span>p><\/span>&<\/span>copy;<\/span> <<\/span>?<\/span>php echo<\/span> date<\/span>(<\/span>"Y"<\/span>)<\/span>;<\/span> ?<\/span>><\/span> \u5458\u5de5\u7ba1\u7406\u7cfb\u7edf –<\/span> \u7248\u6743\u6240\u6709<<\/span>\/<\/span>p><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>footer><\/span><\/p>\n

<<\/span>script src=<\/span>"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.3.0-alpha1\/dist\/js\/bootstrap.bundle.min.js"<\/span>><\/span><<\/span>\/<\/span>script><\/span>
\n <<\/span>script><\/span>
\n document.<\/span>addEventListener<\/span>(<\/span>'DOMContentLoaded'<\/span>,<\/span> function<\/span>(<\/span>)<\/span> {<\/span>
\n \/\/ \u521d\u59cb\u5316\u8868\u5355\u4ea4\u4e92\u6548\u679c<\/span>
\n const<\/span> formInputs =<\/span> document.<\/span>querySelectorAll<\/span>(<\/span>'.form-control'<\/span>)<\/span>;<\/span>
\n formInputs.<\/span>forEach<\/span>(<\/span>input =><\/span> {<\/span>
\n input.<\/span>addEventListener<\/span>(<\/span>'focus'<\/span>,<\/span> function<\/span>(<\/span>)<\/span> {<\/span>
\n this.<\/span>parentElement.<\/span>classList.<\/span>add<\/span>(<\/span>'focused'<\/span>)<\/span>;<\/span>
\n }<\/span>)<\/span>;<\/span>
\n input.<\/span>addEventListener<\/span>(<\/span>'blur'<\/span>,<\/span> function<\/span>(<\/span>)<\/span> {<\/span>
\n this.<\/span>parentElement.<\/span>classList.<\/span>remove<\/span>(<\/span>'focused'<\/span>)<\/span>;<\/span>
\n }<\/span>)<\/span>;<\/span>
\n }<\/span>)<\/span>;<\/span>
\n }<\/span>)<\/span>;<\/span>
\n <<\/span>\/<\/span>script><\/span>
\n<<\/span>\/<\/span>body><\/span>
\n<<\/span>\/<\/span>html><\/span><\/p>\n

5. \u5220\u9664\u5458\u5de5\u8bb0\u5f55（delete.php）<\/h6>\n

\u786e\u8ba4\u540e\u5220\u9664\u6307\u5b9a\u5458\u5de5，\u5305\u542b\u4e8c\u6b21\u786e\u8ba4\u673a\u5236：<\/p>\n

<?php<\/span>
\nrequire_once<\/span> "config.php"<\/span>;<\/span><\/p>\n

\/\/ \u5904\u7406\u5220\u9664\u63d0\u4ea4<\/span>
\nif<\/span> (<\/span>$_SERVER<\/span>[<\/span>"REQUEST_METHOD"<\/span>]<\/span> ===<\/span> "POST"<\/span>)<\/span> {<\/span>
\n if<\/span> (<\/span>!<\/span>isset<\/span>(<\/span>$_POST<\/span>[<\/span>"id"<\/span>]<\/span>)<\/span> ||<\/span> empty<\/span>(<\/span>trim<\/span>(<\/span>$_POST<\/span>[<\/span>"id"<\/span>]<\/span>)<\/span>)<\/span>)<\/span> {<\/span>
\n header<\/span>(<\/span>"location: error.php"<\/span>)<\/span>;<\/span>
\n exit<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span>
\n $id<\/span> =<\/span> trim<\/span>(<\/span>$_POST<\/span>[<\/span>"id"<\/span>]<\/span>)<\/span>;<\/span><\/p>\n

try<\/span> {<\/span>
\n $sql<\/span> =<\/span> "DELETE FROM employees WHERE id = ?"<\/span>;<\/span>
\n $stmt<\/span> =<\/span> $link<\/span>-><\/span>prepare<\/span>(<\/span>$sql<\/span>)<\/span>;<\/span>
\n $stmt<\/span>-><\/span>bind_param<\/span>(<\/span>"i"<\/span>,<\/span> $id<\/span>)<\/span>;<\/span><\/p>\n

if<\/span> (<\/span>$stmt<\/span>-><\/span>execute<\/span>(<\/span>)<\/span>)<\/span> {<\/span>
\n header<\/span>(<\/span>"location: index.php"<\/span>)<\/span>;<\/span>
\n exit<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span> else<\/span> {<\/span>
\n throw<\/span> new<\/span> mysqli_sql_exception<\/span>(<\/span>"\u5220\u9664\u5931\u8d25: "<\/span> .<\/span> $stmt<\/span>-><\/span>error<\/span>)<\/span>;<\/span>
\n }<\/span>
\n }<\/span> catch<\/span> (<\/span>mysqli_sql_exception<\/span> $e<\/span>)<\/span> {<\/span>
\n echo<\/span> "\u9519\u8bef: "<\/span> .<\/span> $e<\/span>-><\/span>getMessage<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span> finally<\/span> {<\/span>
\n $stmt<\/span>-><\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n $link<\/span>-><\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span>
\n}<\/span> else<\/span> {<\/span>
\n \/\/ \u9a8c\u8bc1ID\u53c2\u6570<\/span>
\n if<\/span> (<\/span>empty<\/span>(<\/span>trim<\/span>(<\/span>$_GET<\/span>[<\/span>"id"<\/span>]<\/span>)<\/span>)<\/span>)<\/span> {<\/span>
\n header<\/span>(<\/span>"location: error.php"<\/span>)<\/span>;<\/span>
\n exit<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span>
\n $id<\/span> =<\/span> trim<\/span>(<\/span>$_GET<\/span>[<\/span>"id"<\/span>]<\/span>)<\/span>;<\/span>
\n}<\/span>
\n?<\/span>><\/span><\/p>\n

<<\/span>!<\/span>DOCTYPE<\/span> html><\/span>
\n<<\/span>html><\/span>
\n<<\/span>head><\/span>
\n <<\/span>meta charset=<\/span>"UTF-8"<\/span>><\/span>
\n <<\/span>title><\/span>\u5220\u9664\u5458\u5de5<<\/span>\/<\/span>title><\/span>
\n <<\/span>link rel=<\/span>"stylesheet"<\/span> href=<\/span>"https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/css\/bootstrap.css"<\/span>><\/span>
\n<<\/span>\/<\/span>head><\/span>
\n<<\/span>body><\/span>
\n <<\/span>div class<\/span>=<\/span>"container"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"row"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"col-md-12"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"page-header"<\/span>><\/span>
\n <<\/span>h1><\/span>\u786e\u8ba4\u5220\u9664<<\/span>\/<\/span>h1><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>form action=<\/span>"<?php echo htmlspecialchars($_SERVER<\/span><\/span>["<\/span>PHP_SELF<\/span>"]); ?>"<\/span> method=<\/span>"post"<\/span>><\/span>
\n <<\/span>div class<\/span>=<\/span>"alert alert-danger"<\/span>><\/span>
\n <<\/span>input type=<\/span>"hidden"<\/span> name=<\/span>"id"<\/span> value=<\/span>"<?php echo $id<\/span><\/span>; ?>"<\/span>><\/span>
\n <<\/span>p><\/span>\u60a8\u786e\u5b9a\u8981\u5220\u9664\u8fd9\u6761\u8bb0\u5f55\u5417？\u6b64\u64cd\u4f5c\u4e0d\u53ef\u6062\u590d！<<\/span>\/<\/span>p><\/span>
\n <<\/span>p><\/span>
\n <<\/span>input type=<\/span>"submit"<\/span> value=<\/span>"\u786e\u8ba4\u5220\u9664"<\/span> class<\/span>=<\/span>"btn btn-danger"<\/span>><\/span>
\n <<\/span>a href=<\/span>"index.php"<\/span> class<\/span>=<\/span>"btn btn-default"<\/span>><\/span>\u53d6\u6d88<<\/span>\/<\/span>a><\/span>
\n <<\/span>\/<\/span>p><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>form><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n <<\/span>\/<\/span>div><\/span>
\n<<\/span>\/<\/span>body><\/span>
\n<<\/span>\/<\/span>html><\/span><\/p>\n

6. \u9519\u8bef\u9875\u9762（error.php）<\/h6>\n

\u5904\u7406\u65e0\u6548\u8bf7\u6c42\u6216\u9519\u8bef\u65f6\u7684\u63d0\u793a\u9875\u9762：<\/p>\n

<!<\/span>DOCTYPE<\/span> html<\/span>><\/span><\/span>
\n<<\/span>html<\/span>><\/span><\/span>
\n<<\/span>head<\/span>><\/span><\/span>
\n <<\/span>meta<\/span> charset<\/span>=<\/span>"<\/span>UTF-8"<\/span><\/span>><\/span><\/span>
\n <<\/span>title<\/span>><\/span><\/span>\u8bf7\u6c42\u9519\u8bef<\/<\/span>title<\/span>><\/span><\/span>
\n <<\/span>link<\/span> rel<\/span>=<\/span>"<\/span>stylesheet"<\/span><\/span> href<\/span>=<\/span>"<\/span>https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/css\/bootstrap.css"<\/span><\/span>><\/span><\/span>
\n<\/<\/span>head<\/span>><\/span><\/span>
\n<<\/span>body<\/span>><\/span><\/span>
\n <<\/span>div<\/span> class<\/span>=<\/span>"<\/span>container"<\/span><\/span>><\/span><\/span>
\n <<\/span>div<\/span> class<\/span>=<\/span>"<\/span>row"<\/span><\/span>><\/span><\/span>
\n <<\/span>div<\/span> class<\/span>=<\/span>"<\/span>col-md-12"<\/span><\/span>><\/span><\/span>
\n <<\/span>div<\/span> class<\/span>=<\/span>"<\/span>page-header"<\/span><\/span>><\/span><\/span>
\n <<\/span>h1<\/span>><\/span><\/span>\u65e0\u6548\u8bf7\u6c42<\/<\/span>h1<\/span>><\/span><\/span>
\n <\/<\/span>div<\/span>><\/span><\/span>
\n <<\/span>div<\/span> class<\/span>=<\/span>"<\/span>alert alert-danger"<\/span><\/span>><\/span><\/span>
\n <<\/span>p<\/span>><\/span><\/span>\u62b1\u6b49，\u60a8\u7684\u8bf7\u6c42\u65e0\u6548\u6216\u8bb0\u5f55\u4e0d\u5b58\u5728\u3002\u8bf7 <<\/span>a<\/span> href<\/span>=<\/span>"<\/span>index.php"<\/span><\/span> class<\/span>=<\/span>"<\/span>alert-link"<\/span><\/span>><\/span><\/span>\u8fd4\u56de\u5217\u8868\u9875<\/<\/span>a<\/span>><\/span><\/span> \u91cd\u8bd5\u3002<\/<\/span>p<\/span>><\/span><\/span>
\n <\/<\/span>div<\/span>><\/span><\/span>
\n <\/<\/span>div<\/span>><\/span><\/span>
\n <\/<\/span>div<\/span>><\/span><\/span>
\n <\/<\/span>div<\/span>><\/span><\/span>
\n<\/<\/span>body<\/span>><\/span><\/span>
\n<\/<\/span>html<\/span>><\/span><\/span><\/p>\n

\n

\u7ed3\u8bed<\/h3>\n

\u901a\u8fc7\u672c\u6587\u7684\u5458\u5de5\u7ba1\u7406\u7cfb\u7edf\u6848\u4f8b，\u6211\u4eec\u5b8c\u6574\u5b9e\u73b0\u4e86\u4ece\u6570\u636e\u5e93\u8bbe\u8ba1\u5230 CRUD \u529f\u80fd\u843d\u5730\u7684\u5168\u6d41\u7a0b\u3002\u56de\u987e\u6574\u4e2a\u5f00\u53d1\u8fc7\u7a0b，\u6838\u5fc3\u4eae\u70b9\u5728\u4e8e：\u901a\u8fc7\u9884\u5904\u7406\u8bed\u53e5prepare()+bind_param()\u6709\u6548\u9632\u8303\u4e86 SQL \u6ce8\u5165\u98ce\u9669，\u901a\u8fc7\u8f93\u5165\u9a8c\u8bc1\u548c HTML \u8f6c\u4e49\u5904\u7406\u907f\u514d\u4e86 XSS \u653b\u51fb，\u540c\u65f6\u501f\u52a9\u9762\u5411\u5bf9\u8c61\u601d\u60f3\u5c01\u88c5\u4e86\u6570\u636e\u5e93\u64cd\u4f5c，\u63d0\u5347\u4e86\u4ee3\u7801\u7684\u53ef\u7ef4\u62a4\u6027\u3002\u524d\u7aef\u5219\u901a\u8fc7 Bootstrap \u548c Font Awesome \u5b9e\u73b0\u4e86\u54cd\u5e94\u5f0f\u5e03\u5c40\u4e0e\u53cb\u597d\u4ea4\u4e92，\u8ba9\u7cfb\u7edf\u65e2\u5b9e\u7528\u53c8\u7f8e\u89c2\u3002 CRUD \u770b\u4f3c\u57fa\u7840，\u5374\u662f Web \u5f00\u53d1\u7684 \u201c\u57fa\u672c\u529f\u201d，\u5176\u8bbe\u8ba1\u601d\u8def\u53ef\u8fc1\u79fb\u5230\u5404\u7c7b\u6570\u636e\u7ba1\u7406\u573a\u666f（\u5982\u5546\u54c1\u7ba1\u7406\u3001\u7528\u6237\u7ba1\u7406\u7b49）\u3002\u638c\u63e1\u672c\u6587\u7684\u6280\u672f\u8981\u70b9\u540e，\u4f60\u53ef\u4ee5\u8fdb\u4e00\u6b65\u6269\u5c55\u529f\u80fd：\u4f8b\u5982\u6dfb\u52a0\u5206\u9875\u67e5\u8be2\u4f18\u5316\u5927\u6570\u636e\u5c55\u793a，\u589e\u52a0\u641c\u7d22\u7b5b\u9009\u529f\u80fd\u63d0\u5347\u7528\u6237\u4f53\u9a8c，\u6216\u7ed3\u5408 Session \u5b9e\u73b0\u7528\u6237\u6743\u9650\u63a7\u5236\u3002 \u6280\u672f\u7684\u63d0\u5347\u6e90\u4e8e\u5b9e\u8df5，\u5efa\u8bae\u5927\u5bb6\u57fa\u4e8e\u672c\u6587\u4ee3\u7801\u8fdb\u884c\u4e8c\u6b21\u5f00\u53d1：\u5c1d\u8bd5\u4fee\u6539\u6570\u636e\u5e93\u5b57\u6bb5\u3001\u6269\u5c55\u8868\u5355\u9a8c\u8bc1\u89c4\u5219，\u6216\u66ff\u6362\u524d\u7aef\u6837\u5f0f\u6846\u67b6，\u5728\u52a8\u624b\u8fc7\u7a0b\u4e2d\u52a0\u6df1\u5bf9 PHP \u4e0e MySQL \u4ea4\u4e92\u903b\u8f91\u7684\u7406\u89e3\u3002\u5e0c\u671b\u672c\u6587\u80fd\u6210\u4e3a\u4f60 Web \u5f00\u53d1\u8def\u4e0a\u7684\u4e00\u5757\u57fa\u77f3，\u52a9\u4f60\u5728\u5b9e\u6218\u4e2d\u4e0d\u65ad\u8fdb\u9636！<\/p>\n","protected":false},"excerpt":{"rendered":"

\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb919\u6b21\uff0c\u70b9\u8d5e32\u6b21\uff0c\u6536\u85cf12\u6b21\u3002\u672c\u6587\u4ecb\u7ecd\u4e86\u4f7f\u7528PHP\u548cMySQL\u6784\u5efa\u5458\u5de5\u7ba1\u7406\u7cfb\u7edf\u7684\u5b8c\u6574\u6d41\u7a0b\u3002\u4ece\u6570\u636e\u5e93\u8bbe\u8ba1\u5f00\u59cb\uff0c\u521b\u5efa\u4e86\u5305\u542b\u5458\u5de5\u57fa\u672c\u4fe1\u606f\u7684employees\u8868\u3002\u901a\u8fc7config.php\u914d\u7f6e\u6587\u4ef6\u5efa\u7acb\u5b89\u5168\u7684\u6570\u636e\u5e93\u8fde\u63a5\uff0c\u652f\u6301UTF-8\u7f16\u7801\u548c\u5f02\u5e38\u5904\u7406\u3002\u7cfb\u7edf\u5b9e\u73b0\u4e86CRUD\u6838\u5fc3\u529f\u80fd\uff1a\u9996\u9875\u5c55\u793a\u5458\u5de5\u5217\u8868\u5e76\u63d0\u4f9b\u64cd\u4f5c\u5165\u53e3\uff0c\u4f7f\u7528Bootstrap\u548cFont Awesome\u4f18\u5316\u754c\u9762\uff0c\u91c7\u7528\u9884\u5904\u7406\u8bed\u53e5\u9632\u6b62SQL\u6ce8\u5165\uff0c\u5305\u542b\u6570\u636e\u9a8c\u8bc1\u7b49\u5b89\u5168\u63aa\u65bd\u3002\u6587\u7ae0\u8be6\u7ec6\u8bb2\u89e3\u4e86\u4ece\u73af\u5883\u914d\u7f6e\u5230\u529f\u80fd\u5b9e\u73b0\u7684\u5404\u4e2a\u6b65\u9aa4\uff0c\u4e3a\u5f00\u53d1\u8005\u63d0\u4f9b\u4e86\u4e00\u4e2a\u53ef\u76f4\u63a5\u590d\u7528\u7684PHP+MySQL\u5e94\u7528\u5f00\u53d1\u6a21\u677f\uff0c\u7279\u522b\u9002\u5408\u9700\u8981\u5feb\u901f\u6784\u5efa\u6570\u636e_phpmysql\u7ba1\u7406\u7cfb\u7edf<\/p>\n","protected":false},"author":2,"featured_media":50846,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[84,114,230,4677,190,1800,4962,4961],"topic":[],"class_list":["post-50847","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-android","tag-mysql","tag-php","tag-4677","tag-190","tag-1800","tag-4962","tag-4961"],"yoast_head":"\nPHP+MySQL \u5b9e\u6218\uff1a\u4ece\u96f6\u642d\u5efa\u5458\u5de5\u7ba1\u7406\u7cfb\u7edf CRUD \u5168\u6d41\u7a0b\u8be6\u89e3 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/50847.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PHP+MySQL \u5b9e\u6218\uff1a\u4ece\u96f6\u642d\u5efa\u5458\u5de5\u7ba1\u7406\u7cfb\u7edf CRUD \u5168\u6d41\u7a0b\u8be6\u89e3 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb919\u6b21\uff0c\u70b9\u8d5e32\u6b21\uff0c\u6536\u85cf12\u6b21\u3002\u672c\u6587\u4ecb\u7ecd\u4e86\u4f7f\u7528PHP\u548cMySQL\u6784\u5efa\u5458\u5de5\u7ba1\u7406\u7cfb\u7edf\u7684\u5b8c\u6574\u6d41\u7a0b\u3002\u4ece\u6570\u636e\u5e93\u8bbe\u8ba1\u5f00\u59cb\uff0c\u521b\u5efa\u4e86\u5305\u542b\u5458\u5de5\u57fa\u672c\u4fe1\u606f\u7684employees\u8868\u3002\u901a\u8fc7config.php\u914d\u7f6e\u6587\u4ef6\u5efa\u7acb\u5b89\u5168\u7684\u6570\u636e\u5e93\u8fde\u63a5\uff0c\u652f\u6301UTF-8\u7f16\u7801\u548c\u5f02\u5e38\u5904\u7406\u3002\u7cfb\u7edf\u5b9e\u73b0\u4e86CRUD\u6838\u5fc3\u529f\u80fd\uff1a\u9996\u9875\u5c55\u793a\u5458\u5de5\u5217\u8868\u5e76\u63d0\u4f9b\u64cd\u4f5c\u5165\u53e3\uff0c\u4f7f\u7528Bootstrap\u548cFont Awesome\u4f18\u5316\u754c\u9762\uff0c\u91c7\u7528\u9884\u5904\u7406\u8bed\u53e5\u9632\u6b62SQL\u6ce8\u5165\uff0c\u5305\u542b\u6570\u636e\u9a8c\u8bc1\u7b49\u5b89\u5168\u63aa\u65bd\u3002\u6587\u7ae0\u8be6\u7ec6\u8bb2\u89e3\u4e86\u4ece\u73af\u5883\u914d\u7f6e\u5230\u529f\u80fd\u5b9e\u73b0\u7684\u5404\u4e2a\u6b65\u9aa4\uff0c\u4e3a\u5f00\u53d1\u8005\u63d0\u4f9b\u4e86\u4e00\u4e2a\u53ef\u76f4\u63a5\u590d\u7528\u7684PHP+MySQL\u5e94\u7528\u5f00\u53d1\u6a21\u677f\uff0c\u7279\u522b\u9002\u5408\u9700\u8981\u5feb\u901f\u6784\u5efa\u6570\u636e_phpmysql\u7ba1\u7406\u7cfb\u7edf\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/50847.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-10T04:45:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/08\/20250810044531-689823ebc7ca8.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"30 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/50847.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/50847.html\",\"name\":\"PHP+MySQL \u5b9e\u6218\uff1a\u4ece\u96f6\u642d\u5efa\u5458\u5de5\u7ba1\u7406\u7cfb\u7edf CRUD \u5168\u6d41\u7a0b\u8be6\u89e3 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2025-08-10T04:45:34+00:00\",\"dateModified\":\"2025-08-10T04:45:34+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/50847.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/50847.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/50847.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PHP+MySQL \u5b9e\u6218\uff1a\u4ece\u96f6\u642d\u5efa\u5458\u5de5\u7ba1\u7406\u7cfb\u7edf CRUD \u5168\u6d41\u7a0b\u8be6\u89e3\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PHP+MySQL \u5b9e\u6218\uff1a\u4ece\u96f6\u642d\u5efa\u5458\u5de5\u7ba1\u7406\u7cfb\u7edf CRUD \u5168\u6d41\u7a0b\u8be6\u89e3 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/50847.html","og_locale":"zh_CN","og_type":"article","og_title":"PHP+MySQL \u5b9e\u6218\uff1a\u4ece\u96f6\u642d\u5efa\u5458\u5de5\u7ba1\u7406\u7cfb\u7edf CRUD \u5168\u6d41\u7a0b\u8be6\u89e3 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb919\u6b21\uff0c\u70b9\u8d5e32\u6b21\uff0c\u6536\u85cf12\u6b21\u3002\u672c\u6587\u4ecb\u7ecd\u4e86\u4f7f\u7528PHP\u548cMySQL\u6784\u5efa\u5458\u5de5\u7ba1\u7406\u7cfb\u7edf\u7684\u5b8c\u6574\u6d41\u7a0b\u3002\u4ece\u6570\u636e\u5e93\u8bbe\u8ba1\u5f00\u59cb\uff0c\u521b\u5efa\u4e86\u5305\u542b\u5458\u5de5\u57fa\u672c\u4fe1\u606f\u7684employees\u8868\u3002\u901a\u8fc7config.php\u914d\u7f6e\u6587\u4ef6\u5efa\u7acb\u5b89\u5168\u7684\u6570\u636e\u5e93\u8fde\u63a5\uff0c\u652f\u6301UTF-8\u7f16\u7801\u548c\u5f02\u5e38\u5904\u7406\u3002\u7cfb\u7edf\u5b9e\u73b0\u4e86CRUD\u6838\u5fc3\u529f\u80fd\uff1a\u9996\u9875\u5c55\u793a\u5458\u5de5\u5217\u8868\u5e76\u63d0\u4f9b\u64cd\u4f5c\u5165\u53e3\uff0c\u4f7f\u7528Bootstrap\u548cFont Awesome\u4f18\u5316\u754c\u9762\uff0c\u91c7\u7528\u9884\u5904\u7406\u8bed\u53e5\u9632\u6b62SQL\u6ce8\u5165\uff0c\u5305\u542b\u6570\u636e\u9a8c\u8bc1\u7b49\u5b89\u5168\u63aa\u65bd\u3002\u6587\u7ae0\u8be6\u7ec6\u8bb2\u89e3\u4e86\u4ece\u73af\u5883\u914d\u7f6e\u5230\u529f\u80fd\u5b9e\u73b0\u7684\u5404\u4e2a\u6b65\u9aa4\uff0c\u4e3a\u5f00\u53d1\u8005\u63d0\u4f9b\u4e86\u4e00\u4e2a\u53ef\u76f4\u63a5\u590d\u7528\u7684PHP+MySQL\u5e94\u7528\u5f00\u53d1\u6a21\u677f\uff0c\u7279\u522b\u9002\u5408\u9700\u8981\u5feb\u901f\u6784\u5efa\u6570\u636e_phpmysql\u7ba1\u7406\u7cfb\u7edf","og_url":"https:\/\/www.wsisp.com\/helps\/50847.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2025-08-10T04:45:34+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/08\/20250810044531-689823ebc7ca8.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"30 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/50847.html","url":"https:\/\/www.wsisp.com\/helps\/50847.html","name":"PHP+MySQL \u5b9e\u6218\uff1a\u4ece\u96f6\u642d\u5efa\u5458\u5de5\u7ba1\u7406\u7cfb\u7edf CRUD \u5168\u6d41\u7a0b\u8be6\u89e3 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2025-08-10T04:45:34+00:00","dateModified":"2025-08-10T04:45:34+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/50847.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/50847.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/50847.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"PHP+MySQL \u5b9e\u6218\uff1a\u4ece\u96f6\u642d\u5efa\u5458\u5de5\u7ba1\u7406\u7cfb\u7edf CRUD \u5168\u6d41\u7a0b\u8be6\u89e3"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/50847","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=50847"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/50847\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/50846"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=50847"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=50847"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=50847"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=50847"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}