우리말교육현장연구

REQUEST['find_field']) : ''); $get_word = escape_string($_REQUEST['find_word'],'1'); $get_ordby = preg_replace('/[^a-zA-Z0-9_,]/','',(string)$_REQUEST['ordby']); $get_viewtype = escape_string($_REQUEST['find_viewtype']); $get_page = intval($_GET['page']); $get_plist = intval($_REQUEST['plist']); $get_mode = escape_string($_REQUEST['find_mode']); $pagePerBlock = "10"; empty($get_plist) ? $pagesize = "12" : $pagesize = $get_plist; /// 페이지출력수 empty($get_page) ? $page = 1 : $page = $get_page; /// 페이지번호 $pageurl = $_SERVER['PHP_SELF']; $perpage = ($page-1) * $pagesize; $search = "plist=".$get_plist."&find_field=".$get_field."&find_word=".$get_word."&find_state=".$find_state."&find_ordby=".$get_ordby."&conf=".$conf."&find_mode=".$find_mode."&mode=".$mode."&language=".$get_language; ///정렬 if(empty($get_ordby)){ $ORDER_BY = ""; }else{ $ORDER_BY = str_replace("__"," ",$get_ordby).","; } ///검색정보 $where_add =""; if(!empty($get_field) && !empty($get_word)){ $where_add .= " AND ".$get_field." like '%".$get_word."%'"; } if(!empty($get_viewtype)){ //상태정보 $where_add .= " AND viewtype = '".$find_viewtype."'"; } if(!empty($get_mode)){ //분류 $where_add .= " AND mode = '".$get_mode."'"; } if(!empty($mode)){ //분류 $where_add .= " AND mode = '".$mode."'"; } /// 갯수뽑기용 쿼리 $count_query = "SELECT COUNT(*) FROM $tablename WHERE 1=1 ".$where_add; $total_num = $db->select_one( $count_query ); // ===== 디버그: 카운트 결과 ===== error_log("[BBOARD2-LIST] count_query: " . $count_query); error_log("[BBOARD2-LIST] total_num: " . $total_num); if(!empty($total_num)){ //연결 URL, 총번호, 한페이지갯수, 최대페이지번호, 현재페이지, 서치 $pageNavi = $common->paging_new($pageurl, $total_num, $pagesize, $pagePerBlock, $page, $search); $pageNaviHTML = $pageNavi; ///페이징 //목록 출력 적용 $limit = "limit $perpage, $pagesize"; $numbers = $total_num - $perpage; $query = "SELECT * FROM $tablename WHERE topview!='Y' and viewtype!='N' $w_sql ".$where_add." $wsql_lantype ORDER BY ".$ORDER_BY." reg_date desc"; // 전체 쿼리에 제한 걸기 $query = $query ." ".$limit; //echo "$query ///
"; $result = $db->fetch_array( $query ); $rcount = count((array)$result) ; } $totalNumOfPage = ceil($total_num/$pagesize); ?> REQUEST['ordby']); $get_viewtype = escape_string($_REQUEST['find_viewtype']); $get_page = intval($_GET['page']); $get_plist = intval($_REQUEST['plist']); $get_mode = escape_string($_REQUEST['find_mode']); $pagePerBlock = "10"; empty($get_plist) ? $pagesize = "12" : $pagesize = $get_plist; /// 페이지출력수 empty($get_page) ? $page = 1 : $page = $get_page; /// 페이지번호 $pageurl = $_SERVER['PHP_SELF']; $perpage = ($page-1) * $pagesize; $search = "plist=".$get_plist."&find_field=".$get_field."&find_word=".$get_word."&find_state=".$find_state."&find_ordby=".$get_ordby."&conf=".$conf."&find_mode=".$find_mode."&mode=".$mode."&language=".$get_language; ///정렬 if(empty($get_ordby)){ $ORDER_BY = ""; }else{ $ORDER_BY = str_replace("__"," ",$get_ordby).","; } ///검색정보 $where_add =""; if(!empty($get_field) && !empty($get_word)){ $where_add .= " AND ".$get_field." like '%".$get_word."%'"; } if(!empty($get_viewtype)){ //상태정보 $where_add .= " AND viewtype = '".$find_viewtype."'"; } if(!empty($get_mode)){ //분류 $where_add .= " AND mode = '".$get_mode."'"; } if(!empty($mode)){ //분류 $where_add .= " AND mode = '".$mode."'"; } /// 갯수뽑기용 쿼리 $count_query = "SELECT COUNT(*) FROM $tablename WHERE 1=1 ".$where_add; $total_num = $db->select_one( $count_query ); // ===== 디버그: 카운트 결과 ===== error_log("[BBOARD2-LIST] count_query: " . $count_query); error_log("[BBOARD2-LIST] total_num: " . $total_num); if(!empty($total_num)){ //연결 URL, 총번호, 한페이지갯수, 최대페이지번호, 현재페이지, 서치 $pageNavi = $common->paging_new($pageurl, $total_num, $pagesize, $pagePerBlock, $page, $search); $pageNaviHTML = $pageNavi; ///페이징 //목록 출력 적용 $limit = "limit $perpage, $pagesize"; $numbers = $total_num - $perpage; $query = "SELECT * FROM $tablename WHERE topview!='Y' and viewtype!='N' $w_sql ".$where_add." $wsql_lantype ORDER BY ".$ORDER_BY." reg_date desc"; // 전체 쿼리에 제한 걸기 $query = $query ." ".$limit; //echo "$query ///
"; $result = $db->fetch_array( $query ); $rcount = count((array)$result) ; } $totalNumOfPage = ceil($total_num/$pagesize); ?> GET['page']); $get_plist = intval($_REQUEST['plist']); $get_mode = escape_string($_REQUEST['find_mode']); $pagePerBlock = "10"; empty($get_plist) ? $pagesize = "12" : $pagesize = $get_plist; /// 페이지출력수 empty($get_page) ? $page = 1 : $page = $get_page; /// 페이지번호 $pageurl = $_SERVER['PHP_SELF']; $perpage = ($page-1) * $pagesize; $search = "plist=".$get_plist."&find_field=".$get_field."&find_word=".$get_word."&find_state=".$find_state."&find_ordby=".$get_ordby."&conf=".$conf."&find_mode=".$find_mode."&mode=".$mode."&language=".$get_language; ///정렬 if(empty($get_ordby)){ $ORDER_BY = ""; }else{ $ORDER_BY = str_replace("__"," ",$get_ordby).","; } ///검색정보 $where_add =""; if(!empty($get_field) && !empty($get_word)){ $where_add .= " AND ".$get_field." like '%".$get_word."%'"; } if(!empty($get_viewtype)){ //상태정보 $where_add .= " AND viewtype = '".$find_viewtype."'"; } if(!empty($get_mode)){ //분류 $where_add .= " AND mode = '".$get_mode."'"; } if(!empty($mode)){ //분류 $where_add .= " AND mode = '".$mode."'"; } /// 갯수뽑기용 쿼리 $count_query = "SELECT COUNT(*) FROM $tablename WHERE 1=1 ".$where_add; $total_num = $db->select_one( $count_query ); // ===== 디버그: 카운트 결과 ===== error_log("[BBOARD2-LIST] count_query: " . $count_query); error_log("[BBOARD2-LIST] total_num: " . $total_num); if(!empty($total_num)){ //연결 URL, 총번호, 한페이지갯수, 최대페이지번호, 현재페이지, 서치 $pageNavi = $common->paging_new($pageurl, $total_num, $pagesize, $pagePerBlock, $page, $search); $pageNaviHTML = $pageNavi; ///페이징 //목록 출력 적용 $limit = "limit $perpage, $pagesize"; $numbers = $total_num - $perpage; $query = "SELECT * FROM $tablename WHERE topview!='Y' and viewtype!='N' $w_sql ".$where_add." $wsql_lantype ORDER BY ".$ORDER_BY." reg_date desc"; // 전체 쿼리에 제한 걸기 $query = $query ." ".$limit; //echo "$query ///
"; $result = $db->fetch_array( $query ); $rcount = count((array)$result) ; } $totalNumOfPage = ceil($total_num/$pagesize); ?> REQUEST['plist']); $get_mode = escape_string($_REQUEST['find_mode']); $pagePerBlock = "10"; empty($get_plist) ? $pagesize = "12" : $pagesize = $get_plist; /// 페이지출력수 empty($get_page) ? $page = 1 : $page = $get_page; /// 페이지번호 $pageurl = $_SERVER['PHP_SELF']; $perpage = ($page-1) * $pagesize; $search = "plist=".$get_plist."&find_field=".$get_field."&find_word=".$get_word."&find_state=".$find_state."&find_ordby=".$get_ordby."&conf=".$conf."&find_mode=".$find_mode."&mode=".$mode."&language=".$get_language; ///정렬 if(empty($get_ordby)){ $ORDER_BY = ""; }else{ $ORDER_BY = str_replace("__"," ",$get_ordby).","; } ///검색정보 $where_add =""; if(!empty($get_field) && !empty($get_word)){ $where_add .= " AND ".$get_field." like '%".$get_word."%'"; } if(!empty($get_viewtype)){ //상태정보 $where_add .= " AND viewtype = '".$find_viewtype."'"; } if(!empty($get_mode)){ //분류 $where_add .= " AND mode = '".$get_mode."'"; } if(!empty($mode)){ //분류 $where_add .= " AND mode = '".$mode."'"; } /// 갯수뽑기용 쿼리 $count_query = "SELECT COUNT(*) FROM $tablename WHERE 1=1 ".$where_add; $total_num = $db->select_one( $count_query ); // ===== 디버그: 카운트 결과 ===== error_log("[BBOARD2-LIST] count_query: " . $count_query); error_log("[BBOARD2-LIST] total_num: " . $total_num); if(!empty($total_num)){ //연결 URL, 총번호, 한페이지갯수, 최대페이지번호, 현재페이지, 서치 $pageNavi = $common->paging_new($pageurl, $total_num, $pagesize, $pagePerBlock, $page, $search); $pageNaviHTML = $pageNavi; ///페이징 //목록 출력 적용 $limit = "limit $perpage, $pagesize"; $numbers = $total_num - $perpage; $query = "SELECT * FROM $tablename WHERE topview!='Y' and viewtype!='N' $w_sql ".$where_add." $wsql_lantype ORDER BY ".$ORDER_BY." reg_date desc"; // 전체 쿼리에 제한 걸기 $query = $query ." ".$limit; //echo "$query ///
"; $result = $db->fetch_array( $query ); $rcount = count((array)$result) ; } $totalNumOfPage = ceil($total_num/$pagesize); ?>