|
include "../../com/l_menu08.html";?>
include "../../com/lt_quick.html";?>
|
 |
Home > °í°´¼¾ÅÍ > ÀÚÁÖ¹¯´ÂÁú¹® |
//°Ë»öÀÎ °æ¿ì
if($find == 'title') {
$where = " WHERE AF_TITLE LIKE '%$search%'";
} else if ($find == 'content') {
$where = " WHERE AF_CONTENT LIKE '%$search%'";
}
if ($typenum) {
if($where == '') { $where = " WHERE "; }else{ $where = $where." AND "; }
$where = $where."AF_TYPE = '$typenum'";
}
//Àüü ·¹ÄÚµå¼ö
$query = "SELECT COUNT(*) AS CNT from FAQBOARD $where";
$result = mysql_query($query,$G_CONNECT);
$prow = mysql_fetch_array($result,MYSQL_ASSOC);
$total_record = mysql_result($result,0,0);
$totaljum = $prow[total_jum];
//ÇÑ ÆäÀÌÁö´ç Ãâ·ÂÇÒ ¼ö
$num_per_page = 20;
//ÇÑ ºí·°´ç Ãâ·ÂÇÒ À̵¿ ÆäÀÌÁöÀÇ °¹¼ö
$page_per_block = 8;
//ÇöÀç ÆäÀÌÁö
if($page == '') $page = 1;
//Àüü ÆäÀÌÁö¼ö
$total_page = ceil($total_record/$num_per_page);
//ÀüüÆäÀÌÁö¼ö º¸´Ù ÇöÀçÆäÀÌÁö°¡ Å©´Ù¸é ÀüüÆäÀÌÁö¼ö·Î ¼³Á¤
if($total_page < $page) {
$page = $total_page;
}
if($total_page == 0) {
$page = 1;
}
//ÃÑ ºí·°¼ö
$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($total_record == 0) {
$first = 1;
$last = 0;
}else {
$first = $num_per_page*($page-1);
$last = $num_per_page*$page;
}
?>
 |
=$total_record;?> |
|
 |
=$page;?>/=$total_page;?> |
|
|
//¸ñ·ÏÀ» ²¨³»¿Â´Ù.
$query = "SELECT * FROM FAQBOARD $where order by AF_IDX asc limit $first, $num_per_page";
$result = mysql_query($query,$G_CONNECT);
$curr_row_cnt = mysql_num_rows($result); //ÇöÀç ÆäÀÌÁö¿¡¼ º¸¿©ÁÙ ·¹ÄÚµå ¼ö(À§ Äõ¸® °á°ú ¼ö)
//±Û¹øÈ£
$tmp_num = $total_record - ($num_per_page *($page-1));
//ÆäÀÌÁö¸¸Å ¸ñ·Ï ¾²±â
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
if ($row[AF_TYPE] == '2') {
$tmp_type = '¿©ÇàÆÐŰÁö';
} else if ($row[AF_TYPE] == '3') {
$tmp_type = '¼÷¹Ú';
} else if ($row[AF_TYPE] == '4') {
$tmp_type = '·»Æ®Ä«';
} else if ($row[AF_TYPE] == '5') {
$tmp_type = 'Ç×°ø';
} else if ($row[AF_TYPE] == '1') {
$tmp_type = 'ÇÒÀÎÄíÆù';
} else if ($row[AF_TYPE] == '6') {
$tmp_type = '¿¹¾à/°áÁ¦';
} else if ($row[AF_TYPE] == '7') {
$tmp_type = 'ȯºÒ/º¯°æ';
} else if ($row[AF_TYPE] == '10') {
$tmp_type = '±âŸ';
}
?>
| |
echo $tmp_num-- ?> |
|
=$tmp_type;?> |
|
=rfn_kstrcut($row[AF_TITLE], 60, '...');?> |
|
|
}
if($curr_row_cnt == 0) {
echo "
| ³»¿ëÀÌ ¾ø½À´Ï´Ù. |
|
";
}
?>
if($block > 1) { $my_page = $first_page; echo" "; }else{ echo" "; } ?>
if($page > 1) { $my_page = $page - 1; echo" "; }else{ echo" "; } ?>
|
for($i = $first_page+1; $i <= $last_page ; $i++) {
if($i == $page) {
?>
echo $i;?> .
} else { ?>
echo $i;?> if ($last_page != $i) { ?> . } ?>
} ?>
}
?>
|
//´ÙÀ½
if($page < $total_page)
{
$my_page = $page + 1;
echo" ";
}else{
echo" ";
}
?>
//ºí·°Ç¥Çö - ´ÙÀ½*°³
if($block < $total_block)
{
$my_page = $last_page+1;
echo" ";
}else{
echo" ";
}
?>
|
|
if ($SES_MEM_LEVEL == '003' or $SES_MEM_LEVEL == '002') { ?>
 |
|
} ?>
 |
|
|
|
| |