¹è³Ê¿¡ Ä«¿îÅÍ ´Þ±â >> ÀÛ¼ºÀÚ : ÀåÇüÈ ÀÛ¼ºÀÏ : 2003. 04. 21 ¼öÁ¤ÀÏ : ÀÌ ÇÁ·Î±×·¥Àº ȨÆäÀÌÁö¿¡ ¹è³Ê ±³È¯À» ÇÒ °æ¿ì ¼·Î ¾ó¸¶³ª ÂüÁ¶ÇÏ°í ÀÖ´ÂÁö ¾Ë±âÀ§ÇØ ¸¸µé¾î ºÃ½À´Ï´Ù. ÀÏ´Ü µÎ°³ÀÇ Å×À̺íÀ» »ç¿ëÇÕ´Ï´Ù. bannercount : ³» ȨÇÇÀÇ ¹è³Ê¸¦ ´©¸¦°æ¿ì »ç¿ë bannercnt_refer : ´Ù¸¥ »çÀÌÆ®¿¡¼ µé¾î¿À´Â°æ¿ì »ç¿ë µÎ Å×ÀÌºí ±¸Á¶´Â ¾Æ·¡¿Í °°½À´Ï´Ù. ÇϳªÀÇ Å×À̺íÀ» »ç¿ëÇصµ µÇÁö¸¸ ±×³É µÎ°³¸¦ ÀÌ¿ëÇؼ ¸¸µé¾ú½À´Ï´Ù. (¸¶Áö¸·À¸·Î °»½ÅµÈ ³¯Â¥¸¦ ¾Ë°í ½Í¾î¼ µÎ Å×À̺í·Î ³ª´«°ÅÁÒ.^^) ÀÏ´Ü Å×À̺íÀ» ¸¸µé°í ¹è³Ê¸¦ ±³È¯ÇÒ »çÀÌÆ®ÀÇ Á¤º¸¸¦ Çϳª¾¿ Ãß°¡ÇØ¾ß µË´Ï´Ù. Ãß°¡ÇÏ´Â ÁúÀǹ®ÀÇ ¾Æ·¡ insert ¹®ÀåÀ» º¸½Ã°í banner.com À» ±³È¯ÇÒ »çÀÌÆ®ÀÇ domain À¸·Î º¯°æÇÏ½Ã¸é µË´Ï´Ù. ======================================================================== CREATE TABLE bannercount ( url char(30) not null, month char(6) not null, count int default 0 not null, lasttime date not null, PRIMARY KEY(url) ); # url : »çÀÌÆ® ÁÖ¼Ò # month : Ä«¿îÆ® ´Þ # count : Ä«¿îÆ® ¼ö # lasttime : ¸¶Áö¸· ¾÷µ¥ÀÌÆ® ³¯Â¥ # insert into bannercount values('banner.com', '200304', 0, sysdate()); CREATE TABLE bannercnt_refer ( url char(30) not null, month char(6) not null, count int default 0 not null, lasttime date not null, PRIMARY KEY(url) ); ======================================================================== ###################### # ¹è³Ê¸¦ Ŭ¸¯ÇÑ °æ¿ì ###################### ÀÏ´Ü ¹è³Ê¿¡ ¸µÅ©¸¦ ´ÙÀ½°ú °°ÀÌ °É¾î µÓ´Ï´Ù. ¿©±â¼ click.html À» ÀÌ¿ëÇؼ Ä«¿îÅ͸¦ Áõ°¡ÇÏ°Ô µË´Ï´Ù. ±×¸®°í³ª¼´Â http://banner.com À¸·Î À̵¿À» Çϴ°ÅÁÒ. ¼Ò½º´Â ´ÙÀ½°ú °°½À´Ï´Ù. ======================================================================== // file : click.html # # ¹è³Ê Ŭ¸¯½Ã Ä«¿îÆ® Áõ°¡ # ## GET : QUERY_STRING /********************************************* µ¥ÀÌÅÍ Á¢¼Ó ºÎºÐÀ» ¼³Á¤Çϼ¼¿ä *********************************************/ $hostname = "È£½ºÆ®À̸§"; $username = "»ç¿ëÀÚÀ̸§"; $password = "»ç¿ëÀÚºñ¹ø"; $dbname = "DBÀ̸§"; mysql_connect($hostname, $username, $password); $tablename = "bannercount"; if(!$QUERY_STRING) exit; $url = str_replace("http://", "", $QUERY_STRING); $today = getdate(); $month = $today['month']; $query = "update $tablename set count=count+1, lasttime=sysdate() where url='$url'"; mysql_query( $query ) or die("E"); mysql_close(); ?>