{"id":4304,"date":"2025-07-31T10:32:15","date_gmt":"2025-07-31T02:32:15","guid":{"rendered":"https:\/\/www.zhaozhao123.cn\/wpcms\/bjjc\/4304.html"},"modified":"2025-10-16T10:08:18","modified_gmt":"2025-10-16T02:08:18","slug":"wordpress%e5%88%9b%e5%bb%ba%e8%87%aa%e5%ae%9a%e4%b9%89%e9%98%9f%e5%88%97%e6%95%b0%e6%8d%ae%e8%a1%a8%e4%b8%8e%e6%97%a5%e5%bf%97%e6%95%b0%e6%8d%ae%e8%a1%a8%e7%a4%ba%e4%be%8b%e4%bb%a3%e7%a0%81","status":"publish","type":"bjjc","link":"https:\/\/www.zhaozhao123.cn\/wpcms\/bjjc\/4304.html","title":{"rendered":"WordPress\u521b\u5efa\u81ea\u5b9a\u4e49\u961f\u5217\u6570\u636e\u8868\u4e0e\u65e5\u5fd7\u6570\u636e\u8868\u793a\u4f8b\u4ee3\u7801\uff0c\u9644\u5b57\u6bb5\u589e\u6539\u67e5\u51fd\u6570"},"content":{"rendered":"<p>\u672c\u6587WordPress\u521b\u5efa\u81ea\u5b9a\u4e49\u961f\u5217\u6570\u636e\u8868\u4e0e\u65e5\u5fd7\u6570\u636e\u8868\u4ee3\u7801\u4ec5\u4f9b\u53c2\u8003\uff0c\u4f60\u53ef\u4ee5\u6839\u636e\u81ea\u5df1\u7684\u9700\u6c42\u4fee\u6539\u6216\u4f7f\u7528\u3002<\/p><h2 class=\"wp-block-heading\">\u521b\u5efa\u6570\u636e\u8868\u4ee3\u7801<\/h2><pre class=\"wp-block-code\"><code>\/\/\u9884\u5b9a\u4e49\u5e38\u91cf\ndefine('ZZW_TABLE_NAME', 'zzw_static_queue'); \/\/\u6570\u636e\u5e93\u961f\u5217\u6570\u636e\u8868\ndefine('ZZW_TABLE_LOG_NAME', 'zzw_static_log');\/\/\u65e5\u5fd7\u6570\u636e\u8868\n\n\/\/\u521b\u5efa\u961f\u5217\u6570\u636e\u8868\u4e0e\u65e5\u5fd7\u6570\u636e\u8868\nfunction zzw_create_table() {\n    global $wpdb;\n\n    \/\/\u8fd4\u56de\uff1a\u5b57\u7b26\u4e32\u6570\u636e\u5e93\u5b57\u7b26\u6574\u7406\uff0c\u8be6\u89c1\uff1ahttps:\/\/developer.wordpress.org\/reference\/classes\/wpdb\/get_charset_collate\/\n    $charset_collate = $wpdb-&gt;get_charset_collate();\n\n    \/\/ \u961f\u5217\u6570\u636e\u8868\n    $table_name = $wpdb-&gt;prefix . ZZW_TABLE_NAME; \n    $sql_queue = \"CREATE TABLE $table_name (\n        id bigint(20) NOT NULL AUTO_INCREMENT,\n        type varchar(20) NOT NULL,\n        tax_pt varchar(20) NOT NULL,\n        object_id bigint(20) NOT NULL DEFAULT '0',\n        status varchar(20) NOT NULL DEFAULT 'pending',\n        created datetime NOT NULL,\n        updated datetime NOT NULL,\n        PRIMARY KEY (id),\n        KEY type_status (type, status)\n    ) $charset_collate;\";\n    \n\n    \/\/ \u65e5\u5fd7\u8868\n    $table_log_name = $wpdb-&gt;prefix . ZZW_TABLE_LOG_NAME;\n    $sql_log = \"CREATE TABLE $table_log_name (\n        log_id bigint(20) NOT NULL AUTO_INCREMENT,\n        log_name varchar(20) NOT NULL,\n        log_value longtext NOT NULL,\n        log_created datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,\n        PRIMARY KEY (log_id),\n        KEY log_name_idx (log_name)\n    ) $charset_collate;\";\n    \n    \/\/\u5f15\u5165 WordPress \u6838\u5fc3\u6587\u4ef6 upgrade.php\uff0c\u8be5\u6587\u4ef6\u5b9a\u4e49\u4e86\u6570\u636e\u5e93\u8868\u64cd\u4f5c\u7684\u5173\u952e\u51fd\u6570 dbDelta()\n    require_once(ABSPATH . 'wp-admin\/includes\/upgrade.php');\n    \n    \/\/ \u6267\u884c\u521b\u5efa\u5e76\u6355\u83b7\u9519\u8bef\n    $queue_result = dbDelta($sql_queue);\n    $log_result = dbDelta($sql_log);\n    \n    \/\/ \u589e\u5f3a\u9519\u8bef\u8bca\u65ad:\u6839\u636e\u81ea\u5df1\u9700\u6c42\u589e\u5220\u6539\n    \/\/ if (false === $log_result) {\n    \/\/     error_log(\"\u65e5\u5fd7\u8868\u521b\u5efa\u5931\u8d25: \" . $wpdb-&gt;last_error);\n    \/\/     error_log(\"\u6267\u884c\u7684SQL: \" . $sql_log);\n    \/\/ } else {\n    \/\/     error_log(\"\u65e5\u5fd7\u8868\u521b\u5efa\u6210\u529f: $table_log_name\");\n    \/\/ }\n    \n    \/\/ \u8fd4\u56de\u521b\u5efa\u72b6\u6001\n    return [\n        'queue_table' =&gt; $queue_result ? true : false,\n        'log_table' =&gt; $log_result ? true : false\n    ];\n}<\/code><\/pre><h2 class=\"wp-block-heading\">\u5173\u4e8e\u4f7f\u7528\u6838\u5fc3\u6587\u4ef6 upgrade.php \u7684\u8bf4\u660e<\/h2><p>\u4ee3\u7801\u5206\u6790\uff1a<code>require_once(ABSPATH . 'wp-admin\/includes\/upgrade.php')<\/code><\/p><h4 class=\"wp-block-heading\">1. <strong>\u4f5c\u7528<\/strong><\/h4><ul class=\"wp-block-list\">\n<li>\u5f15\u5165 WordPress \u6838\u5fc3\u6587\u4ef6 <code>upgrade.php<\/code>\uff0c\u8be5\u6587\u4ef6\u5b9a\u4e49\u4e86\u6570\u636e\u5e93\u8868\u64cd\u4f5c\u7684\u5173\u952e\u51fd\u6570 <strong><code>dbDelta()<\/code><\/strong>\u3002<\/li>\n\n\n\n<li><code>dbDelta()<\/code> \u662f WordPress \u7528\u4e8e<strong>\u5b89\u5168\u521b\u5efa\u6216\u66f4\u65b0\u6570\u636e\u5e93\u8868<\/strong>\u7684\u6838\u5fc3\u5de5\u5177\uff0c\u5b83\u4f1a\u667a\u80fd\u5bf9\u6bd4\u8868\u7ed3\u6784\u5dee\u5f02\uff0c\u6267\u884c\u5fc5\u8981\u7684 SQL \u4fee\u6539\uff08\u5982\u6dfb\u52a0\/\u4fee\u6539\u5b57\u6bb5\u3001\u7d22\u5f15\uff09\uff0c\u907f\u514d\u6570\u636e\u4e22\u5931\u3002<\/li>\n<\/ul><hr class=\"wp-block-separator has-alpha-channel-opacity\"><h4 class=\"wp-block-heading\">2. <strong>\u4f7f\u7528\u539f\u56e0<\/strong><\/h4><ul class=\"wp-block-list\">\n<li><strong>\u4f9d\u8d56\u5173\u952e\u51fd\u6570<\/strong>\uff1a<code>dbDelta()<\/code> \u51fd\u6570\u672a\u5728 WordPress \u5168\u5c40\u4f5c\u7528\u57df\u4e2d\u81ea\u52a8\u52a0\u8f7d\uff0c\u5fc5\u987b\u663e\u5f0f\u5f15\u5165 <code>upgrade.php<\/code> \u624d\u80fd\u4f7f\u7528\u3002<\/li>\n\n\n\n<li><strong>\u8868\u7ed3\u6784\u5b89\u5168\u66f4\u65b0<\/strong>\uff1a\u76f4\u63a5\u6267\u884c <code>CREATE TABLE<\/code> \u53ef\u80fd\u56e0\u8868\u5df2\u5b58\u5728\u800c\u62a5\u9519\uff0c<code>dbDelta()<\/code> \u4f1a\u81ea\u52a8\u5904\u7406\uff1a\n<ul class=\"wp-block-list\">\n<li>\u82e5\u8868\u4e0d\u5b58\u5728 \u2192 \u521b\u5efa\u65b0\u8868<\/li>\n\n\n\n<li>\u82e5\u8868\u5b58\u5728 \u2192 \u68c0\u67e5\u5b57\u6bb5\/\u7d22\u5f15\u5dee\u5f02 \u2192 \u4ec5\u66f4\u65b0\u5dee\u5f02\u90e8\u5206<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u7b26\u5408 WordPress \u89c4\u8303<\/strong>\uff1a\u5b98\u65b9\u63a8\u8350\u4f7f\u7528 <code>dbDelta()<\/code> \u521b\u5efa\u63d2\u4ef6\u8868\uff0c\u786e\u4fdd\u517c\u5bb9\u4e0d\u540c\u6570\u636e\u5e93\u73af\u5883\uff08\u5982 MySQL\/MariaDB\uff09\u3002<\/li>\n<\/ul><hr class=\"wp-block-separator has-alpha-channel-opacity\"><h4 class=\"wp-block-heading\">3. <strong>\u4ee3\u7801\u4e2d\u7684\u4f4d\u7f6e<\/strong><\/h4><ul class=\"wp-block-list\">\n<li><strong>\u4f4d\u7f6e<\/strong>\uff1a\u5728\u5b9a\u4e49 SQL \u8bed\u53e5\uff08<code>$sql_queue<\/code>, <code>$sql_log<\/code>\uff09\u4e4b\u540e\u3001\u8c03\u7528 <code>dbDelta()<\/code> \u4e4b\u524d\u3002<\/li>\n\n\n\n<li><strong>\u5fc5\u8981\u6027<\/strong>\uff1a <\/li>\n<\/ul><pre class=\"wp-block-code\"><code>\/\/ 1. \u5b9a\u4e49SQL\u8bed\u53e5 \n$sql_queue = \"CREATE TABLE ...\"; $sql_log = \"CREATE TABLE ...\"; \n\/\/ 2. \u5f15\u5165upgrade.php\uff08\u4f7fdbDelta()\u53ef\u7528\uff09 \nrequire_once(ABSPATH . 'wp-admin\/includes\/upgrade.php'); \n\/\/ 3. \u4f7f\u7528dbDelta()\u5b89\u5168\u521b\u5efa\/\u66f4\u65b0\u8868 \n$queue_result = dbDelta($sql_queue); \n\/\/ \u4f9d\u8d56\u5f15\u5165\u7684\u6587\u4ef6 \n$log_result = dbDelta($sql_log);<\/code><\/pre><hr class=\"wp-block-separator has-alpha-channel-opacity\"><h4 class=\"wp-block-heading\">4. <strong>\u662f\u5426\u53ef\u4ee5\u79fb\u9664\uff1f<\/strong><\/h4><ul class=\"wp-block-list\">\n<li><strong>\u4e0d\u53ef\u79fb\u9664<\/strong>\uff01\u79fb\u9664\u4f1a\u5bfc\u81f4\uff1a\n<ol class=\"wp-block-list\">\n<li><strong>\u81f4\u547d\u9519\u8bef<\/strong>\uff1a<code>dbDelta()<\/code> \u51fd\u6570\u672a\u5b9a\u4e49\uff0c\u811a\u672c\u7ec8\u6b62\u3002<\/li>\n\n\n\n<li><strong>\u8868\u521b\u5efa\u5931\u8d25<\/strong>\uff1a\u65e0\u6cd5\u5b89\u5168\u5904\u7406\u8868\u7ed3\u6784\u53d8\u66f4\u3002<\/li>\n<\/ol>\n<\/li>\n\n\n\n<li><strong>\u7279\u6b8a\u60c5\u51b5<\/strong>\uff1a\u5982\u679c\u4ee3\u7801\u5728 WordPress \u540e\u53f0\uff08\u5982\u63d2\u4ef6\u5b89\u88c5\u94a9\u5b50\uff09\u4e14\u5df2\u52a0\u8f7d\u8fc7 <code>upgrade.php<\/code>\uff08\u901a\u5e38\u4e0d\u4f1a\uff09\uff0c\u53ef\u80fd\u91cd\u590d\u5f15\u5165\uff0c\u4f46 <code>require_once<\/code> \u4f1a\u907f\u514d\u91cd\u590d\u52a0\u8f7d\uff0c\u65e0\u5bb3\u3002<\/li>\n<\/ul><hr class=\"wp-block-separator has-alpha-channel-opacity\"><h4 class=\"wp-block-heading\">5. <strong>\u5173\u952e\u51fd\u6570 <code>dbDelta()<\/code> \u8bf4\u660e<\/strong><\/h4><p><strong>\u8f93\u5165<\/strong>\uff1a\u63a5\u53d7\u5b8c\u6574\u7684 <code>CREATE TABLE<\/code> SQL \u8bed\u53e5\u3002<\/p><p><strong>\u8f93\u51fa<\/strong>\uff1a\u8fd4\u56de\u6267\u884c\u7ed3\u679c\u7684\u6570\u7ec4\uff08\u5b57\u6bb5\u7ea7\u64cd\u4f5c\u65e5\u5fd7\uff09\u3002<\/p><p><strong>\u6ce8\u610f\u4e8b\u9879<\/strong>\uff1a<\/p><p>SQL \u5fc5\u987b\u4f7f\u7528 <strong>\u4e25\u683c\u683c\u5f0f<\/strong>\uff08\u5b57\u6bb5\u5b9a\u4e49\u6362\u884c\u3001\u4e3b\u952e\u5355\u72ec\u58f0\u660e\uff09\u3002<\/p><p>\u8868\u540d\u9700\u5305\u88f9\u53cd\u5f15\u53f7\uff08<code>`table_name`<\/code>\uff09\uff0c\u907f\u514d\u5173\u952e\u5b57\u51b2\u7a81\u3002<\/p><p>\u793a\u4f8b\u683c\u5f0f\uff1a<\/p><pre class=\"wp-block-code\"><code>sql CREATE TABLE `wp_example_table` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `data` varchar(100) NOT NULL, PRIMARY KEY (`id`) \n\/\/ \u5fc5\u987b\u663e\u5f0f\u58f0\u660ePRIMARY KEY ) ENGINE=InnoDB DEFAULT CHARSET=utf8;<\/code><\/pre><hr class=\"wp-block-separator has-alpha-channel-opacity\"><h4 class=\"wp-block-heading\">6. <strong>\u603b\u7ed3<\/strong><\/h4><figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th><strong>\u9879\u76ee<\/strong><\/th><th><strong>\u8bf4\u660e<\/strong><\/th><\/tr><\/thead><tbody><tr><td><strong>\u4f5c\u7528<\/strong><\/td><td>\u5f15\u5165 <code>dbDelta()<\/code> \u51fd\u6570\uff0c\u7528\u4e8e\u5b89\u5168\u521b\u5efa\/\u66f4\u65b0\u6570\u636e\u5e93\u8868\u3002<\/td><\/tr><tr><td><strong>\u5fc5\u8981\u6027<\/strong><\/td><td>\u5fc5\u987b\u4fdd\u7559\uff0c\u5426\u5219\u4ee3\u7801\u65e0\u6cd5\u5de5\u4f5c\u3002<\/td><\/tr><tr><td><strong>\u4f4d\u7f6e<\/strong><\/td><td>\u8c03\u7528 <code>dbDelta()<\/code> \u4e4b\u524d\uff0cSQL \u5b9a\u4e49\u4e4b\u540e\u3002<\/td><\/tr><tr><td><strong>\u66ff\u4ee3\u65b9\u6848<\/strong><\/td><td>\u65e0\u3002\u4e0d\u4f7f\u7528 <code>dbDelta()<\/code> \u9700\u624b\u52a8\u5904\u7406\u590d\u6742\u8868\u7ed3\u6784\u903b\u8f91\uff08\u4e0d\u63a8\u8350\uff09\u3002<\/td><\/tr><tr><td><strong>\u6700\u4f73\u5b9e\u8df5<\/strong><\/td><td>\u59cb\u7ec8\u5728\u63d2\u4ef6\u6fc0\u6d3b\u94a9\u5b50\u4e2d\u4f7f\u7528\u6b64\u4ee3\u7801\u521b\u5efa\u8868\uff0c\u5e76\u9075\u5faa <code>dbDelta()<\/code> \u7684 SQL \u683c\u5f0f\u89c4\u8303\u3002<\/td><\/tr><\/tbody><\/table><\/figure><h2 class=\"wp-block-heading\">\u65e5\u5fd7\u6570\u636e\u8868\u914d\u5957\u64cd\u4f5c\u51fd\u6570<\/h2><p>\u67e5\u5b57\u6bb5\u503c\uff1a<\/p><pre class=\"wp-block-code\"><code>\/\/\u65e5\u5fd7\u6570\u636e\u8868\u83b7\u53d6\u6307\u5b9a\u2018log_name\u2019\u5b57\u6bb5\u7684\u6307\u5b9a\u2018log_value\u2019\u5b57\u6bb5\u503c\nfunction zzw_get_server_status_value($log_name) {\n    global $wpdb;\n    $table_name = $wpdb-&gt;prefix . ZZW_TABLE_LOG_NAME;\n    \n    \/*\/\/ \u7f13\u5b58\u4f18\u5316\uff1a\u51cf\u5c11\u91cd\u590d\u67e5\u8be2\n    static $cache = [];\n    $cache_key = md5($table_name . $log_name);\n    \n    if (isset($cache[$cache_key])) {\n        return $cache[$cache_key];\n    }*\/\n\n    \/\/ \u4f7f\u7528\u66f4\u53ef\u9760\u7684\u67e5\u8be2\u65b9\u6cd5\n    $query = $wpdb-&gt;prepare(\n        \"SELECT log_value FROM $table_name WHERE log_name = %s LIMIT 1\",\n        $log_name\n    );\n    \n    \/\/ \u6dfb\u52a0\u9519\u8bef\u6291\u5236\u548c\u7ed3\u679c\u7f13\u5b58\n    $log_value = $wpdb-&gt;get_var($query);\n    \n    \/\/ \u589e\u5f3a\u9519\u8bef\u5904\u7406\n    if (null === $log_value) {\n        $error_type = '';\n        \n        if ($wpdb-&gt;last_error) {\n            \/\/ \u6570\u636e\u5e93\u7ea7\u9519\u8bef\n            $error_type = '\u6570\u636e\u5e93\u67e5\u8be2\u5931\u8d25';\n            error_log(\"\u72b6\u6001\u67e5\u8be2\u9519\u8bef - {$log_name}: \" . $wpdb-&gt;last_error);\n        } else {\n            \/\/ \u4e1a\u52a1\u7ea7\u6570\u636e\u7f3a\u5931\n            $error_type = '\u8bb0\u5f55\u4e0d\u5b58\u5728';\n            \/\/ \u964d\u7ea7\u4e3a\u8c03\u8bd5\u65e5\u5fd7\uff0c\u907f\u514d\u751f\u4ea7\u73af\u5883\u5237\u5c4f\n            if (WP_DEBUG) {\n                error_log(\"\u72b6\u6001\u67e5\u8be2\u8b66\u544a - {$log_name}: \u672a\u627e\u5230\u72b6\u6001\u8bb0\u5f55\");\n            }\n        }\n        \n        \/\/ \u7f13\u5b58\u7a7a\u7ed3\u679c\u907f\u514d\u91cd\u590d\u67e5\u8be2\n        \/\/ $cache[$cache_key] = false;\n        return false;\n    }\n    \n    \/\/ \u7f13\u5b58\u6709\u6548\u7ed3\u679c\n    \/\/ $cache[$cache_key] = $log_value;\n    return $log_value;\n}<\/code><\/pre><hr class=\"wp-block-separator has-alpha-channel-opacity\"><p>\u521b\u5efa\u6216\u4fee\u6539\u5b57\u6bb5\uff1a<\/p><pre class=\"wp-block-code\"><code>\/\/\u65e5\u5fd7\u6570\u636e\u8868\u6570\u636e\uff1a\u589e\u3001\u6539 -----------------------------------------------\n\/\/\u65e5\u5fd7\u6570\u636e\u8868\u5bf9\u5e94\u5b57\u6bb5\u503c\u7684\u4fee\u6539\u51fd\u6570\u6216\u521b\u5efa\u6570\u636e\nfunction zzw_update_log_value($log_name, $log_value) {\n    global $wpdb;\n    \n    \/\/ \u83b7\u53d6\u65e5\u5fd7\u8868\u540d\uff08\u5047\u8bbe\u5e38\u91cf ZZW_TABLE_LOG_NAME \u5df2\u5b9a\u4e49\uff09\n    $table_name = $wpdb-&gt;prefix . ZZW_TABLE_LOG_NAME;\n    \n    \/\/ \u786e\u4fdd\u540d\u79f0\u957f\u5ea6\u4e0d\u8d85\u8fc7\u5b57\u6bb5\u9650\u5236\uff08varchar(20)\uff09\n    \/\/$log_name = substr($log_name, 0, 20);\n    \n    \/\/ 1. \u68c0\u67e5\u8bb0\u5f55\u662f\u5426\u5b58\u5728\n    $existing_record = $wpdb-&gt;get_row(\n        $wpdb-&gt;prepare(\n            \"SELECT log_id FROM $table_name WHERE log_name = %s\",\n            $log_name\n        )\n    );\n    \n    if ($existing_record) {\n        \/\/ 2. \u5b58\u5728\u8bb0\u5f55\uff1a\u66f4\u65b0\u73b0\u6709\u503c\n        $result = $wpdb-&gt;update(\n            $table_name,\n            array('log_value' =&gt; $log_value),\n            array('log_id' =&gt; $existing_record-&gt;log_id),\n            array('%s'),   \/\/ log_value \u683c\u5f0f\n            array('%d')    \/\/ log_id \u683c\u5f0f\n        );\n        \n        if (false === $result) {\n            error_log(\"\u66f4\u65b0\u65e5\u5fd7\u8bb0\u5f55\u5931\u8d25 (log_name: $log_name): \" . $wpdb-&gt;last_error);\n            return false;\n        }\n    } else {\n        \/\/ 3. \u4e0d\u5b58\u5728\u8bb0\u5f55\uff1a\u63d2\u5165\u65b0\u8bb0\u5f55\n        $result = $wpdb-&gt;insert(\n            $table_name,\n            array(\n                'log_name' =&gt; $log_name,\n                'log_value' =&gt; $log_value\n            ),\n            array('%s', '%s')  \/\/ \u4e24\u4e2a\u5b57\u6bb5\u5747\u4e3a\u5b57\u7b26\u4e32\u683c\u5f0f\n        );\n        \n        if (false === $result) {\n            error_log(\"\u63d2\u5165\u65e5\u5fd7\u8bb0\u5f55\u5931\u8d25 (log_name: $log_name): \" . $wpdb-&gt;last_error);\n            return false;\n        }\n    }\n    \n    return true;\n}<\/code><\/pre><h2 class=\"wp-block-heading\">\u961f\u5217\u6570\u636e\u5e93\u63d2\u5165\u6570\u636e\u51fd\u6570<\/h2><pre class=\"wp-block-code\"><code>\/\/ \u5411\u961f\u5217\u6570\u636e\u8868\u6dfb\u52a0\u65b0\u4efb\u52a1\n    \/**\n     * $type:\u7c7b\u578b\u6807\u8bc6\uff1apost term index\n     * $object_id:\u6587\u7ae0ID\n     * $post_type:\u5bf9\u5e94\u7684posttype\u540d\n     * *\/\n    \/\/\u5df2\u7ecf\u4f5c\u5e9f\n    private function zzw_add_to_queue($type, $object_id,$post_type) {\n        global $wpdb;\n        \n        \/\/ 1. \u83b7\u53d6\u961f\u5217\u8868\u540d\uff08\u786e\u4fdd\u4e0e\u521b\u5efa\u65f6\u7684\u8868\u540d\u4e00\u81f4\uff09\n        $table_name = $wpdb-&gt;prefix . ZZW_TABLE_NAME;\n        \n        \/\/ 2. \u51c6\u5907\u8981\u63d2\u5165\u7684\u6570\u636e\uff08\u4f7f\u7528\u5f53\u524d\u65f6\u95f4\uff09\n        $current_time = current_time('mysql'); \/\/ WordPress\u51fd\u6570\u83b7\u53d6\u5f53\u524d\u65f6\u95f4\n        \n        $data = array(\n            'type'       =&gt; $type,        \/\/ \u4efb\u52a1\u7c7b\u578b  \uff1a * today - \u66f4\u65b0\u5f53\u5929\u5185\u5bb9 * home - \u66f4\u65b0\u9996\u9875 * terms - \u5206\u7c7b\u66f4\u65b0 * posts - \u66f4\u65b0\u6587\u7ae0 * all - \u66f4\u65b0\u5168\u7ad9 * clear - \u6e05\u7a7a\u9759\u6001\n            'object_id'  =&gt; $object_id,   \/\/ \u5173\u8054\u5bf9\u8c61ID\uff1a\u6587\u7ae0\u7684ID \u6216 term\u7684ID \u6216 -1\uff08posttype\u5f52\u6863\u7684ID\uff09\u6216 0\uff08\u7f51\u7ad9\u9996\u9875\u7684ID\uff09\n            'tax_pt'     =&gt; $post_type,   \/\/ \u57df\u7c7b\u578b    \uff1a posttype\u540d\uff08\u5bf9\u5e94\u6587\u7ae0\u6216\u5176\u5f52\u7c7b\uff09 \u6216 taxonomy\u540d\uff08\u5bf9\u5e94term\uff09 \u6216 index\uff08\u5bf9\u5e94\u9996\u9875\uff09\n            ..\n        );\n        \n        \/\/ 3. \u6307\u5b9a\u6570\u636e\u7c7b\u578b\u683c\u5f0f\uff08\u5b89\u5168\u9632\u62a4\uff09\n        $format = array(\n            '%s', \/\/ type \u662f\u5b57\u7b26\u4e32\n            '%d', \/\/ object_id \u662f\u6574\u6570\n            '%s',\n            ..\n        );\n        \n        \/\/ 4. \u6267\u884c\u5b89\u5168\u63d2\u5165\n        $result = $wpdb-&gt;insert($table_name, $data, $format);\n        \n        \/\/ 5. \u5904\u7406\u7ed3\u679c\n        if (false === $result) {\n            \/\/ \u63d2\u5165\u5931\u8d25\u5904\u7406\n            error_log(\"[zzw_add_to_queue] \".$object_id.\"|\".$post_type.\" \u52a0\u5165\u961f\u5217\u5931\u8d25: \" . $wpdb-&gt;last_error);\n            return false;\n        } else {\n            \/\/ \u8fd4\u56de\u65b0\u63d2\u5165\u7684\u4efb\u52a1ID\n            return $wpdb-&gt;insert_id;\n        }\n    }<\/code><\/pre>","protected":false},"excerpt":{"rendered":"<p>\u672c\u6587WordPress\u521b\u5efa\u81ea\u5b9a\u4e49\u961f\u5217\u6570\u636e\u8868\u4e0e\u65e5\u5fd7\u6570\u636e\u8868\u4ee3\u7801\u4ec5\u4f9b\u53c2\u8003\uff0c\u4f60\u53ef\u4ee5\u6839\u636e\u81ea\u5df1\u7684\u9700\u6c42\u4fee\u6539\u6216\u4f7f\u7528\u3002 \u521b\u5efa\u6570\u636e\u8868\u4ee3\u7801 \u5173\u4e8e\u4f7f\u7528\u6838\u5fc3\u6587\u4ef6 upgrade.php \u7684\u8bf4\u660e \u4ee3\u7801\u5206\u6790\uff1arequire_once(ABSPATH . &#8216;wp-admin\/includes\/upgrade.php&#8217;) 1. \u4f5c\u7528 2. \u4f7f\u7528\u539f\u56e0 3..<\/p>\n","protected":false},"author":1,"featured_media":0,"menu_order":0,"template":"","meta":{"_acf_changed":false},"tags":[3219],"bjjc2nav":[3217],"tuisongtax":[],"class_list":["post-4304","bjjc","type-bjjc","status-publish","hentry","tag-sjbckff","bjjc2nav-datatable"],"acf":{"qian_art_seotitle":"","qian_art_seotitle_source":{"label":"SEO\u6807\u9898","type":"text","formatted_value":""},"qian_art_seokws":"","qian_art_seokws_source":{"label":"SEO\u5173\u952e\u8bcd","type":"text","formatted_value":""},"qian_art_stzhong":"\u521b\u5efa\u6570\u636e\u8868\u793a\u4f8b\u4ee3\u7801","qian_art_stzhong_source":{"label":"\u4e2d | \u77ed\u6807\u9898","type":"text","formatted_value":"\u521b\u5efa\u6570\u636e\u8868\u793a\u4f8b\u4ee3\u7801"}},"_links":{"self":[{"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/bjjc\/4304","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/bjjc"}],"about":[{"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/types\/bjjc"}],"author":[{"embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/users\/1"}],"wp:attachment":[{"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/media?parent=4304"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/tags?post=4304"},{"taxonomy":"bjjc2nav","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/bjjc2nav?post=4304"},{"taxonomy":"tuisongtax","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/tuisongtax?post=4304"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}