fetch1("select tbname from {$dbtbpre}enewstable where tbname='$tbname' limit 1");
if(!$tbr['tbname'])
{
exit();
}
$changeinfonum=0;
if($changeinfoid)
{
$changeinfonumr=explode(',',$changeinfoid);
$changeinfonum=count($changeinfonumr);
}
$search="&enews=$enews&changeinfoid=$changeinfoid&keyboard=$keyboard&show=$show&sear=$sear&tbname=$tbname&classid=$classid".$ecms_hashur['ehref'];
$add='';
$and=' where ';
//分页
$page=(int)$_POST['page'];
$page=RepPIntvar($page);
$start=0;
$line=30;//每页显示条数
$page_line=6;//每页显示链接数
$offset=$page*$line;//总偏移量
//栏目
if($classid)
{
if($class_r[$classid][islast])
{
$add.=$and."classid='$classid'";
}
else
{
$add.=$and."(".ReturnClass($class_r[$classid][sonclass]).")";
}
$and=' and ';
}
//搜索
if($keyboard)
{
$kbr=explode(' ',$keyboard);
$kbcount=count($kbr);
$kbor='';
$kbwhere='';
for($kbi=0;$kbi<$kbcount;$kbi++)
{
if(!$kbr[$kbi])
{
continue;
}
if($show==1)
{
$kbwhere.=$kbor."title like '%".$kbr[$kbi]."%'";
}
elseif($show==2)
{
$kbwhere.=$kbor."keyboard like '%".$kbr[$kbi]."%'";
}
else
{
$kbwhere.=$kbor."id='".$kbr[$kbi]."'";
}
$kbor=' or ';
}
if($kbwhere)
{
$add.=$and.'('.$kbwhere.')';
}
}
$query="select isurl,titleurl,classid,id,newstime,username,userid,title from {$dbtbpre}ecms_".$tbr['tbname'].$add;
$totalquery="select count(*) as total from {$dbtbpre}ecms_".$tbr['tbname'].$add;
$totalnum=(int)$_POST['totalnum'];
if($totalnum<1)
{
$num=$empire->gettotal($totalquery);//取得总条数
}
else
{
$num=$totalnum;
}
$query=$query." order by newstime desc limit $offset,$line";
$sql=$empire->query($query);
$returnpage=postpage($num,$line,$page_line,$start,$page,"document.changeinfoform");
?>
选择信息