@session_start();
include ("../db_cnn.php");
$VARS = array_merge($_GET,$_POST);
/////////////////////////////session check/////////////////////////////
$check_id_sql="select mb_id from g4_member where mb_id='$_SESSION[MODOOSID]'";
$check_id_re=mysql_query($check_id_sql);
$check_id_num=mysql_num_rows($check_id_re);
/////////////////////////////session check/////////////////////////////
$where = " where 1=1 ";
if($VARS[sfl]=="title"){
$where .= " and wn.wr_subject like '%$VARS[stx]%' ";
}else if($VARS[sfl]=="contents"){
$where .= " and wn.wr_content like '%$VARS[stx]%' ";
}else if($VARS[sfl]=="title_contents"){
$where .= " and wn.wr_content like '%$VARS[stx]%' or wn.wr_subject like '%$VARS[stx]%' ";
}
//$new_sql="select * from g4_write_news order by wr_datetime desc";
$new_num_sql = "select wn.wr_id, wn.wr_content, wn.wr_subject, wn.wr_datetime, bf.bf_source, bf.bf_file from g4_write_news as wn left join g4_board_file as bf on wn.wr_id=bf.wr_id $where order by wn.wr_datetime desc";
$new_num_re=mysql_query($new_num_sql);
$new_num=mysql_num_rows($new_num_re);
$num=$new_num;
$page = ($_GET['page'])?$_GET['page']:1;
$list = 20;
$block = 3;
$pageNum = ceil($num/$list); // 총 페이지
$blockNum = ceil($pageNum/$block); // 총 블록
$nowBlock = ceil($page/$block);
$s_page = ($nowBlock * $block) - 2;
if ($s_page <= 1) {
$s_page = 1;
}
$e_page = $nowBlock*$block;
if ($pageNum <= $e_page) {
$e_page = $pageNum;
}
/*
echo "현재 페이지는".$page."
";
echo "현재 블록은".$nowBlock."
";
echo "현재 블록의 시작 페이지는".$s_page."
";
echo "현재 블록의 끝 페이지는".$e_page."
";
echo "총 페이지는".$pageNum."
";
echo "총 블록은".$blockNum."
";
*/
$s_point = ($page-1) * $list;
$new_sql = "select wn.wr_id, wn.wr_content, wn.wr_subject, wn.wr_datetime, bf.bf_source, bf.bf_file from g4_write_news as wn left join g4_board_file as bf on wn.wr_id=bf.wr_id $where order by wn.wr_datetime desc LIMIT $s_point,$list";
$new_sql_result=mysql_query($new_sql);
?>
![]() |
=$row[wr_subject]?>=$row[wr_content]?>
=$row[wr_datetime]?>
|
![]() |