=3 && $month<=8) $now_session_no=1; else $now_session_no=2; if ($course_year=="") $course_year=$now_course_year; if ($sessions<1 || $sessions>2 || $sessions=="") $sessions=$now_session_no; ########## $division = 6; $query = "SELECT COUNT(idx) AS cnt FROM course WHERE course_year=$course_year AND session=$sessions AND division=$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=$sessions AND division=$division"; $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; } ?>
³âµµ
$last) break; $idx = mysql_result($result,$i,0); $course_year = mysql_result($result,$i,1); $sessions = mysql_result($result,$i,2); $division = mysql_result($result,$i,3); $course_name = mysql_result($result,$i,4); $class = mysql_result($result,$i,5); $class_no = mysql_result($result,$i,6); $subject = mysql_result($result,$i,7); $teacher = mysql_result($result,$i,8); $content = mysql_result($result,$i,9); $regdate = mysql_result($result,$i,10); ?> ""){?> = $last) { break; } else { $first++; } } ?>
°³¿ä :
¼öÁ¤ »èÁ¦
µî·Ï "") {?> logout   modify login   join