include "../include/_prepend.php";
if (!$user_id) {
httpRedirect("/chem/member/login_form.php?goto=".$REQUEST_URI);
exit();
}
cacheControl(0);
$db = getConnection();
if(!$page) { $page = 1; }
#°Ô½Ã¹° ÃÑ °³¼ö
if ($stu_no<>"") {
$where = " WHERE stu_no=$stu_no ";
} else {
$where = "";
}
$query = "SELECT COUNT(idx) AS cnt FROM address " . $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 = 1000;
$end_limit=$num_per_page * $page;
$start_limit=$end_limit - $num_per_page;
########## ÇöÀçÆäÀÌÁöÀÇ ¹üÀ§³»¿¡ Ãâ·ÂÇÒ °á°ú·¹Äڵ弼Ʈ¸¦ ¾ò´Â´Ù. ##########
$query = "SELECT * FROM address " . $where . " order by stu_no asc, binary(name) 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 "collegeleft.php"; ?>
|
|
|
|
|
|
|
|
|
|
|
|
$num = 0;
######### Å×ÀÌºí³» ¸ðµç ·¹ÄÚµåÀÇ °¢ Çʵ尪À» °¢°¢ÀÇ º¯¼ö¿¡ ÀúÀåÇÏ¿© Ãâ·ÂÇÑ´Ù. ##########
for($i = 0; $i < $num_per_page; $i++) {
if($first > $last) break;
$idx = mysql_result($result,$i,0);
$stu_no = mysql_result($result,$i,1);
$name = mysql_result($result,$i,2);
$email = mysql_result($result,$i,3);
?>
|
¡® |
|
|
|
|
|
¼öÁ¤»èÁ¦ |
}?>
|
if($first >= $last) {
break;
} else {
$first++;
}
}
?>
µî·Ï} else {?>login join}?> |
|
include "collegeright.php"; ?>