ÀÚ À¯ °Ô
½Ã ÆÇ |
|
¹øÈ£ |
Á¦¸ñ |
±Û¾´ÀÌ |
±Û¾´³¯ |
Ä«¿îÆ® |
| |
// ÇöÀç ÃÑ ¸î °³ÀÇ °Ô½Ã¹°ÀÌ ÀÖ´ÂÁö ±¸ÇÑ´Ù.
$total_query = "SELECT uid FROM notic_board";
$total_result = mysql_query($total_query,$connect);
//$total = mysql_result($total_result,0,0);
$total = mysql_num_rows($total_result);//040419
// Àüü ÆäÀÌÁö ¼ö¸¦ $totalpages¿¡ ´ã´Â´Ù.
$totalpages = ceil($total/10);
// DBÀÇ ½ÃÀÛ row¸¦ ±¸ÇÑ´Ù.
$startnum = ($page - 1)*10;
// ºÒ·¯¿À´Â Äõ¸®¹®
$query = "SELECT * FROM notic_board ORDER BY uid DESC LIMIT $startnum,10";
$result = mysql_query($query, $connect);
?>
while ($row = mysql_fetch_array($result))
{
// Á¦¸ñ°ú À̸§¿¡ ºÙÀº quotesÁ¦°Å
$title = stripslashes($row[title]);
$noticname = stripslashes($row[noticname]);
echo"
$row[uid] |
";
echo"
$title |
$noticname |
$row[wdate] |
$row[count] |
";
}
?>
|
 |
|
|
|
// ÃÑ ÆäÀÌÁö°¡ 1 ÀÌ»óÀÏ °æ¿ì¿¡¸¸ Ãâ·ÂÇÑ´Ù.
if ($totalpages >= 1)
{
// 10 ÆäÀÌÁö ´ÜÀ§·Î ²÷´Â´Ù.
$total_count = $totalpages/10;
$total_count = ceil($total_count);
// ÇöÀç ÆäÀÌÁöÀÇ À§Ä¡¸¦ ±¸ÇÑ´Ù.
$page_count = $page/10;
$page_count = ceil($page_count);
// ¸µÅ© ½ÃÀÛ ÆäÀÌÁö, Á¾·áÆäÀÌÁö¸¦ ±¸ÇÑ´Ù.
$start_page = ($page_count - 1) * 10 +1;
$end_page = $start_page + 9;
// ¸¸¾à Á¾·áÆäÀÌÁö°¡ ÃÑ ÆäÀÌÁöº¸´Ù Å©¸é Á¾·áÆäÀÌÁö°ª¿¡ ¸¶Áö¸· ÆäÀÌÁö °ªÀ» ³Ö´Â´Ù.
if ($end_page > $totalpages)
{
$end_page = $totalpages;
}
// ´ÙÀ½ÆäÀÌÁö°ª, ÀÌÀüÆäÀÌÁö°ª ±¸Çϱâ
$next_count = $end_page + 1;
$past_count = $start_page - 1;
// ÀÌÀüÆäÀÌÁö¸¦ Ãâ·ÂÇØ¾ß ÇÏ´Â °æ¿ì
if ($page_count!=1 && $total_count>1)
{
echo "¢¸";
}
// ÆäÀÌÁö ¸µÅ©¸¦ »Ñ·ÁÁØ´Ù.
for ($j=$start_page;$j<=$end_page;$j++){
if ($j==$page){
echo" [$j]";
}else{
echo" [$j]";
}
}
// ´ÙÀ½ÆäÀÌÁö¸¦ Ãâ·ÂÇØ¾ß ÇÏ´Â °æ¿ì
if ($page_count<$total_count)
{
echo "¢º";
}
}
?>
|
// ¸ñ·ÏÀ¸·Î °¡±â
echo"¸ñ·Ïº¸±â";
// ÀüÆäÀÌÁö·Î °¡±â
if ($page!=1)
{
$past_page = $page - 1;
echo"¢¸- ";
}
// ±Û¾²±â ¹öư
echo" | ±Û¾²±â ";
// ´ÙÀ½ÆäÀÌÁö·Î °¡±â
if ($page < $totalpages)
{
$next_page = $page + 1;
echo"-¢º ";
}
?>
|