$db = new DB;
// ÃÑ µî·Ï ±Û °³¼ö ±¸Çϱâ
$result3 = $db->execute($countSql);
$row3 = mysql_fetch_array($result3);
$total3 = $row3[0];
// ÃÑ ÆäÀÌÁö ±¸Çϱâ
$pages = intval($total3 / $size);
$pages += ($total3 % $size) ? 1 : 0;
// $page°¡ $pages º¸°¡ Å©¸é ¾È µÇ°ÚÁö¿ä?
if ($page > $pages)
$page = $pages;
$begin = ($page - 1) * $size;
// ±Û ±¸Çϱâ
$result = $db->execute($basicSql . " limit $begin, $size");
$total = mysql_num_rows($result);
?>
// °ü¸®ÀÚ ·Î±×ÀΠüũ
$admin_login = isAdminLogin($admin_id, $admin_pw, $cook_admin_id, $cook_admin_pw);
// °ü¸®ÀÚ ¸ðµå ¼³Á¤
$admin = ($admin_login) ? "Logout" : "Admin";
?>
border=0 cellspacing=0 cellpadding=0>
ÃÑ >°³ÀÇ ±ÛÀÌ °Ë»öµÇ¾ú½À´Ï´Ù.(page >/>) |
[] |
border=0 cellspacing=0 cellpadding=1 bgcolor=>
border=0 cellspacing=0 cellpadding=5>
>
?bid=&mode=order&orderBy=id>¹øÈ£ |
?bid=&mode=order&orderBy=category>Á¾·ù |
?bid=&mode=order&orderBy=writer>À̸§ |
?bid=&mode=order&orderBy=subject>Á¦¸ñ |
?bid=&mode=order&orderBy=wdate>³¯Â¥ |
?bid=&mode=order&orderBy=count>Á¶È¸ |
for ($i = 0; $i < $total; $i++) {
$row = mysql_fetch_array($result);
// Ãâ·ÂÇϱâ ÁÁµµ·Ï µ¥ÀÌÅÍ º¯°æ
$no = ($page - 1) * $size + $i + 1;
$indent = '';
for ($j = 0; $j < $row[indent] && $j < $maxIndent; $j++) {
$indent .= ' ';
}
$subjectLength = $subjectMax - strlen($indent);
$writer = stripslashes($row[writer]);
$writer = htmlspecialchars($writer);
$subject = subkostr($row[subject], $subjectLength);
$subject = htmlspecialchars($subject);
// °Ë»ö³»¿ëÀÌ ÀÖÀ¸¸é, ÂðÇÏ°Ô Ãâ·Â...
if (($searchWhere == 'writer' || $searchWhere == 'all') && $searchWhat) {
$writer = eregi_replace("$searchWhat", "$searchWhat", $writer);
}
if (($searchWhere == 'subject' || $searchWhere == 'all') && $searchWhat) {
$subject = eregi_replace("$searchWhat", "$searchWhat", $subject);
}
$wdate = date('Y.m.d', $row[wdate]);
$today = date('Y.m.d');
if ($row[email]) {
$row[email] = encodeEmail($row[email]);
$writer = "$writer";
}
if ($row[indent]) {
$indent = str_replace(' ', ' ', $indent);
$indent .= " ";
}
$newImage = ($wdate == $today) ? " " : '';
$hotImage = ($row[count] >= $hot) ? " " : '';
$category = $row[category];
// ÈÀÏÀÌ ÀÖ´ÂÁö Á¶»ç
$result2 = $db->execute("select count(*) from $file_table where id = $row[uid]");
$row2 = mysql_fetch_row($result2);
$fileImage = ($row2[0]) ? " " : '';
// ¸àÆ®°¡ ÀÖ´ÂÁö Á¶»ç
$result2 = $db->execute("select count(*) from $comment_table where id = $row[uid]");
$row2 = mysql_fetch_row($result2);
$commentImage = ($row2[0]) ? " $row2[0]" : '';
$bgcolor = (($i + 1)% 2) ? $colorList1 : $colorList2;
if ($row[uid] == $uid) {
$bgcolor = $colorSelect;
}
echo ("
$row[id] |
![$categoryName[$category]]($categoryImage[$category]) |
$writer |
$indent $subject $commentImage $fileImage $newImage $hotImage |
$wdate |
$row[count] |
");
}
?>
|
cellspacing=0 cellpadding=0 border=0>
$pageListSize = 5; // ÆäÀÌÁö ¸ñ·ÏÀÇ Å©±â/2
$begin = ($page - $pageListSize);
$begin = ($begin > 1) ? $begin : 1;
$end = ($page + $pageListSize);
$end = ($end > $pages) ? $pages : $end;
if ($begin != 1)
echo ("[1] ... ");
for ($i = $begin; $i <= $end; $i++) {
if ($i == $page)
echo ("[$i]");
else
echo ("[$i]");
}
if ($end != $pages)
echo (" ... [$pages]");
?>
|
$prevPage = $page - 1;
$nextPage = $page + 1;
if ($prevPage > 0)
$prevIcon = "
";
else
$prevIcon = "
";
if ($nextPage <= $pages)
$nextIcon = "
";
else
$nextIcon = "
";
// °ü¸®ÀÚ Àü¿ë(onlyAdmin) ¸ðµå¶ó¸é °ü¸®ÀÚ¸¸ ±ÛÀ» ¾µ ¼ö ÀÖ´ç~
$insertIcon = ($onlyAdmin && !$admin_login) ? '' : "
";
?>
border=0 cellspacing=0 cellpadding=0>