{"id":29915,"date":"2024-11-25T10:32:07","date_gmt":"2024-11-25T02:32:07","guid":{"rendered":"https:\/\/fwq.ai\/blog\/29915\/"},"modified":"2024-11-25T10:32:07","modified_gmt":"2024-11-25T02:32:07","slug":"ecms%e7%81%b5%e5%8a%a8%e6%a0%87%e7%ad%beeloop%e7%9a%84%e7%94%a8%e6%b3%95%e9%80%9a%e8%bf%87%e6%89%a7%e8%a1%8csql%e8%8e%b7%e5%8f%96%e9%9c%80%e8%a6%81%e7%9a%84%e8%ae%b0%e5%bd%95","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/29915\/","title":{"rendered":"ecms\u7075\u52a8\u6807\u7b7ee:loop\u7684\u7528\u6cd5\u901a\u8fc7\u6267\u884csql\u83b7\u53d6\u9700\u8981\u7684\u8bb0\u5f55"},"content":{"rendered":"<p style=\"text-align: center\"><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/033\/5de1f911d24ae461.jpg\" class=\"aligncenter\" title=\"ecms\u7075\u52a8\u6807\u7b7ee:loop\u7684\u7528\u6cd5\u901a\u8fc7\u6267\u884csql\u83b7\u53d6\u9700\u8981\u7684\u8bb0\u5f55\u63d2\u56fe\" alt=\"ecms\u7075\u52a8\u6807\u7b7ee:loop\u7684\u7528\u6cd5\u901a\u8fc7\u6267\u884csql\u83b7\u53d6\u9700\u8981\u7684\u8bb0\u5f55\u63d2\u56fe\" \/><\/p>\n<p>\u5728\u67d0\u4e9b\u6761\u4ef6\u4e0b\uff0c\u6211\u4eec\u8981\u6c42\u7f51\u7ad9\u7684\u67d0\u9875\u4e0a\u663e\u793a\u6307\u5b9a\u7684\u4fe1\u606f\uff0c<\/p>\n<p>\u4f46\u662f\u8fd9\u79cd\u6307\u5b9a\u5982\u679c\u56fa\u5b9a\u53bb\u7528\u4ee3\u7801\u5199\u6b7b\u7684\u8bdd\uff0c\u5bf9\u4ee5\u540e\u7684\u6539\u52a8\u5c06\u4f1a\u662f\u5927\u9ebb\u70e6\uff1b<\/p>\n<p>\u8fd9\u65f6\u5019sql\u8bed\u53e5\u7684\u4f18\u52bf\u5c31\u51f8\u663e\u51fa\u6765\uff0c\u5229\u7528sql\u8bed\u53e5\u53ea\u9700\u8981\u6539\u6539\u6570\u5b57\uff0c\u5c31\u80fd\u8ba9\u663e\u793a\u7684\u5185\u5bb9\u5f7b\u5e95\u66ff\u6362\uff1b<br \/>\u63a8\u8350\u5b66\u4e60\u300a\u6559\u7a0b\u300b<\/p>\n<p>\u4ee3\u7801\u5982\u4e0b:<\/p>\n<pre>[e:loop={'select&nbsp;*&nbsp;from&nbsp;phome_ecms_news&nbsp;where&nbsp;id&nbsp;in&nbsp;(2452,2697,2299,2267)',4,24,0}]\n<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/p>\n<li> <span><\/span> <\/li>\n<p> [\/e:loop] <\/p>\n<p>\u6309\u7167sql\u8bed\u53e5\u7684\u6307\u5b9a\uff0c\u8fd4\u56deid\u7f16\u53f7\u5206\u522b\u4e3a2452,2697,2299,2267\u7684\u5185\u5bb9\u4fe1\u606f\uff0c\u540c\u65f6\u4ee3\u7801\u540e\u9762\u7684\u5012\u6570\u7b2c\u4e8c\u4e2a\u53c2\u6570\u4e3a24\uff0c<br \/>\u8fd9\u6837\u624d\u662fsql\u7684\u6267\u884c\u3002<br \/>\uff08\u4ee5\u4e0b\u5185\u5bb9\u6765\u81ea\u4e92\u8054\u7f51\u8bf4\u660e\u7075\u52a8\u6807\u7b7e\u7684\u7528\u6cd5\uff09<br \/>\u7075\u52a8\u6807\u7b7e\u7684\u4f7f\u7528\u8bf4\u660e\uff1a<br \/>\u7075\u52a8\u6807\u7b7e (e:loop)<br \/>\u683c\u5f0f\uff1a<br \/>[e:loop={\u680f\u76eeID\/\u4e13\u9898ID,\u663e\u793a\u6761\u6570,\u64cd\u4f5c\u7c7b\u578b, \u53ea\u663e\u793a\u6709\u6807\u9898\u56fe\u7247,\u9644\u52a0SQL\u6761\u4ef6,\u663e\u793a\u6392\u5e8f}]<br \/>\u6a21\u677f\u4ee3\u7801\u5185\u5bb9<br \/>[\/e:loop]<br \/>\u4f8b\u5b50\uff1a<\/p>\n<p>\u4ee3\u7801\u5982\u4e0b:<\/p>\n<pre>[e:loop={\u680f\u76eeID\/\u4e13\u9898ID,\u663e\u793a\u6761\u6570,\u64cd\u4f5c\u7c7b\u578b,\u53ea\u663e\u793a\u6709\u6807\u9898\u56fe\u7247,\u9644\u52a0SQL\u6761\u4ef6,\u663e\u793a\u6392\u5e8f}]\n&lt;tr&gt;\n&lt;td&gt;\n&lt;a&gt;\"&nbsp;target=\"_blank\"&amp;gt;=$bqr[title]?&amp;gt;&lt;\/a&gt;&nbsp;(=date('Y-m-d',$bqr[newstime])?&amp;gt;)\n&lt;\/td&gt;\n&lt;\/tr&gt;\n[\/e:loop]<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/p>\n<p>\u5177\u4f53\u7684\u64cd\u4f5c\u7c7b\u578b\u8bf4\u660e\u5982\u4e0b\uff1a<br \/>\u64cd\u4f5c\u7c7b\u578b \u8bf4\u660e<br \/>0 \u5404\u680f\u76ee\u6700\u65b0<br \/>1 \u5404\u680f\u76ee\u70ed\u95e8<br \/>2 \u5404\u680f\u76ee\u63a8\u8350<br \/>9 \u5404\u680f\u76ee\u8bc4\u8bba\u6392\u884c<br \/>12 \u5404\u680f\u76ee\u5934\u6761\u4fe1\u606f<br \/>15 \u5404\u680f\u76ee\u4e0b\u8f7d\u6392\u884c<br \/>25 \u5404\u680f\u76ee\u8bc4\u5206\u6392\u884c<br \/>26 \u5404\u680f\u76ee\u6295\u7968\u6392\u884c<br \/>3 \u6240\u6709\u4fe1\u606f\u6700\u65b0(\u9ed8\u8ba4\u8868)<br \/>4 \u6240\u6709\u4fe1\u606f\u70ed\u95e8(\u9ed8\u8ba4\u8868)<br \/>5 \u6240\u6709\u4fe1\u606f\u63a8\u8350(\u9ed8\u8ba4\u8868)<br \/>10 \u6240\u6709\u4fe1\u606f\u8bc4\u8bba\u6392\u884c(\u9ed8\u8ba4\u8868)<br \/>13 \u6240\u6709\u4fe1\u606f\u5934\u6761(\u9ed8\u8ba4\u8868)<br \/>16 \u6240\u6709\u4fe1\u606f\u4e0b\u8f7d\u6392\u884c(\u9ed8\u8ba4\u8868)<br \/>27 \u6240\u6709\u4fe1\u606f\u8bc4\u5206\u6392\u884c(\u9ed8\u8ba4\u8868)<br \/>28 \u6240\u6709\u4fe1\u606f\u6295\u7968\u6392\u884c(\u9ed8\u8ba4\u8868)<br \/>6 \u4e13\u9898\u6700\u65b0\u4fe1\u606f<br \/>7 \u4e13\u9898\u70ed\u95e8\u4fe1\u606f<br \/>8 \u4e13\u9898\u63a8\u8350\u4fe1\u606f<br \/>11 \u4e13\u9898\u8bc4\u8bba\u6392\u884c<br \/>14 \u4e13\u9898\u5934\u6761<br \/>17 \u5404\u4e13\u9898\u4e0b\u8f7d\u6392\u884c<br \/>29 \u5404\u4e13\u9898\u8bc4\u5206\u6392\u884c<br \/>30 \u5404\u4e13\u9898\u6295\u7968\u6392\u884c<br \/>18 \u5404\u8868\u6700\u65b0 (\u680f\u76eeID=&#8217;\u8868\u540d&#8217;)<br \/>19 \u5404\u8868\u70ed\u95e8 (\u680f\u76eeID=&#8217;\u8868\u540d&#8217;)<br \/>20 \u5404\u8868\u63a8\u8350 (\u680f\u76eeID=&#8217;\u8868\u540d&#8217;)<br \/>21 \u5404\u8868\u8bc4\u8bba\u6392\u884c (\u680f\u76eeID=&#8217;\u8868\u540d&#8217;)<br \/>22 \u5404\u8868\u5934\u6761\u4fe1\u606f (\u680f\u76eeID=&#8217;\u8868\u540d&#8217;)<br \/>23 \u5404\u8868\u4e0b\u8f7d\u6392\u884c (\u680f\u76eeID=&#8217;\u8868\u540d&#8217;)<br \/>31 \u5404\u8868\u8bc4\u5206\u6392\u884c (\u680f\u76eeID=&#8217;\u8868\u540d&#8217;)<br \/>32 \u5404\u8868\u6295\u7968\u6392\u884c (\u680f\u76eeID=&#8217;\u8868\u540d&#8217;)<br \/>24 \u6309sql\u67e5\u8be2(\u680f\u76eeID=&#8217;sql\u8bed\u53e5&#8217;)<br \/>\u6570\u636e\u8868\u524d\u7f00\u53ef\u7528\uff1a\u201c[!db.pre!]&#8221;\u8868\u793a<\/p>\n<p>\u4ee5\u4e0a\u5c31\u662fecms\u7075\u52a8\u6807\u7b7ee:loop\u7684\u7528\u6cd5\u901a\u8fc7\u6267\u884csql\u83b7\u53d6\u9700\u8981\u7684\u8bb0\u5f55\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>\u5728\u67d0\u4e9b\u6761\u4ef6\u4e0b\uff0c\u6211\u4eec\u8981\u6c42\u7f51\u7ad9\u7684\u67d0\u9875\u4e0a\u663e\u793a\u6307\u5b9a\u7684\u4fe1\u606f\uff0c \u4f46\u662f\u8fd9\u79cd\u6307\u5b9a\u5982\u679c\u56fa\u5b9a\u53bb\u7528\u4ee3\u7801\u5199\u6b7b\u7684\u8bdd\uff0c\u5bf9\u4ee5\u540e\u7684\u6539\u52a8\u5c06\u4f1a\u662f\u5927\u9ebb\u70e6\uff1b \u8fd9\u65f6\u5019sql\u8bed\u53e5\u7684\u4f18\u52bf\u5c31\u51f8\u663e\u51fa\u6765\uff0c\u5229\u7528sql\u8bed\u53e5\u53ea\u9700\u8981\u6539\u6539\u6570\u5b57\uff0c\u5c31\u80fd\u8ba9\u663e\u793a\u7684\u5185\u5bb9\u5f7b\u5e95\u66ff\u6362\uff1b\u63a8\u8350\u5b66\u4e60\u300a\u6559\u7a0b\u300b \u4ee3\u7801\u5982\u4e0b: [e:loop={&#8216;select&nbsp;*&nbsp;from&nbsp;phome_ecms_news&nbsp;where&nbsp;id&nbsp;in&nbsp;(2452,2697,2299,2267)&#8217;,4,24,0}] \u767b\u5f55\u540e\u590d\u5236 [\/e:loop] \u6309\u7167sql\u8bed\u53e5\u7684\u6307\u5b9a\uff0c\u8fd4\u56deid\u7f16\u53f7\u5206\u522b\u4e3a2452,2697,2299,2267\u7684\u5185\u5bb9\u4fe1\u606f\uff0c\u540c\u65f6\u4ee3\u7801\u540e\u9762\u7684\u5012\u6570\u7b2c\u4e8c\u4e2a\u53c2\u6570\u4e3a24\uff0c\u8fd9\u6837\u624d\u662fsql\u7684\u6267\u884c\u3002\uff08\u4ee5\u4e0b\u5185\u5bb9\u6765\u81ea\u4e92\u8054\u7f51\u8bf4\u660e\u7075\u52a8\u6807\u7b7e\u7684\u7528\u6cd5\uff09\u7075\u52a8\u6807\u7b7e\u7684\u4f7f\u7528\u8bf4\u660e\uff1a\u7075\u52a8\u6807\u7b7e (e:loop)\u683c\u5f0f\uff1a[e:loop={\u680f\u76eeID\/\u4e13\u9898ID,\u663e\u793a\u6761\u6570,\u64cd\u4f5c\u7c7b\u578b, \u53ea\u663e\u793a\u6709\u6807\u9898\u56fe\u7247,\u9644\u52a0SQL\u6761\u4ef6,\u663e\u793a\u6392\u5e8f}]\u6a21\u677f\u4ee3\u7801\u5185\u5bb9[\/e:loop]\u4f8b\u5b50\uff1a \u4ee3\u7801\u5982\u4e0b: [e:loop={\u680f\u76eeID\/\u4e13\u9898ID,\u663e\u793a\u6761\u6570,\u64cd\u4f5c\u7c7b\u578b,\u53ea\u663e\u793a\u6709\u6807\u9898\u56fe\u7247,\u9644\u52a0SQL\u6761\u4ef6,\u663e\u793a\u6392\u5e8f}] &lt;tr&gt; &lt;td&gt; &lt;a&gt;&#8221;&nbsp;target=&#8221;_blank&#8221;&amp;gt;=$bqr[title]?&amp;gt;&lt;\/a&gt;&nbsp;(=date(&#8216;Y-m-d&#8217;,$bqr[newstime])?&amp;gt;) &lt;\/td&gt; &lt;\/tr&gt; [\/e:loop] \u767b\u5f55\u540e\u590d\u5236 \u5177\u4f53\u7684\u64cd\u4f5c\u7c7b\u578b\u8bf4\u660e\u5982\u4e0b\uff1a\u64cd\u4f5c\u7c7b\u578b \u8bf4\u660e0 \u5404\u680f\u76ee\u6700\u65b01 \u5404\u680f\u76ee\u70ed\u95e82 \u5404\u680f\u76ee\u63a8\u83509 \u5404\u680f\u76ee\u8bc4\u8bba\u6392\u884c12 \u5404\u680f\u76ee\u5934\u6761\u4fe1\u606f15 \u5404\u680f\u76ee\u4e0b\u8f7d\u6392\u884c25 \u5404\u680f\u76ee\u8bc4\u5206\u6392\u884c26 \u5404\u680f\u76ee\u6295\u7968\u6392\u884c3 \u6240\u6709\u4fe1\u606f\u6700\u65b0(\u9ed8\u8ba4\u8868)4 \u6240\u6709\u4fe1\u606f\u70ed\u95e8(\u9ed8\u8ba4\u8868)5 \u6240\u6709\u4fe1\u606f\u63a8\u8350(\u9ed8\u8ba4\u8868)10 \u6240\u6709\u4fe1\u606f\u8bc4\u8bba\u6392\u884c(\u9ed8\u8ba4\u8868)13 \u6240\u6709\u4fe1\u606f\u5934\u6761(\u9ed8\u8ba4\u8868)16 \u6240\u6709\u4fe1\u606f\u4e0b\u8f7d\u6392\u884c(\u9ed8\u8ba4\u8868)27 \u6240\u6709\u4fe1\u606f\u8bc4\u5206\u6392\u884c(\u9ed8\u8ba4\u8868)28 \u6240\u6709\u4fe1\u606f\u6295\u7968\u6392\u884c(\u9ed8\u8ba4\u8868)6 \u4e13\u9898\u6700\u65b0\u4fe1\u606f7 \u4e13\u9898\u70ed\u95e8\u4fe1\u606f8 \u4e13\u9898\u63a8\u8350\u4fe1\u606f11 \u4e13\u9898\u8bc4\u8bba\u6392\u884c14 \u4e13\u9898\u5934\u676117 \u5404\u4e13\u9898\u4e0b\u8f7d\u6392\u884c29 \u5404\u4e13\u9898\u8bc4\u5206\u6392\u884c30 \u5404\u4e13\u9898\u6295\u7968\u6392\u884c18 \u5404\u8868\u6700\u65b0 (\u680f\u76eeID=&#8217;\u8868\u540d&#8217;)19 \u5404\u8868\u70ed\u95e8 (\u680f\u76eeID=&#8217;\u8868\u540d&#8217;)20 \u5404\u8868\u63a8\u8350 (\u680f\u76eeID=&#8217;\u8868\u540d&#8217;)21 \u5404\u8868\u8bc4\u8bba\u6392\u884c (\u680f\u76eeID=&#8217;\u8868\u540d&#8217;)22 \u5404\u8868\u5934\u6761\u4fe1\u606f (\u680f\u76eeID=&#8217;\u8868\u540d&#8217;)23 [&hellip;]<\/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-29915","post","type-post","status-publish","format-standard","hentry","category-cms"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/29915","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=29915"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/29915\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=29915"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=29915"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=29915"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}