include "../../menu_board.inc" ?> |
include "../../mysql.php";
if ($search && $find) $sql_query = "select count(idx) from $db where $search like '%$find%'";
else $sql_query = "select count(idx) from $db";
$sql = mysql_query($sql_query);
$total = mysql_result($sql, 0, 0 );
if (!$page) $page = 1;
$nowpage = 15;
$limit1 = ($page-1)*$nowpage;
if ($page >= ceil($total/$nowpage))
{
$limit2 = $total % $nowpage;
if ($limit2 == 0 && $total!=0) $limit2 = $nowpage;
}
else $limit2 = $nowpage;
?>
:: echo "ÃÑ : ".$total." °Ç / ".(ceil($total/$nowpage))." ÆäÀÌÁö Áß $page ÆäÀÌÁö"; ?> :: |
if ($board_uid == "master") echo "[P/Wº¯°æ] | [·Î±×¾Æ¿ô]"; else echo " "; ?> |
|
¹øÈ£ |
Á¦¸ñ |
À̸§ |
ÀÛ¼ºÀÏ |
Á¶È¸ |
|
$today = date("Y-m-d");
if ($search && $find) $sql_query = "select * from $db where $search like '%$find%' order by num DESC limit $limit1, $limit2";
else $sql_query = "select * from $db order by num DESC limit $limit1, $limit2";
$sql = mysql_query($sql_query);
for ($i=1; $i<=$limit2; $i++)
{
$data = mysql_fetch_array($sql);
if ($search == "subject" && $find) $subject = str_replace($find, "$find", stripslashes($data[subject]));
else $subject = stripslashes($data[subject]);
if ($data[upfile])
{
$ext = strtolower(substr($data[upfile], -3, 3));
if (file_exists("../../images/icon_".$ext.".gif")) $icon = " ";
else $icon = " ";
}
else $icon = "";
echo "\n";
echo "$data[num] | \n";
echo "$icon $subject";
if ($today == $data[date]) echo " ";
echo " | \n";
echo "$data[name] | \n";
echo "$data[date] | \n";
echo "$data[hit] | \n";
echo " \n";
if ($i != $limit2) echo " | \n";
else echo " | \n";
}
mysql_close($mydb);
?>
if ("master" == $board_uid) echo " " ?> |
$npage = floor(($page-1)/10)*10;
echo " ";
for ($q=$npage+1; $q<=$npage+10; $q++)
{
if ($q <= ceil($total/$nowpage))
{
if ($q == $page) echo "".$q."";
else echo " ".$q."";
if ($q != $npage+10 && $q < ceil($total/$nowpage)) echo " | ";
}
}
if ($q > ceil($total/$nowpage)) $q = ceil($total/$nowpage);
echo " ";
?>
|
if ($find && $search) echo " " ?> |
|