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

    rowCount(); //echo $cnt; $num = $total_record - ($pagesize * ($var_Page -1)); if ($cnt > 0) { for ($i = 0; $i < $cnt; $i++) { $row = $result->fetch(PDO::FETCH_ASSOC); //내용 변경 //$print_content = strip_tags($row["CONTENT"]); //대표이미지 추출 $var_SQL = " SELECT"; $var_SQL .= " FILE_SEQ"; $var_SQL .= ", FILE_PATH"; $var_SQL .= ", FILE_NAME"; $var_SQL .= ", FILE_SAVE"; $var_SQL .= ", FILE_DESC"; $var_SQL .= ", DOWN_COUNT"; $var_SQL .= ", REG_DATE"; $var_SQL .= " FROM TB_BOARD_NOTICE_FILE"; $var_SQL .= " WHERE BOARD_SEQ=:BOARD_SEQ"; $var_SQL .= " AND FILE_TYPE='attach_one'"; $var_SQL .= " ORDER BY FILE_NO DESC"; $var_SQL .= " Limit 1"; $stmt = $pdo->prepare($var_SQL); $stmt->bindParam(":BOARD_SEQ", $row["BOARD_SEQ"]); $stmt->execute(); $totalc = $stmt->rowCount(); if ($totalc > 0) { for ($x = 0; $x < $totalc; $x++) { $rs = $stmt->fetch(PDO::FETCH_ASSOC); $col_file_seq = trim($rs["FILE_SEQ"]); $col_file_path = trim($rs["FILE_PATH"]); $col_file_name = trim($rs["FILE_NAME"]); $col_file_save = trim($rs["FILE_SAVE"]); $col_file_desc = trim($rs["FILE_DESC"]); $col_file_down_cnt = trim($rs["DOWN_COUNT"]); $col_file_regdate = trim($rs["REG_DATE"]); $print_one_image = ""; } } else { $print_one_image = ""; } ?>
  • ">tit($row["SUBJECT"],45)?>

  • 没有挂号邮寄。

  • closeCursor(); ?>
    frontpaging($var_Page, $tt_page, $list); ?>