{"id":31924,"date":"2024-11-25T13:52:13","date_gmt":"2024-11-25T05:52:13","guid":{"rendered":"https:\/\/fwq.ai\/blog\/31924\/"},"modified":"2024-11-25T13:52:13","modified_gmt":"2024-11-25T05:52:13","slug":"%e8%af%a6%e8%a7%a3%e9%80%9a%e8%bf%87wordpress%e5%86%85%e7%bd%ae%e5%87%bd%e6%95%b0%e6%89%b9%e9%87%8f%e6%b7%bb%e5%8a%a0%e6%96%87%e7%ab%a0%e7%9a%84%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/31924\/","title":{"rendered":"\u8be6\u89e3\u901a\u8fc7WordPress\u5185\u7f6e\u51fd\u6570\u6279\u91cf\u6dfb\u52a0\u6587\u7ae0\u7684\u65b9\u6cd5"},"content":{"rendered":"<p><span style=\"font-family:\">\u4e0b\u9762\u7531\/&#8221; target=&#8221;_blank&#8221;&gt;<strong>WordPress<\/strong>\u6559\u7a0b\u680f\u76ee\u7ed9\u5927\u5bb6\u4ecb\u7ecd\u901a\u8fc7WordPress\u5185\u7f6e\u51fd\u6570\u6279\u91cf\u6dfb\u52a0\u6587\u7ae0\u7684\u65b9\u6cd5\uff0c\u5e0c\u671b\u5bf9\u9700\u8981\u7684\u670b\u53cb\u6709\u6240\u5e2e\u52a9\uff01<\/span><\/p>\n<p style=\"text-align: center\"><span style=\"font-family:\"><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/020\/60225369ddbb2522.jpg\" class=\"aligncenter\" title=\"\u8be6\u89e3\u901a\u8fc7WordPress\u5185\u7f6e\u51fd\u6570\u6279\u91cf\u6dfb\u52a0\u6587\u7ae0\u7684\u65b9\u6cd5\u63d2\u56fe\" alt=\"\u8be6\u89e3\u901a\u8fc7WordPress\u5185\u7f6e\u51fd\u6570\u6279\u91cf\u6dfb\u52a0\u6587\u7ae0\u7684\u65b9\u6cd5\u63d2\u56fe\" \/><\/span><\/p>\n<p><span style=\"font-family:\">\u6700\u8fd1\u4e1a\u52a1\u9700\u8981\u5728\u7f51\u7ad9\u4e0a\u6279\u91cf\u6dfb\u52a0\u5927\u91cf\u7684\u6587\u7ae0\u3002\u4e00\u7bc7\u4e00\u7bc7\u5730\u624b\u52a8\u6dfb\u52a0\u7edd\u5bf9\u4f1a\u641e\u6b7b\u6211\uff0c\u6240\u4ee5\uff0c\u6211\u5c31\u5f00\u59cb\u5bfb\u627e\u6279\u91cf\u6dfb\u52a0\u7684\u65b9\u6cd5\u3002\u5176\u5b9e\uff0c\u6587\u7ae0\u7684\u76f8\u5173\u5185\u5bb9\u90fd\u5df2\u7ecf\u5728\u672c\u5730\u7684\u6570\u636e\u5e93\u91cc\u4e86\u3002\u6211\u6700\u5148\u60f3\u5230\u7684\u65b9\u6cd5\u662f\u901a\u8fc7sql\u8bed\u53e5\u76f4\u63a5\u628a\u6570\u636e\u5bfc\u5165\u7ebf\u4e0a\u7684\u5e93\u91cc\u3002<\/span><\/p>\n<p>\u4e8e\u662f\u6211\u901a\u8fc7<\/p>\n<pre>INSERT&nbsp;INTO&nbsp;target_table&nbsp;(key1,&nbsp;key2...)&nbsp;SELECT&nbsp;key1',&nbsp;key2'&nbsp;...&nbsp;FROM&nbsp;source_table;<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/p>\n<p>\u5c06\u6570\u636e\u63d2\u5165\u5230\u4e86\u7ebf\u4e0a\u7684\u8868\u4e2d\u3002\u6253\u5f00\u9875\u9762\u4e00\u770b\uff0c\u5168\u662f\u4e71\u7801\u3002\u4e8e\u662f\uff0c\u6211\u53c8\u5728\u63d2\u5165\u524d\u8bbe\u7f6e\u4e86\u4e00\u4e0b\u7f16\u7801\uff0c\u8fd8\u662f\u6709\u95ee\u9898\u3002<\/p>\n<p>\u7531\u4e8e\u6211\u662f\u4e00\u4e2a\u4e0d\u5584\u957fsql\u7684\u4eba\uff0c\u6211\u8c03\u6574\u4e86\u4e00\u4e0b\u7b56\u7565\u3002\u5076\u7136\u95f4\uff0c\u6211\u53d1\u73b0\u4e86\u4e00\u4e2aWordPress\u7684\u5185\u7f6e\u51fd\u6570 \u2018wp_insert_post\u2019\u3002\u55ef\uff0c\u5c31\u662f\u4ed6\u4e86\u3002<\/p>\n<p>\u4e8e\u662f\uff0c\u6211\u5c06\u76ee\u6807\u6570\u636e\u5bfc\u51fa\u6210php_array\uff0c\u7136\u540e\u5f15\u5165\u5230\u6211\u7684\u811a\u672c\u4e2d\uff0c\u901a\u8fc7wp_insert_post\u51fd\u6570\u6dfb\u52a0\u5230\u6570\u636e\u5e93\u4e2d\u3002<\/p>\n<pre>foreach(&nbsp;$php_array&nbsp;as&nbsp;$item&nbsp;){\n&nbsp;&nbsp;&nbsp;&nbsp;$arg&nbsp;=&nbsp;array(\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'post_title'&nbsp;=&amp;gt;&nbsp;$item['title'],\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'post_content'&nbsp;=&amp;gt;&nbsp;$item['content'],\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'post_excerpt'&nbsp;=&amp;gt;&nbsp;$item['excerpt'],\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'post_type'&nbsp;=&amp;gt;&nbsp;'post',\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'post_status'&nbsp;=&amp;gt;&nbsp;'public',\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'meta_input'&nbsp;=&amp;gt;&nbsp;array(\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'meta_key'&nbsp;=&amp;gt;&nbsp;'meta_value'\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)\n&nbsp;&nbsp;&nbsp;&nbsp;);\n&nbsp;&nbsp;&nbsp;&nbsp;wp_insert_post(&nbsp;$arg&nbsp;);\n}<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/p>\n<p>\u8fd9\u6837\uff0c\u5c31\u901a\u8fc7WordPress\u201c\u5408\u6cd5\u201d\u7684\u65b9\u5f0f\u6279\u91cf\u6dfb\u52a0\u4e86\u6587\u7ae0\uff0c\u800c\u4e14meta_input\u4e2d\u53ef\u4ee5\u6dfb\u52a0\u81ea\u5b9a\u4e49\u680f\u76ee\uff0c\u53ef\u4ee5\u8bf4\u975e\u5e38\u68d2\u4e86\u3002<\/p>\n<p>wp_insert_post\u5177\u4f53\u7684\u4f7f\u7528\u65b9\u6cd5\u53c2\u89c1\uff1a\u5b98\u65b9\u6587\u6863<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"UYgd9l8W5M\"><p><a href=\"https:\/\/developer.wordpress.org\/reference\/functions\/wp_insert_post\/\">wp_insert_post()<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;wp_insert_post()&#8221; &#8212; WordPress Developer Resources\" src=\"https:\/\/developer.wordpress.org\/reference\/functions\/wp_insert_post\/embed\/#?secret=ojdi8PRxWh#?secret=UYgd9l8W5M\" data-secret=\"UYgd9l8W5M\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>\u4ee5\u4e0a\u5c31\u662f\u8be6\u89e3\u901a\u8fc7WordPress\u5185\u7f6e\u51fd\u6570\u6279\u91cf\u6dfb\u52a0\u6587\u7ae0\u7684\u65b9\u6cd5\u7684\u8be6\u7ec6\u5185\u5bb9\uff0c\u66f4\u591a\u8bf7\u5173\u6ce8\u7c73\u4e91\u5176\u5b83\u76f8\u5173\u6587\u7ae0\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e0b\u9762\u7531\/&#8221; target=&#8221;_blank&#8221;&gt;WordPress\u6559\u7a0b\u680f\u76ee\u7ed9\u5927\u5bb6\u4ecb\u7ecd\u901a\u8fc7WordPress\u5185\u7f6e\u51fd\u6570\u6279\u91cf\u6dfb\u52a0\u6587\u7ae0\u7684\u65b9\u6cd5\uff0c\u5e0c\u671b\u5bf9\u9700\u8981\u7684\u670b\u53cb\u6709\u6240\u5e2e\u52a9\uff01 \u6700\u8fd1\u4e1a\u52a1\u9700\u8981\u5728\u7f51\u7ad9\u4e0a\u6279\u91cf\u6dfb\u52a0\u5927\u91cf\u7684\u6587\u7ae0\u3002\u4e00\u7bc7\u4e00\u7bc7\u5730\u624b\u52a8\u6dfb\u52a0\u7edd\u5bf9\u4f1a\u641e\u6b7b\u6211\uff0c\u6240\u4ee5\uff0c\u6211\u5c31\u5f00\u59cb\u5bfb\u627e\u6279\u91cf\u6dfb\u52a0\u7684\u65b9\u6cd5\u3002\u5176\u5b9e\uff0c\u6587\u7ae0\u7684\u76f8\u5173\u5185\u5bb9\u90fd\u5df2\u7ecf\u5728\u672c\u5730\u7684\u6570\u636e\u5e93\u91cc\u4e86\u3002\u6211\u6700\u5148\u60f3\u5230\u7684\u65b9\u6cd5\u662f\u901a\u8fc7sql\u8bed\u53e5\u76f4\u63a5\u628a\u6570\u636e\u5bfc\u5165\u7ebf\u4e0a\u7684\u5e93\u91cc\u3002 \u4e8e\u662f\u6211\u901a\u8fc7 INSERT&nbsp;INTO&nbsp;target_table&nbsp;(key1,&nbsp;key2&#8230;)&nbsp;SELECT&nbsp;key1&#8242;,&nbsp;key2&#8242;&nbsp;&#8230;&nbsp;FROM&nbsp;source_table; \u767b\u5f55\u540e\u590d\u5236 \u5c06\u6570\u636e\u63d2\u5165\u5230\u4e86\u7ebf\u4e0a\u7684\u8868\u4e2d\u3002\u6253\u5f00\u9875\u9762\u4e00\u770b\uff0c\u5168\u662f\u4e71\u7801\u3002\u4e8e\u662f\uff0c\u6211\u53c8\u5728\u63d2\u5165\u524d\u8bbe\u7f6e\u4e86\u4e00\u4e0b\u7f16\u7801\uff0c\u8fd8\u662f\u6709\u95ee\u9898\u3002 \u7531\u4e8e\u6211\u662f\u4e00\u4e2a\u4e0d\u5584\u957fsql\u7684\u4eba\uff0c\u6211\u8c03\u6574\u4e86\u4e00\u4e0b\u7b56\u7565\u3002\u5076\u7136\u95f4\uff0c\u6211\u53d1\u73b0\u4e86\u4e00\u4e2aWordPress\u7684\u5185\u7f6e\u51fd\u6570 \u2018wp_insert_post\u2019\u3002\u55ef\uff0c\u5c31\u662f\u4ed6\u4e86\u3002 \u4e8e\u662f\uff0c\u6211\u5c06\u76ee\u6807\u6570\u636e\u5bfc\u51fa\u6210php_array\uff0c\u7136\u540e\u5f15\u5165\u5230\u6211\u7684\u811a\u672c\u4e2d\uff0c\u901a\u8fc7wp_insert_post\u51fd\u6570\u6dfb\u52a0\u5230\u6570\u636e\u5e93\u4e2d\u3002 foreach(&nbsp;$php_array&nbsp;as&nbsp;$item&nbsp;){ &nbsp;&nbsp;&nbsp;&nbsp;$arg&nbsp;=&nbsp;array( &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#8216;post_title&#8217;&nbsp;=&amp;gt;&nbsp;$item[&#8216;title&#8217;], &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#8216;post_content&#8217;&nbsp;=&amp;gt;&nbsp;$item[&#8216;content&#8217;], &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#8216;post_excerpt&#8217;&nbsp;=&amp;gt;&nbsp;$item[&#8216;excerpt&#8217;], &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#8216;post_type&#8217;&nbsp;=&amp;gt;&nbsp;&#8216;post&#8217;, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#8216;post_status&#8217;&nbsp;=&amp;gt;&nbsp;&#8216;public&#8217;, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#8216;meta_input&#8217;&nbsp;=&amp;gt;&nbsp;array( &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#8216;meta_key&#8217;&nbsp;=&amp;gt;&nbsp;&#8216;meta_value&#8217; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;) &nbsp;&nbsp;&nbsp;&nbsp;); &nbsp;&nbsp;&nbsp;&nbsp;wp_insert_post(&nbsp;$arg&nbsp;); } \u767b\u5f55\u540e\u590d\u5236 \u8fd9\u6837\uff0c\u5c31\u901a\u8fc7WordPress\u201c\u5408\u6cd5\u201d\u7684\u65b9\u5f0f\u6279\u91cf\u6dfb\u52a0\u4e86\u6587\u7ae0\uff0c\u800c\u4e14meta_input\u4e2d\u53ef\u4ee5\u6dfb\u52a0\u81ea\u5b9a\u4e49\u680f\u76ee\uff0c\u53ef\u4ee5\u8bf4\u975e\u5e38\u68d2\u4e86\u3002 wp_insert_post\u5177\u4f53\u7684\u4f7f\u7528\u65b9\u6cd5\u53c2\u89c1\uff1a\u5b98\u65b9\u6587\u6863 wp_insert_post() \u4ee5\u4e0a\u5c31\u662f\u8be6\u89e3\u901a\u8fc7WordPress\u5185\u7f6e\u51fd\u6570\u6279\u91cf\u6dfb\u52a0\u6587\u7ae0\u7684\u65b9\u6cd5\u7684\u8be6\u7ec6\u5185\u5bb9\uff0c\u66f4\u591a\u8bf7\u5173\u6ce8\u7c73\u4e91\u5176\u5b83\u76f8\u5173\u6587\u7ae0\uff01<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-31924","post","type-post","status-publish","format-standard","hentry","category-cms"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/31924","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/comments?post=31924"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/31924\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=31924"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=31924"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=31924"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}