{"id":737,"date":"2025-07-12T03:04:30","date_gmt":"2025-07-12T03:04:30","guid":{"rendered":"https:\/\/easyaccsoft.com\/webdesign\/?p=737"},"modified":"2025-07-12T03:04:30","modified_gmt":"2025-07-12T03:04:30","slug":"php-%e8%87%aa%e5%8a%a8%e5%8c%b9%e9%85%8d%e8%af%8a%e6%96%ad%e5%87%bd%e6%95%b0","status":"publish","type":"post","link":"https:\/\/easyaccsoft.com\/webdesign\/2025\/07\/12\/php-%e8%87%aa%e5%8a%a8%e5%8c%b9%e9%85%8d%e8%af%8a%e6%96%ad%e5%87%bd%e6%95%b0\/","title":{"rendered":"PHP \u81ea\u52a8\u5339\u914d\u8bca\u65ad\u51fd\u6570"},"content":{"rendered":"\n<p>\u4ee5\u4e0b\u662f\u5b8c\u6574\u7684 <strong>PHP \u81ea\u52a8\u5339\u914d\u8bca\u65ad\u51fd\u6570<\/strong>\uff0c\u5b83\u4ece <strong>MySQL \u6570\u636e\u5e93\u4e2d\u7684 <code>diagnosis_rules<\/code> \u8868<\/strong> \u4e2d\u8bfb\u53d6\u89c4\u5219\u5e76\u5339\u914d\u7528\u6237\u8f93\u5165\u7684\u75c7\u72b6\u3001\u820c\u8c61\u3001\u8109\u8c61\uff0c\u8f93\u51fa\u6700\u4f73\u8bc1\u578b\u4e0e\u63a8\u8350\u65b9\u5242\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u2705 \u4e00\u3001\u51c6\u5907\u5de5\u4f5c\uff08\u786e\u4fdd\u4ee5\u4e0b\uff09\uff1a<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u5df2\u5efa\u7acb <code>diagnosis_rules<\/code> \u8868<\/li>\n\n\n\n<li>\u8868\u4e2d\u5b57\u6bb5\u5305\u62ec\uff1a<code>diagnosis<\/code>, <code>formula<\/code>, <code>symptoms<\/code>, <code>tongue<\/code>, <code>pulse<\/code>\uff08\u75c7\u72b6\u548c\u8109\u8c61\u4e3a JSON \u683c\u5f0f\uff09<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83e\udde0 \u4e8c\u3001PHP \u51fd\u6570\uff1a<code>diagnose_from_db()<\/code><\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;?php\nfunction diagnose_from_db($conn, $user_symptoms, $tongue_input, $pulse_input) {\n    $sql = \"SELECT * FROM diagnosis_rules\";\n    $result = mysqli_query($conn, $sql);\n\n    $best_match = null;\n    $max_score = 0;\n\n    while ($row = mysqli_fetch_assoc($result)) {\n        $score = 0;\n        $rule_symptoms = json_decode($row&#91;'symptoms'], true);\n        $rule_pulse = json_decode($row&#91;'pulse'], true);\n        $rule_tongue = $row&#91;'tongue'];\n\n        \/\/ \u75c7\u72b6\u5339\u914d\uff1a\u5173\u952e\u8bcd\u6a21\u7cca\u5339\u914d\n        foreach ($rule_symptoms as $keyword) {\n            foreach ($user_symptoms as $symptom) {\n                if (strpos($symptom, $keyword) !== false) {\n                    $score++;\n                    break;\n                }\n            }\n        }\n\n        \/\/ \u820c\u8c61\u5339\u914d\n        if (!empty($rule_tongue) &amp;&amp; $rule_tongue === $tongue_input) {\n            $score++;\n        }\n\n        \/\/ \u8109\u8c61\u5339\u914d\n        foreach ($rule_pulse as $p_keyword) {\n            foreach ($pulse_input as $p_input) {\n                if (strpos($p_input, $p_keyword) !== false) {\n                    $score++;\n                    break;\n                }\n            }\n        }\n\n        \/\/ \u8bb0\u5f55\u6700\u4f73\u5339\u914d\n        if ($score &gt; $max_score) {\n            $max_score = $score;\n            $best_match = &#91;\n                'diagnosis' =&gt; $row&#91;'diagnosis'],\n                'formula' =&gt; $row&#91;'formula'],\n                'score' =&gt; $score\n            ];\n        }\n    }\n\n    return $best_match ?: &#91;'diagnosis' =&gt; '\u65e0\u5339\u914d\u8bc1\u578b', 'formula' =&gt; '\u8bf7\u4eba\u5de5\u5224\u65ad', 'score' =&gt; 0];\n}\n?&gt;\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83e\uddea \u4e09\u3001\u4f7f\u7528\u65b9\u6cd5\uff08\u524d\u7aef\u8c03\u7528\u4f8b\u5b50\uff09<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;?php\nrequire_once 'db_connect.php'; \/\/ \u5305\u542b $conn\nrequire_once 'diagnose_function.php'; \/\/ \u4e0a\u8ff0\u51fd\u6570\u6587\u4ef6\n\n$user_symptoms = &#91;'\u54b3\u55fd', '\u75f0\u591a', '\u53e3\u6e34'];\n$tongue = '\u9ec4\u817b';\n$pulse = &#91;'\u6ed1'];\n\n$result = diagnose_from_db($conn, $user_symptoms, $tongue, $pulse);\n\necho \"\u5efa\u8bae\u8bc1\u578b\uff1a{$result&#91;'diagnosis']}&lt;br&gt;\";\necho \"\u63a8\u8350\u65b9\u5242\uff1a{$result&#91;'formula']}&lt;br&gt;\";\necho \"\u5339\u914d\u5f97\u5206\uff1a{$result&#91;'score']}\";\n?&gt;\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udccc \u56db\u3001\u6ce8\u610f\u4e8b\u9879<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>symptoms<\/code> \u4e0e <code>pulse<\/code> \u5b57\u6bb5\u9700\u4e3a JSON \u683c\u5f0f\uff0c\u5982\uff1a<code>[\"\u54b3\",\"\u75f0\"]<\/code>\u3002<\/li>\n\n\n\n<li>\u652f\u6301\u6a21\u7cca\u5339\u914d\uff08\u5982\u201c\u54b3\u55fd\u201d\u80fd\u5339\u914d\u201c\u54b3\u201d\u89c4\u5219\uff09\u3002<\/li>\n\n\n\n<li>\u652f\u6301\u8bc4\u5206\u673a\u5236\uff0c\u53ef\u672a\u6765\u6269\u5c55\u591a\u5019\u9009\u65b9\u6848\u3002<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\u662f\u5426\u9700\u8981\u6211\u5e2e\u4f60\uff1a<\/p>\n\n\n\n<p>\u2705 \u6574\u7406 <code>diagnose_function.php<\/code> \u6587\u4ef6\uff1f<br>\u2705 \u589e\u52a0\u201c\u591a\u5019\u9009\u7ed3\u679c\u6392\u5e8f\u201d\uff1f<br>\u2705 \u6574\u5408 HTML \u8868\u5355\u524d\u7aef + \u663e\u793a\u5339\u914d\u5206\u6790\uff1f<\/p>\n\n\n\n<p>\u544a\u8bc9\u6211\u4f60\u7684\u4e0b\u4e00\u6b65\u76ee\u6807\uff0c\u6211\u53ef\u4ee5\u5feb\u901f\u751f\u6210\u6574\u5957\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4ee5\u4e0b\u662f\u5b8c\u6574\u7684 PHP \u81ea\u52a8\u5339\u914d\u8bca\u65ad\u51fd\u6570\uff0c\u5b83\u4ece MySQL \u6570\u636e\u5e93\u4e2d\u7684 diagnosis_rules \u8868 \u4e2d\u8bfb\u53d6\u89c4\u5219\u5e76\u5339\u914d\u7528\u6237\u8f93\u5165\u7684\u75c7\u72b6\u3001\u820c\u8c61\u3001\u8109\u8c61\uff0c\u8f93\u51fa\u6700\u4f73\u8bc1\u578b\u4e0e\u63a8\u8350\u65b9\u5242\u3002 \u2705 \u4e00\u3001\u51c6\u5907\u5de5\u4f5c\uff08\u786e\u4fdd\u4ee5\u4e0b\uff09\uff1a \ud83e\udde0 \u4e8c\u3001PHP \u51fd\u6570\uff1adiagnose_from_db() \ud83e\uddea \u4e09\u3001\u4f7f\u7528\u65b9\u6cd5\uff08\u524d\u7aef\u8c03\u7528\u4f8b\u5b50\uff09 \ud83d\udccc \u56db\u3001\u6ce8\u610f\u4e8b\u9879 \u662f\u5426\u9700\u8981\u6211\u5e2e\u4f60\uff1a \u2705 \u6574\u7406 diagnose_function.php \u6587\u4ef6\uff1f\u2705 \u589e\u52a0\u201c\u591a\u5019\u9009\u7ed3\u679c\u6392\u5e8f\u201d\uff1f\u2705 \u6574\u5408 HTML \u8868\u5355\u524d\u7aef + \u663e\u793a\u5339\u914d\u5206\u6790\uff1f \u544a\u8bc9\u6211\u4f60\u7684\u4e0b\u4e00\u6b65\u76ee\u6807\uff0c\u6211\u53ef\u4ee5\u5feb\u901f\u751f\u6210\u6574\u5957\uff01<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-737","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/easyaccsoft.com\/webdesign\/wp-json\/wp\/v2\/posts\/737","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/easyaccsoft.com\/webdesign\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/easyaccsoft.com\/webdesign\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/easyaccsoft.com\/webdesign\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/easyaccsoft.com\/webdesign\/wp-json\/wp\/v2\/comments?post=737"}],"version-history":[{"count":1,"href":"https:\/\/easyaccsoft.com\/webdesign\/wp-json\/wp\/v2\/posts\/737\/revisions"}],"predecessor-version":[{"id":738,"href":"https:\/\/easyaccsoft.com\/webdesign\/wp-json\/wp\/v2\/posts\/737\/revisions\/738"}],"wp:attachment":[{"href":"https:\/\/easyaccsoft.com\/webdesign\/wp-json\/wp\/v2\/media?parent=737"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/easyaccsoft.com\/webdesign\/wp-json\/wp\/v2\/categories?post=737"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/easyaccsoft.com\/webdesign\/wp-json\/wp\/v2\/tags?post=737"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}