帝國cms靈動標簽模糊查詢關鍵字詞應該怎么寫調用?
帝國cms模糊查詢用靈動標簽應該怎么寫,標題包含關鍵字詞或者關鍵字詞相同,模糊匹配或者精準匹配,模板網整理了關于帝國cms靈動標簽查詢關鍵字詞的調用方法,供大家參考。
標題包含關鍵字
①、比較粗糙的匹配,可能不太精確:title like '%$navinfor[keyboard]%'
②、精確的匹配,比較消耗資源:title regexp '(^|,)$navinfor[keyboard]($|,)'
關鍵字相同
①、比較粗糙的匹配,可能不太精確:keyboard like '%$navinfor[keyboard]%'
②、精確的匹配,比較消耗資源:keyboard regexp '(^|,)$navinfor[keyboard]($|,)'
格式1
①、模糊匹配
②、精確的匹配
- [e:loop={"select * from phome_ecms_news where title like '%$navinfor[keyboard]%' or keyboard like '%$navinfor[keyboard]%' order by id desc limit 10",0,24,0}]
- <a href="<?=$bqsr['titleurl']?>" target="_blank"><?=$bqr['title']?></a> <br>
- [/e:loop]
- [e:loop={"select * from phome_ecms_news where title regexp '(^|,)$navinfor[keyboard]($|,)' or keyboard regexp '(^|,)$navinfor[keyboard]($|,)' order by id desc limit 10",0,24,0}]
- <a href="<?=$bqsr['titleurl']?>" target="_blank"><?=$bqr['title']?></a> <br>
- [/e:loop]
格式2
①、模糊匹配
②、精確的匹配
- [e:loop={'news',10,3,0,"keyboard like '%$navinfor[keyboard]%' or title like '%$navinfor[keyboard]%'",''}]
- <li>·<a href="<?=$bqsr['titleurl']?>" target="_blank"><?=esub($bqr[title],24)?></a></li>
- [/e:loop]
其他關于模糊查詢的方法:萬能標簽《帝國cms在列表頁模板用萬能標簽模糊匹配關鍵字詞?》
- [e:loop={0,10,3,0,"keyboard like '%$navinfor[keyboard]%' or title like '%$navinfor[keyboard]%'",''}]
- <a href="<?=$bqsr['titleurl']?>" target="_blank"><?=$bqr['title']?></a> <br>
- [/e:loop]
點個贊! ()