{php} $size = 10; $page = isset($_REQUEST['page']) ? intval($_REQUEST['page']) : 1; if(!empty($_GET['classid'])){ $where = " AND ClassID = '".$_GET['classid']."' "; $classidsql = "&classid=".$_GET['classid'] ; } if($GLOBALS['lang'] == 'zh'){ $sql = "SELECT COUNT(*) FROM ".$GLOBALS['eces']->table('firm_products')." WHERE FirmID = '". $GLOBALS['FrimID']."' $where "; }elseif($GLOBALS['lang'] == 'tw'){ $sql = "SELECT COUNT(*) FROM ".$GLOBALS['eces']->table('firm_products_tw')." WHERE FirmID = '". $GLOBALS['FrimID']."' $where "; }else{ $sql = "SELECT COUNT(*) FROM ".$GLOBALS['eces']->table('firm_products_en')." WHERE FirmID = '". $GLOBALS['FrimID']."' $where "; } $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 .="".$i.""; } $pagesstr = ""; if($GLOBALS['lang'] == 'zh'){ $sql = "SELECT * FROM ".$GLOBALS['eces']->table('firm_products')." WHERE FirmID = '". $GLOBALS['FrimID']."' $where "; }elseif($GLOBALS['lang'] == 'tw'){ $sql = "SELECT * FROM ".$GLOBALS['eces']->table('firm_products_tw')." WHERE FirmID = '". $GLOBALS['FrimID']."' $where "; }else{ $sql = "SELECT * FROM ".$GLOBALS['eces']->table('firm_products_en')." WHERE FirmID = '". $GLOBALS['FrimID']."' $where "; } $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 .= ' '; } echo $contenet; {/php}