$no); //======================================== // Data Load //======================================== $view = $Db->row("SELECT no, sort, best, store, insert_date, name, title, content, likes, hit, tag, etc2 FROM $TABLE_EPILOGUE WHERE no = :no", $param); $keyword = explode("|", $Db->single("SELECT keyword FROM $TABLE_KEYWORD WHERE code = :code", array('code' => "B"))); $no = $view['no']; $sort = $view['sort']; $bestClass = ($view['best'] === "Y") ? "best" : ""; $store = $storeNameArr[$view['store']]; $storeColor = StoreColorClass($view['store']); $insert_date = $view['insert_date']; $name = Utf8SubstrReplace(stripslashes($view['name']), "o"); $title = stripslashes($view['title']); $content = stripslashes($view['content']); $likes = $view['likes']; $hit = $view['hit']; $temp_tag = explode(",", stripslashes($view['tag'])); $tag = implode(",", array_filter($temp_tag)); $etc2 = $view['etc2']; $pnparam = array('sort' => $sort, 'show' => PARAMETER_Y, 'del' => PARAMETER_N, 'best' => $view['best']); if($sd === "likes"){ $pnparam['likes'] = $likes; $prevINS .= "likes > :likes"; $nextINS .= "likes < :likes"; $prevOrderINS .= "likes ASC"; $nextOrderINS .= "likes DESC"; } else if($sd === "hit"){ $pnparam['hit'] = $hit; $prevINS .= "hit > :hit"; $nextINS .= "hit < :hit"; $prevOrderINS .= "hit ASC"; $nextOrderINS .= "hit DESC"; } else { $pnparam['insert_date'] = $insert_date; $prevINS .= "insert_date > :insert_date"; $nextINS .= "insert_date < :insert_date"; $prevOrderINS .= "insert_date ASC"; $nextOrderINS .= "insert_date DESC"; } $prev = $Db->row("SELECT no, store, title FROM $TABLE_EPILOGUE WHERE $prevINS AND sort = :sort AND d_show = :show AND del = :del AND best = :best ORDER BY $prevOrderINS LIMIT 0, 1", $pnparam); $next = $Db->row("SELECT no, store, title FROM $TABLE_EPILOGUE WHERE $nextINS AND sort = :sort AND d_show = :show AND del = :del AND best = :best ORDER BY $nextOrderINS LIMIT 0, 1", $pnparam); if($prev > 0){ $prevTitle = "[".$storeNameArr[$prev['store']]."]".stripslashes($prev['title']); $prevLink = "#".$prev['no']; } else { $prevTitle = "이전글이 없습니다."; $prevLink = "#self"; } if($next > 0){ $nextTitle = "[".$storeNameArr[$next['store']]."]".stripslashes($next['title']); $nextLink = "#".$next['no']; } else { $nextTitle = "다음글이 없습니다."; $nextLink = "#self"; } //첫 이미지 $content_img = explode("src=\"",$content); $content_img = explode("\"",$content_img[1]); $content_img = $content_img[0]; //$imgPath = $content_img; //$ext = array_pop(explode(".",strtolower($content_img))); $parts = explode(".", strtolower($content_img)); $ext = array_pop($parts); $save_path = "../../uploads/thumb/".$no.".".$ext; if(!is_file($save_path)){ if(!preg_match('#http#',$content_img)){ $content_img = "https://www.ssdream.co.kr".$content_img; } if($ext == 'jpg'){ $ori_path = $content_img; $ori_img = imagecreatefromjpeg($ori_path); $info_img = getimagesize($ori_path); $new_img = imagecreatetruecolor(100,100); imagecopyresampled($new_img,$ori_img,0,0,0,0,100,100,$info_img[0],$info_img[1]); imagejpeg($new_img,$save_path); }else if($ext == 'png'){ $ori_path = $content_img; $ori_img = imagecreatefrompng($ori_path); $info_img = getimagesize($ori_path); $new_img = imagecreatetruecolor(100,100); imagecopyresampled($new_img,$ori_img,0,0,0,0,100,100,$info_img[0],$info_img[1]); imagepng($new_img,$save_path); }else if($ext == 'gif'){ $ori_path = $content_img; $ori_img = imagecreatefromgif($ori_path); $info_img = getimagesize($ori_path); $new_img = imagecreatetruecolor(100,100); imagecopyresampled($new_img,$ori_img,0,0,0,0,100,100,$info_img[0],$info_img[1]); imagegif($new_img,$save_path); } } $imgPath = "/uploads/thumb/".$no.".".$ext; //======================================== // 2019-11-13 //======================================== if($_GET['etc2']){ $etc2 = $_GET['etc2']; }else{ $etc2 = 1; } $epirel = $Db->row("SELECT * FROM 2019_epilogue_relate WHERE del = 'N' AND self_view = '".$_GET['no']."'"); $beaf_param = array('show' => PARAMETER_Y, 'del' => PARAMETER_N); if($epirel['self_view']){ $ep1 = $Db->row("SELECT * FROM $TABLE_EPILOGUE WHERE sort = 'A' AND d_show = :show AND del = :del AND no = '".$epirel['self_view']."'", $beaf_param); } if($epirel['real_view']){ $ep2 = $Db->row("SELECT * FROM $TABLE_EPILOGUE WHERE sort = 'B' AND d_show = :show AND del = :del AND no = '".$epirel['real_view']."'", $beaf_param); } $beaf_param = array_merge($beaf_param, array('Bcode' => "photo", 'Ccode' => "photo", 'Bseq' => 1, 'Cseq' => 2)); if($epirel['beaf']){ $beaf = $Db->row("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.d_show = :show AND A.del = :del AND A.no = ".$epirel['beaf']."", $beaf_param); } if($epirel['beaf2']){ $beaf2 = $Db->row("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.d_show = :show AND A.del = :del AND A.no = ".$epirel['beaf2']."", $beaf_param); } $epirel_name = Utf8SubstrReplace(stripslashes($epirel['name']), "o"); preg_match_all("/]*src=[\"']?([^>\"']+)[\"']?[^>]*>/i", $ep1['content'], $matches); preg_match_all("/]*src=[\"']?([^>\"']+)[\"']?[^>]*>/i", $ep2['content'], $matches2); /*$beaf_param = array('show' => PARAMETER_Y, 'del' => PARAMETER_N, 'etc2' => $etc2); $ep1 = $Db->row("SELECT * FROM $TABLE_EPILOGUE WHERE sort = 'A' AND d_show = :show AND del = :del AND etc2 = :etc2", $beaf_param); $ep2 = $Db->row("SELECT * FROM $TABLE_EPILOGUE WHERE sort = 'B' AND d_show = :show AND del = :del AND etc2 = :etc2", $beaf_param); $beaf_param = array_merge($beaf_param, array('Bcode' => "photo", 'Ccode' => "photo", 'Bseq' => 1, 'Cseq' => 2)); $beaf = $Db->row("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.d_show = :show AND A.del = :del AND A.etc2 = :etc2", $beaf_param); preg_match_all("/]*src=[\"']?([^>\"']+)[\"']?[^>]*>/i", $ep1['content'], $matches); preg_match_all("/]*src=[\"']?([^>\"']+)[\"']?[^>]*>/i", $ep2['content'], $matches2); */ //======================================== // Hit Update //======================================== if(!$_COOKIE["HIT::".$TABLE_EPILOGUE."_".$no]){ $hitPlus = $hit + 1; $hitUp = $Db->query("UPDATE $TABLE_EPILOGUE SET hit = :hit WHERE no = :no", array('hit' => $hitPlus, 'no' => $no)); setcookie("HIT::".$TABLE_EPILOGUE."_".$no, time()+(60*60*24)); } $Db->CloseConnection; //======================================== // Meta Tag //======================================== $metaTitle = $title; $metaTitle2 = $title; $metaDescription = StrCut(strip_tags($content), 0, 100); $metaKeyword = $tag; $metaNav = $metaInfo['self_list']['nav']; //======================================== // header Include //======================================== include PATH_INCLUDE."header.php"; //======================================== // Page Auth //======================================== //if(MobileCheck() == "Desktop"){ // 일단 없애봄 170703 // 2020-03-19 검색엔진은 통과시키기 // 2020-05-25 header까지는 나오게하기 if( preg_match('#Yeti#',$_SERVER['HTTP_USER_AGENT']) || preg_match('#Googlebot#',$_SERVER['HTTP_USER_AGENT']) || preg_match('#GoogleDocs#',$_SERVER['HTTP_USER_AGENT']) ){ }else{ //echo $_SERVER['HTTP_USER_AGENT']; AuthCheck2($_SESSION['MEMBER_LOGIN_EXIST'],$_GET['no']); } ?> '1', 'title' => 'a1b1.jpg', 'no' => '27'), array('seq' => '2', 'title' => 'a1b2.jpg', 'no' => '1229'), array('seq' => '3', 'title' => 'a1b3.jpg', 'no' => '1927') ); $tmp2 = array( array('seq' => '1', 'title' => '아들의 꿈을 지켜주셔서 감사해요!', 'no' => '2201'), array('seq' => '2', 'title' => '딸이 원장님 이름 등에 붙이고 다니고 싶대요!', 'no' => '1816'), array('seq' => '3', 'title' => '아들의 상황 이해해주셔서 너무 감사합니다.', 'no' => '724') ); $tmp3 = array( array('seq' => '1', 'title' => '남편, 이해해줘서 고마워요!', 'no' => '1426'), array('seq' => '2', 'title' => '부부가 함께 받는 코수술 의지 됩니다.', 'no' => '1445'), array('seq' => '3', 'title' => '코골이 해결 후 와이프가 좋아해요!', 'no' => '1140') ); $tmp4 = array( array('seq' => '1', 'title' => '코수술 후 인정받고 포상휴가도 많이 받았습니다!', 'no' => '2259'), array('seq' => '2', 'title' => '군인분들 코수술 적극 추천합니다!', 'no' => '1723'), array('seq' => '3', 'title' => '휴가 기간 중 코수술 만족 합니다!', 'no' => '2111') ); ?>
HOME  >  ".$metaNav[4]."  > "; } if($metaNav[3]){ echo "".$metaNav[3]."  > "; } if($metaNav[2]){ echo "".$metaNav[2]."  > "; } if($metaNav[1]){ echo "".$metaNav[1]."  > "; } echo "".$metaNav[0].""; ?>

수술자필후기

환자분이 자필로 직접 알려주는 삼성드림이비인후과!

문서 BEST 자필후기 작성자 등록일 조회
님의 리얼후기영상 보기
님의 리얼후기 보기
님의 전후사진 보기
  • /'>

    코성형 전후사진 aaa

    수술후 3개월

    /'>
  • /'>

    코성형 전후사진 aaa

    수술후 3개월

    /'>
수술자필후기
  • 수술자필후기
'1', 'title' => 'a1b1.jpg', 'no' => '27'), array('seq' => '2', 'title' => 'a1b2.jpg', 'no' => '1229'), array('seq' => '3', 'title' => 'a1b3.jpg', 'no' => '1927') ); $tmp2 = array( array('seq' => '1', 'title' => '아들의 꿈을 지켜주셔서 감사해요!', 'no' => '2201'), array('seq' => '2', 'title' => '딸이 원장님 이름 등에 붙이고 다니고 싶대요!', 'no' => '1816'), array('seq' => '3', 'title' => '아들의 상황 이해해주셔서 너무 감사합니다.', 'no' => '724') ); $tmp3 = array( array('seq' => '1', 'title' => '남편, 이해해줘서 고마워요!', 'no' => '1426'), array('seq' => '2', 'title' => '부부가 함께 받는 코수술 의지 됩니다.', 'no' => '1445'), array('seq' => '3', 'title' => '코골이 해결 후 와이프가 좋아해요!', 'no' => '1140') ); $tmp4 = array( array('seq' => '1', 'title' => '코수술 후 인정받고 포상휴가도 많이 받았습니다!', 'no' => '2259'), array('seq' => '2', 'title' => '군인분들 코수술 적극 추천합니다!', 'no' => '1723'), array('seq' => '3', 'title' => '휴가 기간 중 코수술 만족 합니다!', 'no' => '2111') ); ?>
    '; } ?>
    '; } ?>
    '; } ?>
    '; } ?>
이전 글 다음 글

    수술후기 모아보기

      $val){ ?>