|
include "../../com/l_menu08.html";?>
include "../../com/lt_quick.html";?>
|
 |
Home > °í°´¼¾ÅÍ > ´Üü¿©Çà°ßÀû¹®ÀÇ |

|
 |
//°Ë»öÀÎ °æ¿ì
if($find == 'title') {
$where = " WHERE GR_TITLE LIKE '%$search%'";
} else if ($find == 'name') {
$where = " WHERE GR_NAME LIKE '%$search%'";
}
$nowtime=date(Ymd);
//Àüü ·¹ÄÚµå¼ö
$query = "SELECT COUNT(*) AS CNT FROM AQU_GROUPBOARD $where";
$result = mysql_query($query,$G_CONNECT);
$total_record = mysql_result($result,0,0);
//ÇÑ ÆäÀÌÁö´ç Ãâ·ÂÇÒ ¼ö
$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;
}
?>
|
| ¹øÈ£ |
Á¦¸ñ |
±Û¾´ÀÌ |
µî·ÏÀÏ |
Á¶È¸¼ö |
|
|
//¸ñ·ÏÀ» ²¨³»¿Â´Ù.
$query = "SELECT * FROM AQU_GROUPBOARD $where order by GR_REF desc, GR_STEP 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)) {
$tmp_fdate = substr($row[GR_FDATE],0,4)."-".substr($row[GR_FDATE],4,2)."-".substr($row[GR_FDATE],6,2);
$tmp_fdate1 = substr($row[GR_FDATE],0,4).substr($row[GR_FDATE],4,2).substr($row[GR_FDATE],6,2);
$name=htmlspecialchars($row[GR_NAME]);
//¿À´Ã³¯Â¥ ±¸Çϱâ
$today = mktime (0,0,0,date("m") ,date("d"),date("Y"));
$today_year = date("Y",$today); $today_month = date("m",$today); $today_day = date("d",$today);
//±Û¾´ ³¯Â¥ ±¸Çϱâ
$fdate_year = substr($row[GR_FDATE],0,4); $fdate_month = substr($row[GR_FDATE],4,2); $fdate_day = substr($row[GR_FDATE],6,2);
$timestamp = strtotime("$today_year-$today_month-$today_day 00:00:00")-strtotime("$fdate_year-$fdate_month-$fdate_day 00:00:00");
$tmp_usetime = intval($timestamp/60/60);
$tmod = '';
?>
| echo $tmp_num-- ?> |
If($row[GR_LEVEL] > 0) {
$wid = $row[GR_LEVEL] * 3;
$tmod = 'Y';
?>
if ($SES_MEM_LEVEL == '003' or $SES_MEM_LEVEL == '002') { ?>
 [´ä±Û] =rfn_kstrcut($row[GR_TITLE], 40, '...');?> if ($tmp_fdate1 == $nowtime) { ?> } ?>
} else { ?>
 [´ä±Û] =rfn_kstrcut($row[GR_TITLE], 40, '...');?> if ($tmp_fdate1 == $nowtime) { ?> } ?>
} ?>
} else { ?>
if ($SES_MEM_LEVEL == '003' or $SES_MEM_LEVEL == '002') { ?>
=rfn_kstrcut($row[GR_TITLE], 40, '...');?> if ($tmp_fdate1 == $nowtime) { ?> } ?>
} else { ?>
=rfn_kstrcut($row[GR_TITLE], 40, '...');?> if ($tmp_fdate1 == $nowtime) { ?> } ?>
} ?>
} ?> |
=rfn_kstrcut($row[GR_NAME], 18, '...');?> |
=$tmp_fdate;?> |
=$row[GR_HIT];?> |
|
}
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" ";
}
?> |
|
|
|
|
|
| |
|
|
include "../../com/rt_quick.html";?>
|