'/front/nsurgery/n_dns.php',
// 'A2' => '/front/nsurgery/n_congestion1.php',
// 'A3' => '/front/nsurgery/nsurgery4.php',
// 'A4' => '/front/nsurgery/nsurgery5.php',
// 'A5' => '/front/nsurgery/nsurgery6.php',
// 'B1' => '/front/nplastic/n_band.php',
// 'B2' => '/front/nplastic/n_updown.php',
// 'B3' => '/front/nplastic/nplastic3.php',
// 'B4' => '/front/nplastic/nplastic4.php',
// 'B5' => '/front/nplastic/n_flat_nose.php',
// 'B6' => '/front/nplastic/nplastic6.php',
// 'B7' => '/front/nplastic/n_fracture.php',
// 'B8' => '/front/nplastic/nplastic8.php'
// );
// if($request_category){
// if(in_array($request_uri, $reqeust_arr) == FALSE){
// echo "\n";
// exit;
// }
// }
include_once $_SERVER['DOCUMENT_ROOT']."/front/include/dehead.php";
//========================================
// Class Connect
//========================================
$Db = new Db(); // 데이터 베이스 클래스
//========================================
// Data Process
//========================================
$rowCount = $pageInfo['post']['rowCount']; // 한 페이지에 보여질 게시물 수
$startNum = ($page - 1) * $rowCount; // limit 시작 위치
//$param = array('no' => PARAMETER_NO, 'show' => PARAMETER_Y, 'del' => PARAMETER_N, 'disease' => $disease, 'category' => $Db->likeify($category));
$param = array('no' => PARAMETER_NO, 'show' => PARAMETER_Y, 'del' => PARAMETER_N, 'category' => $Db->likeify($category));
//$addPath = "&category=$category&disease=$disease#tab";
$addPath = "&category=$category#tab";
//========================================
// Data Load
//========================================
//$totalCount = $Db->single("SELECT COUNT(*) FROM $TABLE_POST WHERE no > :no AND d_show = :show AND del = :del AND disease = :disease AND category LIKE :category", $param);
$totalCount = $Db->single("SELECT COUNT(*) FROM $TABLE_POST WHERE no > :no AND d_show = :show AND del = :del AND category LIKE :category", $param);
$totalPages = ceil($totalCount / $rowCount);
$param = array_merge($param, array('startNum' => $startNum, 'rowCount' => $rowCount, 'code' => "post", 'seq' => PARAMETER_ONE));
//2017-08-03
if($category=='A1'){
$addOrderQry = '(A.no = 19 or A.no = 28 or A.no = 39 or A.no = 47) DESC,';
}
//$list = $Db->query("SELECT A.no, A.category, A.title, A.content, A.hit, A.reg_date, B.no AS fno, B.attach, B.attach_ori, B.mod_date FROM $TABLE_POST A LEFT JOIN $TABLE_ATTACH B ON A.no = B.wno AND B.code = :code AND B.seq = :seq WHERE A.no > :no AND A.d_show = :show AND A.del = :del AND A.disease = :disease AND A.category LIKE :category ORDER BY A.reg_date DESC LIMIT :startNum, :rowCount", $param);
$list = $Db->query("SELECT A.no, A.category, A.title, A.content, A.hit, A.reg_date, B.no AS fno, B.attach, B.attach_ori, B.mod_date FROM $TABLE_POST A LEFT JOIN $TABLE_ATTACH B ON A.no = B.wno AND B.code = :code AND B.seq = :seq WHERE A.no > :no AND A.d_show = :show AND A.del = :del AND A.category LIKE :category ORDER BY $addOrderQry A.reg_date DESC LIMIT :startNum, :rowCount", $param);
$Db->CloseConnection;
include_once PATH_INCLUDE."header.php";
?>
0){
foreach ($list as $key => $val) {
$no = $val['no'];
$title = stripslashes($val['title']);
$content = stripslashes($val['content']);
$imgPath = ($val['attach']) ? $pathInfo['post']['file'].DateConv($val['mod_date'], 3)."/".$val['attach'] : PATH_IMAGES."/common/no_img.png";
$content = StrCut(strip_tags($content), 0, 125, "...");
$reg_date = DateConv($val['reg_date'], 11);
$hit = $val['hit'];
?>
-
- 내용이 없습니다.