ceil($total_pages – $range/2)) {
$start = $total_pages – $curpage + (ceil($curpage – ($range – 1)));
} else {
$start = ceil($curpage – ($range-1)/2)>1 ? ceil($curpage – ($range-1)/2) : 1;
}
if ($total_pages > $range)
$end = $start + $range – 1;
else
$end = $total_pages;

$pages = range($start, $end ? $end : 1);

$next = $curpage + 1;
$prev = $curpage – 1;
$first_group = 1;
$last_group = $start + $range;

$prev = $prev >= 1 ? $prev : null;
$next = $next <= $total_pages ? $next : null; $first_group = ceil($curpage - ($range - 1)/2) > 1 ? $first_group : null;
$last_group = $last_group <= $total_pages ? $last_group : null; return array( 'total_pages' => $total_pages,
‘curpage’ => $curpage,
‘pages’ => $pages,
‘prev’ => $prev,
‘next’ => $next,
‘first_group’ => $first_group,
‘last_group’ => $last_group,
‘offset’ => $offset,
‘limit’ => $perpage,
);
}
}
//プライスの配列
$price_array = array(‘open’=>”Open Price”,’1000’=>’～1,000円’,’2000’=>’～2,000円’,’3000’=>’～3,000円’,’4000’=>’～4,000円’,’5000’=>’～5,000円’,’10000’=>’～10,000円’,’over’=>’10,000円以上’);
//値の取得
if(empty($_REQUEST[‘price’])){
$price = ”;
}else{
$price = $_REQUEST[‘price’];
}
if($_REQUEST[‘c_flg’]==1 or empty($_REQUEST[‘c_flg’])){
$c_flg = “1”;
$c_class_1 = ‘ class=”on”‘;
$c_class_2 = ”;
}else{
$c_flg = $_REQUEST[‘c_flg’];
$c_class_1 = ”;
$c_class_2 = ‘ class=”on”‘;
}
if(empty($_REQUEST[‘pa’])){
$get_page = 1;
}else{
$get_page = $_REQUEST[‘pa’];
}

//価格設定の情報取得
function ProductInfoPriceGet($price,$c_flg,$get_page){
// 表示件数
$size = 20;
if($get_page==1 or empty($get_page)){
$p_page = $size*0;
}else{
$p_page = ($get_page-1)*$size;
}
//over対策
if(!empty($price)){
if($price==’over’){
$where = ” WHERE genre_list.exhibition_flg=’0′ AND product_info.tax_price BETWEEN 10001 AND 100000 “;
}elseif($price==’open’){
$where = ” WHERE genre_list.exhibition_flg=’0′ AND product_info.tax_price=’0′”;
}elseif($price==’10000′){
$s_price = $price-4999;
$where = ” WHERE genre_list.exhibition_flg=’0′ AND product_info.tax_price BETWEEN “.$s_price.” AND “.$price.” “;
}else{
$s_price = $price-999;
$where = ” WHERE genre_list.exhibition_flg=’0′ AND product_info.tax_price BETWEEN “.$s_price.” AND “.$price.” “;
}
}else{
$where = ” WHERE genre_list.exhibition_flg=’0′ “;
}
if($c_flg==1 or empty($c_flg)){
$order = ” ORDER BY genre_list.sale_date DESC”;
}else{
$order = ” ORDER BY CAST(product_info.unit_price AS SIGNED) DESC”;
}

$sql = “SELECT * FROM product_info INNER JOIN genre_list ON product_info.id=genre_list.id”.$where.$order.” LIMIT “.$p_page.”,”.$size;

$result = mysql_query($sql);
$data = array();
while($row = mysql_fetch_array($result)){
$data[] = $row;
}
return $data;
}
//価格のトータルカウントの取得
function ProductInfoPriceCntGet($price){
//over対策
if(!empty($price)){
if($price==’over’){
$where = ” WHERE genre_list.exhibition_flg=’0′ AND product_info.tax_price BETWEEN 10001 AND 100000 “;
}elseif($price==’open’){
$where = ” WHERE genre_list.exhibition_flg=’0′ AND product_info.tax_price=’0′”;
}elseif($price==’10000′){
$s_price = $price-4999;
$where = ” WHERE genre_list.exhibition_flg=’0′ AND product_info.tax_price BETWEEN “.$s_price.” AND “.$price.” “;
}else{
$s_price = $price-999;
$where = ” WHERE genre_list.exhibition_flg=’0′ AND product_info.tax_price BETWEEN “.$s_price.” AND “.$price.” “;
}
}else{
$where = ” WHERE genre_list.exhibition_flg=’0′ “;
}
$sql = “SELECT COUNT(*) AS cnt FROM product_info INNER JOIN genre_list ON product_info.id=genre_list.id”.$where;
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
return $row[‘cnt’];
}

//ここで一覧取得
$price_data = ProductInfoPriceGet($price,$c_flg,$get_page);
$price_cnt = ProductInfoPriceCntGet($price);
//ページャー作成
$params[‘total’] = $price_cnt; //全件数（DBからselectするが、ここでは仮に代入）
if ($get_page) {
$params[‘curpage’] = $get_page;
} else {
$params[‘curpage’] = 1;
}
$params[‘perpage’] = 20; //1ページの表示件数
$params[‘range’] = 3; //1ページの表示ブロック数
/////////////////
// ページャー //
/////////////////
$pager = Pager::getPager($params[‘total’], $params[‘curpage’], $params[‘perpage’], $params[‘range’]);
//ページカウント
if(!empty($price_data)){
if($get_page==1){
$p_p = 1;
$p_n = 20;
}else{
$p_p = (20*$get_page)-20;
$p_n = (20*$get_page);
}
}else{
$price_cnt = 0;
$p_p = 0;
$p_n = 0;
}

/**********************/
/* ＵＲＬの生成を行う */
/**********************/
if(empty($price)){
$url_new = “./”;
$url_ka = “./?c_flg=2″;
}else{
$url_new = “./?price=”.$price;
$url_ka = “./?price=”.$price.”&c_flg=2″;
}

?>

>

/js/html5.js" type="text/javascript">

>