用法:后台增加自定义页面添加下面PHP代码 $sql=$empire->query('select title,id from {$dbtbpre}ecms_news where id>0'); while ($row=$empire->fetch($sql)) { $tou=mb_substr($row...
$sqlb=$empire->query('select * from {$dbtbpre}ecms_zaoju where feilei<>'英语造句''); while($r=$empire->fetch($sqlb)){ $input=$r['title']; $input=str_replace(',','',$inp...
$str='春,夏,秋,冬'; $czpstr=explode(',',$str); foreach($czpstr as $key=>$value){ $rr=$empire->fetch1('select * from {$dbtbpre}ecms_news where title='{$value}''); if($rr[id]){...
$sql=$empire->query('select id,filename from phome_ecms_cidian where classid=1 group by filename having(count(*))>1'); //词典表栏目1的数据去重 while($r=$empire->fetch($sql...
$sql=$empire->query('select id,filename from phome_ecms_news where classid=1 group by filename having(count(*))>2'); while($r=$empire->fetch($sql)){ echo $r[id].'<br /&...