session_start();
include_once $_SERVER['DOCUMENT_ROOT']."/common/inc/config.php";
include_once $_SERVER['DOCUMENT_ROOT']."/common/inc/db.php";
include_once $_SERVER['DOCUMENT_ROOT']."/common/inc/function.php";
$mod = new mod();
?>
UTIMS MINI (Centerless Lifting) - NEWS
$search_keyword = $mod->trans(trim($_REQUEST["search_keyword"]));
$var_Page = $mod->trans(trim($_REQUEST["page"]));
$search_language = "CN";
if ($search_division == "") $search_division = "ALL";
if ($search_language == "") $search_language = "CN";
$pagesize = 15;
if ($var_Page == "") $var_Page = 1;
$START_NUMBER = ($var_Page - 1) * $pagesize;
$var_AddSQL = "";
$var_AddSQL = " WHERE A.DEL_YN='N' AND A.DIVISION=:division AND A.LANGUAGE_TYPE='".$search_language."'";
$param[] = array(":division"=>$search_division);
$list[] = "search_division=".$search_division;
If ($search_keyword != "") {
$var_AddSQL .= " AND ( SUBJECT LIKE CONCAT('%',:keyword1,'%') OR CONTENT LIKE CONCAT('%',:keyword2,'%')) ";
$param[] = array(":keyword1"=>$search_keyword);
$param[] = array(":keyword2"=>$search_keyword);
$list[] = "search_keyword=".$search_keyword;
}
$cntq = "SELECT COUNT(*) cnt FROM TB_BOARD_NOTICE A ".$var_AddSQL;
$stmt = $mod->select($pdo, $cntq, $param);
$row = $stmt->fetch(PDO::FETCH_ASSOC);
$total_record = $row["cnt"];
$stmt->closeCursor();
$query = "SELECT A.BOARD_SEQ";
$query .= ", A.DIVISION";
$query .= ", A.SUBJECT";
$query .= ", A.CONTENT";
$query .= ", A.HIT";
$query .= ", A.NOTICE_YN";
$query .= ", A.EDITOR_YN";
$query .= ", A.VIEW_YN";
$query .= ", A.DEL_YN";
$query .= ", A.LANGUAGE_TYPE";
$query .= ", A.REG_DATE";
$query .= ", A.USER_NAME";
$query .= ", A.PASSWORD";
$query .= ", A.USER_DIVISION";
$query .= ", A.USER_SEQ";
$query .= ", A.ETC_1";
$query .= ", A.ETC_2";
$query .= ", A.ETC_3";
$query .= " FROM TB_BOARD_NOTICE A ".$var_AddSQL;
$query .= " ORDER BY A.REG_DATE DESC LIMIT ".$START_NUMBER.",".$pagesize;
$result = $mod->select($pdo, $query, $param);
//echo $query;
if ($total_record % $pagesize != 0) $tt_page = intval($total_record / $pagesize) + 1;
else $tt_page = intval($total_record / $pagesize);
?>
NEWS & EVENTS
$list = implode("&",$list);
echo $mod -> frontpaging($var_Page, $tt_page, $list);
?>