"") { $where = " AND stu_no=$stu_no "; } else { $where = ""; } $query = "SELECT COUNT(idx) AS cnt FROM research " . $where; $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 = 10; $end_limit=$num_per_page * $page; $start_limit=$end_limit - $num_per_page; ########## ÇöÀçÆäÀÌÁöÀÇ ¹üÀ§³»¿¡ Ãâ·ÂÇÒ °á°ú·¹Äڵ弼Ʈ¸¦ ¾ò´Â´Ù. ########## $query = "SELECT * FROM research " . $where . " order by regdate DESC LIMIT ".$start_limit.",".$end_limit; $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); $jurnel = mysql_result($result,$i,1); $ryear = mysql_result($result,$i,2); $vol = mysql_result($result,$i,3); $page = mysql_result($result,$i,4); $subject = mysql_result($result,$i,5); $writer = mysql_result($result,$i,6); $files = mysql_result($result,$i,7); $link = mysql_result($result,$i,8); // $regdate = mysql_result($result,$i,9); $abstract = mysql_result($result,$i,10); $e_subject = mysql_result($result,$i,13); ?> = $last) { break; } else { $first++; } } ?>
"") { ?> ¼öÁ¤ »èÁ¦ , , ,
- "") {?>
-
1) { $my_page = $first_page; ?>
login  join