include "../include/_prepend.php";
cacheControl(0);
$db = getConnection();
if(!$page) { $page = 1; }
#°Ô½Ã¹° ÃÑ °³¼ö
$query = "SELECT COUNT(idx) AS cnt FROM prize";
$rs = @mysql_query($query, $db);
if(!$rs) {
jserror('ÀڷḦ ÀÐÀ» ¼ö ¾ø½À´Ï´Ù.'. mysql_error());
}
$result = mysql_fetch_array($rs);
$total_record = $result[cnt];
if($total_record==0) {
// jserror('°Ë»öµÈ °á°ú°¡ ¾ø½À´Ï´Ù.','location.replace("board_list.php?page=1")');
}
########## ÇöÀçÀÇ ÆäÀÌÁö¿¡¼ Ãâ·ÂÇÒ °Ô½Ã¹°ÀÇ ¹üÀ§¸¦ °áÁ¤ÇÑ´Ù. ##########
$num_per_page = 1000;
$end_limit=$num_per_page * $page;
$start_limit=$end_limit - $num_per_page;
########## ÇöÀçÆäÀÌÁöÀÇ ¹üÀ§³»¿¡ Ãâ·ÂÇÒ °á°ú·¹Äڵ弼Ʈ¸¦ ¾ò´Â´Ù. ##########
$query = "SELECT * FROM prize order by idx asc";
$result = mysql_query($query);
if (!$result) {
echo mysql_error($db) . '
';
exit;
}
if(!$total_record) {
$first = 1;
$last = 0;
} else {
$first = $num_per_page*($page-1);
$last = $num_per_page*$page;
$IsNext = $total_record - $last;
if($IsNext > 0) {
$last -= 1;
} else {
$last = $total_record - 1;
}
}
########## Àüü ÆäÀÌÁö¼ö ##########
$total_page = ceil($total_record/$num_per_page);
########## °Ô½Ã¹° ¸ñ·Ï ÇÏ´ÜÀÇ °¢ ÆäÀÌÁö·Î Á÷Á¢ À̵¿ÇÒ ¼ö ÀÖ´Â ÆäÀÌÁö¸µÅ©¿¡ ´ëÇÑ ¼³Á¤ ##########
$page_per_block = 10; # ÇÏ´Ü¿¡ ³ª¿Ã ÆäÀÌÁö °³¼ö
$total_block = ceil($total_page/$page_per_block);
$block = ceil($page/$page_per_block);
$first_page = ($block-1)*$page_per_block;
$last_page = $block*$page_per_block;
if($total_block <= $block) {
$last_page = $total_page;
}
?>
include "introduceleft.php"; ?>
|