본문 바로가기

Web Progreming

페이지 리스트

<?
$page_post=10; // 페이지당 게시물 표시 갯수
$page_block=10; // 최대 페이지 리스트 갯수

if( !$_GET[page] ) {
$page = 1;
}else{
$page = $_GET[page];
}

$book_sql="SELECT * FROM `".$DB."`.`profile_book` WHERE 1";
$book_count=mysql_query($book_sql);
$total_post=mysql_num_rows($book_count);

$total_page=ceil($total_post/$page_post);

// $s_page_num=(ceil($page/$total_page)-1)*$page_count+1; // 페이지 시작 찾기
// $e_page_num=$s_page_num+$total_page-1; // 페이지 마지막 찾기

$s_page_num=(ceil($page/$page_block)-1)*$page_block+1; // 페이지 시작 찾기
$e_page_num=$s_page_num+$page_block-1; // 페이지 마지막 찾기
if($total_page<$e_page_num) $e_page_num=$total_page;

$start=($page-1)*$page_post;

$book_sql.=" ORDER BY `idx` DESC";
$book_sql.=" LIMIT ".$start.",".$page_post." ";
$book_result=mysql_query($book_sql);
while( $book=mysql_fetch_array($book_result) ){
?>




<?
// echo $s_page_num."<br>";
// echo $e_page_num."<br>";

if( "1" != $s_page_num ){
$prev_page_block_link="_profile.html?type=thss&page=".($s_page_num-$page_block);
echo "<img src='images/prev.gif' onclick='location.href(\"$prev_page_block_link\");'>&nbsp;&nbsp;";
}

for( $i=$s_page_num; $i<=$e_page_num;$i++){
if( $i == $page ) {
echo "&nbsp;<font color='#FF0000'>".$i."</font>&nbsp;";
}else{
echo "&nbsp;<a href='#' onclick='location.href(\"_profile.html?type=thss&page=".$i."\");'><b>".$i."</b></a>&nbsp;";
}
}

if( $total_page > $e_page_num ){
$next_page_block_link="_profile.html?type=thss&page=".($e_page_num+1);
echo "&nbsp;&nbsp;<img src='images/next.gif' onclick='location.href(\"$next_page_block_link\");'>";
}
echo "<br>";
?>