¼Ò¸ðÀÓÀ» ¼±ÅÃÇÏ¿© Áֽñ⠹ٶø´Ï´Ù. |
¼Ò¸ðÀÓ¸í |
¼Ò¸ðÀÓ¼³¸í |
µî·ÏÀÏ |
ºñ°í |
$num_per_page = 10;
$page_per_block = 10;
if(!$page) {
$page = 1;
}
$query = "SELECT count(cid) FROM club_cat";
$result = mysql_query($query,$dbconn);
if (!$result) {
exit;
}
$total_record = mysql_result($result,0,0);
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);
$club_res = mysql_query("select * from club_cat order by signdate desc", $dbconn);
$club_count = mysql_num_rows($club_res);
if($club_count < 1) {
?>
µî·ÏµÇ¾î ÀÖ´Â ¼Ò¸ðÀÓÀÌ ¾ø½À´Ï´Ù. |
} else {
while($club_row = mysql_fetch_array($club_res)) {
$security = $club_row[security];
$clubcode = $club_row[clubcode];
$clubpds = $club_row[clubpds];
$clubname = cut_string($club_row[clubname],17);
$comment = cut_string($club_row[comment],44);
$signdate = date("Y/m/d", $club_row[signdate]);
$add_image = " ";
if($clubpds == "Y") {
$add_image = " ";
}
$clubmem_res = mysql_query("select count(*) from club_mem where clubcode='$clubcode' and mid='$vsclub_id'", $dbconn);
$clubmem_ing = mysql_result($clubmem_res,0,0);
?>
$clubname");?> |
$comment");?> |
|
if($clubmem_ing == 0) {
if($vsclub_id == "") {
echo("¡Ø");
} else {
echo("½Åû");
}
} else {
echo("Å»Åð");
}
?>
|
}
?>
¼Ò¸ðÀÓ °³¼³½Åû |
$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;
}
if($block > 1) {
$my_page = $first_page;
echo("[ÀÌÀü ${page_per_block}°³]");
}
for($direct_page = $first_page+1; $direct_page <= $last_page; $direct_page++) {
if($page == $direct_page) {
echo("[$direct_page]");
} else {
echo("[$direct_page]");
}
}
if($block < $total_block) {
$my_page = $last_page+1;
echo("[´ÙÀ½ ${page_per_block}°³]");
}
?>
|
}
?>
|
|
|