{"id":4214,"date":"2025-07-01T11:00:18","date_gmt":"2025-07-01T03:00:18","guid":{"rendered":"https:\/\/www.zhaozhao123.cn\/wpcms\/bjjc\/4214.html"},"modified":"2025-12-11T10:16:01","modified_gmt":"2025-12-11T02:16:01","slug":"wordpress%e4%b8%ad%e4%bd%bf%e7%94%a8global-wpdb%e7%9a%84%e5%87%bd%e6%95%b0%e4%b8%ad%e8%b0%83%e7%94%a8%e5%8f%a6%e4%b8%80%e4%bd%bf%e7%94%a8%e8%af%a5%e5%8f%98%e9%87%8f%e7%9a%84%e5%87%bd%e6%95%b0","status":"publish","type":"bjjc","link":"https:\/\/www.zhaozhao123.cn\/wpcms\/bjjc\/4214.html","title":{"rendered":"WordPress\u4e2d\u4f7f\u7528global $wpdb\u7684\u51fd\u6570\u4e2d\u8c03\u7528\u53e6\u4e00\u4f7f\u7528\u8be5\u53d8\u91cf\u7684\u51fd\u6570\u7684\u66f4\u4f18\u505a\u6cd5"},"content":{"rendered":"<p>\u5728 WordPress \u5f00\u53d1\u4e2d\uff0c\u5173\u4e8e <code>global $wpdb<\/code> \u7684\u4f7f\u7528\u65b9\u5f0f\uff0c<strong>\u5c06 <code>$wpdb<\/code> \u901a\u8fc7\u53c2\u6570\u4f20\u9012\u7ed9\u51fd\u6570 B \u662f\u66f4\u4f18\u7684\u505a\u6cd5<\/strong>\u3002\u4ee5\u4e0b\u662f\u8be6\u7ec6\u5206\u6790\u548c\u539f\u56e0\uff1a<\/p><h3 class=\"wp-block-heading\">\u2699\ufe0f 1. <strong>\u964d\u4f4e\u8026\u5408\u6027\u4e0e\u63d0\u9ad8\u53ef\u7ef4\u62a4\u6027<\/strong><\/h3><pre class=\"wp-block-code\"><code>- **\u76f4\u63a5 `global` \u7684\u7f3a\u70b9**\uff1a\u5728\u51fd\u6570 B \u5185\u90e8\u4f7f\u7528 `global $wpdb` \u4f1a\u4f7f\u5176**\u9690\u5f0f\u4f9d\u8d56\u5168\u5c40\u72b6\u6001**\u3002\u8fd9\u5bfc\u81f4\u51fd\u6570 B \u65e0\u6cd5\u72ec\u7acb\u4e8e WordPress \u73af\u5883\u8fd0\u884c\uff08\u4f8b\u5982\u5355\u5143\u6d4b\u8bd5\u65f6\uff09\uff0c\u4e14\u4fee\u6539\u6216\u8c03\u8bd5\u65f6\u9700\u989d\u5916\u68c0\u67e5\u5168\u5c40\u53d8\u91cf\u72b6\u6001\u3002\n- **\u53c2\u6570\u4f20\u9012\u7684\u4f18\u70b9**\uff1a\u901a\u8fc7\u51fd\u6570 A \u5c06 `$wpdb` \u4f5c\u4e3a\u53c2\u6570\u663e\u5f0f\u4f20\u5165\u51fd\u6570 B\uff0c\u660e\u786e\u58f0\u660e\u4e86\u4f9d\u8d56\u5173\u7cfb\u3002\u51fd\u6570 B \u7684\u884c\u4e3a\u4ec5\u7531\u8f93\u5165\u53c2\u6570\u51b3\u5b9a\uff0c\u4e0e\u5916\u90e8\u73af\u5883\u89e3\u8026\uff0c\u4ee3\u7801\u66f4\u6613\u7406\u89e3\u548c\u7ef4\u62a4\u3002<\/code><\/pre><h3 class=\"wp-block-heading\">\ud83e\uddea 2. <strong>\u589e\u5f3a\u53ef\u6d4b\u8bd5\u6027<\/strong><\/h3><pre class=\"wp-block-code\"><code>- \u82e5\u51fd\u6570 B \u76f4\u63a5\u4f7f\u7528 `global`\uff0c\u5728\u5355\u5143\u6d4b\u8bd5\u4e2d\u9700\u6a21\u62df\u5168\u5c40 `$wpdb` \u5bf9\u8c61\uff0c\u8fc7\u7a0b\u590d\u6742\u4e14\u6613\u51fa\u9519\u3002\n- \u901a\u8fc7\u53c2\u6570\u4f20\u9012\uff0c\u53ef\u76f4\u63a5\u5411\u51fd\u6570 B \u6ce8\u5165\u6a21\u62df\u7684\u6570\u636e\u5e93\u5bf9\u8c61\uff08\u5982 PHPUnit Mock \u5bf9\u8c61\uff09\uff0c\u65e0\u9700\u64cd\u4f5c\u5168\u5c40\u4f5c\u7528\u57df\uff0c\u6d4b\u8bd5\u66f4\u7b80\u6d01\u53ef\u9760\u3002<\/code><\/pre><h3 class=\"wp-block-heading\">\ud83d\udd0d 3. <strong>\u907f\u514d\u547d\u540d\u51b2\u7a81\u4e0e\u526f\u4f5c\u7528<\/strong><\/h3><pre class=\"wp-block-code\"><code>- \u5168\u5c40\u53d8\u91cf\u5728\u590d\u6742\u9879\u76ee\u4e2d\u53ef\u80fd\u88ab\u610f\u5916\u8986\u76d6\uff08\u4f8b\u5982\u63d2\u4ef6\u51b2\u7a81\uff09\u3002\u53c2\u6570\u4f20\u9012\u5c06 `$wpdb` \u9650\u5236\u5728\u51fd\u6570\u4f5c\u7528\u57df\u5185\uff0c\u6d88\u9664\u4e86\u547d\u540d\u51b2\u7a81\u98ce\u9669\u3002\n- \u51fd\u6570 B \u5185\u90e8\u82e5\u4fee\u6539 `$wpdb`\uff08\u5982\u6267\u884c\u67e5\u8be2\u540e\u6539\u53d8\u5176\u72b6\u6001\uff09\uff0c\u901a\u8fc7\u53c2\u6570\u4f20\u9012\u7684\u5c40\u90e8\u53d8\u91cf\u4e0d\u4f1a\u6c61\u67d3\u5168\u5c40\u5bf9\u8c61\uff0c\u800c\u76f4\u63a5 `global` \u53ef\u80fd\u5f15\u53d1\u96be\u4ee5\u8ffd\u8e2a\u7684\u526f\u4f5c\u7528\u3002<\/code><\/pre><h3 class=\"wp-block-heading\">\ud83d\udcda 4. <strong>\u7b26\u5408\u73b0\u4ee3\u7f16\u7a0b\u89c4\u8303<\/strong><\/h3><pre class=\"wp-block-code\"><code>- **\u4f9d\u8d56\u6ce8\u5165\uff08DI\uff09\u539f\u5219**\uff1a\u53c2\u6570\u4f20\u9012\u672c\u8d28\u662f\u4f9d\u8d56\u6ce8\u5165\u7684\u7b80\u5355\u5b9e\u73b0\uff0c\u88ab\u5e7f\u6cdb\u89c6\u4e3a\u6700\u4f73\u5b9e\u8df5\u3002WordPress \u6838\u5fc3\u4ee3\u7801\u867d\u56e0\u5386\u53f2\u539f\u56e0\u5927\u91cf\u4f7f\u7528 `global`\uff0c\u4f46\u65b0\u4ee3\u7801\u63a8\u8350\u51cf\u5c11\u5168\u5c40\u4f9d\u8d56\u3002\n- **\u4ee3\u7801\u53ef\u91cd\u7528\u6027**\uff1a\u53c2\u6570\u4f20\u9012\u7684\u51fd\u6570 B \u53ef\u88ab\u975e WordPress \u4e0a\u4e0b\u6587\u8c03\u7528\uff08\u5982 CLI \u811a\u672c\uff09\uff0c\u53ea\u9700\u4f20\u5165\u517c\u5bb9\u7684\u6570\u636e\u5e93\u5bf9\u8c61\u5373\u53ef\u3002<\/code><\/pre><h3 class=\"wp-block-heading\">\u2696\ufe0f 5. <strong>\u6027\u80fd\u5f71\u54cd\u53ef\u5ffd\u7565<\/strong><\/h3><pre class=\"wp-block-code\"><code>- \u4e24\u79cd\u65b9\u5f0f\u6027\u80fd\u5dee\u5f02\u5fae\u4e4e\u5176\u5fae\u3002`global` \u9700\u67e5\u627e\u5168\u5c40\u7b26\u53f7\u8868\uff0c\u53c2\u6570\u4f20\u9012\u6d89\u53ca\u503c\u4f20\u9012\uff08\u5bf9\u8c61\u662f\u5f15\u7528\u4f20\u9012\uff09\uff0c\u5b9e\u9645\u5f00\u9500\u5747\u6781\u4f4e\uff0c**\u4e0d\u5e94\u4f5c\u4e3a\u51b3\u7b56\u4f9d\u636e**\u3002<\/code><\/pre><p><strong>\ud83d\udee0\ufe0f \u4f55\u65f6\u53ef\u63a5\u53d7\u4f7f\u7528 <code>global<\/code>\uff1f<\/strong><br>&#8211; <strong>\u7b80\u5355\u811a\u672c\u6216\u4e34\u65f6\u4ee3\u7801<\/strong>\uff1a\u5feb\u901f\u539f\u578b\u5f00\u53d1\u65f6\u53ef\u7b80\u5316\u4ee3\u7801\u3002<br>&#8211; <strong>\u65e0\u6cd5\u4fee\u6539\u7684\u7b2c\u4e09\u65b9\u56de\u8c03<\/strong>\uff1a\u5982 WordPress Hook \u7684\u56de\u8c03\u51fd\u6570\u5fc5\u987b\u6309\u56fa\u5b9a\u7b7e\u540d\u5b9a\u4e49\uff0c\u6b64\u65f6\u53ef\u80fd\u9700\u7528 <code>global<\/code>\uff08\u4f46\u5e94\u5c3d\u91cf\u5c01\u88c5\uff09\u3002<\/p><hr class=\"wp-block-separator has-alpha-channel-opacity\"><h3 class=\"wp-block-heading\">\u2705 \u6700\u7ec8\u7ed3\u8bba<\/h3><p><strong>\u4f18\u5148\u91c7\u7528\u53c2\u6570\u4f20\u9012<\/strong>\uff1a<\/p><pre class=\"wp-block-code\"><code>function A() {\n    global $wpdb;\n    B($wpdb); \/\/ \u663e\u5f0f\u4f20\u9012\n}\n\nfunction B($db) {\n    $db-&gt;query(...); \/\/ \u4f7f\u7528\u53c2\u6570\n}<\/code><\/pre><p><strong>\u907f\u514d\u5d4c\u5957 <code>global<\/code><\/strong>\uff1a<\/p><pre class=\"wp-block-code\"><code>function B() {\n    global $wpdb; \/\/ \u4e0d\u63a8\u8350\uff1a\u589e\u52a0\u8026\u5408\u6027\n    $wpdb-&gt;query(...);\n}<\/code><\/pre>","protected":false},"excerpt":{"rendered":"<p>\u5728 WordPress \u5f00\u53d1\u4e2d\uff0c\u5173\u4e8e global $wpdb \u7684\u4f7f\u7528\u65b9\u5f0f\uff0c\u5c06 $wpdb \u901a\u8fc7\u53c2\u6570\u4f20\u9012\u7ed9\u51fd\u6570 B \u662f\u66f4\u4f18\u7684\u505a\u6cd5\u3002\u4ee5\u4e0b\u662f\u8be6\u7ec6\u5206\u6790\u548c\u539f\u56e0\uff1a \u2699\ufe0f 1. \u964d\u4f4e\u8026\u5408\u6027\u4e0e\u63d0\u9ad8\u53ef\u7ef4\u62a4\u6027 \ud83e\uddea 2. \u589e\u5f3a\u53ef\u6d4b\u8bd5\u6027 \ud83d\udd0d 3. \u907f\u514d\u547d\u540d\u51b2\u7a81\u4e0e\u526f\u4f5c\u7528 \ud83d\udcda 4. \u7b26\u5408\u73b0\u4ee3\u7f16\u7a0b\u89c4\u8303 \u2696\ufe0f 5. \u6027\u80fd\u5f71\u54cd\u53ef\u5ffd\u7565 \ud83d\udee0\ufe0f \u4f55\u65f6\u53ef\u63a5\u53d7..<\/p>\n","protected":false},"author":1,"featured_media":0,"menu_order":0,"template":"","meta":{"_acf_changed":true},"tags":[3199],"bjjc2nav":[34],"tuisongtax":[],"class_list":["post-4214","bjjc","type-bjjc","status-publish","hentry","tag-qjbl","bjjc2nav-wptspz"],"acf":{"qian_art_seotitle":"WordPress\u4e2d\u4f7f\u7528global $wpdb\u7684\u51fd\u6570\u4e2d\u8c03\u7528\u53e6\u4e00\u4f7f\u7528\u8be5\u53d8\u91cf\u7684\u51fd\u6570\u7684\u66f4\u4f18\u505a\u6cd5","qian_art_seotitle_source":{"label":"SEO\u6807\u9898","type":"text","formatted_value":"WordPress\u4e2d\u4f7f\u7528global $wpdb\u7684\u51fd\u6570\u4e2d\u8c03\u7528\u53e6\u4e00\u4f7f\u7528\u8be5\u53d8\u91cf\u7684\u51fd\u6570\u7684\u66f4\u4f18\u505a\u6cd5"},"qian_art_seokws":"","qian_art_seokws_source":{"label":"SEO\u5173\u952e\u8bcd","type":"text","formatted_value":""},"qian_art_stzhong":"\u5168\u5c40\u53d8\u91cf\u8c03\u7528\u7684\u66f4\u4f18\u505a\u6cd5","qian_art_stzhong_source":{"label":"\u4e2d | \u77ed\u6807\u9898","type":"text","formatted_value":"\u5168\u5c40\u53d8\u91cf\u8c03\u7528\u7684\u66f4\u4f18\u505a\u6cd5"}},"_links":{"self":[{"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/bjjc\/4214","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=4214"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/tags?post=4214"},{"taxonomy":"bjjc2nav","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/bjjc2nav?post=4214"},{"taxonomy":"tuisongtax","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/tuisongtax?post=4214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}