-
{php}
$size = 8;
$page = isset($_REQUEST['page']) ? intval($_REQUEST['page']) : 1;
$sql = "SELECT COUNT(*) FROM ".$GLOBALS['eces']->table('firm_products')." WHERE FirmID = '". $GLOBALS['FrimID']."' ";
$record_count = $GLOBALS['dbes']->getOne($sql);
$start = ($page-1)*$size;
$pages = ceil($record_count/$size);
$pageq = $page-1;
$pagel = $page+1;
if($pageq<1){
$pageq=1;
}
if($pagel>$pages){
$pagel=$pages;
}
$limit = "LIMIT $start,$size ";
for($i=1;$i<=$pages;$i++){
if($i==$page){$selected="selected";}else{$selected="";}
$option .="";
}
$pagesstr = "";
$sql = "SELECT * FROM ".$GLOBALS['eces']->table('firm_products')." WHERE FirmID = '". $GLOBALS['FrimID']."' ";
$sql .= "ORDER BY `addTime` DESC ".$limit ;
$RS = $GLOBALS['dbes']->getAll($sql);
foreach($RS AS $v){
if(!empty($v[PicPath])){
$picimg = $v[PicPath] ;
}else{
$picimg = $GLOBALS['tpl']['img']."imgjs/erreso.gif";
}
$contenet .= '
-
'.$v[Name].'';
}
echo $contenet;
{/php}
旭森网络科技 技术支持