{"id":632,"date":"2025-06-30T02:08:30","date_gmt":"2025-06-30T02:08:30","guid":{"rendered":"https:\/\/easyaccsoft.com\/webdesign\/?p=632"},"modified":"2025-06-30T02:54:35","modified_gmt":"2025-06-30T02:54:35","slug":"gpt-%e4%b8%ad%e5%8c%bb%e8%be%a8%e8%af%81%e8%ae%ba%e6%b2%bb%e7%b3%bb%e7%bb%9f%ef%bc%88tcm-syndrome-differentiation-treatment-system%ef%bc%89","status":"publish","type":"post","link":"https:\/\/easyaccsoft.com\/webdesign\/2025\/06\/30\/gpt-%e4%b8%ad%e5%8c%bb%e8%be%a8%e8%af%81%e8%ae%ba%e6%b2%bb%e7%b3%bb%e7%bb%9f%ef%bc%88tcm-syndrome-differentiation-treatment-system%ef%bc%89\/","title":{"rendered":"gpt \u4e2d\u533b\u8fa8\u8bc1\u8bba\u6cbb\u7cfb\u7edf\uff08TCM Syndrome Differentiation & Treatment System\uff09"},"content":{"rendered":"\n

\u5982\u679c\u4f60\u6b63\u5728\u6784\u5efa\u4e00\u4e2a \u4e2d\u533b\u8fa8\u8bc1\u8bba\u6cbb\u7cfb\u7edf\uff08TCM Syndrome Differentiation & Treatment System\uff09<\/strong>\uff0c\u5e76\u8ba1\u5212\u4f7f\u7528 MySQL + PHP<\/strong> \u6280\u672f\u6808\uff0c\u4ee5\u4e0b\u662f\u4e00\u4e2a\u5b8c\u6574\u7684\u7cfb\u7edf\u6784\u601d\u4e0e\u5f00\u53d1\u5efa\u8bae\uff1a<\/p>\n\n\n\n

\n\n\n\n

\u2705 \u4e00\u3001\u7cfb\u7edf\u529f\u80fd\u67b6\u6784\uff08\u6982\u8981\uff09<\/h2>\n\n\n\n

1. \u7528\u6237\u7ba1\u7406\u6a21\u5757<\/h3>\n\n\n\n
    \n
  • \u7528\u6237\u767b\u5f55\u3001\u6743\u9650\u5206\u7ea7\uff08\u5982\u533b\u5e08\/\u52a9\u7406\/\u7ba1\u7406\u5458\uff09<\/li>\n\n\n\n
  • \u6863\u6848\u7ba1\u7406\u3001\u5bc6\u7801\u91cd\u7f6e<\/li>\n<\/ul>\n\n\n\n

    2. \u60a3\u8005\u7ba1\u7406\u6a21\u5757<\/h3>\n\n\n\n
      \n
    • \u65b0\u589e\/\u67e5\u8be2\/\u7f16\u8f91\u60a3\u8005\u6863\u6848<\/li>\n\n\n\n
    • \u60a3\u8005\u5386\u53f2\u95ee\u8bca\u8bb0\u5f55\u67e5\u770b<\/li>\n<\/ul>\n\n\n\n

      3. \u95ee\u8bca\u4e0e\u8fa8\u8bc1\u6a21\u5757<\/h3>\n\n\n\n
        \n
      • \u95ee\u8bca\u8868\u5355\uff08\u4e3b\u8bc9\u3001\u75c7\u72b6\u3001\u820c\u8c61\u3001\u8109\u8c61\u7b49\uff09<\/li>\n\n\n\n
      • \u81ea\u52a8\u63d0\u53d6\u5173\u952e\u8bcd \u2192 \u5bf9\u5e94\u8bc1\u578b\uff08\u5982\u6c14\u865a\u3001\u8840\u7600\u3001\u6e7f\u70ed\u7b49\uff09<\/li>\n\n\n\n
      • \u81ea\u52a8\u63a8\u8350\u6cbb\u7597\u65b9\u6848\/\u65b9\u5242<\/li>\n<\/ul>\n\n\n\n

        4. \u65b9\u5242\u4e0e\u6cbb\u7597\u6a21\u5757<\/h3>\n\n\n\n
          \n
        • \u5185\u7f6e\u5e38\u7528\u4e2d\u533b\u65b9\u5242\u6570\u636e\u5e93<\/li>\n\n\n\n
        • \u652f\u6301\u624b\u52a8\u914d\u65b9\u3001\u63a8\u8350\u5339\u914d\u65b9\u5242\u3001\u5242\u91cf\u8c03\u6574<\/li>\n\n\n\n
        • \u652f\u6301\u751f\u6210\u6cbb\u7597\u5efa\u8bae\u4e0e\u6253\u5370\u62a5\u544a<\/li>\n<\/ul>\n\n\n\n

          5. \u62a5\u544a\u5bfc\u51fa\u4e0e\u7edf\u8ba1\u6a21\u5757<\/h3>\n\n\n\n
            \n
          • \u652f\u6301\u5bfc\u51fa\u95ee\u8bca\u8bb0\u5f55\u4e3a PDF \u6216 Excel<\/li>\n\n\n\n
          • \u7edf\u8ba1\u5e38\u89c1\u8bc1\u578b\u3001\u6cbb\u7597\u9891\u7387\u3001\u7597\u6548\u8d8b\u52bf\u7b49<\/li>\n<\/ul>\n\n\n\n
            \n\n\n\n

            \u2705 \u4e8c\u3001\u6570\u636e\u5e93\u8bbe\u8ba1\uff08MySQL\uff09<\/h2>\n\n\n\n

            1. \u7528\u6237\u8868 users<\/code><\/h3>\n\n\n\n
            CREATE TABLE users (\n  id INT PRIMARY KEY AUTO_INCREMENT,\n  username VARCHAR(50) UNIQUE,\n  password VARCHAR(255),\n  role ENUM('admin', 'doctor', 'assistant'),\n  created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n);\n<\/code><\/pre>\n\n\n\n
            2. \u60a3\u8005\u8868 patients<\/code><\/h3>\n\n\n\n
            CREATE TABLE patients (\n  id INT PRIMARY KEY AUTO_INCREMENT,\n  name VARCHAR(100),\n  gender ENUM('\u7537', '\u5973'),\n  age INT,\n  contact_info VARCHAR(255),\n  created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n);\n<\/code><\/pre>\n\n\n\n
            3. \u95ee\u8bca\u8bb0\u5f55 consultations<\/code><\/h3>\n\n\n\n
            CREATE TABLE consultations (\n  id INT PRIMARY KEY AUTO_INCREMENT,\n  patient_id INT,\n  doctor_id INT,\n  visit_date DATE,\n  chief_complaint TEXT,\n  symptoms TEXT,\n  tongue TEXT,\n  pulse TEXT,\n  tcm_syndrome TEXT,\n  diagnosis TEXT,\n  treatment_plan TEXT,\n  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n  FOREIGN KEY (patient_id) REFERENCES patients(id),\n  FOREIGN KEY (doctor_id) REFERENCES users(id)\n);\n<\/code><\/pre>\n\n\n\n
            4. \u65b9\u5242\u8868 formulas<\/code><\/h3>\n\n\n\n
            CREATE TABLE formulas (\n  id INT PRIMARY KEY AUTO_INCREMENT,\n  name VARCHAR(100),\n  syndrome TEXT,\n  ingredients TEXT,\n  usage TEXT,\n  remarks TEXT\n);\n<\/code><\/pre>\n\n\n\n
            \n\n\n\n
            \u2705 \u4e09\u3001PHP \u529f\u80fd\u6a21\u5757\u5efa\u8bae<\/h2>\n\n\n\n
            \u2714 \u767b\u5f55\u8ba4\u8bc1\u6a21\u5757\uff08login.php<\/code>\uff09<\/h3>\n\n\n\n
              \n
            • \u8f93\u5165\u7528\u6237\u540d\/\u5bc6\u7801<\/li>\n\n\n\n
            • \u9a8c\u8bc1\u5bc6\u7801\u54c8\u5e0c<\/li>\n\n\n\n
            • \u8bbe\u7f6e session \u6216 JWT<\/li>\n<\/ul>\n\n\n\n
              \u2714 \u95ee\u8bca\u8868\u5355\u9875\u9762\uff08consultation_form.php<\/code>\uff09<\/h3>\n\n\n\n
                \n
              • \u63d0\u4f9b HTML \u8868\u5355\u7528\u4e8e\u5f55\u5165\u75c7\u72b6<\/li>\n\n\n\n
              • \u63d0\u4ea4\u540e\u7528 PHP \u8fdb\u884c\u5173\u952e\u8bcd\u5339\u914d\uff1a<\/li>\n<\/ul>\n\n\n\n
                if (strpos($symptoms, '\u53e3\u5e72') !== false && strpos($tongue, '\u7ea2') !== false) {\n    $syndrome = \"\u9634\u865a\u706b\u65fa\";\n}\n<\/code><\/pre>\n\n\n\n
                \u2714 \u81ea\u52a8\u63a8\u8350\u65b9\u5242\u6a21\u5757<\/h3>\n\n\n\n
                $query = \"SELECT * FROM formulas WHERE syndrome LIKE '%$syndrome%'\";\n$result = mysqli_query($conn, $query);\n<\/code><\/pre>\n\n\n\n
                \u2714 \u751f\u6210 PDF \u62a5\u544a\uff08\u4f7f\u7528 TCPDF \u6216 mPDF\uff09<\/h3>\n\n\n\n
                require('tcpdf\/tcpdf.php');\n\/\/ \u521b\u5efa\u5e76\u586b\u5145\u62a5\u544a\u5185\u5bb9\n<\/code><\/pre>\n\n\n\n
                \n\n\n\n
                \u2705 \u56db\u3001\u524d\u7aef\u754c\u9762\uff08HTML + Bootstrap\uff09<\/h2>\n\n\n\n
                \u8868\u5355\u6837\u5f0f\u53c2\u8003\uff1a<\/p>\n\n\n\n
                <form method=\"post\" action=\"submit_consultation.php\">\n  <label>\u4e3b\u8bc9\uff1a<\/label><textarea name=\"chief_complaint\"><\/textarea>\n  <label>\u75c7\u72b6\uff1a<\/label><textarea name=\"symptoms\"><\/textarea>\n  <label>\u820c\u8c61\uff1a<\/label><input name=\"tongue\" \/>\n  <label>\u8109\u8c61\uff1a<\/label><input name=\"pulse\" \/>\n  <button type=\"submit\">\u63d0\u4ea4<\/button>\n<\/form>\n<\/code><\/pre>\n\n\n\n
                \n\n\n\n
                \u2705 \u4e94\u3001\u9644\u52a0\u529f\u80fd\u5efa\u8bae\uff08\u8fdb\u9636\uff09<\/h2>\n\n\n\n
                \u529f\u80fd<\/th>\u5de5\u5177\u5efa\u8bae<\/th><\/tr><\/thead>
                \u75c7\u72b6\u667a\u80fd\u63d0\u53d6<\/td>\u53ef\u7528 PHP \u89c4\u5219\u5224\u65ad\u6216\u63a5\u5165 Python \u6a21\u578b<\/td><\/tr>
                \u591a\u8bed\u8a00\u652f\u6301\uff08\u4e2d\u82f1\u5bf9\u7167\uff09<\/td>PHP \u591a\u8bed\u8a00\u6587\u4ef6\u7ba1\u7406<\/td><\/tr>
                \u5c0f\u7a0b\u5e8f\u540c\u6b65\u63a5\u53e3<\/td>\u7528 PHP \u6784\u5efa RESTful API<\/td><\/tr>
                \u81ea\u52a8\u63a8\u65ad\u8bc1\u578b AI \u6a21\u578b<\/td>\u53ef\u8003\u8651 TensorFlow.js \/ Python \u540e\u53f0\u670d\u52a1<\/td><\/tr>
                \u6570\u636e\u5907\u4efd\u4e0e\u5bfc\u51fa<\/td>\u81ea\u52a8\u6267\u884c SQL dump + ZIP \u4e0b\u8f7d<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
                \n\n\n\n
                \u5982\u679c\u4f60\u9700\u8981\uff0c\u6211\u53ef\u4ee5\uff1a<\/p>\n\n\n\n
                  \n
                1. \u5e2e\u4f60\u6784\u5efa\u5b8c\u6574\u6570\u636e\u5e93 .sql<\/code> \u6587\u4ef6<\/li>\n\n\n\n
                2. \u7f16\u5199\u5173\u952e PHP \u6587\u4ef6<\/li>\n\n\n\n
                3. \u5236\u4f5c\u524d\u7aef HTML+CSS \u8868\u5355\u9875\u9762<\/li>\n\n\n\n
                4. \u63d0\u4f9b\u4e00\u4e2a AI \u8bc1\u578b\u5224\u65ad\u7b97\u6cd5\u793a\u4f8b\uff08\u57fa\u4e8e PHP \u903b\u8f91\u6216 Python Flask API\uff09<\/li>\n<\/ol>\n\n\n\n
                  \n\n\n\n
                  \u662f\u5426\u5e0c\u671b\u6211\u4e3a\u4f60\u751f\u6210\u4e00\u4e2a\u5b8c\u6574\u7684\u8d77\u59cb\u9879\u76ee\u76ee\u5f55\u7ed3\u6784\u548c\u4ee3\u7801\u6a21\u677f\uff1f\u53ef\u4e00\u6b65\u4e00\u6b65\u5206\u6bb5\u8fdb\u884c\u5f00\u53d1\u3002<\/p>\n\n\n\n
                  \u4ee5\u4e0b\u662f\u4e3a\u4e2d\u533b\u8fa8\u8bc1\u8bba\u6cbb\u7cfb\u7edf\u91cf\u8eab\u5b9a\u5236\u7684 MySQL \u6570\u636e\u5e93\u7ed3\u6784\uff08.sql \u6587\u4ef6\uff09<\/strong>\uff0c\u6db5\u76d6\u7528\u6237\u3001\u60a3\u8005\u3001\u95ee\u8bca\u8bb0\u5f55\u3001\u65b9\u5242\u3001\u8bc1\u578b\u7b49\u4e3b\u8981\u6a21\u5757\uff1a<\/p>\n\n\n\n
                  \n\n\n\n
                  \u2705 \u6570\u636e\u5e93\u540d\u79f0<\/h2>\n\n\n\n
                  CREATE DATABASE IF NOT EXISTS tcm_system CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\nUSE tcm_system;\n<\/code><\/pre>\n\n\n\n
                  \n\n\n\n
                  \u2705 1. \u7528\u6237\u8868 users<\/code><\/h2>\n\n\n\n
                  CREATE TABLE users (\n  id INT AUTO_INCREMENT PRIMARY KEY,\n  username VARCHAR(50) NOT NULL UNIQUE,\n  password VARCHAR(255) NOT NULL,\n  full_name VARCHAR(100),\n  role ENUM('admin', 'doctor', 'assistant') DEFAULT 'doctor',\n  created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n);\n<\/code><\/pre>\n\n\n\n
                  \n\n\n\n
                  \u2705 2. \u60a3\u8005\u8868 patients<\/code><\/h2>\n\n\n\n
                  CREATE TABLE patients (\n  id INT AUTO_INCREMENT PRIMARY KEY,\n  name VARCHAR(100) NOT NULL,\n  gender ENUM('\u7537', '\u5973') NOT NULL,\n  birth_date DATE,\n  phone VARCHAR(20),\n  address VARCHAR(255),\n  medical_history TEXT,\n  created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n);\n<\/code><\/pre>\n\n\n\n
                  \n\n\n\n
                  \u2705 3. \u95ee\u8bca\u8bb0\u5f55\u8868 consultations<\/code><\/h2>\n\n\n\n
                  CREATE TABLE consultations (\n  id INT AUTO_INCREMENT PRIMARY KEY,\n  patient_id INT NOT NULL,\n  doctor_id INT NOT NULL,\n  visit_date DATE NOT NULL,\n  chief_complaint TEXT,\n  symptoms TEXT,\n  tongue TEXT,\n  pulse TEXT,\n  diagnosis TEXT,\n  tcm_syndrome TEXT,\n  treatment_plan TEXT,\n  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n  FOREIGN KEY (patient_id) REFERENCES patients(id) ON DELETE CASCADE,\n  FOREIGN KEY (doctor_id) REFERENCES users(id) ON DELETE SET NULL\n);\n<\/code><\/pre>\n\n\n\n
                  \n\n\n\n
                  \u2705 4. \u65b9\u5242\u8868 formulas<\/code><\/h2>\n\n\n\n
                  CREATE TABLE formulas (\n  id INT AUTO_INCREMENT PRIMARY KEY,\n  name VARCHAR(100) NOT NULL,\n  syndrome TEXT,\n  ingredients TEXT,  -- \u4f8b\u5982\uff1a\u7518\u834910g, \u767d\u672f12g, \u832f\u82d312g\n  usage TEXT,\n  indications TEXT,\n  created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n);\n<\/code><\/pre>\n\n\n\n
                  \n\n\n\n
                  \u2705 5. \u8bc1\u578b\u8bcd\u5e93\u8868 syndrome_library<\/code>\uff08\u7528\u4e8e\u5339\u914d\uff09<\/h2>\n\n\n\n
                  CREATE TABLE syndrome_library (\n  id INT AUTO_INCREMENT PRIMARY KEY,\n  syndrome_name VARCHAR(100) NOT NULL,  -- \u4f8b\u5982\uff1a\u809d\u90c1\u6c14\u6ede\n  keywords TEXT,                        -- \u4f8b\u5982\uff1a\u80f8\u95f7,\u53f9\u6c14,\u60c5\u7eea\u4f4e\u843d\n  recommended_formulas TEXT            -- \u4f8b\u5982\uff1a\u900d\u9065\u6563\n);\n<\/code><\/pre>\n\n\n\n
                  \n\n\n\n
                  \u2705 6. \u95ee\u8bca\u8bb0\u5f55\u4e0e\u65b9\u5242\u7684\u5173\u7cfb\u8868\uff08\u591a\u5bf9\u591a\uff09consultation_formulas<\/code><\/h2>\n\n\n\n
                  CREATE TABLE consultation_formulas (\n  id INT AUTO_INCREMENT PRIMARY KEY,\n  consultation_id INT,\n  formula_id INT,\n  dosage_adjustment TEXT,\n  notes TEXT,\n  FOREIGN KEY (consultation_id) REFERENCES consultations(id) ON DELETE CASCADE,\n  FOREIGN KEY (formula_id) REFERENCES formulas(id) ON DELETE CASCADE\n);\n<\/code><\/pre>\n\n\n\n
                  \n\n\n\n
                  \u2705 \u53ef\u9009\uff1a\u4e2d\u836f\u6750\u8868 herbs<\/code>\uff08\u7528\u4e8e\u65b9\u5242\u7cbe\u7ec6\u5316\u7ba1\u7406\uff09<\/h2>\n\n\n\n
                  CREATE TABLE herbs (\n  id INT AUTO_INCREMENT PRIMARY KEY,\n  name VARCHAR(100) NOT NULL,\n  pinyin VARCHAR(100),\n  nature VARCHAR(50),    -- \u6027\uff1a\u5bd2\u3001\u70ed\u3001\u6e29\u3001\u51c9\u3001\u5e73\n  flavor VARCHAR(50),    -- \u5473\uff1a\u7518\u3001\u8f9b\u3001\u82e6\u3001\u54b8\u3001\u9178\n  meridian TEXT,         -- \u5f52\u7ecf\uff1a\u809d\u3001\u5fc3\u3001\u80ba\u7b49\n  effects TEXT,          -- \u529f\u6548\n  contraindications TEXT,\n  created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n);\n<\/code><\/pre>\n\n\n\n
                  \n\n\n\n
                  \ud83d\udd04 \u793a\u4f8b\u6570\u636e\uff08\u53ef\u9009\uff09<\/h3>\n\n\n\n
                  INSERT INTO users (username, password, full_name, role)\nVALUES ('admin', SHA2('admin123', 256), '\u7ba1\u7406\u5458', 'admin');\n\nINSERT INTO formulas (name, syndrome, ingredients, usage, indications)\nVALUES ('\u56db\u541b\u5b50\u6c64', '\u813e\u6c14\u865a', '\u515a\u53c210g, \u767d\u672f10g, \u832f\u82d310g, \u7518\u83496g', '\u6c34\u714e\u670d\uff0c\u6bcf\u65e5\u4e00\u5242', '\u9762\u8272\u82cd\u767d\uff0c\u5026\u6020\u4e4f\u529b\uff0c\u7eb3\u5446\u8179\u80c0');\n\nINSERT INTO syndrome_library (syndrome_name, keywords, recommended_formulas)\nVALUES ('\u809d\u90c1\u6c14\u6ede', '\u80f8\u95f7,\u53f9\u6c14,\u6613\u6012,\u80c1\u75db', '\u900d\u9065\u6563');\n<\/code><\/pre>\n\n\n\n
                  \n\n\n\n
                  \ud83e\uddfe \u6700\u7ec8\u5bfc\u51fa\u8bf4\u660e<\/h3>\n\n\n\n
                  \u4f60\u53ef\u4ee5\u5c06\u4ee5\u4e0a .sql<\/code> \u5185\u5bb9\u4fdd\u5b58\u4e3a\u6587\u4ef6\uff0c\u4f8b\u5982\uff1atcm_system.sql<\/code>\uff0c\u5e76\u7528\u4ee5\u4e0b\u65b9\u5f0f\u5bfc\u5165\uff1a<\/p>\n\n\n\n
                  mysql -u root -p < tcm_system.sql\n<\/code><\/pre>\n\n\n\n
                  \u6216\u5728 phpMyAdmin \u4e2d\u76f4\u63a5\u5bfc\u5165\u3002<\/p>\n\n\n\n
                  \n\n\n\n
                  \u5982\u679c\u4f60\u8fd8\u9700\u8981\uff1a<\/p>\n\n\n\n
                    \n
                  • \u5bf9\u5e94\u7684 PHP \u540e\u53f0\u7ba1\u7406\u9875\u9762\uff1b<\/li>\n\n\n\n
                  • \u524d\u7aef HTML \u95ee\u8bca\u8868\u5355\uff1b<\/li>\n\n\n\n
                  • \u667a\u80fd\u8fa8\u8bc1\u5339\u914d\u903b\u8f91\uff08PHP \u5b9e\u73b0\uff09\uff1b<\/li>\n<\/ul>\n\n\n\n
                    \u6211\u53ef\u4ee5\u7ee7\u7eed\u4e3a\u4f60\u4e00\u4e00\u6784\u5efa\u3002\u662f\u5426\u7ee7\u7eed\u4e0b\u4e00\u6b65\uff1f\uff08\u5982\u751f\u6210\u8868\u5355\u9875\u9762\u6216\u540e\u53f0 PHP \u811a\u672c\uff09<\/p>\n\n\n\n
                    \u4ee5\u4e0b\u662f\u4e3a\u4f60\u8bbe\u8ba1\u7684 \u4e2d\u533b\u8fa8\u8bc1\u8bba\u6cbb\u7cfb\u7edf<\/strong> \u7684 PHP \u540e\u53f0\u7ba1\u7406\u9875\u9762\u6846\u67b6\uff08\u542b\u76ee\u5f55\u7ed3\u6784 + \u6837\u677f\u4ee3\u7801\uff09<\/strong>\uff0c\u5b9e\u73b0\u7528\u6237\u7ba1\u7406\u3001\u60a3\u8005\u7ba1\u7406\u3001\u95ee\u8bca\u8bb0\u5f55\u5f55\u5165\u4e0e\u65b9\u5242\u63a8\u8350\u7b49\u57fa\u7840\u529f\u80fd\u3002<\/p>\n\n\n\n
                    \n\n\n\n
                    \u2705 \u4e00\u3001\u9879\u76ee\u76ee\u5f55\u7ed3\u6784\u5efa\u8bae<\/h2>\n\n\n\n
                    tcm_system\/\n\u2502\n\u251c\u2500\u2500 config\/\n\u2502   \u2514\u2500\u2500 db.php                \u2190 \u6570\u636e\u5e93\u8fde\u63a5\n\u2502\n\u251c\u2500\u2500 auth\/\n\u2502   \u251c\u2500\u2500 login.php            \u2190 \u767b\u5f55\u9875\u9762\n\u2502   \u251c\u2500\u2500 logout.php           \u2190 \u6ce8\u9500\n\u2502   \u2514\u2500\u2500 auth_check.php       \u2190 \u6743\u9650\u68c0\u67e5\u4e2d\u95f4\u4ef6\n\u2502\n\u251c\u2500\u2500 dashboard\/\n\u2502   \u251c\u2500\u2500 index.php            \u2190 \u540e\u53f0\u9996\u9875\uff08\u4eea\u8868\u76d8\uff09\n\u2502   \u251c\u2500\u2500 patients.php         \u2190 \u60a3\u8005\u5217\u8868\u4e0e\u7ba1\u7406\n\u2502   \u251c\u2500\u2500 consultations.php    \u2190 \u95ee\u8bca\u8bb0\u5f55\u7ba1\u7406\n\u2502   \u251c\u2500\u2500 formulas.php         \u2190 \u65b9\u5242\u5e93\u7ba1\u7406\n\u2502   \u2514\u2500\u2500 syndrome.php         \u2190 \u8bc1\u578b\u8bcd\u5e93\u7ba1\u7406\n\u2502\n\u251c\u2500\u2500 actions\/\n\u2502   \u251c\u2500\u2500 add_patient.php\n\u2502   \u251c\u2500\u2500 add_consultation.php\n\u2502   \u2514\u2500\u2500 match_syndrome.php\n\u2502\n\u251c\u2500\u2500 assets\/\n\u2502   \u251c\u2500\u2500 style.css\n\u2502   \u2514\u2500\u2500 bootstrap.min.css\n\u2502\n\u2514\u2500\u2500 index.php                \u2190 \u5165\u53e3\uff0c\u81ea\u52a8\u8df3\u8f6c\u767b\u5f55\u6216\u4eea\u8868\u76d8\n<\/code><\/pre>\n\n\n\n
                    \n\n\n\n
                    \u2705 \u4e8c\u3001\u6570\u636e\u5e93\u8fde\u63a5\uff1aconfig\/db.php<\/code><\/h2>\n\n\n\n
                    <?php\n$host = 'localhost';\n$db   = 'tcm_system';\n$user = 'root';\n$pass = '';  \/\/ \u6216\u4f60\u7684\u6570\u636e\u5e93\u5bc6\u7801\n\n$conn = new mysqli($host, $user, $pass, $db);\nif ($conn->connect_error) {\n    die(\"\u6570\u636e\u5e93\u8fde\u63a5\u5931\u8d25: \" . $conn->connect_error);\n}\n?>\n<\/code><\/pre>\n\n\n\n
                    \n\n\n\n
                    \u2705 \u4e09\u3001\u7528\u6237\u767b\u5f55\u9875\u9762\uff1aauth\/login.php<\/code><\/h2>\n\n\n\n
                    <?php\nsession_start();\nrequire '..\/config\/db.php';\n\nif ($_SERVER[\"REQUEST_METHOD\"] == \"POST\") {\n    $username = $_POST['username'];\n    $password = hash('sha256', $_POST['password']);\n\n    $stmt = $conn->prepare(\"SELECT * FROM users WHERE username = ? AND password = ?\");\n    $stmt->bind_param(\"ss\", $username, $password);\n    $stmt->execute();\n    $res = $stmt->get_result();\n    $user = $res->fetch_assoc();\n\n    if ($user) {\n        $_SESSION['user'] = $user;\n        header(\"Location: ..\/dashboard\/index.php\");\n        exit;\n    } else {\n        $error = \"\u8d26\u53f7\u6216\u5bc6\u7801\u9519\u8bef\";\n    }\n}\n?>\n<!-- \u7b80\u5355 HTML \u767b\u5f55\u8868\u5355 -->\n<form method=\"post\">\n  \u7528\u6237\u540d: <input name=\"username\"><br>\n  \u5bc6\u7801: <input name=\"password\" type=\"password\"><br>\n  <button type=\"submit\">\u767b\u5f55<\/button>\n  <?php if (isset($error)) echo \"<p style='color:red;'>$error<\/p>\"; ?>\n<\/form>\n<\/code><\/pre>\n\n\n\n
                    \n\n\n\n
                    \u2705 \u56db\u3001\u4eea\u8868\u76d8\u9996\u9875\uff1adashboard\/index.php<\/code><\/h2>\n\n\n\n
                    <?php\nrequire '..\/auth\/auth_check.php';\n?>\n<h2>\u6b22\u8fce\u4f7f\u7528\u4e2d\u533b\u8fa8\u8bc1\u8bba\u6cbb\u7cfb\u7edf<\/h2>\n<ul>\n  <li><a href=\"patients.php\">\u60a3\u8005\u7ba1\u7406<\/a><\/li>\n  <li><a href=\"consultations.php\">\u95ee\u8bca\u8bb0\u5f55<\/a><\/li>\n  <li><a href=\"formulas.php\">\u65b9\u5242\u5e93<\/a><\/li>\n  <li><a href=\"syndrome.php\">\u8bc1\u578b\u8bcd\u5e93<\/a><\/li>\n  <li><a href=\"..\/auth\/logout.php\">\u9000\u51fa<\/a><\/li>\n<\/ul>\n<\/code><\/pre>\n\n\n\n
                    \n\n\n\n
                    \u2705 \u4e94\u3001\u60a3\u8005\u7ba1\u7406\u9875\u9762\uff1adashboard\/patients.php<\/code><\/h2>\n\n\n\n
                    <?php\nrequire '..\/auth\/auth_check.php';\nrequire '..\/config\/db.php';\n\n$patients = $conn->query(\"SELECT * FROM patients ORDER BY id DESC\");\n?>\n<h3>\u60a3\u8005\u5217\u8868<\/h3>\n<a href=\"add_patient_form.php\">\u65b0\u589e\u60a3\u8005<\/a>\n<table border=\"1\">\n  <tr><th>ID<\/th><th>\u59d3\u540d<\/th><th>\u6027\u522b<\/th><th>\u5e74\u9f84<\/th><th>\u64cd\u4f5c<\/th><\/tr>\n  <?php while($p = $patients->fetch_assoc()): ?>\n  <tr>\n    <td><?= $p['id'] ?><\/td>\n    <td><?= $p['name'] ?><\/td>\n    <td><?= $p['gender'] ?><\/td>\n    <td><?= date('Y') - date('Y', strtotime($p['birth_date'])) ?><\/td>\n    <td><a href=\"consultations.php?patient_id=<?= $p['id'] ?>\">\u67e5\u770b\u95ee\u8bca<\/a><\/td>\n  <\/tr>\n  <?php endwhile; ?>\n<\/table>\n<\/code><\/pre>\n\n\n\n
                    \n\n\n\n
                    \u2705 \u516d\u3001\u65b0\u589e\u95ee\u8bca\u8bb0\u5f55\u9875\u9762\uff1adashboard\/consultations.php<\/code><\/h2>\n\n\n\n
                    <?php\nrequire '..\/auth\/auth_check.php';\nrequire '..\/config\/db.php';\n\n$patient_id = $_GET['patient_id'];\n$patient = $conn->query(\"SELECT * FROM patients WHERE id=$patient_id\")->fetch_assoc();\n?>\n<h3>\u95ee\u8bca\u8bb0\u5f55 - <?= $patient['name'] ?><\/h3>\n<form method=\"post\" action=\"..\/actions\/add_consultation.php\">\n  <input type=\"hidden\" name=\"patient_id\" value=\"<?= $patient_id ?>\">\n  \u4e3b\u8bc9: <textarea name=\"chief_complaint\"><\/textarea><br>\n  \u75c7\u72b6: <textarea name=\"symptoms\"><\/textarea><br>\n  \u820c\u8c61: <input name=\"tongue\"><br>\n  \u8109\u8c61: <input name=\"pulse\"><br>\n  <button type=\"submit\">\u63d0\u4ea4\u95ee\u8bca<\/button>\n<\/form>\n<\/code><\/pre>\n\n\n\n
                    \n\n\n\n
                    \u2705 \u4e03\u3001\u95ee\u8bca\u8bb0\u5f55\u5904\u7406\u903b\u8f91\uff1aactions\/add_consultation.php<\/code><\/h2>\n\n\n\n
                    <?php\nsession_start();\nrequire '..\/config\/db.php';\n\n$patient_id = $_POST['patient_id'];\n$doctor_id = $_SESSION['user']['id'];\n$chief = $_POST['chief_complaint'];\n$symptoms = $_POST['symptoms'];\n$tongue = $_POST['tongue'];\n$pulse = $_POST['pulse'];\n$date = date('Y-m-d');\n\n\/\/ \u7b80\u5355\u8fa8\u8bc1\u903b\u8f91\u5339\u914d\n$syndrome = '';\n$result = $conn->query(\"SELECT * FROM syndrome_library\");\nwhile ($row = $result->fetch_assoc()) {\n    $keywords = explode(',', $row['keywords']);\n    foreach ($keywords as $kw) {\n        if (strpos($symptoms, trim($kw)) !== false) {\n            $syndrome = $row['syndrome_name'];\n            break 2;\n        }\n    }\n}\n\n\/\/ \u63d2\u5165\u8bb0\u5f55\n$stmt = $conn->prepare(\"INSERT INTO consultations (patient_id, doctor_id, visit_date, chief_complaint, symptoms, tongue, pulse, tcm_syndrome) VALUES (?, ?, ?, ?, ?, ?, ?, ?)\");\n$stmt->bind_param(\"iissssss\", $patient_id, $doctor_id, $date, $chief, $symptoms, $tongue, $pulse, $syndrome);\n$stmt->execute();\n\nheader(\"Location: ..\/dashboard\/patients.php\");\n<\/code><\/pre>\n\n\n\n
                    \n\n\n\n
                    \u2705 \u540e\u7eed\u53ef\u62d3\u5c55\uff1a<\/h2>\n\n\n\n
                      \n
                    • \u4f7f\u7528 Bootstrap \u7f8e\u5316\u524d\u7aef<\/li>\n\n\n\n
                    • \u652f\u6301\u75c7\u72b6\u5173\u952e\u8bcd\u667a\u80fd\u5206\u6790\uff08\u53ef\u5bf9\u63a5 Python \u6a21\u578b\uff09<\/li>\n\n\n\n
                    • \u6253\u5370\u62a5\u544a\uff08TCPDF\uff09<\/li>\n\n\n\n
                    • REST API \u652f\u6301\u79fb\u52a8\u7aef\u6216\u5c0f\u7a0b\u5e8f<\/li>\n<\/ul>\n\n\n\n
                      \n\n\n\n
                      \u5982\u679c\u4f60\u5e0c\u671b\u6211\u5c06\u4ee5\u4e0a\u5185\u5bb9\u6253\u5305\u4e3a .zip<\/code> \u6216\u76f4\u63a5\u8f93\u51fa\u4e3a\u5b8c\u6574\u9879\u76ee\uff0c\u6211\u4e5f\u53ef\u4ee5\u7acb\u5373\u5e2e\u4f60\u751f\u6210\u3002<\/p>\n\n\n\n
                      \u662f\u5426\u7ee7\u7eed\u751f\u6210\u5b8c\u6574\u7684\u524d\u7aef\u8868\u5355\u754c\u9762\uff08HTML + CSS\uff09\uff1f\u8fd8\u662f\u5bfc\u51fa\u73b0\u6709\u7ed3\u6784\u4e3a\u53ef\u4e0b\u8f7d\u9879\u76ee\uff1f<\/p>\n\n\n\n
                      \u592a\u597d\u4e86\uff01\u4e0b\u9762\u662f\u4f60\u8bf7\u6c42\u7684\uff1a<\/p>\n\n\n\n
                      \n\n\n\n
                      \u2705 \u524d\u7aef HTML \u95ee\u8bca\u8868\u5355 + \u667a\u80fd\u8fa8\u8bc1\u5339\u914d\u903b\u8f91\uff08PHP \u5b9e\u73b0\uff09<\/h1>\n\n\n\n
                      \n\n\n\n
                      \ud83d\udd37 \u4e00\u3001\u524d\u7aef HTML \u95ee\u8bca\u8868\u5355\uff08consultation_form.html<\/code> \u6216\u5d4c\u5165\u5728 consultations.php<\/code>\uff09<\/h2>\n\n\n\n
                      <!DOCTYPE html>\n<html lang=\"zh\">\n<head>\n  <meta charset=\"UTF-8\">\n  <title>\u4e2d\u533b\u95ee\u8bca\u8868\u5355<\/title>\n  <link rel=\"stylesheet\" href=\"..\/assets\/bootstrap.min.css\">\n  <style>\n    body { max-width: 800px; margin: 40px auto; }\n    label { font-weight: bold; margin-top: 10px; }\n  <\/style>\n<\/head>\n<body>\n  <h2>\u4e2d\u533b\u95ee\u8bca\u8bb0\u5f55\u8868<\/h2>\n  <form method=\"post\" action=\"..\/actions\/add_consultation.php\">\n    <input type=\"hidden\" name=\"patient_id\" value=\"1\"><!-- \u5b9e\u9645\u5e94\u7528\u4e2d\u52a8\u6001\u751f\u6210 -->\n\n    <label>\u4e3b\u8bc9\uff1a<\/label>\n    <textarea class=\"form-control\" name=\"chief_complaint\" required><\/textarea>\n\n    <label>\u73b0\u75c5\u53f2 \/ \u4f34\u968f\u75c7\u72b6\uff1a<\/label>\n    <textarea class=\"form-control\" name=\"symptoms\" required><\/textarea>\n\n    <label>\u820c\u8c61\uff1a<\/label>\n    <input class=\"form-control\" name=\"tongue\" placeholder=\"\u4f8b\uff1a\u820c\u7ea2\u82d4\u9ec4\">\n\n    <label>\u8109\u8c61\uff1a<\/label>\n    <input class=\"form-control\" name=\"pulse\" placeholder=\"\u4f8b\uff1a\u5f26\u7ec6\u6570\">\n\n    <button class=\"btn btn-primary mt-3\" type=\"submit\">\u63d0\u4ea4\u95ee\u8bca<\/button>\n  <\/form>\n<\/body>\n<\/html>\n<\/code><\/pre>\n\n\n\n
                      \n\n\n\n
                      \ud83d\udd37 \u4e8c\u3001\u667a\u80fd\u8fa8\u8bc1\u903b\u8f91 + \u63d0\u4ea4\u5904\u7406\uff08actions\/add_consultation.php<\/code>\uff09<\/h2>\n\n\n\n
                      <?php\nsession_start();\nrequire '..\/config\/db.php';\n\n$patient_id = $_POST['patient_id'];\n$doctor_id = $_SESSION['user']['id'] ?? 1; \/\/ \u6d4b\u8bd5\u9636\u6bb5\u9ed8\u8ba4\u533b\u751fID=1\n$chief = $_POST['chief_complaint'];\n$symptoms = $_POST['symptoms'];\n$tongue = $_POST['tongue'];\n$pulse = $_POST['pulse'];\n$visit_date = date('Y-m-d');\n\n\/\/ ---------- \u667a\u80fd\u8fa8\u8bc1\u903b\u8f91 ----------\n$syndrome = '';\n$formula = '';\n$match_score = 0;\n\n$result = $conn->query(\"SELECT * FROM syndrome_library\");\nwhile ($row = $result->fetch_assoc()) {\n    $keywords = explode(',', $row['keywords']);\n    $score = 0;\n\n    foreach ($keywords as $kw) {\n        $kw = trim($kw);\n        if (stripos($symptoms, $kw) !== false) $score++;\n        if (stripos($tongue, $kw) !== false) $score++;\n        if (stripos($pulse, $kw) !== false) $score++;\n    }\n\n    if ($score > $match_score) {\n        $match_score = $score;\n        $syndrome = $row['syndrome_name'];\n        $formula = $row['recommended_formulas'];\n    }\n}\n\n\/\/ ---------- \u63d2\u5165\u95ee\u8bca\u8bb0\u5f55 ----------\n$stmt = $conn->prepare(\"INSERT INTO consultations \n    (patient_id, doctor_id, visit_date, chief_complaint, symptoms, tongue, pulse, tcm_syndrome, treatment_plan)\n    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\");\n$stmt->bind_param(\"iisssssss\", $patient_id, $doctor_id, $visit_date, $chief, $symptoms, $tongue, $pulse, $syndrome, $formula);\n$stmt->execute();\n\n\/\/ \u53ef\u9009\uff1a\u8bb0\u5f55\u4f7f\u7528\u7684\u65b9\u5242\u5230\u5173\u8054\u8868 consultation_formulas\n\n\/\/ ---------- \u663e\u793a\u7ed3\u679c\u9875\u9762\uff08\u63a8\u8350\u8bc1\u578b\u4e0e\u65b9\u5242\uff09 ----------\necho \"<h2>\u667a\u80fd\u8fa8\u8bc1\u7ed3\u679c<\/h2>\";\necho \"<p><strong>\u8bc1\u578b\uff1a<\/strong> \" . ($syndrome ?: '\u672a\u80fd\u5339\u914d') . \"<\/p>\";\necho \"<p><strong>\u63a8\u8350\u65b9\u5242\uff1a<\/strong> \" . ($formula ?: '\u8bf7\u4eba\u5de5\u5224\u65ad') . \"<\/p>\";\necho \"<a href='..\/dashboard\/patients.php'>\u8fd4\u56de\u60a3\u8005\u5217\u8868<\/a>\";\n<\/code><\/pre>\n\n\n\n
                      \n\n\n\n
                      \ud83e\udde0 \u793a\u4f8b syndrome_library<\/code> \u6570\u636e\uff08\u7528\u4e8e\u6d4b\u8bd5\u5339\u914d\uff09<\/h2>\n\n\n\n
                      INSERT INTO syndrome_library (syndrome_name, keywords, recommended_formulas)\nVALUES\n('\u809d\u90c1\u6c14\u6ede', '\u80f8\u95f7,\u53f9\u6c14,\u6613\u6012,\u80c1\u75db,\u60c5\u7eea,\u8109\u5f26,\u820c\u7ea2', '\u900d\u9065\u6563'),\n('\u813e\u80c3\u865a\u5f31', '\u7eb3\u5dee,\u4e4f\u529b,\u5927\u4fbf\u7a00,\u9762\u8272\u840e\u9ec4,\u8109\u5f31,\u820c\u6de1,\u82d4\u767d', '\u56db\u541b\u5b50\u6c64'),\n('\u6e7f\u70ed\u4e0b\u6ce8', '\u5c0f\u4fbf\u9ec4,\u5e26\u4e0b\u9ec4\u81ed,\u820c\u7ea2\u82d4\u9ec4\u817b,\u8109\u6ed1\u6570,\u9634\u75d2', '\u9f99\u80c6\u6cfb\u809d\u6c64');\n<\/code><\/pre>\n\n\n\n
                      \n\n\n\n
                      \u2705 \u4f60\u53ef\u4ee5\u7ee7\u7eed\u6269\u5c55\u7684\u65b9\u5411\uff1a<\/h2>\n\n\n\n
                      \u6269\u5c55\u5185\u5bb9<\/th>\u6280\u672f\u5efa\u8bae<\/th><\/tr><\/thead>
                      \u591a\u8bc1\u578b\u5339\u914d\uff08\u5339\u914d\u591a\u4e2a\u8bc1\u578b\uff09<\/td>\u5efa\u7acb match_score<\/code> \u6570\u7ec4\uff0c\u6392\u5e8f\u663e\u793a<\/td><\/tr>
                      \u6a21\u7cca\u5339\u914d\u7b97\u6cd5<\/td>\u4f7f\u7528 Levenshtein \u6216\u81ea\u7136\u8bed\u8a00\u5904\u7406\u5e93<\/td><\/tr>
                      API \u5f0f\u63a5\u53e3\uff08\u4f9b\u5c0f\u7a0b\u5e8f\uff09<\/td>\u521b\u5efa api\/match.php<\/code> \u8fd4\u56de JSON<\/td><\/tr>
                      \u663e\u793a\u63a8\u8350\u7406\u7531<\/td>\u5728\u5e93\u4e2d\u6dfb\u52a0 \u5339\u914d\u4f9d\u636e<\/code> \u5b57\u6bb5<\/td><\/tr>
                      \u52a0\u5165 AI \u6a21\u578b\u5224\u65ad<\/td>\u7528 Python Flask + \u6a21\u578b\u63a5\u53e3\u914d\u5408 PHP \u8c03\u7528<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
                      \n\n\n\n
                      \u662f\u5426\u9700\u8981\u6211\u4e3a\u4f60\u7ee7\u7eed\u6784\u5efa\uff1a<\/p>\n\n\n\n
                        \n
                      • \ud83c\udf10 \u65b9\u5242\u5339\u914d\u7684\u8be6\u7ec6\u9875\u9762\uff1f<\/li>\n\n\n\n
                      • \ud83d\udcc4 PDF \u62a5\u544a\u751f\u6210\u529f\u80fd\uff1f<\/li>\n\n\n\n
                      • \ud83d\udcf1 \u5c0f\u7a0b\u5e8f\u63a5\u53e3\uff1f<\/li>\n<\/ul>\n\n\n\n
                        \u4f60\u4e5f\u53ef\u4ee5\u8ba9\u6211\u6253\u5305\u6240\u6709\u6587\u4ef6\u4e3a .zip<\/code> \u9879\u76ee\u6846\u67b6\uff0c\u65b9\u4fbf\u4f60\u90e8\u7f72\u6d4b\u8bd5\u3002\u662f\u5426\u7ee7\u7eed\uff1f<\/p>\n\n\n\n
                        \u975e\u5e38\u597d\uff01\u4ee5\u4e0b\u662f\u4f60\u63d0\u5230\u7684\u4e94\u5927\u529f\u80fd\u6269\u5c55\u7684 \u8be6\u7ec6\u5f00\u53d1\u8bf4\u660e<\/strong>\uff08\u542b PHP \u5b9e\u73b0\u903b\u8f91 \u548c \u6a21\u578b\u5bf9\u63a5\u5efa\u8bae\uff09\uff1a<\/p>\n\n\n\n
                        \n\n\n\n
                        \u2705 \u2460 \u591a\u8bc1\u578b\u5339\u914d + \u6392\u5e8f\u5c55\u793a\uff08match_score<\/code> \u6392\u540d\uff09<\/h2>\n\n\n\n
                        \ud83d\udccc \u6539\u8fdb\u903b\u8f91\uff08PHP\uff09\uff1a<\/h3>\n\n\n\n
                        $matches = [];\n\n$result = $conn->query(\"SELECT * FROM syndrome_library\");\nwhile ($row = $result->fetch_assoc()) {\n    $score = 0;\n    $keywords = explode(',', $row['keywords']);\n    foreach ($keywords as $kw) {\n        $kw = trim($kw);\n        if (stripos($symptoms, $kw) !== false) $score++;\n        if (stripos($tongue, $kw) !== false) $score++;\n        if (stripos($pulse, $kw) !== false) $score++;\n    }\n\n    if ($score > 0) {\n        $matches[] = [\n            'syndrome' => $row['syndrome_name'],\n            'formula' => $row['recommended_formulas'],\n            'score' => $score,\n            'reason' => $row['match_reason'] ?? ''\n        ];\n    }\n}\n\n\/\/ \u6392\u5e8f\nusort($matches, function($a, $b) {\n    return $b['score'] - $a['score'];\n});\n<\/code><\/pre>\n\n\n\n
                        \u2705 \u663e\u793a\u524d3\u4e2a\u5339\u914d\uff1a<\/h3>\n\n\n\n
                        echo \"<h3>\u5339\u914d\u8bc1\u578b\u7ed3\u679c\uff1a<\/h3>\";\nforeach (array_slice($matches, 0, 3) as $match) {\n    echo \"<div style='border:1px solid #ccc;padding:10px;margin:10px'>\";\n    echo \"<strong>\u8bc1\u578b\uff1a<\/strong> {$match['syndrome']}<br>\";\n    echo \"<strong>\u63a8\u8350\u65b9\u5242\uff1a<\/strong> {$match['formula']}<br>\";\n    echo \"<strong>\u5339\u914d\u8bc4\u5206\uff1a<\/strong> {$match['score']}<br>\";\n    echo \"<strong>\u63a8\u8350\u7406\u7531\uff1a<\/strong> {$match['reason']}\";\n    echo \"<\/div>\";\n}\n<\/code><\/pre>\n\n\n\n
                        \n\n\n\n
                        \u2705 \u2461 \u6a21\u7cca\u5339\u914d\u7b97\u6cd5\uff08Levenshtein\uff09<\/h2>\n\n\n\n
                        \ud83d\udccc \u793a\u4f8b\uff1a\u5173\u952e\u8bcd\u4e0e\u75c7\u72b6 Levenshtein \u6bd4\u8f83<\/h3>\n\n\n\n
                        foreach ($keywords as $kw) {\n    $kw = trim($kw);\n    \/\/ \u5c06\u75c7\u72b6\u5207\u6210\u8bcd\u53e5\u6bd4\u8f83\n    $symptom_segments = explode(',', $symptoms); \/\/ \u4f60\u53ef\u4f7f\u7528\u66f4\u5f3a\u7684\u4e2d\u6587\u5206\u8bcd\n    foreach ($symptom_segments as $seg) {\n        $lev = levenshtein($kw, $seg);\n        if ($lev < 3) $score++; \/\/ \u5dee\u5f02\u5c0f\u4e8e 3 \u89c6\u4e3a\u5339\u914d\n    }\n}\n<\/code><\/pre>\n\n\n\n
                        \n
                        \u2705 \u53ef\u8fdb\u4e00\u6b65\u7ed3\u5408\u4e2d\u6587\u5206\u8bcd\u5de5\u5177\u5982 jieba.php<\/code> \u6216 Python \u7aef\u5207\u8bcd\u3002<\/p>\n<\/blockquote>\n\n\n\n
                        \n\n\n\n
                        \u2705 \u2462 \u5c0f\u7a0b\u5e8f\u63a5\u53e3\uff08api\/match.php<\/code>\uff09<\/h2>\n\n\n\n
                        \ud83d\udccc \u63a5\u53e3\u683c\u5f0f\uff08POST \u63a5\u6536\u75c7\u72b6\uff0c\u8fd4\u56de\u63a8\u8350\u8bc1\u578b JSON\uff09\uff1a<\/h3>\n\n\n\n
                        <?php\nheader('Content-Type: application\/json');\nrequire '..\/config\/db.php';\n\n$data = json_decode(file_get_contents('php:\/\/input'), true);\n$symptoms = $data['symptoms'];\n$tongue = $data['tongue'];\n$pulse = $data['pulse'];\n\n$matches = [];\n\n\/\/ \u76f8\u540c\u5339\u914d\u903b\u8f91...\n\/\/ \u8fd4\u56de\u7ed3\u679c\necho json_encode([\n  'status' => 'success',\n  'matches' => $matches\n]);\n<\/code><\/pre>\n\n\n\n
                        \ud83d\udcf1 \u5c0f\u7a0b\u5e8f\u524d\u7aef\u8c03\u7528\uff08\u5fae\u4fe1\uff09\uff1a<\/h3>\n\n\n\n
                        wx.request({\n  url: 'https:\/\/yourdomain.com\/api\/match.php',\n  method: 'POST',\n  data: {\n    symptoms: '\u80f8\u95f7,\u53f9\u6c14',\n    tongue: '\u7ea2',\n    pulse: '\u5f26'\n  },\n  success: res => {\n    console.log('\u5339\u914d\u7ed3\u679c:', res.data.matches);\n  }\n})\n<\/code><\/pre>\n\n\n\n
                        \n\n\n\n
                        \u2705 \u2463 \u663e\u793a\u63a8\u8350\u7406\u7531\uff08\u5b57\u6bb5 match_reason<\/code>\uff09<\/h2>\n\n\n\n
                        \ud83d\udccc \u4fee\u6539\u6570\u636e\u5e93\u8868\u7ed3\u6784\uff1a<\/h3>\n\n\n\n
                        ALTER TABLE syndrome_library ADD match_reason TEXT;\n<\/code><\/pre>\n\n\n\n
                        \ud83d\udccc \u793a\u4f8b\u5185\u5bb9\uff1a<\/h3>\n\n\n\n
                        UPDATE syndrome_library SET match_reason = '\u60a3\u8005\u6709\u660e\u663e\u80f8\u95f7\u53f9\u6c14\u3001\u8109\u5f26\uff0c\u60c5\u7eea\u6291\u90c1\u7b49\u8868\u73b0\uff0c\u7b26\u5408\u809d\u90c1\u6c14\u6ede\u8bc1' WHERE syndrome_name='\u809d\u90c1\u6c14\u6ede';\n<\/code><\/pre>\n\n\n\n
                        \n\n\n\n
                        \u2705 \u2464 \u52a0\u5165 AI \u6a21\u578b\u5224\u65ad\uff08Flask + PHP \u8c03\u7528\uff09<\/h2>\n\n\n\n
                        \ud83d\udccc AI \u7aef\u63a5\u53e3\u7ed3\u6784\uff08\/predict<\/code>\uff09<\/h3>\n\n\n\n
                        from flask import Flask, request, jsonify\napp = Flask(__name__)\n\n@app.route('\/predict', methods=['POST'])\ndef predict():\n    data = request.json\n    symptoms = data.get('symptoms', '')\n    # \u6a21\u578b\u5904\u7406\u903b\u8f91\u7565...\n    return jsonify({\n        'syndromes': [\n            {'name': '\u809d\u90c1\u6c14\u6ede', 'score': 0.92},\n            {'name': '\u813e\u865a\u6e7f\u76db', 'score': 0.71}\n        ]\n    })\n<\/code><\/pre>\n\n\n\n
                        \ud83d\udccc PHP \u8c03\u7528\uff08\u4f7f\u7528 CURL\uff09\uff1a<\/h3>\n\n\n\n
                        $ch = curl_init(\"http:\/\/localhost:5000\/predict\");\ncurl_setopt($ch, CURLOPT_RETURNTRANSFER, true);\ncurl_setopt($ch, CURLOPT_POSTFIELDS, json_encode([\n    'symptoms' => $symptoms,\n    'tongue' => $tongue,\n    'pulse' => $pulse\n]));\ncurl_setopt($ch, CURLOPT_HTTPHEADER, ['Content-Type: application\/json']);\n$response = curl_exec($ch);\n$data = json_decode($response, true);\ncurl_close($ch);\n\n\/\/ \u8f93\u51fa AI \u63a8\u8350\nforeach ($data['syndromes'] as $s) {\n    echo \"{$s['name']} (AI\u8bc4\u5206\uff1a{$s['score']})<br>\";\n}\n<\/code><\/pre>\n\n\n\n
                        \n\n\n\n
                        \u2705 \u603b\u7ed3\uff1a\u6a21\u5757\u529f\u80fd\u6c47\u603b<\/h2>\n\n\n\n
                        \u529f\u80fd\u6a21\u5757<\/th>\u5df2\u5b9e\u73b0<\/th>\u4e0b\u4e00\u6b65\u5efa\u8bae<\/th><\/tr><\/thead>
                        \u591a\u8bc1\u578b\u5339\u914d\u6392\u5e8f<\/td>\u2705<\/td>\u5206\u6570\u9608\u503c\u53ef\u8c03\u6574<\/td><\/tr>
                        \u6a21\u7cca\u5339\u914d\u7b97\u6cd5<\/td>\u2705<\/td>\u53ef\u7ed3\u5408\u4e2d\u6587\u5206\u8bcd<\/td><\/tr>
                        \u5c0f\u7a0b\u5e8f\u63a5\u53e3<\/td>\u2705<\/td>\u6dfb\u52a0\u7528\u6237\u9a8c\u8bc1<\/td><\/tr>
                        \u63a8\u8350\u7406\u7531\u5b57\u6bb5<\/td>\u2705<\/td>\u5728\u540e\u53f0\u652f\u6301\u7ef4\u62a4<\/td><\/tr>
                        AI \u6a21\u578b\u5224\u65ad<\/td>\u2705\uff08PHP \u63a5\u53e3\u5bf9\u63a5 Flask\uff09<\/td>\u6a21\u578b\u53ef\u7528 NLP\/LLM<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
                        \n\n\n\n
                        \u662f\u5426\u9700\u8981\u6211\uff1a<\/p>\n\n\n\n
                          \n
                        • \u2705 \u63d0\u4f9b\u5b8c\u6574 api\/<\/code> \u6587\u4ef6\u5939\u7ed3\u6784 + \u793a\u4f8b\u63a5\u53e3\u6253\u5305\uff1f<\/li>\n\n\n\n
                        • \u2705 \u751f\u6210 Flask \u6a21\u578b\u6837\u677f\uff08\u7528\u4e8e AI \u8fa8\u8bc1\uff09\uff1f<\/li>\n\n\n\n
                        • \u2705 \u6574\u5408\u6240\u6709 PHP + HTML \u9875\u9762\u5e76\u751f\u6210 .zip<\/code> \u9879\u76ee\u5305\uff1f<\/li>\n<\/ul>\n\n\n\n
                          \u4f60\u53ef\u6307\u5b9a\u54ea\u4e00\u6b65\u9700\u8981\u6211\u73b0\u5728\u505a\u3002<\/p>\n\n\n\n
                          \u4ee5\u4e0b\u662f\u5b8c\u6574\u7684 api\/<\/code> \u76ee\u5f55\u7ed3\u6784\u4e0e\u5173\u952e\u63a5\u53e3\u6587\u4ef6\u5185\u5bb9\uff0c\u9002\u7528\u4e8e\u4f60\u7684 \u4e2d\u533b\u8fa8\u8bc1\u8bba\u6cbb\u7cfb\u7edf<\/strong>\uff0c\u652f\u6301\u5c0f\u7a0b\u5e8f\u8c03\u7528\u3001\u75c7\u72b6\u63d0\u4ea4\u3001\u8bc1\u578b\u63a8\u8350\u3001AI \u8fa8\u8bc1\u7b49\u529f\u80fd\u3002<\/p>\n\n\n\n
                          \n\n\n\n
                          \u2705 \u4e00\u3001api\/<\/code> \u6587\u4ef6\u5939\u7ed3\u6784<\/h2>\n\n\n\n
                          api\/\n\u251c\u2500\u2500 match.php               \u2190 \u75c7\u72b6\u81ea\u52a8\u8fa8\u8bc1\u5339\u914d\uff08\u89c4\u5219+\u6a21\u7cca\uff09\n\u251c\u2500\u2500 formulas.php            \u2190 \u83b7\u53d6\u63a8\u8350\u65b9\u5242\u4fe1\u606f\n\u251c\u2500\u2500 consultation_submit.php \u2190 \u63d0\u4ea4\u95ee\u8bca\u8bb0\u5f55\n\u251c\u2500\u2500 syndrome_list.php       \u2190 \u6240\u6709\u8bc1\u578b\u8bcd\u5e93\uff08\u4e0b\u62c9\u7528\uff09\n\u251c\u2500\u2500 ai_predict.php          \u2190 \u5bf9\u63a5 Python Flask AI \u6a21\u578b\n\u2514\u2500\u2500 auth.php                \u2190 \u767b\u5f55\u9a8c\u8bc1\uff08\u53ef\u9009\uff09\n<\/code><\/pre>\n\n\n\n
                          \n\n\n\n
                          \u2705 \u4e8c\u3001\u63a5\u53e3\u793a\u4f8b\u4ee3\u7801<\/h2>\n\n\n\n
                          \n\n\n\n
                          \ud83d\udcc1 api\/match.php<\/code>\uff1a\u89c4\u5219+\u6a21\u7cca\u5339\u914d<\/h3>\n\n\n\n
                          <?php\nheader('Content-Type: application\/json');\nrequire '..\/config\/db.php';\n\n$data = json_decode(file_get_contents('php:\/\/input'), true);\n$symptoms = $data['symptoms'] ?? '';\n$tongue = $data['tongue'] ?? '';\n$pulse = $data['pulse'] ?? '';\n\n$matches = [];\n\n$res = $conn->query(\"SELECT * FROM syndrome_library\");\nwhile ($row = $res->fetch_assoc()) {\n    $score = 0;\n    $keywords = explode(',', $row['keywords']);\n    foreach ($keywords as $kw) {\n        $kw = trim($kw);\n        if (stripos($symptoms, $kw) !== false || stripos($tongue, $kw) !== false || stripos($pulse, $kw) !== false) {\n            $score += 2;\n        } else {\n            \/\/ \u6a21\u7cca\u5339\u914d\n            if (levenshtein($kw, $symptoms) < 3) $score += 1;\n        }\n    }\n    if ($score > 0) {\n        $matches[] = [\n            'syndrome' => $row['syndrome_name'],\n            'score' => $score,\n            'reason' => $row['match_reason'],\n            'formula' => $row['recommended_formulas']\n        ];\n    }\n}\n\nusort($matches, fn($a, $b) => $b['score'] - $a['score']);\n\necho json_encode([\n    'status' => 'ok',\n    'matches' => array_slice($matches, 0, 5)\n]);\n<\/code><\/pre>\n\n\n\n
                          \n\n\n\n
                          \ud83d\udcc1 api\/formulas.php<\/code>\uff1a\u83b7\u53d6\u65b9\u5242\u8bf4\u660e\uff08\u652f\u6301\u524d\u7aef\u5c55\u793a\uff09<\/h3>\n\n\n\n
                          <?php\nheader('Content-Type: application\/json');\nrequire '..\/config\/db.php';\n\n$formula = $_GET['name'] ?? '';\n$stmt = $conn->prepare(\"SELECT * FROM formulas WHERE name = ?\");\n$stmt->bind_param(\"s\", $formula);\n$stmt->execute();\n$result = $stmt->get_result();\n$info = $result->fetch_assoc();\n\necho json_encode([\n    'status' => $info ? 'ok' : 'not_found',\n    'data' => $info\n]);\n<\/code><\/pre>\n\n\n\n
                          \n\n\n\n
                          \ud83d\udcc1 api\/consultation_submit.php<\/code>\uff1a\u63d0\u4ea4\u95ee\u8bca\u8bb0\u5f55\uff08\u524d\u7aef\uff09<\/h3>\n\n\n\n
                          <?php\nheader('Content-Type: application\/json');\nrequire '..\/config\/db.php';\n\n$data = json_decode(file_get_contents('php:\/\/input'), true);\n\n$pid = $data['patient_id'];\n$doctor_id = $data['doctor_id'] ?? 1;\n$chief = $data['chief_complaint'];\n$symptoms = $data['symptoms'];\n$tongue = $data['tongue'];\n$pulse = $data['pulse'];\n$syndrome = $data['syndrome'];\n$formula = $data['formula'];\n$date = date('Y-m-d');\n\n$stmt = $conn->prepare(\"INSERT INTO consultations \n    (patient_id, doctor_id, visit_date, chief_complaint, symptoms, tongue, pulse, tcm_syndrome, treatment_plan)\n    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\");\n$stmt->bind_param(\"iisssssss\", $pid, $doctor_id, $date, $chief, $symptoms, $tongue, $pulse, $syndrome, $formula);\n$success = $stmt->execute();\n\necho json_encode(['status' => $success ? 'ok' : 'fail']);\n<\/code><\/pre>\n\n\n\n
                          \n\n\n\n
                          \ud83d\udcc1 api\/syndrome_list.php<\/code>\uff1a\u4f9b\u524d\u7aef\u5c55\u793a\u5168\u90e8\u8bc1\u578b<\/h3>\n\n\n\n
                          <?php\nheader('Content-Type: application\/json');\nrequire '..\/config\/db.php';\n\n$res = $conn->query(\"SELECT syndrome_name FROM syndrome_library\");\n$list = [];\n\nwhile ($row = $res->fetch_assoc()) {\n    $list[] = $row['syndrome_name'];\n}\n\necho json_encode([\n    'status' => 'ok',\n    'data' => $list\n]);\n<\/code><\/pre>\n\n\n\n
                          \n\n\n\n
                          \ud83d\udcc1 api\/ai_predict.php<\/code>\uff1a\u63a5\u5165 Flask \u6a21\u578b\u9884\u6d4b\u63a5\u53e3<\/h3>\n\n\n\n
                          <?php\nheader('Content-Type: application\/json');\n\n$data = json_encode([\n    'symptoms' => $_POST['symptoms'] ?? '',\n    'tongue' => $_POST['tongue'] ?? '',\n    'pulse' => $_POST['pulse'] ?? ''\n]);\n\n$ch = curl_init(\"http:\/\/localhost:5000\/predict\");\ncurl_setopt($ch, CURLOPT_RETURNTRANSFER, true);\ncurl_setopt($ch, CURLOPT_POSTFIELDS, $data);\ncurl_setopt($ch, CURLOPT_HTTPHEADER, ['Content-Type: application\/json']);\n\n$response = curl_exec($ch);\ncurl_close($ch);\n\necho $response;\n<\/code><\/pre>\n\n\n\n
                          \n\n\n\n
                          \u2705 \u4e09\u3001\u5c0f\u7a0b\u5e8f\u6216\u524d\u7aef\u8c03\u7528\u793a\u4f8b<\/h2>\n\n\n\n
                          wx.request({\n  url: 'https:\/\/yourserver.com\/api\/match.php',\n  method: 'POST',\n  data: {\n    symptoms: '\u80f8\u95f7,\u53f9\u6c14,\u60c5\u7eea\u4e0d\u4f73',\n    tongue: '\u7ea2',\n    pulse: '\u5f26'\n  },\n  success: res => {\n    const matches = res.data.matches\n    console.log('\u8bc1\u578b\u63a8\u8350:', matches)\n  }\n})\n<\/code><\/pre>\n\n\n\n
                          \n\n\n\n
                          \u2705 \u56db\u3001\u63a8\u8350\u90e8\u7f72\u65b9\u5f0f<\/h2>\n\n\n\n
                            \n
                          • \u653e\u7f6e api\/<\/code> \u5230\u4f60\u7684\u670d\u52a1\u5668\uff08\u5982 Apache \u6216 nginx \u7684\u5b50\u76ee\u5f55\uff09<\/li>\n\n\n\n
                          • \u914d\u5408\u524d\u7aef\u9875\u9762\u6216\u5c0f\u7a0b\u5e8f\uff0c\u76f4\u63a5\u53d1\u9001 JSON \u8bf7\u6c42<\/li>\n\n\n\n
                          • \u914d\u7f6e .htaccess<\/code> \u6216 CORS \u4ee5\u5141\u8bb8\u8de8\u57df\u8c03\u7528<\/li>\n<\/ul>\n\n\n\n
                            \n\n\n\n
                            \u662f\u5426\u9700\u8981\u6211\u4e3a\u4f60\uff1a<\/p>\n\n\n\n
                              \n
                            1. \ud83c\udf81 \u6253\u5305 api\/<\/code> \u6587\u4ef6\u5939\u4e3a .zip<\/code>\uff1f<\/li>\n\n\n\n
                            2. \ud83e\udde0 \u6784\u5efa Python Flask AI \u6a21\u578b\u670d\u52a1\u7aef\uff1f<\/li>\n\n\n\n
                            3. \ud83d\udce6 \u63d0\u4f9b\u5b8c\u6574\u90e8\u7f72\u73af\u5883\uff08Docker + MySQL + PHP + Flask\uff09\uff1f<\/li>\n<\/ol>\n\n\n\n
                              \u6b22\u8fce\u6307\u5b9a\u4e0b\u4e00\u6b65\uff01<\/p>\n\n\n\n
                              INSERT INTO syndrome_library (syndrome_name, keywords, recommended_formulas)
                              VALUES
                              (‘\u809d\u90c1\u6c14\u6ede’, ‘\u80f8\u95f7,\u53f9\u6c14,\u6613\u6012,\u80c1\u75db,\u60c5\u7eea,\u8109\u5f26,\u820c\u7ea2’, ‘\u900d\u9065\u6563’),
                              (‘\u813e\u80c3\u865a\u5f31’, ‘\u7eb3\u5dee,\u4e4f\u529b,\u5927\u4fbf\u7a00,\u9762\u8272\u840e\u9ec4,\u8109\u5f31,\u820c\u6de1,\u82d4\u767d’, ‘\u56db\u541b\u5b50\u6c64’),
                              (‘\u6e7f\u70ed\u4e0b\u6ce8’, ‘\u5c0f\u4fbf\u9ec4,\u5e26\u4e0b\u9ec4\u81ed,\u820c\u7ea2\u82d4\u9ec4\u817b,\u8109\u6ed1\u6570,\u9634\u75d2’, ‘\u9f99\u80c6\u6cfb\u809d\u6c64’);<\/p>\n\n\n\n
                              INSERT INTO syndrome_library (syndrome_name, keywords, recommended_formulas, match_reason) VALUES
                              (‘\u813e\u6c14\u865a’, ‘\u4e4f\u529b,\u98df\u6b32\u5dee,\u8179\u80c0,\u4fbf\u6e8f,\u9762\u8272\u840e\u9ec4,\u8109\u5f31,\u820c\u6de1,\u7eb3\u5446’, ‘\u56db\u541b\u5b50\u6c64’, ‘\u813e\u6c14\u865a\u8005\u5e38\u89c1\u7eb3\u5446\u3001\u5026\u6020\u3001\u9762\u8272\u840e\u9ec4\u3001\u820c\u6de1\u8109\u5f31\u7b49’),
                              (‘\u813e\u80c3\u865a\u5f31’, ‘\u7eb3\u5c11,\u4e4f\u529b,\u4fbf\u6e8f,\u98df\u540e\u8179\u80c0,\u820c\u6de1,\u82d4\u767d,\u8109\u865a\u7f13’, ‘\u516d\u541b\u5b50\u6c64’, ‘\u813e\u865a\u5939\u75f0\u6e7f\u5219\u7eb3\u5dee\u3001\u82d4\u817b\u3001\u5455\u5410\u75f0\u591a’),
                              (‘\u809d\u90c1\u6c14\u6ede’, ‘\u80f8\u95f7,\u53f9\u6c14,\u60c5\u7eea\u4e0d\u4f73,\u6613\u6012,\u80c1\u75db,\u4e73\u623f\u80c0,\u8109\u5f26,\u820c\u7ea2’, ‘\u900d\u9065\u6563’, ‘\u809d\u90c1\u6c14\u6ede\u591a\u56e0\u60c5\u5fd7\u6240\u4f24\uff0c\u8868\u73b0\u4e3a\u80c1\u80c0\u3001\u60c5\u7eea\u53d8\u5316\u660e\u663e’),
                              (‘\u5916\u611f\u98ce\u5bd2’, ‘\u6076\u5bd2,\u53d1\u70ed,\u65e0\u6c57,\u5934\u75db,\u8eab\u75db,\u9f3b\u585e,\u8109\u6d6e\u7d27’, ‘\u9ebb\u9ec4\u6c64’, ‘\u98ce\u5bd2\u675f\u8868\uff0c\u9633\u6c14\u90c1\u904f\uff0c\u89c1\u6076\u5bd2\u91cd\u53d1\u70ed\u8f7b\u65e0\u6c57’),
                              (‘\u8868\u865a\u611f\u5192’, ‘\u53d1\u70ed,\u6c57\u51fa,\u6076\u98ce,\u8109\u7f13,\u5934\u75db,\u9f3b\u585e’, ‘\u6842\u679d\u6c64’, ‘\u8868\u865a\u81ea\u6c57\uff0c\u6076\u98ce\u660e\u663e\uff0c\u6c57\u51fa\u65e0\u89e3’),
                              (‘\u5c11\u9633\u75c5’, ‘\u5bd2\u70ed\u5f80\u6765,\u80f8\u80c1\u82e6\u6ee1,\u53e3\u82e6,\u54bd\u5e72,\u7729\u6655,\u820c\u7ea2,\u8109\u5f26’, ‘\u5c0f\u67f4\u80e1\u6c64’, ‘\u5c11\u9633\u4e3a\u8868\u91cc\u4e4b\u95f4\uff0c\u75c5\u4f4d\u4e0d\u6e05\uff0c\u5bd2\u70ed\u4ea4\u66ff’),
                              (‘\u75f0\u996e\u5185\u505c’, ‘\u5934\u7729,\u5fc3\u60b8,\u80f8\u95f7,\u75f0\u591a,\u6e05\u6d8e,\u820c\u80d6\u82d4\u767d\u817b,\u8109\u6ed1’, ‘\u82d3\u6842\u672f\u7518\u6c64’, ‘\u6c34\u6e7f\u4e0d\u5316\uff0c\u75f0\u996e\u5185\u505c\uff0c\u81f4\u5fc3\u60b8\u3001\u5934\u6655\u3001\u75f0\u6d8e’);<\/p>\n\n\n\n
                              INSERT INTO formulas (name, syndrome, ingredients, usage, indications) VALUES
                              (‘\u56db\u541b\u5b50\u6c64’, ‘\u813e\u6c14\u865a’, ‘\u515a\u53c210g, \u767d\u672f10g, \u832f\u82d310g, \u7518\u83496g’, ‘\u6c34\u714e\u670d\uff0c\u6bcf\u65e5\u4e00\u5242’, ‘\u9762\u8272\u82cd\u767d\uff0c\u5026\u6020\u4e4f\u529b\uff0c\u7eb3\u5446\u8179\u80c0’),
                              (‘\u516d\u541b\u5b50\u6c64’, ‘\u813e\u80c3\u6c14\u865a\u5939\u75f0\u6e7f’, ‘\u515a\u53c210g, \u767d\u672f10g, \u832f\u82d310g, \u9648\u76ae6g, \u534a\u590f6g, \u7518\u83496g’, ‘\u6c34\u714e\u670d\uff0c\u6bcf\u65e5\u4e00\u5242’, ‘\u7eb3\u5446\u6076\u5fc3\uff0c\u5455\u5410\u75f0\u6d8e\uff0c\u8118\u8179\u80c0\u6ee1’),
                              (‘\u900d\u9065\u6563’, ‘\u809d\u90c1\u813e\u865a’, ‘\u67f4\u80e19g, \u5f53\u5f529g, \u767d\u828d9g, \u767d\u672f9g, \u832f\u82d39g, \u7518\u83496g’, ‘\u6c34\u714e\u670d\uff0c\u6bcf\u65e5\u4e00\u5242’, ‘\u80f8\u80c1\u80c0\u75db\uff0c\u60c5\u7eea\u6291\u90c1\uff0c\u6708\u7ecf\u4e0d\u8c03’),
                              (‘\u6842\u679d\u6c64’, ‘\u5916\u611f\u98ce\u5bd2\u8868\u865a\u8bc1’, ‘\u6842\u679d9g, \u828d\u836f9g, \u7518\u83496g, \u751f\u59dc9g, \u5927\u67a34\u679a’, ‘\u6e29\u670d\uff0c\u65e5\u4e09\u6b21’, ‘\u53d1\u70ed\u6076\u98ce\uff0c\u6c57\u51fa\uff0c\u8109\u7f13’),
                              (‘\u9ebb\u9ec4\u6c64’, ‘\u5916\u611f\u98ce\u5bd2\u8868\u5b9e\u8bc1’, ‘\u9ebb\u9ec49g, \u6842\u679d6g, \u674f\u4ec16g, \u7518\u83493g’, ‘\u714e\u670d\u540e\u53d1\u6c57’, ‘\u65e0\u6c57\u800c\u5598\uff0c\u6076\u5bd2\u53d1\u70ed’),
                              (‘\u5c0f\u67f4\u80e1\u6c64’, ‘\u5c11\u9633\u75c5’, ‘\u67f4\u80e112g, \u9ec4\u82a99g, \u534a\u590f9g, \u751f\u59dc9g, \u515a\u53c29g, \u5927\u67a34\u679a, \u7518\u83496g’, ‘\u6c34\u714e\u670d\uff0c\u6bcf\u65e5\u4e00\u5242’, ‘\u5bd2\u70ed\u5f80\u6765\uff0c\u80f8\u80c1\u82e6\u6ee1\uff0c\u53e3\u82e6\u54bd\u5e72’),
                              (‘\u82d3\u6842\u672f\u7518\u6c64’, ‘\u75f0\u996e\u5185\u505c’, ‘\u832f\u82d315g, \u6842\u679d9g, \u767d\u672f9g, \u7518\u83496g’, ‘\u6c34\u714e\u670d\uff0c\u6bcf\u65e5\u4e00\u5242’, ‘\u5934\u7729\u5fc3\u60b8\uff0c\u80f8\u80c1\u6ee1\u95f7\uff0c\u75f0\u591a\u6e05\u7a00’);<\/p>\n\n\n\n
                              — \u4f7f\u7528\u6570\u636e\u5e93
                              USE tcm_system;<\/p>\n\n\n\n
                              — \u6e05\u7a7a\u539f\u6709\u6570\u636e\uff08\u614e\u7528\uff09
                              TRUNCATE TABLE formulas;
                              TRUNCATE TABLE syndrome_library;
                              TRUNCATE TABLE herbs;<\/p>\n\n\n\n
                              — \u2705 1. \u65b9\u5242\u5e93
                              INSERT INTO formulas (name, syndrome, ingredients, usage, indications) VALUES
                              (‘\u56db\u541b\u5b50\u6c64’, ‘\u813e\u6c14\u865a’, ‘\u515a\u53c210g, \u767d\u672f10g, \u832f\u82d310g, \u7518\u83496g’, ‘\u6c34\u714e\u670d\uff0c\u6bcf\u65e5\u4e00\u5242’, ‘\u9762\u8272\u82cd\u767d\uff0c\u5026\u6020\u4e4f\u529b\uff0c\u7eb3\u5446\u8179\u80c0’),
                              (‘\u516d\u541b\u5b50\u6c64’, ‘\u813e\u80c3\u865a\u5f31’, ‘\u515a\u53c210g, \u767d\u672f10g, \u832f\u82d310g, \u9648\u76ae6g, \u534a\u590f6g, \u7518\u83496g’, ‘\u6c34\u714e\u670d\uff0c\u6bcf\u65e5\u4e00\u5242’, ‘\u7eb3\u5446\u6076\u5fc3\uff0c\u5455\u5410\u75f0\u6d8e\uff0c\u8118\u8179\u80c0\u6ee1’),
                              (‘\u900d\u9065\u6563’, ‘\u809d\u90c1\u813e\u865a’, ‘\u67f4\u80e19g, \u5f53\u5f529g, \u767d\u828d9g, \u767d\u672f9g, \u832f\u82d39g, \u7518\u83496g’, ‘\u6c34\u714e\u670d\uff0c\u6bcf\u65e5\u4e00\u5242’, ‘\u80f8\u80c1\u80c0\u75db\uff0c\u60c5\u7eea\u6291\u90c1\uff0c\u6708\u7ecf\u4e0d\u8c03’),
                              (‘\u6842\u679d\u6c64’, ‘\u5916\u611f\u98ce\u5bd2\u8868\u865a\u8bc1’, ‘\u6842\u679d9g, \u828d\u836f9g, \u7518\u83496g, \u751f\u59dc9g, \u5927\u67a34\u679a’, ‘\u6e29\u670d\uff0c\u65e5\u4e09\u6b21’, ‘\u53d1\u70ed\u6076\u98ce\uff0c\u6c57\u51fa\uff0c\u8109\u7f13’),
                              (‘\u9ebb\u9ec4\u6c64’, ‘\u5916\u611f\u98ce\u5bd2\u8868\u5b9e\u8bc1’, ‘\u9ebb\u9ec49g, \u6842\u679d6g, \u674f\u4ec16g, \u7518\u83493g’, ‘\u714e\u670d\u540e\u53d1\u6c57’, ‘\u65e0\u6c57\u800c\u5598\uff0c\u6076\u5bd2\u53d1\u70ed’),
                              (‘\u5c0f\u67f4\u80e1\u6c64’, ‘\u5c11\u9633\u75c5’, ‘\u67f4\u80e112g, \u9ec4\u82a99g, \u534a\u590f9g, \u751f\u59dc9g, \u515a\u53c29g, \u5927\u67a34\u679a, \u7518\u83496g’, ‘\u6c34\u714e\u670d\uff0c\u6bcf\u65e5\u4e00\u5242’, ‘\u5bd2\u70ed\u5f80\u6765\uff0c\u80f8\u80c1\u82e6\u6ee1\uff0c\u53e3\u82e6\u54bd\u5e72’),
                              (‘\u82d3\u6842\u672f\u7518\u6c64’, ‘\u75f0\u996e\u5185\u505c’, ‘\u832f\u82d315g, \u6842\u679d9g, \u767d\u672f9g, \u7518\u83496g’, ‘\u6c34\u714e\u670d\uff0c\u6bcf\u65e5\u4e00\u5242’, ‘\u5934\u7729\u5fc3\u60b8\uff0c\u80f8\u80c1\u6ee1\u95f7\uff0c\u75f0\u591a\u6e05\u7a00’);<\/p>\n\n\n\n
                              — \u2705 2. \u8bc1\u578b\u8bcd\u5e93
                              INSERT INTO syndrome_library (syndrome_name, keywords, recommended_formulas, match_reason) VALUES
                              (‘\u813e\u6c14\u865a’, ‘\u4e4f\u529b,\u98df\u6b32\u5dee,\u8179\u80c0,\u4fbf\u6e8f,\u9762\u8272\u840e\u9ec4,\u8109\u5f31,\u820c\u6de1,\u7eb3\u5446’, ‘\u56db\u541b\u5b50\u6c64’, ‘\u813e\u6c14\u865a\u8005\u5e38\u89c1\u7eb3\u5446\u3001\u5026\u6020\u3001\u9762\u8272\u840e\u9ec4\u3001\u820c\u6de1\u8109\u5f31\u7b49’),
                              (‘\u813e\u80c3\u865a\u5f31’, ‘\u7eb3\u5c11,\u4e4f\u529b,\u4fbf\u6e8f,\u98df\u540e\u8179\u80c0,\u820c\u6de1,\u82d4\u767d,\u8109\u865a\u7f13’, ‘\u516d\u541b\u5b50\u6c64’, ‘\u813e\u865a\u5939\u75f0\u6e7f\u5219\u7eb3\u5dee\u3001\u82d4\u817b\u3001\u5455\u5410\u75f0\u591a’),
                              (‘\u809d\u90c1\u6c14\u6ede’, ‘\u80f8\u95f7,\u53f9\u6c14,\u60c5\u7eea\u4e0d\u4f73,\u6613\u6012,\u80c1\u75db,\u4e73\u623f\u80c0,\u8109\u5f26,\u820c\u7ea2’, ‘\u900d\u9065\u6563’, ‘\u809d\u90c1\u6c14\u6ede\u591a\u56e0\u60c5\u5fd7\u6240\u4f24\uff0c\u8868\u73b0\u4e3a\u80c1\u80c0\u3001\u60c5\u7eea\u53d8\u5316\u660e\u663e’),
                              (‘\u5916\u611f\u98ce\u5bd2’, ‘\u6076\u5bd2,\u53d1\u70ed,\u65e0\u6c57,\u5934\u75db,\u8eab\u75db,\u9f3b\u585e,\u8109\u6d6e\u7d27’, ‘\u9ebb\u9ec4\u6c64’, ‘\u98ce\u5bd2\u675f\u8868\uff0c\u9633\u6c14\u90c1\u904f\uff0c\u89c1\u6076\u5bd2\u91cd\u53d1\u70ed\u8f7b\u65e0\u6c57’),
                              (‘\u8868\u865a\u611f\u5192’, ‘\u53d1\u70ed,\u6c57\u51fa,\u6076\u98ce,\u8109\u7f13,\u5934\u75db,\u9f3b\u585e’, ‘\u6842\u679d\u6c64’, ‘\u8868\u865a\u81ea\u6c57\uff0c\u6076\u98ce\u660e\u663e\uff0c\u6c57\u51fa\u65e0\u89e3’),
                              (‘\u5c11\u9633\u75c5’, ‘\u5bd2\u70ed\u5f80\u6765,\u80f8\u80c1\u82e6\u6ee1,\u53e3\u82e6,\u54bd\u5e72,\u7729\u6655,\u820c\u7ea2,\u8109\u5f26’, ‘\u5c0f\u67f4\u80e1\u6c64’, ‘\u5c11\u9633\u4e3a\u8868\u91cc\u4e4b\u95f4\uff0c\u75c5\u4f4d\u4e0d\u6e05\uff0c\u5bd2\u70ed\u4ea4\u66ff’),
                              (‘\u75f0\u996e\u5185\u505c’, ‘\u5934\u7729,\u5fc3\u60b8,\u80f8\u95f7,\u75f0\u591a,\u6e05\u6d8e,\u820c\u80d6\u82d4\u767d\u817b,\u8109\u6ed1’, ‘\u82d3\u6842\u672f\u7518\u6c64’, ‘\u6c34\u6e7f\u4e0d\u5316\uff0c\u75f0\u996e\u5185\u505c\uff0c\u81f4\u5fc3\u60b8\u3001\u5934\u6655\u3001\u75f0\u6d8e’);<\/p>\n\n\n\n
                              — \u2705 3. \u4e2d\u836f\u6750\u8868\uff08\u53ef\u9009\uff09
                              INSERT INTO herbs (name, pinyin, nature, flavor, meridian, effects) VALUES
                              (‘\u515a\u53c2’, ‘Dang Shen’, ‘\u5e73’, ‘\u7518’, ‘\u80ba\u3001\u813e’, ‘\u8865\u4e2d\u76ca\u6c14\uff0c\u5065\u813e\u76ca\u80ba’),
                              (‘\u767d\u672f’, ‘Bai Zhu’, ‘\u6e29’, ‘\u82e6\u3001\u7518’, ‘\u813e\u3001\u80c3’, ‘\u5065\u813e\u76ca\u6c14\uff0c\u71e5\u6e7f\u5229\u6c34’),
                              (‘\u832f\u82d3’, ‘Fu Ling’, ‘\u5e73’, ‘\u7518\u3001\u6de1’, ‘\u5fc3\u3001\u813e\u3001\u80ba\u3001\u80be’, ‘\u5229\u6c34\u6e17\u6e7f\uff0c\u5065\u813e\u5b89\u795e’),
                              (‘\u7518\u8349’, ‘Gan Cao’, ‘\u5e73’, ‘\u7518’, ‘\u5fc3\u3001\u80ba\u3001\u813e\u3001\u80c3’, ‘\u8865\u813e\u76ca\u6c14\uff0c\u7f13\u6025\u6b62\u75db’),
                              (‘\u67f4\u80e1’, ‘Chai Hu’, ‘\u5fae\u5bd2’, ‘\u82e6\u3001\u8f9b’, ‘\u809d\u3001\u80c6’, ‘\u758f\u809d\u89e3\u90c1\uff0c\u5347\u9633\u4e3e\u9677’),
                              (‘\u5f53\u5f52’, ‘Dang Gui’, ‘\u6e29’, ‘\u7518\u3001\u8f9b’, ‘\u809d\u3001\u5fc3\u3001\u813e’, ‘\u8865\u8840\u6d3b\u8840\uff0c\u8c03\u7ecf\u6b62\u75db’),
                              (‘\u9ec4\u82a9’, ‘Huang Qin’, ‘\u5bd2’, ‘\u82e6’, ‘\u80ba\u3001\u80c6\u3001\u5927\u80a0\u3001\u80c3’, ‘\u6e05\u70ed\u71e5\u6e7f\uff0c\u6cfb\u706b\u89e3\u6bd2’),
                              (‘\u9ebb\u9ec4’, ‘Ma Huang’, ‘\u6e29’, ‘\u8f9b’, ‘\u80ba\u3001\u8180\u80f1’, ‘\u53d1\u6c57\u89e3\u8868\uff0c\u5ba3\u80ba\u5e73\u5598’),
                              (‘\u534a\u590f’, ‘Ban Xia’, ‘\u6e29’, ‘\u8f9b’, ‘\u813e\u3001\u80c3\u3001\u80ba’, ‘\u71e5\u6e7f\u5316\u75f0\uff0c\u964d\u9006\u6b62\u5455’);<\/p>\n\n\n\n
                              \u975e\u5e38\u597d\uff01\u6211\u4eec\u5c06\u6267\u884c\u4ee5\u4e0b\u4e09\u9879\u589e\u5f3a\uff1a<\/p>\n\n\n\n
                              \n\n\n\n
                              \u2705 \u4e00\u3001\ud83d\udce6 \u589e\u52a0\u66f4\u591a\u65b9\u5242\uff08\u9644\u5c5e\u4e2d\u836f\u7ec4\u6210\u3001\u529f\u6548\u3001\u4e3b\u6cbb\uff09<\/h2>\n\n\n\n
                              INSERT INTO formulas (name, syndrome, ingredients, usage, indications) VALUES\n('\u6e29\u80c6\u6c64', '\u75f0\u70ed\u6270\u5fc3', '\u534a\u590f10g, \u7af9\u833910g, \u67b3\u5b9e10g, \u9648\u76ae10g, \u832f\u82d310g, \u7518\u83496g', '\u6c34\u714e\u670d\uff0c\u6bcf\u65e5\u4e00\u5242', '\u5931\u7720\u591a\u68a6\uff0c\u5fc3\u60b8\u4e0d\u5b89\uff0c\u75f0\u591a\u53e3\u82e6'),\n('\u5f52\u813e\u6c64', '\u5fc3\u813e\u4e24\u865a', '\u515a\u53c210g, \u767d\u672f10g, \u832f\u795e10g, \u9ec4\u82aa10g, \u9f99\u773c\u808910g, \u5f53\u5f5210g, \u9178\u67a3\u4ec110g, \u8fdc\u5fd76g, \u6728\u99996g, \u751f\u59dc3\u7247, \u5927\u67a35\u679a', '\u6c34\u714e\u670d\uff0c\u6bcf\u65e5\u4e00\u5242', '\u5fc3\u60b8\u5931\u7720\uff0c\u5065\u5fd8\u4e4f\u529b\uff0c\u98df\u5c11\u4fbf\u6e8f'),\n('\u8865\u4e2d\u76ca\u6c14\u6c64', '\u6c14\u865a\u4e0b\u9677', '\u9ec4\u82aa15g, \u4eba\u53c29g, \u767d\u672f10g, \u5f53\u5f5210g, \u9648\u76ae6g, \u5347\u9ebb3g, \u67f4\u80e16g, \u7099\u7518\u83496g', '\u6c34\u714e\u670d\uff0c\u65e52\u6b21', '\u6c14\u77ed\u4e4f\u529b\uff0c\u8131\u809b\u4e45\u6cfb\uff0c\u5b50\u5bab\u4e0b\u5782'),\n('\u5c0f\u9752\u9f99\u6c64', '\u5916\u5bd2\u5185\u996e', '\u9ebb\u9ec49g, \u6842\u679d9g, \u5e72\u59dc9g, \u7ec6\u8f9b6g, \u4e94\u5473\u5b506g, \u534a\u590f9g, \u828d\u836f9g, \u7518\u83496g', '\u6c34\u714e\u6e29\u670d', '\u6076\u5bd2\u53d1\u70ed\uff0c\u65e0\u6c57\u54b3\u5598\uff0c\u75f0\u591a\u7a00\u767d'),\n('\u9f99\u80c6\u6cfb\u809d\u6c64', '\u809d\u80c6\u5b9e\u706b\u3001\u6e7f\u70ed\u4e0b\u6ce8', '\u9f99\u80c6\u83496g, \u9ec4\u82a99g, \u6800\u5b509g, \u8f66\u524d\u5b509g, \u6cfd\u6cfb9g, \u6728\u901a6g, \u5f53\u5f526g, \u751f\u5730\u9ec49g, \u67f4\u80e16g, \u7518\u83496g', '\u6c34\u714e\u670d\uff0c\u6bcf\u65e5\u4e00\u5242', '\u5934\u75db\u76ee\u8d64\uff0c\u80c1\u75db\u53e3\u82e6\uff0c\u5c0f\u4fbf\u9ec4\u8d64');\n<\/code><\/pre>\n\n\n\n
                              \n\n\n\n
                              \u2705 \u4e8c\u3001\ud83d\udccc \u589e\u52a0\u66f4\u591a\u8bc1\u578b\uff08\u542b\u5173\u952e\u8bcd\u3001\u65b9\u5242\u63a8\u8350\u3001\u63a8\u8350\u7406\u7531\uff09<\/h2>\n\n\n\n
                              INSERT INTO syndrome_library (syndrome_name, keywords, recommended_formulas, match_reason) VALUES\n('\u75f0\u6e7f\u4e2d\u963b', '\u80f8\u95f7,\u7eb3\u5446,\u5455\u5410,\u5934\u91cd\u5982\u88f9,\u820c\u82d4\u767d\u817b,\u8109\u6ed1', '\u6e29\u80c6\u6c64', '\u813e\u5931\u5065\u8fd0\uff0c\u75f0\u6e7f\u4e2d\u963b\uff0c\u81f4\u7eb3\u5dee\u6076\u5fc3\u3001\u5934\u91cd\u8eab\u56f0'),\n('\u5fc3\u813e\u4e24\u865a', '\u5fc3\u60b8,\u5931\u7720,\u591a\u68a6,\u5065\u5fd8,\u75b2\u5026,\u7eb3\u5dee,\u820c\u6de1,\u8109\u7ec6\u5f31', '\u5f52\u813e\u6c64', '\u5fc3\u8840\u4e0d\u8db3\u517c\u813e\u6c14\u865a\uff0c\u5e38\u89c1\u5931\u7720\u5065\u5fd8\uff0c\u820c\u6de1\u8109\u5f31'),\n('\u6c14\u865a\u4e0b\u9677', '\u6c14\u77ed\u4e4f\u529b,\u8131\u809b,\u4e45\u6cfb,\u5b50\u5bab\u4e0b\u5782,\u820c\u6de1\u82d4\u767d,\u8109\u865a', '\u8865\u4e2d\u76ca\u6c14\u6c64', '\u813e\u6c14\u865a\u5f31\uff0c\u6c14\u4e0d\u6444\u8840\uff0c\u4e0d\u56fa\u4e0b\u7126\uff0c\u5bfc\u81f4\u8131\u5782\u4e45\u6cfb'),\n('\u5916\u5bd2\u5185\u996e', '\u54b3\u55fd\u5598\u606f,\u75f0\u591a\u7a00\u767d,\u6076\u5bd2\u65e0\u6c57,\u8eab\u51b7\u80a2\u51b7,\u820c\u82d4\u767d\u6ed1', '\u5c0f\u9752\u9f99\u6c64', '\u5916\u611f\u98ce\u5bd2\uff0c\u80ba\u5bd2\u996e\u76db\uff0c\u54b3\u75f0\u6e05\u7a00'),\n('\u6e7f\u70ed\u4e0b\u6ce8', '\u5c0f\u4fbf\u9ec4\u8d64,\u9634\u90e8\u7619\u75d2,\u5e26\u4e0b\u9ec4\u81ed,\u820c\u7ea2\u82d4\u9ec4\u817b,\u8109\u6ed1\u6570', '\u9f99\u80c6\u6cfb\u809d\u6c64', '\u809d\u80c6\u6e7f\u70ed\u4e0b\u6ce8\uff0c\u89c1\u5c0f\u4fbf\u70ed\u6da9\u3001\u9634\u75d2\u3001\u82d4\u9ec4\u817b');\n<\/code><\/pre>\n\n\n\n
                              \n\n\n\n
                              \u2705 \u4e09\u3001\ud83d\udc8a \u65b9\u5242\u4e0e\u4e2d\u836f\u6750\u5173\u8054\u5efa\u6a21\uff08\u63a8\u8350\u8868\u7ed3\u6784\uff09<\/h2>\n\n\n\n
                              \ud83d\udcc1 \u8868\u7ed3\u6784\uff08\u65b0\u589e\u8868\uff09<\/h3>\n\n\n\n
                              CREATE TABLE formula_herbs (\n  id INT AUTO_INCREMENT PRIMARY KEY,\n  formula_id INT NOT NULL,\n  herb_id INT NOT NULL,\n  dosage VARCHAR(50),\n  FOREIGN KEY (formula_id) REFERENCES formulas(id),\n  FOREIGN KEY (herb_id) REFERENCES herbs(id)\n);\n<\/code><\/pre>\n\n\n\n
                              \n\n\n\n
                              \ud83d\udd01 \u793a\u4f8b\u6570\u636e\u63d2\u5165<\/h3>\n\n\n\n
                              \n
                              \u5047\u8bbe formulas.id = 1<\/code> \u5bf9\u5e94\u201c\u56db\u541b\u5b50\u6c64\u201d\uff0c\u201cherbs.id = 1 ~ 4<\/code> \u5206\u522b\u662f\u515a\u53c2\u3001\u767d\u672f\u3001\u832f\u82d3\u3001\u7518\u8349\u3002<\/p>\n<\/blockquote>\n\n\n\n
                              -- \u56db\u541b\u5b50\u6c64\u914d\u4f0d\nINSERT INTO formula_herbs (formula_id, herb_id, dosage) VALUES\n(1, 1, '10g'), -- \u515a\u53c2\n(1, 2, '10g'), -- \u767d\u672f\n(1, 3, '10g'), -- \u832f\u82d3\n(1, 4, '6g');  -- \u7518\u8349\n<\/code><\/pre>\n\n\n\n
                              \n
                              \u53ef\u4ee5\u901a\u8fc7 JOIN<\/code> \u67e5\u8be2\u51fa\uff1a\u67d0\u65b9\u5242\u7684\u6240\u6709\u4e2d\u836f\u7ec4\u6210\u3001\u529f\u6548\u3001\u836f\u6027\u7b49\u3002<\/p>\n<\/blockquote>\n\n\n\n
                              \n\n\n\n
                              \u2705 \u793a\u4f8b\u67e5\u8be2\uff08\u65b9\u5242 \u2192 \u836f\u6750\u7ec4\u6210\uff09<\/h2>\n\n\n\n
                              SELECT f.name AS formula, h.name AS herb, fh.dosage, h.effects\nFROM formula_herbs fh\nJOIN formulas f ON fh.formula_id = f.id\nJOIN herbs h ON fh.herb_id = h.id\nWHERE f.name = '\u56db\u541b\u5b50\u6c64';\n<\/code><\/pre>\n\n\n\n
                              \n\n\n\n
                              \ud83d\udd1a \u4e0b\u4e00\u6b65\u4f60\u53ef\u4ee5\u505a\uff1a<\/h2>\n\n\n\n
                              \u76ee\u6807<\/th>\u5efa\u8bae\u64cd\u4f5c<\/th><\/tr><\/thead>
                              \u53ef\u89c6\u5316\u65b9\u5242\u7ec4\u6210<\/td>PHP \/ \u524d\u7aef\u8054\u8868\u5c55\u793a<\/td><\/tr>
                              \u65b9\u5242\u67e5\u8be2\u63a5\u53e3<\/td>\u65b0\u589e api\/formula_detail.php<\/code><\/td><\/tr>
                              \u836f\u6750\u8bcd\u5e93\u7ef4\u62a4<\/td>\u6784\u5efa herbs.php<\/code> \u540e\u53f0\u7ba1\u7406\u9875<\/td><\/tr>
                              \u81ea\u5b9a\u4e49\u65b9\u5242\u6784\u5efa<\/td>\u652f\u6301\u533b\u751f\u540e\u53f0\u81ea\u7531\u914d\u4f0d\u3001\u8bb0\u5f55<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
                              \n\n\n\n
                              \u662f\u5426\u9700\u8981\u6211\u4e3a\u4f60\uff1a<\/p>\n\n\n\n
                                \n
                              • \u2705 \u6253\u5305\u8fd9\u4e9b\u7ed3\u6784\u4e3a .sql<\/code> \u6587\u4ef6\uff1f<\/li>\n\n\n\n
                              • \u2705 \u6784\u5efa formula_herbs.php<\/code> \u7ba1\u7406\u9875\u9762\uff1f<\/li>\n\n\n\n
                              • \u2705 \u6784\u5efa API \u63a5\u53e3\u652f\u6301\u5c0f\u7a0b\u5e8f\u8bfb\u53d6\u65b9\u5242\u7ec4\u6210\uff1f<\/li>\n<\/ul>\n\n\n\n
                                \u8bf7\u544a\u8bc9\u6211\u4f60\u5e0c\u671b\u7ee7\u7eed\u54ea\u4e00\u90e8\u5206\u5f00\u53d1\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
                                \u5982\u679c\u4f60\u6b63\u5728\u6784\u5efa\u4e00\u4e2a \u4e2d\u533b\u8fa8\u8bc1\u8bba\u6cbb\u7cfb\u7edf\uff08TCM Syndrome Differentiation & Treatment System\uff09\uff0c\u5e76\u8ba1\u5212\u4f7f\u7528 MySQL + PHP \u6280\u672f\u6808\uff0c\u4ee5\u4e0b\u662f\u4e00\u4e2a\u5b8c\u6574\u7684\u7cfb\u7edf\u6784\u601d\u4e0e\u5f00\u53d1\u5efa\u8bae\uff1a \u2705 \u4e00\u3001\u7cfb\u7edf\u529f\u80fd\u67b6\u6784\uff08\u6982\u8981\uff09 1. \u7528\u6237\u7ba1\u7406\u6a21\u5757 2. \u60a3\u8005\u7ba1\u7406\u6a21\u5757 3. \u95ee\u8bca\u4e0e\u8fa8\u8bc1\u6a21\u5757 4. \u65b9\u5242\u4e0e\u6cbb\u7597\u6a21\u5757 5. \u62a5\u544a\u5bfc\u51fa\u4e0e\u7edf\u8ba1\u6a21\u5757 \u2705 \u4e8c\u3001\u6570\u636e\u5e93\u8bbe\u8ba1\uff08MySQL\uff09 1. \u7528\u6237\u8868 users 2. \u60a3\u8005\u8868 patients 3. \u95ee\u8bca\u8bb0\u5f55 consultations 4. \u65b9\u5242\u8868 formulas \u2705 \u4e09\u3001PHP \u529f\u80fd\u6a21\u5757\u5efa\u8bae \u2714 \u767b\u5f55\u8ba4\u8bc1\u6a21\u5757\uff08login.php\uff09 \u2714 \u95ee\u8bca\u8868\u5355\u9875\u9762\uff08consultation_form.php\uff09 \u2714 \u81ea\u52a8\u63a8\u8350\u65b9\u5242\u6a21\u5757 \u2714 \u751f\u6210 PDF \u62a5\u544a\uff08\u4f7f\u7528 TCPDF \u6216 mPDF\uff09 \u2705 \u56db\u3001\u524d\u7aef\u754c\u9762\uff08HTML […]<\/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-632","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/easyaccsoft.com\/webdesign\/wp-json\/wp\/v2\/posts\/632","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=632"}],"version-history":[{"count":10,"href":"https:\/\/easyaccsoft.com\/webdesign\/wp-json\/wp\/v2\/posts\/632\/revisions"}],"predecessor-version":[{"id":642,"href":"https:\/\/easyaccsoft.com\/webdesign\/wp-json\/wp\/v2\/posts\/632\/revisions\/642"}],"wp:attachment":[{"href":"https:\/\/easyaccsoft.com\/webdesign\/wp-json\/wp\/v2\/media?parent=632"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/easyaccsoft.com\/webdesign\/wp-json\/wp\/v2\/categories?post=632"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/easyaccsoft.com\/webdesign\/wp-json\/wp\/v2\/tags?post=632"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}