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

프로그램

• [php]ip로 차단,REMOTE_ADDR

  프로그램/php 2013. 7. 21. 17:15

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

  Read More

• [php]쿠키 클래스,cookie

  프로그램/php 2013. 7. 21. 17:12

  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..

  Read More

• where절에서 case when 예제

  프로그램/db 2013. 7. 21. 14:49

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

  Read More

• MS-SQL : 날짜 더하기 함수

  프로그램/db 2013. 7. 21. 14:47

  select date_add(term_date_start,interval 30 day) from term_info

  Read More

• [php]MY-SQL 인코딩 변경, set name utf8

  프로그램/php 2013. 7. 21. 14:46

  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;");

  Read More

• MY-SQL - 시간차이 함수

  프로그램/db 2013. 7. 21. 14:46

  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)

  Read More

• 가상테이블만들어 서브쿼리 날리기

  프로그램/db 2013. 7. 21. 14:43

  select (select count(*) from chul where chul_subject = b and chul_id = a)+ (select count(*) from chul_practice where chul_subject = b and chul_id = a) from (select 'alakog'as a,183 as b) as tab

  Read More

• MY-SQL - isnull

  프로그램/db 2013. 7. 21. 14:42

  SELECT ifnull(thumbImg,'noImg')FROM `board_gallery` WHERE 1

  Read More