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,
);
}
}
//肌タイプの配列を作成
$skin_care_array = array(‘1’=>”乾燥肌”,’2’=>”普通肌”,’3’=>”混合肌”,’4’=>”脂性肌”,’5’=>”敏感肌”);
//値の取得
if(empty($_REQUEST[‘type’])){
$type = ”;
}else{
$type = $_REQUEST[‘type’];
}
if($_REQUEST[‘c_flg’]==1 or empty($_REQUEST[‘c_flg’])){
$c_flg = “”;
$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 ProductInfoSkinGet($type,$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;
}
//肌TYPEが無い場合
if(empty($type)){
$where = ” WHERE genre_list.exhibition_flg=’0′”;
$join = “”;
}else{
$where = ” WHERE genre_list.exhibition_flg=’0′ AND skin_care.care_type='”.$type.”‘”;
$join = ” INNER JOIN skin_care ON product_info.id=skin_care.id”;
}
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”.$join.” LEFT 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 ProductInfoSkinCntGet($type){
//肌TYPEが無い場合
if(empty($type)){
$where = ” WHERE genre_list.exhibition_flg=’0′”;
$join = “”;
}else{
$where = ” WHERE genre_list.exhibition_flg=’0′ AND skin_care.care_type='”.$type.”‘”;
$join = ” INNER JOIN skin_care ON product_info.id=skin_care.id”;
}
$sql = “SELECT COUNT(*) AS cnt FROM product_info”.$join.” LEFT JOIN genre_list ON product_info.id=genre_list.id”.$where;
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
return $row[‘cnt’];
}
//ここで一覧取得
$skin_data = ProductInfoSkinGet($type,$c_flg,$get_page);
$skin_cnt = ProductInfoSkinCntGet($type);
//ページャー作成
$params[‘total’] = $skin_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($skin_data)){
if($get_page==1){
$s_p = 1;
$s_n = 20;
}else{
$s_p = (20*$get_page)-20;
$s_n = (20*$get_page);
}
}else{
$skin_cnt = 0;
$s_p = 0;
$s_n = 0;
}
?>
>
<< 前に戻る | << 前に戻る | << 前に戻る | << 前に戻る | =$skin_cnt;?> 件中/ =$s_p;?> 件~ =$s_n;?> 件 |
次に進む >> | 次に進む >> | 次に進む >> | 次に進む >> | 次に進む >> | 次に進む >> | 次に進む >> | 次に進む >> | 次に進む>> |
$skinvalue){
$ex_sale_time = explode(“-“,$skinvalue[‘sale_date’]);
?>
=$skinvalue['catch_copy'];?>
‘); ‘); ‘); ‘); ‘); =ceil($s_cnt)){ ‘); ‘); ‘); ‘); ‘); ‘); ‘); ‘); ‘);
<< 前に戻る
}else{
print(‘
<< 前に戻る
}
}else{
if(empty($c_flg)){
print(‘
<< 前に戻る
}else{
print(‘
<< 前に戻る
}
}
}else{
print(‘
<< 前に戻る
} echo “\n”; ?>=$skin_cnt;?>
件中/
=$s_p;?>
件~
=$s_n;?>
件
if(empty($type)){
if(empty($c_flg)){
print(‘
次に進む >>
}else{
print(‘
次に進む >>
}
}else{
if(empty($c_flg)){
print(‘
次に進む >>
}else{
print(‘
次に進む >>
}
}
}else{
if(empty($type)){
if(empty($c_flg)){
print(‘
次に進む >>
}else{
print(‘
次に進む >>
}
}else{
if(empty($c_flg)){
print(‘
次に進む >>
}else{
print(‘
次に進む >>
}
}
}
}else{
print(‘
次に進む>>
} echo “\n”; ?>