#######################################
# ¿À´ÃÀÇ ¸í¾ð #
# ¸¸µçÀÌ : Á¶¿µ±æ(cyk2@giristory.net) #
# ¸¸µç³¯ : 2003³â 11¿ù 7ÀÏ(±Ý) #
# ¸¶Áö¸·¼öÁ¤ÀÏ : 2003³â 11¿ù 7ÀÏ(±Ý) #
#######################################
?>
±æÀÌ À̾߱â
include "./db_connect.php";
$connect=mysql_connect("$HOST_NAME","$USER_ID","$USER_PASS");
mysql_select_db("$DB_NAME");
if(!$offset) $offset=0;
$limit=20;
$newoffset=$offset+$limit;
$list_sql="select * from today_proverb order by num desc";
$list_num=mysql_query($list_sql);
$list_sql .=" limit $offset, $limit";
######################################################
$list_result=mysql_query($list_sql);
if(!$page) { $page = 1; }
$total = mysql_num_rows($list_num);
$num_per_page = $limit;
$page_per_block = 10;
$total_page = ceil($total/$num_per_page);
if(!$total) {
echo("ÀÚ·á ¾øÀ½.");
exit;
}
if (!$total) { $first = 1; $last = 0; }
else {
$first = $num_per_page*($page-1);
$last = $num_per_page*$page;
$isnext = $total - $last;
if ($isnext > 0 ) {
$last -= 1;
}
else {
$last = $total - 1;
}
}
$i=$offset;
$now_time = date("y/m/d H:i");
?>
[ ¿À´ÃÀÇ ¸í¾ð ]
¹øÈ£ |
³»¿ë |
À̸§ |
ÀÔ·ÂÀÏ |
ó¸® |
while($list=mysql_fetch_array($list_result)) {
$inputdate = date("Y/m/d H:i:s", $list[inputdate]);
echo "
$list[num] |
$list[content] |
$list[name] |
$inputdate |
¼öÁ¤ »èÁ¦ |
";
}
echo "
";
######### ÆäÀÌÁö ºÐÇÒ ½ÃÀÛ #############
if ($i != $last) {
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($block >= $total_block) {
$last_page = $total_page;
}
if($block>1){
$my_page=$first_page;
echo("[óÀ½] ");
$pre_block_offset=$my_page*$limit-$limit;
echo("[ÀÌÀü ${page_per_block}°³]");
}
for($di_page = $first_page+1; $di_page <= $last_page; $di_page++) {
if ($page == $di_page) {
echo("[$di_page] ");
} else {
$next_offset=($limit*$di_page)-$limit;
echo("[$di_page] ");
}
}
if($block<$total_block){
$my_page = $last_page+1;
$block_offset=$my_page*$limit-$limit;
$total_offset=$limit*$total_page-$limit;
echo("[´ÙÀ½ ${page_per_block}°³]");
echo("[³¡]");
}
echo " |
";
?>
Copyright(c)2003, ±æÀÌ À̾߱â. All rights Reserved.