http://cafe.daum.net/phplove ¿¡ ¼ö·ÏµÈ °ÁÂ
// board_list.php
Á©Áß¿äÇÑ°Ç ÆäÀÌÁöÁÖ¼Ò°¡ ÀÌ·¸°Ô °©´Ï´Ù.
www.phplove.co.kr/board_list.php?code=board
$code=board´Â Áß¿ä. ¹¹ ¸»·Î ¼³¸íÇϱâ Á» ±×·¸Áö¸¸. µû¶óÇÏ¸é ¾Ë°ÔµË´Ï´Ù.¹°·Ð board´Â »ý¼ºÇÑ Å×À̺í À̸§À» Àû¾îÁÖ¸é µË´Ï´Ù.
board_list.php¸¦ boardÅ×ÀÌºí¿¡ ÀÖ´Â ³»¿ëÀ» »ç¿ëÇϰڽÀ´Ï´Ù. ¶ó´Â ³»¿ëÀÌÁ®..
######## ¸ÕÀú ÆäÀÌÁö ½ºÅ©¸³Æ®ºÎºÐ, ŸÀÌÆ²¿¡ µû¶ó´Ù´Ï´Â ¸Þ´ººÎºÐ,ÇÏ´Ü
ÆäÀÌÁö ºÎºÐÀº ¸Å¹ø ÆäÀÌÁö°¡ °¥¶§¸¶´Ù µû¶ó´Ù´Ï¹Ç·Î include·Î ¹¾ú½À´Ï´Ù.
<?
############ »ç¿ëÀÚÀÇ ºê¶ó¿ìÀú¿¡ Àü¼ÛµÇ´Â HTTPÇì´õ¸¦ ÀÌ¿ëÇÏ¿© »ç¿ëÀÚ°¡ ¿äûÇÑ 췝ÆäÀÌÁöÀÇ ³»¿ëÀ» »ç¿ëÀÚÀÇ ½Ã½ºÅÛ¿¡ ij½Ã·Î ³²±æ¼ö ÀÖµµ·Ï Çã¿ëÇÒ°ÍÀÎÁö ±× Çã¿ë¼öÁÙÀ» Á¶ÀýÇϱâ À§ÇØ ¼³Á¤ÇÕ´Ï´Ù. ¹¹ °æ°íµÈÆäÀÌÁöÀÔ´Ï´Ù.
if($SESSION_CACHE_LIMITER) { session_cache_limiter($SESSION_CACHE_LIMITER);
} else { session_cache_limiter('nocache, must-revalidate'); }
header("Pragma: no-cache");
header("Expires: 0");
session_start();
require_once("../html/include.header.php"); // ½ºÅ©¸³Æ®°¡ ÀúÀåµÈ ÆÄÀÏ
require_once("../html/function.user.php");
$cfg_file = "../html/include.config.php";
if(file_exists($cfg_file)) { require($cfg_file);
} else { error("NOT_FOUND_CONFIG_FILE"); exit;}
$db = mysql_select_db($dbName);
if(!$db) { error("FAILED_TO_SELECT_DB"); exit;}
require_once("../html/menu.php"); // »ó´Ü ÆäÀÌÁö°¡ ÀúÀåµÈ ÆÄÀÏ
###### °Ô½Ã¹°¿¡ ¾Æ¹«°Íµµ µî·ÏÀÌ µÇ¾îÀÖÁö ¾Ê´Ù¸é ÆäÀÌÁö¼ö´Â 1·Î Á¤ÀÇÇÏ°í ¶Ç Ã£°íÇÏ´Â °Ë»ö¹®ÀÚ¿ÀÌ ¾ø´Ù¸é Àüü ÆäÀÌÁö ¼ýÀÚ¸¦ ¾Ë¾Æ³À´Ï´Ù.
$key_word º¯¼ö°¡ °Ë»ö¹®ÀÚ¿ ÀÌ ´ã±ä º¯¼ö ¹¹ ±×·±°Å ÀÖÁÒ. ¾Æ·¡¿¡ Á¦¸ñÀ¸·Î ã´øÁö ³»¿ëÀ¸·Î ã´øÁö. ±×·± °Ë»ö¹®ÀÚ¿ÀÔ´Ï´Ù..
if(!$page){ $page=1 ;}
if($key_word == ""){$sql = "SELECT count(*) FROM $code ORDER BY fDate desc, fTitle";
}else if($key_word != ""){$sql = "SELECT count(*) FROM $code WHERE fTitle like '%$key_word%' or fContent like '%$key_word%' ORDER BY fDate desc, fTitle";}
$result = mysql_query($sql);
if (!$result) { error("QUERY_ERROR"); exit;}
###### Àüü ·¹ÄÚµå ¼ö->¾ó¸¶ÅÀÇ °Ô½Ã¹°ÀÌ µî·Ï됬´ÂÁö ¾Ë¼ö ÀÖ½À´Ï´Ù
$total_record = mysql_result($result,0,0);
mysql_free_result($result);
####### Àüü ÆäÀÌÁö¼ö¸¦ ¾Ë¾Æ³À´Ï´Ù. ¿¹¸¦ µé¾î °Ô½Ã¹°¿¡ µî·ÏÇÑ ³»¿ëÀÌ 52°³¶ó¸é ±×°É $num_per_page(10°³ Á¤ÇØÁذоËÁÒ)·Î ³ª´©¾î¼ ceilÀÇ ¿¬»êÇÔ¼ö·Î ¹Þ¾Æ¼ÆäÀÌÁö ¼ö¸¦ ¾Ë¾Æ³À´Ï´Ù. 50¸¦10À¸·Î ³ª´©¾îceilÇÔ¼ö½èÀ¸´Ï±î ´äÀº 6
±×·¡¼ ùÆäÀÌÁö ¼ö¿Í ³¡ÆäÀÌÁö ¼ö¸¦ °è»êÇÕ´Ï´Ù..
$total_page = ceil($total_record/$num_per_page);
if($total_record == 0) { $first = 1; $last = 0;
} else { $first = $num_per_page*($page-1); $last = $num_per_page*$page;}
####### ¿©±ä À§¿¡¿Í °°Áö¸¸ Ʋ·ÁÁø°Ç ÀÌÁ¦ ·¹ÄÚµå ¼ö°¡ ¾Æ´Ñ ³»¿ëÀ» °¡Á®¿Ã¼ö ÀÖ´Â ±â¹ÝÀ» ¸¸µç°ÍÀÔ´Ï´Ù..
if($key_word == ""){$query = "SELECT * FROM $code ORDER BY fUid DESC, fThread LIMIT $first, $num_per_page";
}else if($key_word != ""){$query = "SELECT * FROM $code WHERE fTitle like '%$key_word%' or fContent like '%$key_word%' ORDER BY fUid DESC, fThread LIMIT $first, $num_per_page";}
$qry_result = mysql_query($query);
?>
<table border="0" width="770" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" valign="top"></td>
</tr>
<tr>
<td width="100%" valign="top" align="center"><img border="0" src="../image/<?echo"$code"?>_title.gif"></td>
</tr>
</table>
<table bgcolor="white" width="770">
<tr>
<td align="left" width="25%"> <font color='#3399FF' size="2"><b>¨Ú</b></font> -> »õ·Î¿î ±Û <font color='gray'><b>¨Û</b></font> -> Áö³ ±Û <font color='#ff6600' size="2"><b>¨Í</b></font> <font color='gray'><b>¨Í</b></font> -> ´äº¯ ±Û </td>
<td align="right" width="75%">
<a href="board_list.php?code=<?echo"$code"?>&page=<?echo"$var_page"?>&type=<?echo"$type"?>&key_word=<?echo"$key_word"?>&keyfield=<?echo"$keyfield"?>&key=<?echo"$encoded_key"?>"><img src="../image/board_first.gif" border="0" title="óÀ½¸ñ·Ï"></a>
<?
if($block > 1) { $var_page = $first_page;
echo("<a href="board_list.php?code=$code&page=$var_page&type=$type&key_word=$key_word&keyfield=$keyfield&key=$encoded_key"><img src="../image/board_pre10.gif" border="0" title="´ÙÀ½ ¸ñ·Ï10°³"></a>");}
if ($page > 1) { $page_num = $page - 1;
echo("<a href="board_list.php?code=$code&page=$page_num&type=$type&key_word=$key_word&keyfield=$keyfield&key=$encoded_key"><img src="../image/board_next.gif" border="0" title="´ÙÀ½ ¸ñ·Ï"></a>");}
if ($total_record > $last) { $page_num = $page + 1;
echo("<a href="board_list.php?code=$code&page=$page_num&type=$type&key_word=$key_word&keyfield=$keyfield&key=$encoded_key"><img src="../image/board_pre.gif" border="0" title="ÀÌÀü ¸ñ·Ï"></a>");}
if($block < $total_block) { $var_page = $last_page+1;
echo("<a href="board_list.php?code=$code&page=$var_page&type=$type&key_word=$key_word&keyfield=$keyfield&key=$encoded_key"><img src="../image/board_next10.gif" border="0" title="ÀÌÀü ¸ñ·Ï 10°³"></a>");
}?>
<a href="board_write.php?code=<?echo("$code")?>"><img src="../image/board_new.gif" border="0" title="±Û¾²±â"></a>
<a href="<?echo("$mainpage")?>"><img src="../image/board_home.gif" border="0" title="ȨÀ¸·Î °¡±â"></a>
</td>
</tr>
</table>
<table border="0" width="770" cellspacing="0" cellpadding="0">
<tr>
<td width="770" colspan="3"><img border="0" src="../image/board_background-1.gif" width="770" height="20"></td>
</tr>
<tr>
<td width="20" background="../image/board_background-4.gif" width="20" height="75"></td>
<td width="730" valign="top" class="bold_font">
<table border="0" width="100%">
<tr>
<td width="50" height="20" align="center" bgcolor="#EFEFEF">¹ø È£</td>
<td width="430" height="20" align="center" bgcolor="#EFEFEF">Á¦ ¸ñ</td>
<td width="80" height="20" align="center" bgcolor="#EFEFEF">ÀÌ ¸§</td>
<td width="50" height="20" align="center" bgcolor="#EFEFEF">÷ºÎ</td>
<td width="70" height="20" align="center" bgcolor="#EFEFEF">³¯ Â¥</td>
<td width="50" height="20" align="center" bgcolor="#EFEFEF">Á¶È¸¼ö</td>
</tr>
</table>
<?
$article_num = $total_record - $num_per_page*($page-1);
######### mysql_fetch_object °á°ú ·¹ÄÚµå ¼¼Æ®¿¡¼ ÇÑÇà(·¹ÄÚµå)¸¦ °´Ã¼ÀÇ ÇüÅ·Π°¡Á®¿É´Ï´Ù.. ±×·¡¾ß ÀúÀåµÈ °Ô½Ã¹° °ªÀ» while·Î ¸ðµÎ °¡Á®¿Í¼ ³»¿ëÀ» º¸¿©ÁÖ¸é µË´Ï´Ù...
while($qry_row = mysql_fetch_object($qry_result)) {
$var_idx = $qry_row->fIdx; // ÀÚµ¿Áõ°¡µÇ´Â ³Ñ¹ö°ª
$var_uid = $qry_row->fUid; // ¾ÆÀ̵𠰪
$var_type = $qry_row->fType; // °Ô½Ã¹°ÀÇ Å¸ÀÔ°ª
### addslashes()ÇÔ¼ö ¹Ý´ëµÇ´Â °³³äÀÔ´Ï´Ù. db¿¡ ÀúÀåµÈ ¹®ÀÚ¿À» ¿ø·¡ÀÇ ¹®ÀÚ¿·Î µÇµ¹¸±¶§ »ç¿ëµÇ´Â ÇÔ¼ö stripslashesÇÔ¼ö
$var_title = stripslashes($qry_row->fTitle); // °Ô½Ã¹° Á¦¸ñ
$var_img = $qry_row->fImg; // file¾÷·Îµå µÉ À̹ÌÁö
$var_date = date("Y-m-d",$qry_row->fDate); ³¯Â¥
$var_img_tmp = explode("|%|",$var_img); ´ÙÁß ÆÄÀϾ÷·Îµå¸¦ ±¸ÇöÇÒ·ÁÇϴµ¥ ±× ÆÄÀÏÀ» %·Î ±âÁØÀ» ÇØ¼ Çϳª¾¿ ºÒ·¯µéÀ̱â À§ÇØ »ç¿ë ¾ÆÁÖÀ¯¿ëÇÑ ÇÔ¼ö ÀÔ´Ï´Ù..
$t = count($var_img_tmp);// ÆÄÀÏÀÇ °¹¼ö
$var_name = $qry_row->fName; // À̸§
$var_thread = $qry_row->fThread; // ´äº¯ÀÎÁö
$var_click = $qry_row->fClick; Á¶È¸¼ö
$var_thread = trim($qry_row->fThread); °ø¹é¹®ÀÚ¿À» Á¦°ÅÇÏ°í ±× ³ª¸ÓÁö ¹Ýȯ
if($key_word != ""){$var_title = eregi_replace("($key_word)", "<font color=red>1</font>", $var_title); }
?>
<table border="0" width="100%">
<? if($var_thread == "A"){ ?>
<tr onmouseout="this.style.background='#F5F5F5'" onmouseover="this.style.cursor='hand';this.style.background='#D0E6CE';" style="BACKGROUND: #F5F5F5" onClick="location='board_content.php?code=<?echo"$code"?>&idx=<?echo"$var_idx"?>&key_word=<?echo"$key_word"?>&type=<?echo"$type"?>';">
<? }else{?>
<tr onmouseout="this.style.background='#FFFFFF'" onmouseover="this.style.cursor='hand';this.style.background='#D0E6CE';" style="BACKGROUND: #FFFFFF" onClick="location='board_content.php?code=<?echo"$code"?>&idx=<?echo"$var_idx"?>&key_word=<?echo"$key_word"?>&type=<?echo"$type"?>';">
<? }?>
<td width="50" height="20" align="center"><?echo"$article_num"?></td>
<td width="430" height="20">
<?
$spacer = strlen($var_thread)-1;
for($j = 0; $j < $spacer; $j++) {echo(" ");}
$date_diff = date("Ymd",$qry_row->fDate);
$time_limit = date("Ymd",time());
if ($number == $var_uid) {echo("<b><font color='blue'>¢º</font> </b>");
} else {
if ($date_diff == $time_limit) {
if(!strcmp($var_thread,"A")) {echo("<b><font color='#3399FF'>¨Ú</font> </b>");
} else {echo("<b><font color='#3399FF'>¨Ú</font> <font color='#ff6600'>¨Í</font> </b>");}
} else {
if(!strcmp($var_thread,"A")) {echo("<font color='gray'><b>¨Û</b></font>");
} else {echo("<b><font color='gray'>¨Û</font> <font color='gray'>¨Í</font></b> ");}
}
}?>
<a href="board_content.php?code=<?echo"$code"?>&idx=<?echo"$var_idx"?>&key_word=<?echo"$key_word"?>&type=<?echo"$type"?>">
<font color="black"><?echo"$var_title"?></font></a>
</td>
<td width="80" height="20" align="center"><?echo"$var_name"?></td>
<td width="50" height="20" align="center">
<?
/////// À̹ÌÁö °¹¼ö È®ÀÎ
if($t > 1){?>
<a href="javascript:open_winimg('<?echo"$code"?>','<?echo"$var_img_tmp[0]"?>')"><img src='../image/disk_02a.gif' width='20' height='20' border=0></a>
<? }?>
</td>
<td width="70" height="20" align="center"><?echo"$var_date"?></td>
<td width="50" height="20" align="center"><?echo"$var_click"?></td>
</tr>
</table>
<table border="0" width="100%" bgcolor="white" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" align="center" background="../image/bar02_dot1x1_black.gif" height="1"><img border="0" src="../image/1_line.gif" width="1" height="1"></td>
</tr>
</table>
<? $article_num--;
}?>
##### ¾îÈÞ ÀÌÁ¦ ·çÇÁ°¡ ³¡³µ³×¿ä..
</td>
<td width="20" background="../image/board_background-3.gif" width="20" height="75"></td>
</tr>
<tr>
<td width="100%" colspan="3"><img border="0" src="../image/board_background-2.gif" width="770" height="18"></td>
</tr>
</table>
<table bgcolor="white" width="770">
<tr>
<td align="right" width="100%">
<a href="board_list.php?code=<?echo"$code"?>&page=<?echo"$var_page"?>&type=<?echo"$type"?>&key_word=<?echo"$key_word"?>&keyfield=<?echo"$keyfield"?>&key=<?echo"$encoded_key"?>"><img src="../image/board_first.gif" border="0" title="óÀ½¸ñ·Ï"></a>
<?
if($block > 1) {$var_page = $first_page;
echo("<a href="board_list.php?code=$code&page=$var_page&type=$type&key_word=$key_word&keyfield=$keyfield&key=$encoded_key"><img src="../image/board_pre10.gif" border="0" title="´ÙÀ½ ¸ñ·Ï10°³"></a>");
}
if ($page > 1) {$page_num = $page - 1;
echo("<a href="board_list.php?code=$code&page=$page_num&type=$type&key_word=$key_word&keyfield=$keyfield&key=$encoded_key"><img src="../image/board_next.gif" border="0" title="´ÙÀ½ ¸ñ·Ï"></a>");
}
if ($total_record > $last) {$page_num = $page + 1;
echo("<a href="board_list.php?code=$code&page=$page_num&type=$type&key_word=$key_word&keyfield=$keyfield&key=$encoded_key"><img src="../image/board_pre.gif" border="0" title="ÀÌÀü ¸ñ·Ï"></a>");
}
if($block < $total_block) {$var_page = $last_page+1;
echo("<a href="board_list.php?code=$code&page=$var_page&type=$type&key_word=$key_word&keyfield=$keyfield&key=$encoded_key"><img src="../image/board_next10.gif" border="0" title="ÀÌÀü ¸ñ·Ï 10°³"></a>");
}?>
<a href="board_write.php?code=<?echo("$code")?>"><img src="../image/board_new.gif" border="0" title="±Û¾²±â"></a>
<a href="<?echo("$mainpage")?>"><img src="../image/board_home.gif" border="0" title="ȨÀ¸·Î °¡±â"></a>
</td>
</tr>
</table>
#### °Ë»ö ´Ü¾î¸¦ ã±âÀ§ÇÑ ½ºÅ©¸³Æ® ¾ð¾î
<script language="javascript">
<!--
function find(){
var form = document.board_list01;
if(form.key_word.value == ""){
alert("ãÀ¸½Ç ´Ü¾î¸¦ ÀÔ·Â ÇÏ¼Å¾ß ÇÕ´Ï´Ù.");
form.key_word.focus();
return;
}
var code = form.code.value;
location.href="board_list.php?code=" + code + "&key_word=" + form.key_word.value;
}//-->
</script>
<table border="0" width="770">
<form action="board_list.php" name="board_list01" method="post">
<input type="hidden" name="code" value="<?echo"$code"?>">
<tr>
<td width="10%" height="25" align="right"></td>
<td width="10%" align="center"><input type="text" name="key_word" size="10"></td>
<td width="10%" align="left"><a href="javascript:find()"><img src="../image/find.gif" border="0"></a></td>
<td width="70%" align="center">
<? ¿©±â´Â ÀÌÁ¦ º¸½Ã¸é ¾Ë°ÚÁ®. °Ô½Ã¹°¾Æ·¡ °¢°¢ÀÇ °Ô½Ã¹°¿¡ À̵¿ÇÒ¼ö ÀÖ´Â ´ÜÃ߸¦ ¸¸µå´Â °÷ÀÔ´Ï´Ù..ÀÌÀü ÆäÀÌÁö ´ÙÀ½ ÆäÀÌÁö..µîµî
$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) {
$var_page = $first_page;
echo("<a class='num_link' href="board_list.php?code=$code&cdoe3=$code3&code4=$code4&page=$var_page&type=$type&key_word=$key_word&type=$type"><b>¢¸</b></a>");
}echo" ";
for($direct_page = $first_page+1; $direct_page <= $last_page; $direct_page++) {
if($page == $direct_page) {echo("<font color='red'><b>[$direct_page]</b></font>");
} else {echo("<a class='num_link' href="board_list.php?code=$code&cdoe3=$code3&code4=$code4&page=$direct_page&type=$type&key_word=$key_word&type=$type"><b>[$direct_page]</b></a>"); }
}echo" ";
if($block < $total_block) { $var_page = $last_page+1;
echo("<a class='num_link' href="board_list.php?code=$code&cdoe3=$code3&code4=$code4&page=$var_page&type=$type&key_word=$key_word&type=$type"><b>¢º</b></a>");
}?>
</td>
</tr>
</table>
</form>
###### ¸Þ´º ÇÏ´Ü¿¡ ÆäÀÌÁö¸¦ ÀúÀåÇÑ ÆÄÀÏ.
<?require_once("../html/include.bottom.php");?>
</center>
</body> |