'/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
//========================================
if(!$type){
$type = 'A';
}
$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 = "&no=$no&category=$category&type=$type";
//========================================
// 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 AND type='".$type."'", $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,';
$addOrderQry = 'CASE A.no
WHEN 47 THEN 0
WHEN 39 THEN 1
WHEN 28 THEN 2
WHEN 19 THEN 3
WHEN 206 THEN 100
ELSE 10 END,
A.no DESC,';
}else if($category == 'B1'){
$addOrderQry = 'CASE A.no
WHEN 184 THEN 0
WHEN 10 THEN 1
WHEN 12 THEN 2
WHEN 29 THEN 3
ELSE 10 END,
A.no DESC,';
/*
$addOrderQry = 'CASE A.no
WHEN 10 THEN 0
WHEN 12 THEN 1
WHEN 29 THEN 2
WHEN 52 THEN 3
ELSE 10 END,
A.no DESC,';*/
}else if($category == 'B2'){
$addOrderQry = 'CASE A.no
WHEN 13 THEN 0
WHEN 26 THEN 1
WHEN 54 THEN 2
WHEN 65 THEN 3
ELSE 10 END,
A.no DESC,';
}else if($category == 'A2'){
$addOrderQry = 'CASE A.no
WHEN 4 THEN 0
WHEN 23 THEN 1
WHEN 46 THEN 2
WHEN 68 THEN 3
ELSE 10 END,
A.no DESC,';
}else if($category == 'A3'){
$addOrderQry = 'CASE A.no
WHEN 197 THEN 0
WHEN 9 THEN 1
WHEN 18 THEN 2
WHEN 61 THEN 3
WHEN 51 THEN 4
ELSE 10 END,
A.no DESC,';
}else if ($category == 'A7'){
$addOrderQry = 'CASE A.no
WHEN 196 THEN 0
WHEN 185 THEN 1
ELSE 10 END,
A.no DESC,';
}
//========================================
// landing Include
//========================================
switch ($category) {
case 'A1':
$landing_key = "n_dns";
$origin_path = "nsurgery/".$landing_key;
//$landing_title = "비중격만곡증 수술";
break;
case 'A2':
if(!$tab){ $tab = 1;}
$landing_key = "n_congestion".$tab;
$origin_path = "nsurgery/".$landing_key;
//if($tab == 1){ $landing_title = "비염수술"; }else if($tab == 2){ $landing_title = "코막힘/비염"; }
break;
case 'A3':
//if(!$tab){ $tab = 1;}
$landing_key = "nsurgery4".$tab;
$origin_path = "nsurgery/".$landing_key;
//if($tab == 1){ $landing_title = "축농증 수술"; }else if($tab == 2){ $landing_title = "축농증"; }
break;
case 'A4':
$landing_key = "nsurgery5";
$origin_path = "nsurgery/".$landing_key;
//$landing_title = "코골이/수면무호흡증";
break;
case 'A5':
$landing_key = "nsurgery6";
$origin_path = "nsurgery/".$landing_key;
break;
case 'A7':
$landing_key = "nsurgery7";
$origin_path = "nsurgery/".$landing_key;
break;
case 'B1':
$landing_key = "n_band";
$origin_path = "nplastic/".$landing_key;
break;
case 'B2':
$landing_key = "n_updown";
$origin_path = "nplastic/".$landing_key;
break;
case 'B3':
$landing_key = "nplastic3";
$origin_path = "nplastic/".$landing_key;
break;
case 'B4':
$landing_key = "nplastic4";
$origin_path = "nplastic/".$landing_key;
break;
case 'B5':
$landing_key = "n_flat_nose";
$origin_path = "nplastic/".$landing_key;
break;
case 'B6':
$landing_key = "nplastic6";
$origin_path = "nplastic/".$landing_key;
break;
case 'B7':
$landing_key = "n_fracture";
$origin_path = "nplastic/".$landing_key;
break;
case 'B8':
$landing_key = "nplastic8";
$origin_path = "nplastic/".$landing_key;
break;
default:
$landing_key = "n_dns";
$origin_path = "nsurgery/".$landing_key;
break;
}
$metaNav = $metaInfo[$landing_key]['nav'];
//$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,A.youtube, 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 AND type = '".$type."' ORDER BY $addOrderQry A.reg_date DESC LIMIT :startNum, :rowCount", $param);
/*$param2 = array('no' => PARAMETER_NO, 'show' => PARAMETER_Y, 'del' => PARAMETER_N);
$totalCount2 = $Db->single("SELECT COUNT(*) FROM $TABLE_POST WHERE no > :no AND d_show = :show AND del = :del AND category LIKE :category AND type='B'", $param);
$totalPages2 = ceil($totalCount2 / $rowCount);
$param2 = array_merge($param2, array('startNum' => $startNum, 'rowCount' => $rowCount));
//echo $param2[startNum];
$searchINS = "";
$orderINS = "no DESC";
$list2 = $Db->query("SELECT no, best, store, title, content, hit, youtube, likes, tag FROM 2015_post3 WHERE no > :no AND d_show = :show AND del = :del $searchINS ORDER BY $orderINS LIMIT :startNum, :rowCount", $param2);
echo "SELECT no, best, store, title, content, hit, youtube, likes, tag FROM 2015_post3 WHERE no > :no AND d_show = :show AND del = :del $searchINS ORDER BY $orderINS LIMIT :startNum, :rowCount";
echo "
";
print_r($param2);
*/
$Db->CloseConnection;
include_once PATH_INCLUDE."header.php";
include_once PATH_LANDING.$landing_key.".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'];
?>
-
- 내용이 없습니다.
0){
foreach($list as $key => $val){
$no = $val['no'];
$best = ($val['best'] === "Y" && $sb === "Y") ? "best" : "";
$store = $storeNameArr[$val['store']];
$storeColor = StoreColorClass($val['store']);
$name = Utf8SubstrReplace(stripslashes($val['name']), "o");
$title = stripslashes($val['title']);
$content = stripslashes($val['content']);
preg_match("/]*src=[\"']?([^>\"']+)[\"']?[^>]*>/i", $content, $contImg);
$imgPath = "https://i.ytimg.com/vi/".$val['youtube']."/mqdefault.jpg";
$likes = $val['likes'];
$hit = $val['hit'];
$insert_date = DateConv($val['insert_date'], 7);
$tag = $val['tag'];
$tag_arr = explode(',',$tag);
$mTagMatch = 0;
foreach($tag_arr as $kw){
if(in_array($kw, $mTagArr)){
$mTagMatch = 1;
}
}
?>
-
- 내용이 없습니다.