帝國cms靈動標簽調用多表多模型調用文章的方法

2024-08-28 12:17:52

字體：大中小

來源：轉載

供稿：網友

調用多模型的最新文章

[e:loop={'select * from (?select id,classid,titleurl,filename,title,newstime,titlepic from [!db.pre!]ecms_movie where newstime union?select id,classid,titleurl,filename,title,newstime,titlepic from [!db.pre!]ecms_news where newstime union?select id,classid,titleurl,filename,title,newstime,titlepic from [!db.pre!]ecms_photo where newstime union?select id,classid,titleurl,filename,title,newstime,titlepic from [!db.pre!]ecms_flash where newstime union?select id,classid,titleurl,filename,title,newstime,titlepic from [!db.pre!]ecms_article where newstime) a order by newstime desc limit 10',10,24,1}]?" target="_blank"><?=$bqr['title']?> 
[/e:loop]

帝國cms多表調用最新信息,該演示代碼為默認數據表下全站最新10條圖片信息,自己根據需求可以附加條件,實現全站點擊,全站頭條,全站推薦等等.
注釋：以上多個模型用“Union”連接調用
若只調用圖片：要加ispic=1條件
舉例：

[e:loop={'select * from (select id,classid,titleurl,filename,title,newstime,titlepic from [!db.pre!]ecms_news where newstime and ispic=1 unionselect id,classid,titleurl,filename,title,newstime,titlepic from [!db.pre!]ecms_photo where newstime and ispic=1 unionselect id,classid,titleurl,filename,title,newstime,titlepic from [!db.pre!]ecms_flash where newstime and ispic=1 unionselect id,classid,titleurl,filename,title,newstime,titlepic from [!db.pre!]ecms_article where newstime and ispic=1) a order by newstime desc limit 10',10,24,1}]" target="_blank"><?=$bqr['title']?> 
[/e:loop]?