聯(lián)系官方銷售客服
1835022288
028-61286886
投訴
解決中 / 官方已回 tag關(guān)聯(lián)其他字段調(diào)用顯示
5 0
| 插件名稱 | 關(guān)鍵詞TAG V3.28 |
| 插件作者 | 迅睿官方團(tuán)隊 |
| 最近更新 | 2025-04-09 11:48:24 |
| [高級版]增加補(bǔ)錄索引生成按鈕 [高級版]針對建站系統(tǒng)高級版進(jìn)行查詢優(yōu)化 |
標(biāo)簽解析：{related module=all field=id,title,url,keywords,tag1 tag=tag測試 page=1 pagesize=10 urlrule=/index.php?s=tag&name=tagceshi&page=[page]}
查詢解析: SELECT count(*) as c FROM (SELECT id,title,url,keywords,tag1,'news' AS mid FROM `dr_1_news`) as my WHERE ((`title` LIKE "%tag測試%" OR `keywords` LIKE "%tag測試%")) ORDER BY NULL
當(dāng)前路由：tag/home/index
動態(tài)地址：index.php?s=tag&name=tagceshi
沒有查詢到內(nèi)容
變量前綴：t
總記錄數(shù)：0
分頁功能：未開啟怎么把
WHERE ((`title` LIKE "%tag測試%" OR `keywords` LIKE "%tag測試%"))
改成
WHERE ((`title` LIKE "%tag測試%" OR `tag1` LIKE "%tag測試%"))
回復(fù)@開源社區(qū)插件技術(shù)-阿飛 麻煩問下sql標(biāo)簽怎么改
{related module=all field=id,title,url,keywords,tag1 tag=$tag.tags page=1 pagesize=10 urlrule=$urlrule}
<li><span class="badge badge-empty badge-success"></span> <a href="{$t.url}" class="title">{dr_strcut($t.title, 35)}</a></li>
{/related}
{php $ss=urlencode('SELECT count(*) as c FROM (SELECT id,title,url,keywords,tag1,\'news\' AS mid FROM `dr_1_news`) as my WHERE ((`title` LIKE "%tag測試%" OR `tag1` LIKE "%tag測試%")) ORDER BY NULL');} {sql sql='$ss'} {/sql} {$debug}回復(fù)@開源社區(qū)插件技術(shù)-阿飛 麻煩在問下怎么把 <li><a href="{$t.url}" class="title">{$t.title}</a></li> 調(diào)用顯示出來
{php $ss=urlencode('SELECT count(*) as c FROM (SELECT id,title,url,keywords,tag1,\'news\' AS mid FROM `dr_1_news`) as my WHERE ((`title` LIKE "%tag測試%" OR `tag1` LIKE "%tag測試%")) ORDER BY NULL');} {sql sql='$ss'} <li><a href="{$t.url}" class="title">{$t.title}</a></li> {/sql} <li><a href="{$t.url}" class="title">{$t.title}</a></li> 顯示不出數(shù)據(jù) {$debug}顯示已經(jīng)有數(shù)據(jù)