//======================================== // dehead(config/function/lib) Include //======================================== include $_SERVER['DOCUMENT_ROOT']."/front/include/dehead.php"; //======================================== // Meta Tag //======================================== $metaTitle = $metaInfo['nbeaf']['title']; $metaDescription = $metaInfo['nbeaf']['description']; $metaKeyword = $metaInfo['nbeaf']['keyword']; $metaImage = $metaInfo['nbeaf']['image']; $metaNav = $metaInfo['nbeaf']['nav']; //======================================== // Class Connect //======================================== $Db = new Db(); // 데이터 베이스 클래스 //======================================== // Data Process //======================================== $rowCount = $pageInfo['photo']['rowCount']; // 한 페이지에 보여질 게시물 수 if($tmp == 1){ $rowCount = 12; } $startNum = ($page - 1) * $rowCount; // limit 시작 위치 $param = array('no' => PARAMETER_NO, 'show' => PARAMETER_Y, 'del' => PARAMETER_N); //======================================== // Search Query //======================================== if($st){ $param['tag'] = $Db->likeify($st); $searchINS .= " AND tag LIKE :tag"; } $addPath = "&st=".urlencode($st); //======================================== // Data Load //======================================== $totalCount = $Db->single("SELECT COUNT(*) FROM $TABLE_PHOTO WHERE no > :no AND d_show = :show AND del = :del $searchINS", $param); $totalPages = ceil($totalCount / $rowCount); //bklee160407 지점 태그일 때만 베스트 상위노출 if($st){ if($st == '강남점' or $st == '삼성점' or $st == '노원점' or $st == '종로점' or $st == '일산점' ){ $b_bestINS = "A.b_best DESC,"; } $metaTitle2 = $st." 전후사진"; } //190906 if($tmp == 1){ $b_bestINS = "CASE A.no WHEN 6798 THEN 0 WHEN 6797 THEN 1 WHEN 6792 THEN 2 WHEN 6791 THEN 3 WHEN 6754 THEN 4 WHEN 6753 THEN 5 WHEN 6750 THEN 6 WHEN 6749 THEN 7 WHEN 6732 THEN 8 WHEN 6731 THEN 9 WHEN 6418 THEN 10 WHEN 6417 THEN 11 ELSE 12 END, A.no DESC,"; } $param = array_merge($param, array('Bcode' => "photo", 'Ccode' => "photo", 'Bseq' => 1, 'Cseq' => 2, 'startNum' => $startNum, 'rowCount' => $rowCount)); $list = $Db->query("SELECT A.no, A.title, A.before_content, A.after_content, A.reg_date, A.etc1, B.attach AS attach1, B.attach_ori AS attach_ori1, B.mod_date AS mod_date1, C.attach AS attach2, C.attach_ori AS attach_ori2, C.mod_date AS mod_date2 FROM $TABLE_PHOTO A LEFT JOIN $TABLE_ATTACH B ON A.no = B.wno AND B.code = :Bcode AND B.seq = :Bseq LEFT JOIN $TABLE_ATTACH C ON A.no = C.wno AND C.code = :Ccode AND C.seq = :Cseq WHERE A.no > :no AND A.d_show = :show AND A.del = :del AND A.reg_date < now() $searchINS ORDER BY $b_bestINS A.reg_date DESC, A.no DESC LIMIT :startNum, :rowCount", $param); $keyword = explode("|", $Db->single("SELECT keyword FROM $TABLE_KEYWORD WHERE code = :code", array('code' => "A"))); $Db->CloseConnection; //$metaTitle2 = $metaTitle2." ".$page; $metaNav[0] = $metaNav[0]." ".$page; //======================================== // header Include //======================================== include PATH_INCLUDE."header.php"; ?>
수술후 3//=$etc1?>개월
**수술 후 출혈, 감염, 염증 등의 합병증이 있을 수 있으며 주관적인 만족도는 개인마다 차이가 있을 수 있으므로 의사와 상의하시기 바랍니다.**