{"id":181,"date":"2026-08-19T21:33:33","date_gmt":"2026-08-19T13:33:33","guid":{"rendered":"https:\/\/myboy.vip\/?p=181"},"modified":"2026-08-19T21:33:33","modified_gmt":"2026-08-19T13:33:33","slug":"%e6%82%84%e6%82%84%e8%af%9d%e4%b8%8d%e6%b1%82%e4%ba%ba%ef%bc%81%e5%9c%a8%e7%ba%bf%e8%81%8a%e5%a4%a9%e5%ae%a4%e7%9a%84%e8%af%9e%e7%94%9f%ef%bc%9aphp-mysql-%e5%85%a8%e6%a0%88%e5%ae%9e%e8%b7%b5","status":"publish","type":"post","link":"https:\/\/myboy.vip\/?p=181","title":{"rendered":"\u6084\u6084\u8bdd\u4e0d\u6c42\u4eba\uff01\u5728\u7ebf\u804a\u5929\u5ba4\u7684\u8bde\u751f\uff1aPHP + MySQL \u5168\u6808\u5b9e\u8df5"},"content":{"rendered":"<blockquote><p><strong>\u4e00\u4e2a\u804a\u5929\u5ba4\u7684\u8bde\u751f\uff1aPHP + MySQL \u5168\u6808\u5b9e\u5f55<\/strong><\/p><\/blockquote>\n<h3><strong>\u4f9d\u65e7\u201c\u4f5c\u6848\u52a8\u673a\u201d<\/strong><\/h3>\n<p>\u8bf4\u5b9e\u8bdd\uff0cQQ\u548c\u5fae\u4fe1\u8fd9\u4e24\u4e2a\u201c\u8001\u5927\u54e5\u201d\u5df2\u7ecf\u5f88\u597d\u7528\u4e86\u3002\u4f46\u7528\u5f97\u8d8a\u4e45\uff0c\u8d8a\u89c9\u5f97\u6709\u4e9b\u5730\u65b9\u4e0d\u5bf9\u52b2\uff1a<\/p>\n<ul>\n<li>\u7fa4\u804a\u6d88\u606f\u5237\u5f97\u98de\u5feb\uff0c\u91cd\u8981\u5185\u5bb9\u7728\u773c\u5c31\u88ab\u6df9\u6ca1\uff0c\u60f3\u5f80\u56de\u7ffb\u6839\u672c\u627e\u4e0d\u5230<\/li>\n<li>\u7fa4\u662f\u522b\u4eba\u5efa\u7684\uff0c\u89c4\u5219\u662f\u5e73\u53f0\u5b9a\u7684\uff0c\u4f60\u6c38\u8fdc\u662f\u4e2a\u201c\u5ba2\u4eba\u201d<\/li>\n<li>\u8bf4\u5c01\u5c31\u5c01\u3001\u8bf4\u5220\u5c31\u5220\uff0c\u6570\u636e\u4ece\u6765\u4e0d\u5728\u81ea\u5df1\u624b\u91cc<\/li>\n<\/ul>\n<p>\u6211\u60f3\u8981\u4e00\u4e2a\u81ea\u5df1\u8bf4\u4e86\u7b97\u7684\u804a\u5929\u5730\u65b9\u2014\u2014\u6570\u636e\u5728\u81ea\u5df1\u6570\u636e\u5e93\u91cc\uff0c\u529f\u80fd\u81ea\u5df1\u5b9a\uff0c\u89c4\u5219\u81ea\u5df1\u8bbe\uff0c\u670b\u53cb\u62c9\u8fdb\u6765\u5c31\u80fd\u804a\u3002<\/p>\n<p>\u5c31\u8fd9\u4e48\u7b80\u5355\u3002<\/p>\n<h3><strong>\u4e00\u4e2a\u76ee\u6807\u4e00\u573a\u68a6<\/strong><\/h3>\n<p>\u6700\u521d\u7684\u60f3\u6cd5\u5f88\u6734\u7d20\uff1a<\/p>\n<ul>\n<li>\u80fd\u6ce8\u518c\u3001\u80fd\u767b\u5f55\uff0c\u6bcf\u4eba\u4e00\u4e2a\u552f\u4e00UID<\/li>\n<li>\u6709\u4e2a\u516c\u5171\u5927\u5385\uff0c\u8c01\u8fdb\u6765\u90fd\u80fd\u8bf4\u8bdd<\/li>\n<li>\u80fd\u52a0\u597d\u53cb\u3001\u80fd\u79c1\u804a\u3001\u80fd\u5efa\u7fa4<\/li>\n<li>\u60f3\u201c\u6f5c\u6c34\u201d\u7684\u65f6\u5019\u80fd\u9690\u8eab<\/li>\n<\/ul>\n<p>\u4f46\u505a\u7740\u505a\u7740\u5c31\u6536\u4e0d\u4f4f\u4e86\u2014\u2014\u529f\u80fd\u50cf\u6eda\u96ea\u7403\u4e00\u6837\u8d8a\u6eda\u8d8a\u5927\uff1a<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-190\"  src=\"http:\/\/myboy.vip\/wp-content\/themes\/Kizumi-master\/assets\/images\/loading.gif\" data-src=\"http:\/\/myboy.vip\/wp-content\/uploads\/2026\/08\/screenshot-300x201.png\" class=\"lazy\" loading=\"lazy\" alt=\"\" srcset=\"https:\/\/myboy.vip\/wp-content\/uploads\/2026\/08\/screenshot-300x201.png 300w, https:\/\/myboy.vip\/wp-content\/uploads\/2026\/08\/screenshot-1024x687.png 1024w, https:\/\/myboy.vip\/wp-content\/uploads\/2026\/08\/screenshot-768x515.png 768w, https:\/\/myboy.vip\/wp-content\/uploads\/2026\/08\/screenshot.png 1178w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<h4><strong>\u804a\u5929\u7684\u57fa\u672c\u76d8\uff1a<\/strong><\/h4>\n<ul>\n<li>\u597d\u53cb\u7cfb\u7edf\uff1a\u6309UID\/\u7528\u6237\u540d\u641c\u7d22\u3001\u597d\u53cb\u7533\u8bf7\u3001\u5907\u6ce8\u3001\u7f6e\u9876\u3001\u9ed1\u540d\u5355<\/li>\n<li>\u79c1\u804a\uff1a\u6587\u5b57\/\u56fe\u7247\/\u6587\u4ef6\u3001\u8868\u60c5\u3001\u6d88\u606f\u64a4\u56de\u3001\u5f15\u7528\u56de\u590d\u3001\u8f6c\u53d1\u3001\u8f93\u5165\u72b6\u6001\u63d0\u793a\u3001\u8349\u7a3f\u7bb1\u3001\u5bfc\u51fa\u804a\u5929\u8bb0\u5f55<\/li>\n<li>\u7fa4\u804a\uff1a\u5efa\u7fa4\u3001\u9080\u8bf7\u5165\u7fa4\uff08\u5e26\u5ba1\u6838\uff09\u3001\u7fa4\u516c\u544a\u3001@\u6210\u5458\u3001\u7fa4\u4e3b\u7ba1\u7406\uff08\u79fb\u9664\/\u8f6c\u8ba9\/\u89e3\u6563\uff09<\/li>\n<\/ul>\n<h4><strong>\u4e0d\u6b62\u662f\u804a\u5929\uff1a<\/strong><\/h4>\n<ul>\n<li>\u901a\u77e5\u4e2d\u5fc3\uff1a\u597d\u53cb\u7533\u8bf7\u3001\u5165\u7fa4\u9080\u8bf7\u3001@\u63d0\u53ca\u3001\u7cfb\u7edf\u516c\u544a\uff0c\u672a\u8bfb\u6570\u89d2\u6807\u3001\u6807\u7b7e\u9875\u6807\u9898\u95ea\u70c1<\/li>\n<li>\u5168\u7ad9\u641c\u7d22\uff1a\u5927\u5385\u3001\u79c1\u804a\u3001\u7fa4\u804a\u4e00\u8d77\u641c\uff0c\u6807\u6ce8\u6765\u6e90\u8fd8\u80fd\u5b9a\u4f4d\u9ad8\u4eae<\/li>\n<li>\u7ba1\u7406\u540e\u53f0\uff1a\u7528\u6237\/\u6d88\u606f\/\u7fa4\u7ec4\u7ba1\u7406\u3001\u516c\u544a\u3001\u53cd\u9988\u3001\u65e5\u5fd7\u3001\u6570\u636e\u5907\u4efd<\/li>\n<li>\u90ae\u4ef6\u7cfb\u7edf\uff1aSMTP\u53d1\u4fe1\u3001\u6ce8\u518c\u90ae\u7bb1\u9a8c\u8bc1\u3001\u627e\u56de\u5bc6\u7801<\/li>\n<\/ul>\n<p>\u8bf4\u767d\u4e86\u5c31\u662f\uff1a\u628a\u201c\u804a\u5929\u201d\u8fd9\u4ef6\u5c0f\u4e8b\uff0c\u505a\u6210\u4e00\u4e2a\u81ea\u5df1\u80fd\u5b8c\u5168\u638c\u63a7\u7684\u5c0f\u793e\u533a<strong>\u3002<\/strong><\/p>\n<h3><strong>\u6280\u672f\u9009\u578b\uff1a\u4e3a\u4ec0\u4e48\u662f PHP + MySQL<\/strong><\/h3>\n<p>\u6211\u624b\u5934\u90a3\u51e0\u53f0\u7a7a\u95f2\u7684\u865a\u62df\u4e3b\u673a\u4f9d\u65e7\u7a7a\u95f2\uff0c\u4e0d\u4e0a\u73ed\u5de5\u4f5c\u600e\u4e48\u884c\u5462\uff1f\u800c\u5b83\u4eec\u90fd\u652f\u6301PHP + MySQL\uff0c\u4e0a\u4f20\u5c31\u80fd\u8dd1\uff0c\u4e0d\u7528\u88c5\u4efb\u4f55\u73af\u5883\u3002<\/p>\n<ul>\n<li>PHP\uff1a\u865a\u62df\u4e3b\u673a\u6807\u914d\uff0c\u4e0a\u4f20\u5373\u7528\uff0c\u96f6\u914d\u7f6e<\/li>\n<li>MySQL\uff1a\u804a\u5929\u7cfb\u7edf\u662f\u591a\u7528\u6237\u3001\u9ad8\u5e76\u53d1\u573a\u666f\uff0c\u8bfb\u591a\u5199\u591a\uff0cMySQL\u6bd4SQLite\u66f4\u7a33<\/li>\n<\/ul>\n<p>\u524d\u7aef\u6211\u4e5f\u6ca1\u78b0\u4efb\u4f55\u6846\u67b6\u2014\u2014\u7eaf\u539f\u751fJavaScript\uff0c\u6ca1\u6709npm\u3001\u6ca1\u6709webpack\u3001\u6ca1\u6709\u5916\u90e8\u4f9d\u8d56\u3002\u7528\u6237\u62ff\u5230\u4ee3\u7801\u8981\u505a\u7684\u5c31\u4e09\u6b65\uff1a\u5bfc\u5165chat.sql\u00a0\u2192 \u6539config.php\u91cc\u7684\u6570\u636e\u5e93\u8d26\u53f7 \u2192 \u8bbf\u95ee\u9996\u9875\u81ea\u52a8\u5efa\u7ba1\u7406\u5458\u3002<\/p>\n<p>\u7eaf\u539f\u751f\uff0c\u5f00\u7bb1\u5373\u7528\u3002<\/p>\n<h3><strong>\u9879\u76ee\u957f\u4ec0\u4e48\u9e1f\u6837<\/strong><\/h3>\n<p>text<\/p>\n<p>ychat\/<\/p>\n<p>\u251c\u2500\u2500 index.php\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # \u4e3b\u754c\u9762\uff08\u5927\u5385 + \u804a\u5929\uff09<\/p>\n<p>\u251c\u2500\u2500 login.php \/ register.php \/ logout.php<\/p>\n<p>\u251c\u2500\u2500 forgot_password.php \/ reset_password.php \/ verify_email.php<\/p>\n<p>\u251c\u2500\u2500 profile.php \/ change_password.php<\/p>\n<p>\u251c\u2500\u2500 config.php\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # \u5168\u5c40\u914d\u7f6e<\/p>\n<p>\u251c\u2500\u2500 functions.php\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # \u516c\u5171\u51fd\u6570\u5e93\uff08\u542bSMTP\u53d1\u9001\uff09<\/p>\n<p>\u251c\u2500\u2500 chat.sql\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # \u6570\u636e\u5e93\u7ed3\u6784\uff0818\u5f20\u8868\uff09<\/p>\n<p>\u251c\u2500\u2500 api\/\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # 49\u4e2aAJAX\u63a5\u53e3<\/p>\n<p>\u251c\u2500\u2500 admin\/\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # \u7ba1\u7406\u540e\u53f0<\/p>\n<p>\u251c\u2500\u2500 uploads\/\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # \u4e0a\u4f20\u76ee\u5f55\uff08\u542b\u9632\u6267\u884c.htaccess\uff09<\/p>\n<p>\u251c\u2500\u2500 assets\/\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # \u9759\u6001\u8d44\u6e90<\/p>\n<p>\u251c\u2500\u2500 css\/\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # \u6837\u5f0f\u6587\u4ef6<\/p>\n<p>\u2514\u2500\u2500 js\/\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # \u524d\u7aef\u903b\u8f91<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-189\"  src=\"http:\/\/myboy.vip\/wp-content\/themes\/Kizumi-master\/assets\/images\/loading.gif\" data-src=\"http:\/\/myboy.vip\/wp-content\/uploads\/2026\/08\/screenshot-admin-300x201.png\" class=\"lazy\" loading=\"lazy\" alt=\"\" srcset=\"https:\/\/myboy.vip\/wp-content\/uploads\/2026\/08\/screenshot-admin-300x201.png 300w, https:\/\/myboy.vip\/wp-content\/uploads\/2026\/08\/screenshot-admin-1024x686.png 1024w, https:\/\/myboy.vip\/wp-content\/uploads\/2026\/08\/screenshot-admin-768x514.png 768w, https:\/\/myboy.vip\/wp-content\/uploads\/2026\/08\/screenshot-admin.png 1177w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<h3><strong>\u51e0\u4e2a\u5173\u952e\u8bbe\u8ba1<\/strong><\/h3>\n<h4><strong>\u6ca1\u6709WebSocket\uff0c\u600e\u4e48\u201c\u5b9e\u65f6\u201d\u804a\u5929\uff1f<\/strong><\/h4>\n<p>\u6211\u7684\u865a\u62df\u4e3b\u673a\u4e0d\u652f\u6301\u957f\u8fde\u63a5\uff08\u54ed\uff09\uff0cWebSocket\u57fa\u672c\u4e0d\u7528\u60f3\u3002\u6211\u7528\u7684\u662f\u6700\u6734\u7d20\u7684AJAX\u8f6e\u8be2\uff1a<\/p>\n<ul>\n<li>\u524d\u53f0\u6bcf4\u79d2\u62c9\u4e00\u6b21\u65b0\u6d88\u606f<\/li>\n<li>\u6bcf15\u79d2\u5237\u65b0\u4f1a\u8bdd\u5217\u8868\u3001\u5728\u7ebf\u7528\u6237\u3001\u5927\u5385\u7981\u8a00\u72b6\u6001<\/li>\n<li>\u6bcf30\u79d2\u518d\u5237\u4e00\u6b21\u5728\u7ebf\u7528\u6237<\/li>\n<\/ul>\n<p>\u8fd8\u6709\u4e2a\u4f18\u5316\uff1a\u6807\u7b7e\u9875\u9690\u85cf\u65f6\u81ea\u52a8\u6682\u505c\u8f6e\u8be2\uff08document.hidden === false\u624d\u62c9\u6570\u636e\uff09\uff0c\u5207\u8d70\u4e0d\u6d6a\u8d39\u6d41\u91cf\uff0c\u5207\u56de\u6765\u7acb\u523b\u7eed\u4e0a\u3002\u514d\u8d39\u4e3b\u673a\u8dd1\u8d77\u6765\u6beb\u65e0\u538b\u529b\u3002<\/p>\n<h4><strong>\u5728\u7ebf\u72b6\u6001\u548c\u9690\u8eab\u6a21\u5f0f<\/strong><\/h4>\n<p>\u5728\u7ebf\u5224\u65ad\u9760\u201c\u5fc3\u8df3\u201d\uff1a\u7528\u6237\u6bcf\u6b21\u64cd\u4f5c\u66f4\u65b0last_active\u65f6\u95f4\u6233\uff0c\u6700\u8fd15\u5206\u949f\u5185\u6709\u52a8\u4f5c\u5c31\u7b97\u5728\u7ebf\u3002<\/p>\n<p>\u9690\u8eab\u6a21\u5f0f\u662f\u540e\u52a0\u7684\uff1a\u9876\u680f\u4e00\u952e\u5207\u201c\u5728\u7ebf\/\u9690\u8eab\u201d\u3002\u9690\u8eab\u65f6visible=0\uff0c\u524d\u53f0\u7684\u5927\u5385\u3001\u597d\u53cb\u5217\u8868\u3001\u7fa4\u6210\u5458\u7edf\u7edf\u4e0d\u663e\u793a\u4f60\u5728\u7ebf\u2014\u2014\u4f46\u540e\u53f0\u7ba1\u7406\u4ecd\u7136\u6309\u771f\u5b9e\u72b6\u6001\u7edf\u8ba1\u3002<strong>\u7792\u5f97\u4f4f\u597d\u53cb\uff0c\u7792\u4e0d\u4f4f\u7ba1\u7406\u5458\u3002<\/strong><\/p>\n<h4><strong>\u7fa4\u516c\u544a\u7684\u8bbe\u8ba1<\/strong><\/h4>\n<p>\u7fa4\u516c\u544a\u4e0d\u80fd\u53ea\u53d1\u4e00\u6761\u666e\u901a\u6d88\u606f\u2014\u2014\u4f1a\u88ab\u5237\u5c4f\u9876\u6ca1\u3002\u6211\u7684\u505a\u6cd5\u662f\uff1a\u516c\u544a\u5185\u5bb9\u6301\u4e45\u5316\u5b58\u5728groups\u8868\u7684announcement\u5b57\u6bb5\u91cc\uff0c\u53d1\u5e03\u540e\u5728\u7fa4\u804a\u9876\u90e8\u663e\u793a\u5e38\u9a7b\u6a2a\u5e45\u3001\u8d44\u6599\u9762\u677f\u91cc\u4e5f\u80fd\u770b\uff0c\u540c\u65f6\u4ee5\u4e00\u6761\u5e26\u5b8c\u6574\u5185\u5bb9\u7684\u901a\u77e5\u63a8\u9001\u7ed9\u5168\u4f53\u6210\u5458\u3002<\/p>\n<h4><strong>\u81ea\u5b9a\u4e49\u786e\u8ba4\u5f39\u7a97<\/strong><\/h4>\n<p>\u79fb\u9664\u7fa4\u6210\u5458\u3001\u8f6c\u8ba9\u7fa4\u4e3b\u3001\u89e3\u6563\u7fa4\u2026\u2026\u8fd9\u4e9b\u90fd\u662f\u5371\u9669\u64cd\u4f5c\u3002\u6d4f\u89c8\u5668\u539f\u751fconfirm()\u592a\u4e11\uff0c\u800c\u4e14\u8ddf\u6574\u4e2a\u6bdb\u73bb\u7483UI\u683c\u683c\u4e0d\u5165\u3002\u6211\u5168\u90e8\u6362\u6210\u4e86\u5c4f\u5e55\u4e2d\u592e\u7684\u81ea\u5b9a\u4e49\u5f39\u7a97\u2014\u2014\u7edf\u4e00\u98ce\u683c\u3001\u6709\u4e3b\u6b21\u6309\u94ae\u3001\u8fd8\u80fd\u8ddf\u9875\u9762\u4e3b\u9898\u8054\u52a8\u3002<\/p>\n<h4><strong>\u5b89\u5168\u65b9\u9762<\/strong><\/h4>\n<p>\u804a\u5929\u7cfb\u7edf\u6700\u6015\u88ab\u4eba\u641e\uff0c\u5b89\u5168\u4e0a\u82b1\u4e86\u4e0d\u5c11\u5fc3\u601d\uff1a<\/p>\n<ul>\n<li>\u9884\u5904\u7406\u8bed\u53e5\uff08mysqli prepared statements\uff09\u9632SQL\u6ce8\u5165\uff0c\u6709\u7528\u5417\u6211\u4e5f\u4e0d\u77e5\u9053<\/li>\n<li>htmlspecialchars\u7edf\u4e00\u8f6c\u4e49\u9632XSS<\/li>\n<li>CSRF Token\uff1a\u524d\u7aef\u8bf7\u6c42\u5934 + \u8868\u5355\u9690\u85cf\u5b57\u6bb5\u53cc\u4fdd\u9669<\/li>\n<li>\u4e0a\u4f20\u76ee\u5f55\u653e.htaccess\u7981\u6b62\u6267\u884cPHP\uff0c\u5934\u50cf\u7528GD\u5e93\u91cd\u7ed8\uff0c\u56fe\u7247\/\u6587\u4ef6\u6821\u9a8c\u771f\u5b9e\u7c7b\u578b<\/li>\n<li>\u767b\u5f55\u5931\u8d255\u6b21\u9501\u5b9a15\u5206\u949f\uff0cSession 24\u5c0f\u65f6\u8d85\u65f6<\/li>\n<\/ul>\n<h4><strong>\u6d88\u606f\u64a4\u56de \/ \u5f15\u7528 \/ \u8f6c\u53d1<\/strong><\/h4>\n<p>\u79c1\u804a\u6d88\u606f2\u5206\u949f\u5185\u53ef\u64a4\u56de\uff0c\u652f\u6301\u5f15\u7528\u56de\u590d\u3001\u8f6c\u53d1\u5230\u5176\u4ed6\u4f1a\u8bdd\uff0c\u8fd8\u6709\u201c\u5bf9\u65b9\u6b63\u5728\u8f93\u5165\u2026\u201d\u7684\u8f93\u5165\u72b6\u6001\u63d0\u793a\u3002\u8fd9\u4e9b\u5c0f\u4ea4\u4e92\u5355\u4e2a\u770b\u90fd\u4e0d\u8d77\u773c\uff0c\u4f46\u51d1\u5728\u4e00\u8d77\u4f53\u9a8c\u5c31\u5b8c\u6574\u5f88\u591a\u3002<\/p>\n<h4><strong>\u90ae\u4ef6\u7cfb\u7edf<\/strong><\/h4>\n<p>\u540e\u53f0\u53ef\u4ee5\u914d\u7f6eSMTP\uff08QQ\u3001163\u3001Gmail\u90fd\u652f\u6301\uff0cSSL\/TLS\/\u65e0\u52a0\u5bc6\u4e09\u79cd\u65b9\u5f0f\uff09\uff0c\u914d\u597d\u8fd8\u80fd\u4e00\u952e\u201c\u53d1\u9001\u6d4b\u8bd5\u90ae\u4ef6\u201d\u9a8c\u8bc1\u3002\u53ef\u4ee5\u9009\u62e9\u662f\u5426\u5f00\u542f\u201c\u6ce8\u518c\u90ae\u7bb1\u9a8c\u8bc1\u201d\uff0c\u800c\u5f00\u4e86\u201c\u6ce8\u518c\u90ae\u7bb1\u9a8c\u8bc1\u201d\u540e\uff0c\u6ce8\u518c\u5fc5\u987b\u586b\u90ae\u7bb1\u3001\u70b9\u9a8c\u8bc1\u94fe\u63a5\u624d\u80fd\u767b\u5f55\uff1b\u5fd8\u8bb0\u5bc6\u7801\u4e5f\u8d70\u540c\u4e00\u6761\u901a\u9053\u3002<\/p>\n<h3><strong>\u8fd9\u4e1c\u897f\u80fd\u62ff\u6765\u5e72\u4ec0\u4e48<\/strong><\/h3>\n<ul>\n<li>\u540c\u5b66\u7fa4\u3001\u670b\u53cb\u5c0f\u5708\u5b50\u7684\u4e13\u5c5e\u804a\u5929\u5ba4<\/li>\n<li>\u5b66\u4e60\u5c0f\u7ec4\u3001\u9879\u76ee\u7ec4\u5185\u90e8\u8ba8\u8bba\u7a7a\u95f4<\/li>\n<li>\u81ea\u5df1\u642d\u4e00\u4e2a\u201c\u6570\u636e\u5728\u81ea\u5df1\u624b\u91cc\u201d\u7684\u804a\u5929\u5de5\u5177<\/li>\n<li>\u60f3\u7cfb\u7edf\u7ec3\u624bPHP + MySQL\u5168\u6808\u5f00\u53d1\u7684\u5b66\u4e60\u9879\u76ee<\/li>\n<\/ul>\n<h3><strong>\u4f53\u9a8c\u4e0e\u5f00\u6e90<\/strong><\/h3>\n<p><strong>\u6b64\u9879\u76ee\u4f9d\u65e7\u662f\u5f00\u6e90\u9879\u76ee<\/strong><\/p>\n<p><strong>\u5728\u7ebf\u4f53\u9a8c\uff1a<\/strong><a href=\"https:\/\/china.uuk.pp.ua\/\">https:\/\/china.uuk.pp.ua\/<\/a>\uff08\u8001\u6837\u5b50\uff0c\u94fe\u63a5\u4e0d\u5b9a\u65f6\u5931\u6548\uff0c\u5982\u65e0\u6cd5\u6253\u5f00\u5219\u9ed8\u8ba4\u4f53\u9a8c\u5730\u5740\u53d6\u6d88\uff09<\/p>\n<p><strong>\u5f00\u6e90\u5730\u5740\uff1a<\/strong><a href=\"https:\/\/github.com\/HIWB\/ychat\">HIWB\/ychat: PHP + MySQL \u5728\u7ebf\u804a\u5929\u7cfb\u7edf<\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-191\"  src=\"http:\/\/myboy.vip\/wp-content\/themes\/Kizumi-master\/assets\/images\/loading.gif\" data-src=\"http:\/\/myboy.vip\/wp-content\/uploads\/2026\/08\/ychat-github-300x155.png\" class=\"lazy\" loading=\"lazy\" alt=\"\" srcset=\"https:\/\/myboy.vip\/wp-content\/uploads\/2026\/08\/ychat-github-300x155.png 300w, https:\/\/myboy.vip\/wp-content\/uploads\/2026\/08\/ychat-github-1024x531.png 1024w, https:\/\/myboy.vip\/wp-content\/uploads\/2026\/08\/ychat-github-768x398.png 768w, https:\/\/myboy.vip\/wp-content\/uploads\/2026\/08\/ychat-github-1536x796.png 1536w, https:\/\/myboy.vip\/wp-content\/uploads\/2026\/08\/ychat-github.png 1895w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>\u672c\u9879\u76ee\u4ec5\u4f9b\u5b66\u4e60\u4ea4\u6d41\u4f7f\u7528\uff0c\u6b22\u8fce\u4e0b\u8f7d\u3001\u5b66\u4e60\u3001\u4e8c\u6b21\u5f00\u53d1\u3002<\/p>\n<h3><strong>\u5199\u5728\u6700\u540e<\/strong><\/h3>\n<p>\u4ece\u6700\u5f00\u59cb\u7684\u201c\u60f3\u6709\u4e2a\u81ea\u5df1\u7684\u804a\u5929\u5ba4\u201d\uff0c\u5230\u8bbe\u8ba118\u5f20\u8868\u3001\u519949\u4e2a\u63a5\u53e3\u3001\u8c03\u8f6e\u8be2\u3001\u78e8UI\u3001\u505a\u540e\u53f0\u3001\u90e8\u7f72\u4e0a\u7ebf\u3002\u529f\u80fd\u4e0d\u591a\uff0cBUG\u4e0d\u5c11\u2014\u2014\u865a\u62df\u4e3b\u673a\u4e0d\u8ba4\u4e2d\u6587\u8def\u5f84\u3001PHP\u65b0\u7248\u5f03\u7528GD\u51fd\u6570\u3001\u514d\u8d39\u4e3b\u673a\u4f1a\u62e6\u6587\u4ef6\u540d\u5e26\u201cchat\u201d\u7684\u8d44\u6e90\u2026\u2026\u4e00\u4e2a\u7d27\u63a5\u4e00\u4e2a\uff0c\u4e5f\u4e0d\u4e4f\u8bb8\u591a\u80fd\u591f\u4ee4\u4eba\u5fcd\u4fca\u4e0d\u7981\u7684\u95ee\u9898\uff08\u73b0\u5728\u8001\u7ef7\u5e26\u662f\u4e5f\uff09<\/p>\n<p>\u63d2\u5165\uff1a\u4ec0\u4e48\uff0c\u4eca\u5929\u662f\u4e03\u5915\uff1f\u6211\u8bf4\u7fa4\u91cc\u600e\u4e48\u8fd9\u4e48\u591a\u5c0f\u4f19\u4f34\u5230\u5904@\u8be2\u95ee\u662f\u5426\u5728\u7ebf\uff0c\u539f\u6765\u90fd\u662f\u5355\u8eab\u72d7\u554a\uff0c\u90a3\u6211\u5c31\u4e0d\u4e0a\u7ebf\uff0c\u6025\u6b7b\u4ed6\u4eec\uff08\u7b11\uff09<\/p>\n<p><del>\u518d\u6765\u4e00\u53e5\uff1a\u4e00\u5ba4\u65e2\u6210\uff0c\u4e07\u4eba\u53ef\u805a\uff1b\u6570\u636e\u5728\u624b\uff0c\u65b9\u5bf8\u81ea\u7559\u3002<\/del><\/p>\n<p>\u6700\u540e\uff0c\u9879\u76ee\u4ecd\u5728\u6301\u7eed\u5b8c\u5584\u4e2d\uff0c\u5982\u6709\u5e2e\u52a9\uff0c\u4e0d\u59a8\u70b9\u4e2a \u2b50 Star \u652f\u6301\u4e00\u4e0b\u3002<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\u4e2a\u804a\u5929\u5ba4\u7684\u8bde\u751f\uff1aPHP + MySQL \u5168\u6808\u5b9e\u5f55 \u4f9d\u65e7\u201c\u4f5c\u6848\u52a8\u673a\u201d \u8bf4\u5b9e\u8bdd\uff0cQQ\u548c\u5fae\u4fe1\u8fd9\u4e24\u4e2a\u201c\u8001\u5927\u54e5\u201d\u5df2\u7ecf\u5f88\u597d\u7528\u4e86\u3002\u4f46\u7528\u5f97\u8d8a\u4e45\uff0c\u8d8a\u89c9\u5f97\u6709\u4e9b\u5730\u65b9\u4e0d\u5bf9\u52b2\uff1a \u7fa4\u804a\u6d88\u606f\u5237\u5f97\u98de\u5feb\uff0c\u91cd\u8981\u5185\u5bb9\u7728\u773c\u5c31\u88ab\u6df9\u6ca1\uff0c\u60f3\u5f80\u56de\u7ffb\u6839\u672c\u627e\u4e0d\u5230 \u7fa4\u662f\u522b\u4eba\u5efa\u7684\uff0c\u89c4\u5219\u662f\u5e73\u53f0\u5b9a\u7684\uff0c\u4f60\u6c38\u8fdc\u662f\u4e2a\u201c\u5ba2\u4eba\u201d \u8bf4\u5c01\u5c31\u5c01\u3001\u8bf4\u5220\u5c31\u5220\uff0c\u6570\u636e\u4ece\u6765\u4e0d\u5728\u81ea\u5df1\u624b\u91cc \u6211\u60f3\u8981\u4e00\u4e2a\u81ea\u5df1\u8bf4\u4e86\u7b97\u7684\u804a\u5929\u5730\u65b9\u2014\u2014\u6570\u636e\u5728\u81ea\u5df1\u6570\u636e\u5e93\u91cc\uff0c\u529f\u80fd\u81ea\u5df1\u5b9a\uff0c\u89c4\u5219\u81ea\u5df1\u8bbe\uff0c\u670b\u53cb\u62c9\u8fdb\u6765\u5c31\u80fd\u804a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":190,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,18],"tags":[],"class_list":["post-181","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","category-18"],"_links":{"self":[{"href":"https:\/\/myboy.vip\/index.php?rest_route=\/wp\/v2\/posts\/181","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myboy.vip\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/myboy.vip\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/myboy.vip\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/myboy.vip\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=181"}],"version-history":[{"count":7,"href":"https:\/\/myboy.vip\/index.php?rest_route=\/wp\/v2\/posts\/181\/revisions"}],"predecessor-version":[{"id":192,"href":"https:\/\/myboy.vip\/index.php?rest_route=\/wp\/v2\/posts\/181\/revisions\/192"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/myboy.vip\/index.php?rest_route=\/wp\/v2\/media\/190"}],"wp:attachment":[{"href":"https:\/\/myboy.vip\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=181"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myboy.vip\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=181"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myboy.vip\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=181"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}