{"id":28889,"date":"2024-11-25T09:41:07","date_gmt":"2024-11-25T01:41:07","guid":{"rendered":"https:\/\/fwq.ai\/blog\/28889\/"},"modified":"2024-11-25T09:41:07","modified_gmt":"2024-11-25T01:41:07","slug":"%e6%80%8e%e4%b9%88%e8%a7%a3%e5%86%b3dedearclist-keyword%e7%9a%84%e7%9b%b8%e5%85%b3%e9%97%ae%e9%a2%98","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/28889\/","title":{"rendered":"\u600e\u4e48\u89e3\u51b3dede:arclist keyword\u7684\u76f8\u5173\u95ee\u9898"},"content":{"rendered":"

\"\u600e\u4e48\u89e3\u51b3dede:arclist<\/strong><\/p>\n

\u600e\u4e48\u89e3\u51b3{dede:arclist keyword=’\u52a8\u6001\u83b7\u53d6\u5173\u952e\u8bcd’}\uff1f<\/strong><\/p>\n

\u89e3\u51b3{dede:arclist keyword=’\u52a8\u6001\u83b7\u53d6\u5173\u952e\u8bcd’}<\/strong><\/p>\n

\u63a8\u8350\u5b66\u4e60\uff1a<\/p>\n

\u6700\u8fd1\u4fee\u6539\u6a21\u7248\uff0c\u4e3a\u4e86\u8ba9\u76f8\u5173\u6587\u7ae0\u7684\u76f8\u5173\u5ea6\u66f4\u9ad8\uff0c\u6253\u7b97\u4f18\u5316\u4e00\u4e0b\uff0c\u4e0d\u8fc7\u4f1a\u589e\u52a0\u751f\u6210\u9875\u9762\u65f6\u95f4\uff0c\u5982\u679c\u4e0d\u7ecf\u5e38\u66f4\u65b0\u5012\u662f\u4e0d\u9519\u7684<\/p>\n

  <\/p>\n

\u6700\u8fd1\u5728\u505a\u4e00\u4e2a\u7ad9\uff0c\u60f3\u505a\u4e00\u4e2a\u529f\u80fd\uff0c\u5c31\u662f\u6709\u4e00\u4e2adiv\u5757\u91cc\u663e\u793a\u7684\u662f\u4e0e\u5f53\u524d\u6587\u7ae0\u5173\u952e\u8bcd\u76f8\u540c\u7684\u6587\u7ae0\u7684\u6807\u9898\u3002\u5f00\u59cb\u7684\u65f6\u5019\u662f\u8fd9\u6837\u5199\u7684<\/p>\n

{dede:arclist keyword='{dede:field name=’keyword’}’}\u7ed3\u679c\u80af\u5b9a\u662f\u4e0d\u53ef\u4ee5\u7684\u3002\u3002\u3002\u3002\u5728\u7f51\u4e0a\u627e\u4e5f\u6ca1\u627e\u5230\u3002\u4e8e\u662f\u5c31\u81ea\u5df1\u8bfb\u4ee3\u7801\uff0c\u81ea\u5df1\u5199\u4e86\u4e2a\u7b80\u5355\u5904\u7406\u7684\u3002<\/p>\n

\u5728arclist.lib.php \u7b2c149\u884c<\/p>\n

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

\/\/\u5173\u952e\u5b57\u6761\u4ef6 \nif($keyword!='')<\/pre>\n
 \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
\u628a{}\u4e2d\u95f4\u7684\u5185\u5bb9\u6539\u6210 <\/p>\n
{ \n$rowGetKeyword = $dsql-&gt;GetOne(\"select keywords From `dede_archives` where id='$arcid'\"); \n$keyword=$rowGetKeyword['keywords']; \n$keyword = str_replace(',', '|', $keyword); \n$orwheres[] = \" CONCAT(arc.title,arc.keywords) REGEXP '$keyword' \"; \n}<\/pre>\n
 \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
\u8fd9\u6837\u76f4\u63a5\u8c03\u7528{dede:arclist keyword=’\u8fd9\u91cc\u968f\u4fbf\u5199\u53ea\u8981\u662f\u4e0d\u4e3a\u7a7a\u5c31\u53ef\u4ee5’} \u8fd9\u6837\u8fd9\u91cc\u7684keyword\u5c31\u662f\u52a8\u6001\u83b7\u53d6\u7684\u4e86\u3002\u4e0d\u7136\u53ea\u80fd\u662f\u56fa\u5b9a\u7684\u3002 <\/p>\n
\u5c31\u5728\u521a\u521a\u6211\u53d1\u5e16\u4e4b\u524d\u770b\u5230dede5.6\u91cc\u6709\u4e2a\u6807\u7b7e <\/p>\n
{dede:likeart titlelen='' row=''}\n{\/dede:likeart}<\/pre>\n
 \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
\u8fd9\u4e2a\u6807\u7b7e\u8fd8\u6ca1\u6d4b\u8bd5\uff0c\u4e0d\u8fc7\u5e94\u8be5\u5c31\u662f\u8fd9\u4e2a\u529f\u80fd\u3002\u5982\u679c\u4e0d\u662f\uff0c\u5927\u5bb6\u5c31\u4e00\u7528\u6211\u4e0a\u9762\u7684\u65b9\u6cd5\u3002\u6d4b\u8bd5\u8fc7\u4e86\uff0c\u53ef\u4ee5\u7528\u3002<\/p>\n
DEDECMS\u76f8\u5173\u6587\u7ae0\u4ee5\u5173\u952e\u5b57\u76f8\u5173\u7684\u4fee\u6539\u65b9\u6cd5 <\/p>\n
DEDE\u7684\u76f8\u5173\u6587\u7ae0\u5b8c\u5168\u4e0d\u76f8\u5173\uff0c\u6709\u670b\u53cb\u5728DEDE\u5b98\u65b9\u653e\u51fa\u6839\u636eTAG\u663e\u793a\u76f8\u5173\u6587\u7ae0\uff0c\u4e5f\u662f\u5f88\u4e0d\u9519\uff0c\u53ef\u60dc\u6211\u5728\u6839\u636e\u90a3\u8fb9\u6587\u7ae0\u6539DEDE\u4ee3\u7801\u540e\u8001\u662f\u4e0d\u884c\uff0c\u53ef\u80fd\u662f\u80fd\u529b\u6709\u9650\uff0c\u5f53\u7136\u4e5f\u6709\u53ef\u80fd\u662f\u4ee3\u7801\u6709\u95ee\u9898<\/p>\n
\u73b0\u5728\u7ec8\u4e8e\u51fa\u4e86\u89e3\u51b3\u529e\u6cd5\uff1a<\/p>\n
1 \u5728 inc_functions.php \u6700\u540e?>\u524d \u52a0\u4e0a<\/p>\n
\u4ee3\u7801\u5982\u4e0b:<\/p>\n
\/\/\u67e5\u8be2\u6307\u5b9a\u680f\u76ee\u91cc\u5305\u542b\u76f8\u5e94\u5173\u952e\u5b57\u7684\u6587\u7ae0\uff0c\u5e76\u5217\u51fa \n\/\/\u53c2\u6570\u8bf4\u660e\uff1a$showImg \u662f\u5426\u663e\u793a\u7f29\u7565\u56fe\uff0c0\u8868\u793a\u4e0d\u663e\u793a\uff0c1\u8868\u793a\u663e\u793a \n\/\/ $titleLen \u6807\u9898\u957f\u5ea6\uff0c0\u8868\u793a\u65e0\u9650 \n\/\/ $rowCount \u8f93\u51fa\u884c\u6570\uff0c0\u8868\u793a\u65e0\u9650 \n\/\/ $typeid \u680f\u76eeID\uff0c0\u8868\u793a\u6240\u6709\u680f\u76ee \n\/\/ $keyWord \u5173\u952e\u5b57\uff0c\u5b57\u7b26\u4e32 \nfunction ShowKeyWordArc($showImg,$titleLen,$rowCount,$typeid,$keyWord){ \n$dsql = new DedeSql(false); \n$sql = TypeGetSunID($typeid,$dsql);  <p>\/\/\u5173\u952e\u5b57\u5206\u8bcd\u6280\u672f \n$ks = explode(\" \",$keyWord); \nforeach($ks as $k){ \n$k = trim($k); \nif ($k!=\"\") { \n$kwsqlarr[] = \" (xkzzz_archives.title like '%$k%')\"; \n\/\/$kwsqlarr[] = \" (xkzzz_archives.keywords like '%$k%') \"; \/\/\u5982\u679c\u9700\u8981\u76f8\u5173\u5230\u5176\u5b83\u6587\u7ae0\u7684\u5173\u952e\u5b57\uff0c\u89e3\u9664\u6b64\u884c\u6ce8\u91ca \n} \n} \n$where = implode(' OR ',$kwsqlarr); <\/p> <p>$sql=\"Select tp.namerule,tp.typedir,xkzzz_full_search.aid,xkzzz_full_search.url,xkzzz_archives.* From xkzzz_full_search left join xkzzz_archives on xkzzz_full_search.aid=xkzzz_archives.ID left join xkzzz_arctype tp on xkzzz_archives.typeid=tp.ID where {$sql} and ((xkzzz_archives.title like '%\".$keyWord.\"%') or $where) order by xkzzz_full_search.aid desc\"; \n$dsql-&gt;SetQuery($sql); \n$dsql-&gt;Execute(); \n$ss=\"\"; \n$i=0; \nwhile($row=$dsql-&gt;GetObject()){ \n$url=GetFileUrl($row-&gt;ID,$row-&gt;typeid,$row-&gt;senddate,$row-&gt;title,$row-&gt;ismake,$row-&gt;arcrank,$row-&gt;namerule,$row-&gt;typedir,$row-&gt;money); \nif ($showImg==0){ \n$ss=$ss.\"<\/p><\/pre>\n
 \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
  • <\/li>\n
    “;  }else{  $ss=$ss.” <\/p>\n
  •  <\/span><\/span> <\/li>\n
    “;  }  $i++;  if (($rowCount!=0)&&($i>=$rowCount)) return $ss;  }  return $ss;  } <\/p>\n
    2 \u653e\u5728\u6587\u7ae0\u6a21\u677f\u9875\u5185<\/p>\n
    {dede:field name=\u2019keywords\u2019 function=\u2019ShowKeyWordArc(0,32,10,0,\u201d@me\u201d)\u2019\/}<\/pre>\n
     \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
    \u5c31\u8868\u793a\u662f\u53d6\u6240\u6709\u680f\u76ee\u5185\u7684\u76f8\u5173\u6587\u7ae0(\u4e0e\u5f53\u524d\u6587\u7ae0\u7684\u5173\u952e\u5b57\u76f8\u5173)\uff0c\u6807\u9898\u957f\u5ea6\u6700\u592732\uff0c\u6700\u591a\u663e\u793a10\u6761,\u4e0d\u663e\u793a\u7f29\u7565\u56fe<\/p>\n
    \u6216 <\/p>\n
    {dede:field name=\u2019keywords\u2019 function=\u2019ShowKeyWordArc(0,32,10,0,\u201d\u9ad8\u4e09 \u8bed\u6587\u201d)\u2019\/} \n\u53ef\u4ee5\u627e\u5230\u6807\u9898\u91cc\uff0c\u542b\u6709\u201c\u9ad8\u4e09 \u8bed\u6587\u201d\uff0c\u6216\u8005\u542b\u6709\u201c\u9ad8\u4e09\u201d\u6216\u201c\u8bed\u6587\u201d\u7684\u6587\u7ae0<\/pre>\n
     \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
    \u4f8b\u5982\uff0c\u8fd9\u4e00\u6bb5\uff1a<\/p>\n
    \u76f8\u5173\u6587\u7ae0 \n{dede:likeart titlelen=\u201924\u2032 row=\u201910\u2032}\n[field:textlink\/] \n{\/dede:likeart}<\/pre>\n
     \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
    \u5c31\u6539\u6210\uff1a<\/p>\n
    \u76f8\u5173\u6587\u7ae0 \n{dede:field name=\u2019keywords\u2019 function=\u2019ShowKeyWordArc(0,32,10,0,\u201d@me\u201d)\u2019\/}<\/pre>\n
     \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
    \u7533\u660e\uff1a\u8fd9\u4e2a\u51fd\u6570\u4e0d\u662f\u6211\u5199\u7684 <\/p>\n
    \u6839\u636e\u5173\u952e\u5b57\u6765\u76f8\u5173\u6587\u7ae0\uff0c\u5c31\u7528\u6237\u4f53\u9a8c\u4ee5\u53caSEO\u6765\u8bf4\u90fd\u662f\u975e\u5e38\u597d\u7684 <\/p>\n
    \u4f46\u662f\u552f\u4e00\u4e0d\u597d\u7684\u5730\u65b9\u5c31\u662f\u751f\u6210\u9759\u6001\u7684\u65f6\u5019\u4f1a\u6162\u5f88\u591a\uff0c\u54c8\u54c8\uff0c\u670d\u52a1\u5668\u53c8\u8981\u8f9b\u82e6\u4e86<\/p>\n
    \u4ee5\u4e0a\u5c31\u662f\u600e\u4e48\u89e3\u51b3dede:arclist keyword\u7684\u76f8\u5173\u95ee\u9898\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":"
    \u600e\u4e48\u89e3\u51b3{dede:arclist keyword=’\u52a8\u6001\u83b7\u53d6\u5173\u952e\u8bcd’}\uff1f \u89e3\u51b3{dede:arclist keyword=’\u52a8\u6001\u83b7\u53d6\u5173\u952e\u8bcd’} \u63a8\u8350\u5b66\u4e60\uff1a \u6700\u8fd1\u4fee\u6539\u6a21\u7248\uff0c\u4e3a\u4e86\u8ba9\u76f8\u5173\u6587\u7ae0\u7684\u76f8\u5173\u5ea6\u66f4\u9ad8\uff0c\u6253\u7b97\u4f18\u5316\u4e00\u4e0b\uff0c\u4e0d\u8fc7\u4f1a\u589e\u52a0\u751f\u6210\u9875\u9762\u65f6\u95f4\uff0c\u5982\u679c\u4e0d\u7ecf\u5e38\u66f4\u65b0\u5012\u662f\u4e0d\u9519\u7684    \u6700\u8fd1\u5728\u505a\u4e00\u4e2a\u7ad9\uff0c\u60f3\u505a\u4e00\u4e2a\u529f\u80fd\uff0c\u5c31\u662f\u6709\u4e00\u4e2adiv\u5757\u91cc\u663e\u793a\u7684\u662f\u4e0e\u5f53\u524d\u6587\u7ae0\u5173\u952e\u8bcd\u76f8\u540c\u7684\u6587\u7ae0\u7684\u6807\u9898\u3002\u5f00\u59cb\u7684\u65f6\u5019\u662f\u8fd9\u6837\u5199\u7684 {dede:arclist keyword='{dede:field name=’keyword’}’}\u7ed3\u679c\u80af\u5b9a\u662f\u4e0d\u53ef\u4ee5\u7684\u3002\u3002\u3002\u3002\u5728\u7f51\u4e0a\u627e\u4e5f\u6ca1\u627e\u5230\u3002\u4e8e\u662f\u5c31\u81ea\u5df1\u8bfb\u4ee3\u7801\uff0c\u81ea\u5df1\u5199\u4e86\u4e2a\u7b80\u5355\u5904\u7406\u7684\u3002 \u5728arclist.lib.php \u7b2c149\u884c \u4ee3\u7801\u5982\u4e0b: \/\/\u5173\u952e\u5b57\u6761\u4ef6  if($keyword!=”) \u767b\u5f55\u540e\u590d\u5236 \u628a{}\u4e2d\u95f4\u7684\u5185\u5bb9\u6539\u6210  {  $rowGetKeyword = $dsql-&gt;GetOne(“select keywords From `dede_archives` where id=’$arcid'”);  $keyword=$rowGetKeyword[‘keywords’];  $keyword = str_replace(‘,’, ‘|’, $keyword);  $orwheres[] = ” CONCAT(arc.title,arc.keywords) REGEXP ‘$keyword’ “;  } \u767b\u5f55\u540e\u590d\u5236 \u8fd9\u6837\u76f4\u63a5\u8c03\u7528{dede:arclist keyword=’\u8fd9\u91cc\u968f\u4fbf\u5199\u53ea\u8981\u662f\u4e0d\u4e3a\u7a7a\u5c31\u53ef\u4ee5’} \u8fd9\u6837\u8fd9\u91cc\u7684keyword\u5c31\u662f\u52a8\u6001\u83b7\u53d6\u7684\u4e86\u3002\u4e0d\u7136\u53ea\u80fd\u662f\u56fa\u5b9a\u7684\u3002  \u5c31\u5728\u521a\u521a\u6211\u53d1\u5e16\u4e4b\u524d\u770b\u5230dede5.6\u91cc\u6709\u4e2a\u6807\u7b7e  {dede:likeart titlelen=” row=”} {\/dede:likeart} \u767b\u5f55\u540e\u590d\u5236 \u8fd9\u4e2a\u6807\u7b7e\u8fd8\u6ca1\u6d4b\u8bd5\uff0c\u4e0d\u8fc7\u5e94\u8be5\u5c31\u662f\u8fd9\u4e2a\u529f\u80fd\u3002\u5982\u679c\u4e0d\u662f\uff0c\u5927\u5bb6\u5c31\u4e00\u7528\u6211\u4e0a\u9762\u7684\u65b9\u6cd5\u3002\u6d4b\u8bd5\u8fc7\u4e86\uff0c\u53ef\u4ee5\u7528\u3002 DEDECMS\u76f8\u5173\u6587\u7ae0\u4ee5\u5173\u952e\u5b57\u76f8\u5173\u7684\u4fee\u6539\u65b9\u6cd5  DEDE\u7684\u76f8\u5173\u6587\u7ae0\u5b8c\u5168\u4e0d\u76f8\u5173\uff0c\u6709\u670b\u53cb\u5728DEDE\u5b98\u65b9\u653e\u51fa\u6839\u636eTAG\u663e\u793a\u76f8\u5173\u6587\u7ae0\uff0c\u4e5f\u662f\u5f88\u4e0d\u9519\uff0c\u53ef\u60dc\u6211\u5728\u6839\u636e\u90a3\u8fb9\u6587\u7ae0\u6539DEDE\u4ee3\u7801\u540e\u8001\u662f\u4e0d\u884c\uff0c\u53ef\u80fd\u662f\u80fd\u529b\u6709\u9650\uff0c\u5f53\u7136\u4e5f\u6709\u53ef\u80fd\u662f\u4ee3\u7801\u6709\u95ee\u9898 \u73b0\u5728\u7ec8\u4e8e\u51fa\u4e86\u89e3\u51b3\u529e\u6cd5\uff1a 1 \u5728 inc_functions.php \u6700\u540e?>\u524d \u52a0\u4e0a \u4ee3\u7801\u5982\u4e0b: \/\/\u67e5\u8be2\u6307\u5b9a\u680f\u76ee\u91cc\u5305\u542b\u76f8\u5e94\u5173\u952e\u5b57\u7684\u6587\u7ae0\uff0c\u5e76\u5217\u51fa  \/\/\u53c2\u6570\u8bf4\u660e\uff1a$showImg \u662f\u5426\u663e\u793a\u7f29\u7565\u56fe\uff0c0\u8868\u793a\u4e0d\u663e\u793a\uff0c1\u8868\u793a\u663e\u793a  \/\/ $titleLen \u6807\u9898\u957f\u5ea6\uff0c0\u8868\u793a\u65e0\u9650  \/\/ $rowCount \u8f93\u51fa\u884c\u6570\uff0c0\u8868\u793a\u65e0\u9650  \/\/ $typeid \u680f\u76eeID\uff0c0\u8868\u793a\u6240\u6709\u680f\u76ee  \/\/ $keyWord \u5173\u952e\u5b57\uff0c\u5b57\u7b26\u4e32  function ShowKeyWordArc($showImg,$titleLen,$rowCount,$typeid,$keyWord){  $dsql = new DedeSql(false);  $sql = TypeGetSunID($typeid,$dsql);  <p>\/\/\u5173\u952e\u5b57\u5206\u8bcd\u6280\u672f  $ks = explode(” “,$keyWord);  foreach($ks as $k){  $k = trim($k);  if ($k!=””) {  […]<\/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-28889","post","type-post","status-publish","format-standard","hentry","category-cms"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/28889","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=28889"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/28889\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=28889"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=28889"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=28889"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}