include "../include/_prepend.php";
cacheControl(0);
$db = getConnection("chem","localhost","chem", "ilovechem");
if(!$page) { $page = 1; }
########## ÇöÀç ³âµµ,Çб⠰è»ê
$now_course_year = date("Y",mktime());
$month=date("n",mktime());
if($month>=3 && $month<=8) $now_session_no=1;
else $now_session_no=2;
if ($course_year=="") $course_year=$now_course_year;
if ($session_no<1 || $session_no>2 || $session_no=="") $session_no=$now_session_no;
##########
if ($division<=0 || $division>5) {
$division = 1;
}
$query = "SELECT COUNT(idx) AS cnt FROM course WHERE course_year=$course_year AND session like '%$session_no%' AND division like '%$division%'";
$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 course WHERE course_year=$course_year AND session like '%$session_no%' AND division like '%$division%'";
//echo $query;
$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 "collegeleft.php"; ?>
|