{"id":30076,"date":"2024-11-25T11:08:20","date_gmt":"2024-11-25T03:08:20","guid":{"rendered":"https:\/\/fwq.ai\/blog\/30076\/"},"modified":"2024-11-25T11:08:20","modified_gmt":"2024-11-25T03:08:20","slug":"ecms%e6%80%8e%e4%b9%88%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\/30076\/","title":{"rendered":"ecms\u600e\u4e48\u901a\u8fc7\u6267\u884csql\u83b7\u53d6\u9700\u8981\u7684\u8bb0\u5f55"},"content":{"rendered":"

\"ecms\u600e\u4e48\u901a\u8fc7\u6267\u884csql\u83b7\u53d6\u9700\u8981\u7684\u8bb0\u5f55\u63d2\u56fe\"<\/strong><\/p>\n

ecms\u600e\u4e48\u901a\u8fc7\u6267\u884csql\u83b7\u53d6\u9700\u8981\u7684\u8bb0\u5f55\uff1f<\/strong><\/p>\n

ecms\u7075\u52a8\u6807\u7b7ee:loop\u7684\u7528\u6cd5\u901a\u8fc7\u6267\u884csql\u83b7\u53d6\u9700\u8981\u7684\u8bb0\u5f55<\/strong><\/p>\n

\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

\u63a8\u8350\u5b66\u4e60\u300a\u300b<\/p>\n

\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

\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 <\/p>\n

\u4ee3\u7801\u5982\u4e0b:<\/p>\n

[e:loop={'select * from phome_ecms_news where id in (2452,2697,2299,2267)',4,24,0}] \n<\/pre>\n
 \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
  •  <\/span> <\/li>\n
      [\/e:loop] <\/p>\n
    \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 <\/p>\n
    \u8fd9\u6837\u624d\u662fsql\u7684\u6267\u884c\u3002 <\/p>\n
    \uff08\u4ee5\u4e0b\u5185\u5bb9\u6765\u81ea\u4e92\u8054\u7f51\u8bf4\u660e\u7075\u52a8\u6807\u7b7e\u7684\u7528\u6cd5\uff09 <\/p>\n
    \u7075\u52a8\u6807\u7b7e\u7684\u4f7f\u7528\u8bf4\u660e\uff1a <\/p>\n
    \u7075\u52a8\u6807\u7b7e (e:loop) <\/p>\n
    \u683c\u5f0f\uff1a <\/p>\n
    [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\u6a21\u677f\u4ee3\u7801\u5185\u5bb9 \n[\/e:loop]<\/pre>\n
     \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
    \u4f8b\u5b50\uff1a <\/p>\n
    \u4ee3\u7801\u5982\u4e0b:<\/p>\n
    [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<tr> \n<td> \n<a>\" target=\"_blank\"&gt;=$bqr[title]?&gt;<\/a> (=date('Y-m-d',$bqr[newstime])?&gt;) \n<\/td> \n<\/tr> \n[\/e:loop]<\/pre>\n
     \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
    \u5177\u4f53\u7684\u64cd\u4f5c\u7c7b\u578b\u8bf4\u660e\u5982\u4e0b\uff1a <\/p>\n
    \u64cd\u4f5c\u7c7b\u578b \u8bf4\u660e <\/p>\n
    0 \u5404\u680f\u76ee\u6700\u65b0 <\/p>\n
    1 \u5404\u680f\u76ee\u70ed\u95e8 <\/p>\n
    2 \u5404\u680f\u76ee\u63a8\u8350 <\/p>\n
    9 \u5404\u680f\u76ee\u8bc4\u8bba\u6392\u884c <\/p>\n
    12 \u5404\u680f\u76ee\u5934\u6761\u4fe1\u606f <\/p>\n
    15 \u5404\u680f\u76ee\u4e0b\u8f7d\u6392\u884c <\/p>\n
    25 \u5404\u680f\u76ee\u8bc4\u5206\u6392\u884c <\/p>\n
    26 \u5404\u680f\u76ee\u6295\u7968\u6392\u884c <\/p>\n
    3 \u6240\u6709\u4fe1\u606f\u6700\u65b0(\u9ed8\u8ba4\u8868) <\/p>\n
    4 \u6240\u6709\u4fe1\u606f\u70ed\u95e8(\u9ed8\u8ba4\u8868) <\/p>\n
    5 \u6240\u6709\u4fe1\u606f\u63a8\u8350(\u9ed8\u8ba4\u8868) <\/p>\n
    10 \u6240\u6709\u4fe1\u606f\u8bc4\u8bba\u6392\u884c(\u9ed8\u8ba4\u8868) <\/p>\n
    13 \u6240\u6709\u4fe1\u606f\u5934\u6761(\u9ed8\u8ba4\u8868) <\/p>\n
    16 \u6240\u6709\u4fe1\u606f\u4e0b\u8f7d\u6392\u884c(\u9ed8\u8ba4\u8868) <\/p>\n
    27 \u6240\u6709\u4fe1\u606f\u8bc4\u5206\u6392\u884c(\u9ed8\u8ba4\u8868) <\/p>\n
    28 \u6240\u6709\u4fe1\u606f\u6295\u7968\u6392\u884c(\u9ed8\u8ba4\u8868) <\/p>\n
    6 \u4e13\u9898\u6700\u65b0\u4fe1\u606f <\/p>\n
    7 \u4e13\u9898\u70ed\u95e8\u4fe1\u606f <\/p>\n
    8 \u4e13\u9898\u63a8\u8350\u4fe1\u606f <\/p>\n
    11 \u4e13\u9898\u8bc4\u8bba\u6392\u884c <\/p>\n
    14 \u4e13\u9898\u5934\u6761 <\/p>\n
    17 \u5404\u4e13\u9898\u4e0b\u8f7d\u6392\u884c <\/p>\n
    29 \u5404\u4e13\u9898\u8bc4\u5206\u6392\u884c <\/p>\n
    30 \u5404\u4e13\u9898\u6295\u7968\u6392\u884c <\/p>\n
    18 \u5404\u8868\u6700\u65b0 (\u680f\u76eeID=’\u8868\u540d’) <\/p>\n
    19 \u5404\u8868\u70ed\u95e8 (\u680f\u76eeID=’\u8868\u540d’) <\/p>\n
    20 \u5404\u8868\u63a8\u8350 (\u680f\u76eeID=’\u8868\u540d’) <\/p>\n
    21 \u5404\u8868\u8bc4\u8bba\u6392\u884c (\u680f\u76eeID=’\u8868\u540d’) <\/p>\n
    22 \u5404\u8868\u5934\u6761\u4fe1\u606f (\u680f\u76eeID=’\u8868\u540d’) <\/p>\n
    23 \u5404\u8868\u4e0b\u8f7d\u6392\u884c (\u680f\u76eeID=’\u8868\u540d’) <\/p>\n
    31 \u5404\u8868\u8bc4\u5206\u6392\u884c (\u680f\u76eeID=’\u8868\u540d’) <\/p>\n
    32 \u5404\u8868\u6295\u7968\u6392\u884c (\u680f\u76eeID=’\u8868\u540d’) <\/p>\n
    24 \u6309sql\u67e5\u8be2(\u680f\u76eeID=’sql\u8bed\u53e5’) <\/p>\n
    \u6570\u636e\u8868\u524d\u7f00\u53ef\u7528\uff1a\u201c[!db.pre!]”\u8868\u793a<\/p>\n
    \u4ee5\u4e0a\u5c31\u662fecms\u600e\u4e48\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":"
    ecms\u600e\u4e48\u901a\u8fc7\u6267\u884csql\u83b7\u53d6\u9700\u8981\u7684\u8bb0\u5f55\uff1f ecms\u7075\u52a8\u6807\u7b7ee:loop\u7684\u7528\u6cd5\u901a\u8fc7\u6267\u884csql\u83b7\u53d6\u9700\u8981\u7684\u8bb0\u5f55 \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  \u63a8\u8350\u5b66\u4e60\u300a\u300b \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  \u4ee3\u7801\u5982\u4e0b: [e:loop={‘select * from phome_ecms_news where id in (2452,2697,2299,2267)’,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] \u767b\u5f55\u540e\u590d\u5236 \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}]  <tr>  <td>  <a>” target=”_blank”&gt;=$bqr[title]?&gt;<\/a> (=date(‘Y-m-d’,$bqr[newstime])?&gt;)  <\/td>  <\/tr>  [\/e:loop] \u767b\u5f55\u540e\u590d\u5236 \u5177\u4f53\u7684\u64cd\u4f5c\u7c7b\u578b\u8bf4\u660e\u5982\u4e0b\uff1a  \u64cd\u4f5c\u7c7b\u578b \u8bf4\u660e  0 \u5404\u680f\u76ee\u6700\u65b0  1 \u5404\u680f\u76ee\u70ed\u95e8  2 \u5404\u680f\u76ee\u63a8\u8350  9 \u5404\u680f\u76ee\u8bc4\u8bba\u6392\u884c  12 \u5404\u680f\u76ee\u5934\u6761\u4fe1\u606f  15 \u5404\u680f\u76ee\u4e0b\u8f7d\u6392\u884c  25 \u5404\u680f\u76ee\u8bc4\u5206\u6392\u884c  26 \u5404\u680f\u76ee\u6295\u7968\u6392\u884c  3 \u6240\u6709\u4fe1\u606f\u6700\u65b0(\u9ed8\u8ba4\u8868)  4 \u6240\u6709\u4fe1\u606f\u70ed\u95e8(\u9ed8\u8ba4\u8868)  […]<\/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-30076","post","type-post","status-publish","format-standard","hentry","category-cms"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/30076","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=30076"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/30076\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=30076"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=30076"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=30076"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}