:) dlrow ym ot emocleW :) dlrow ym ot emocleW

\n"; $additional.= "Reply-to: $sender\n"; $additional.= "Content-Type: text/html; charset=EUC-KR"; $val = mail($receiver, $title, $content, $additional); if($val > 0){ return true; //echo "메일 보내기 성공"; }else{ return false; //echo "메일 보내기 실패"; }}?>

글 쿼리부분 // db 객체 생성 $db = new MysqlClass; // 검색어 찾기 $shTitle = ($_GET['shTitle']) ? $_GET['shTitle'] : $_POST['shTitle']; $shKey = ($_GET['shKey']) ? $_GET['shKey'] : $_POST['shKey']; $searchQue = "where 1 "; $searchQue .= ($shTitle && $shKey) ? " and ".$shTitle." like '%".$shKey."%' " : NULL; $sortQue =" order by ref desc, seq asc"; // 스타트 찾기 $start = ($_GET['start']) ? $_GET['start'] : $_POST['..

if($_SERVER["REMOTE_ADDR"] == "211.217.103.53"){ include $_SERVER[DOCUMENT_ROOT]."/include/main_popup.php"; }

class cookie{ var $cookie; var $key; var $name = 'information'; var $time = 0; var $loc = '/'; var $limit = 5000; function cookie(){ $this->key = $this->name; if(get_magic_quotes_gpc()){ $cookie = stripslashes($_COOKIE[$this->key]); }else{ $cookie = $_COOKIE[$this->key]; } $this->cookie = unserialize($cookie); } function add($name, $value){ $this->cookie[$name] = $value; } function burn(){ $seri..

where절에서 case when 예제 update term_info set term_event = case when term_idx = 'termCheck' then 'term_check' else 'N' end";

select date_add(term_date_start,interval 30 day) from term_info

mysql_query('set names utf8'); mysql_query("set session character_set_connection=utf8;"); mysql_query("set session character_set_results=utf8;"); mysql_query("set session character_set_client=utf8;");

datediff(시간형식,비교시간a,비교시간b) select u_no,datediff(s,u_reg_updated,u_reg_start),* from exam_user where u_no in( select (case when datediff(mi,u_reg_start,u_reg_updated) > 90 then u_no end) as u_no from exam_user)