°ñµåÆÁ]]> <![CDATA[happycgi > °ñµåÆÁ]]> °ñµåÆÁ]]> °ñµåÆÁ https://happycgi.com/community/ Á¦°ø, All rights reserved.]]> Thu, 18 Apr 2024 11:43:37 Thu, 18 Apr 2024 11:43:37 <![CDATA[±×·ì³» ¹è³ÊµéÀ» ¸î °³ ¸ðµëÀ¸·Î ³ª´©¾î °ñ°í·ç Ãâ·ÂÇϱâ]]> ±×·ì³» ¹è³Ê Àüü¸¦ n°³ ¸ðµÒÀ¸·Î ³ª´©¾î ±ºµ¥±ºµ¥ ÀûÀýÈ÷ »Ñ¸®´Â°Ç ºÒ°¡´ÉÇß½À´Ï´Ù.
»ç½Ç»ó ¹è³ÊÁ¦¸ñÀ» ÀÌ¿ëÇؼ­ ÀÏÀÏÀÌ ¼öµ¿À¸·Î ¹èÄ¡½ÃÄÑ¾ß Çϴµ¥¿ä.
°°Àº ÀÚ¸®¿¡ ¹è³Ê±¤°í ¸¹ÀÌ À¯Ä¡ÇÏ¼Å¾ß ÇÒ °æ¿ì ºÒÆíÇßÀ» °Ì´Ï´Ù.

ÀÌ°É °³¼±ÇÑ ÇïÆÛÇÔ¼ö¸¦ ¸¸µé¾ú½À´Ï´Ù.
ÀÌ ¿ª½Ã ÇÊ¿äÇϽŠºÐÀÌ ÀÖÀ»¸® ¾øÁö¸¸ È¥ÀÚ »ðÁúÇÑ °Ô ¾Æ±î¿ö¼­ ¿Ã·Áº¾´Ï´Ù.



/**
 * ±×·ì³» ¹è³Ê Àüü¸¦ ¶ç¿ì´Â ½ºÅ©¸³Æ®.
 *
 * $groupid str ¹è³ÊµéÀÇ ±×·ì¸íÀÌ µé¾î°©´Ï´Ù. "¸ÀÁý»ó´Ü" µî
 * $mod1 int ±âº»°ª 1. ±×·ì ³» ¸ðµç ¹è³Ê¸¦ n°³ÀÇ ±×·ìÀ¸·Î ³ª´©¾î¾ß ÇÒ ¶§ ±× nÀ» ÀÔ·ÂÇÕ´Ï´Ù.
 * $mod2 int ±âº»°ª 1. ÀÌ ÇÔ¼ö°¡ n°³ÀÇ ±×·ìÀ¸·Î ³ª´¶ ±×·ìµé Áß m¹ø° ±×·ìÀÏ ¶§ ±× mÀ» ÀÔ·ÂÇÕ´Ï´Ù.
 * $wrapper_left str °¢ ¹è³ÊÀÇ ¿ÞÂÊ¿¡ Ãâ·ÂÇØ¾ß ÇÒ html ¹®ÀÚ¿­ÀÔ´Ï´Ù. <div class="banners"> µî
 * $wrapper_right str °¢ ¹è³ÊÀÇ ¿À¸¥ÂÊ¿¡ Ãâ·ÂÇØ¾ß ÇÒ html ¹®ÀÚ¿­ÀÔ´Ï´Ù. </div> µî
 */
function groupped_banners ($groupid, $mod1 = 1, $mod2 = 1, $wrapper_left = "", $wrapper_right = "") {
// ¹è³Ê¸¦ ÀúÀåÇÏ´Â Å×À̺í¸í ±Û·Î¹úÇÔ¼öÀÔ´Ï´Ù. ¼Ö·ç¼Çº°·Î ´Ù¸¦¼öÀÖÀ½
global $happy_banner_tb;

// ¹è³Ê SQLÀ» µ¹¸³´Ï´Ù.
$banners_sql = "SELECT * FROM $happy_banner_tb WHERE groupid = "$groupid" AND display = "Y" ORDER BY title ASC";
$banners = query($banners_sql);

// iterator¸¦ ¾²±â À§ÇÑ ¹è¿­À» ±»ÀÌ Çϳª »õ·Î ¸¸µé¾î¼­
$the_banner = array();

// ±× ¹è¿­¿¡ while¹®À¸·Î sql°á°ú¸¦ ¸ð¾Æ³õ°í
while ($each_banner = mysql_fetch_assoc($banners)) : $the_banner[] = $each_banner; endwhile;

// ¹è³Ê¸¦ n°³ÀÇ ±×·ìÀ¸·Î ³ª´¯´Ï´Ù. µîÂ÷¼ö¿­ ¿ø¸®°¡ Àû¿ëµÇ¾î ÀÖ½À´Ï´Ù.
for ($i = 0; $i < count($the_banner); $i++) {

// m¹ø° ±×·ìÀÇ 1Ç×, 2Ç×, 3Ç×... ¸¸À» °¡Á®¿É´Ï´Ù.
$j = $mod1 * $i + $mod2;

// ½ÇÁ¦ ³ª¿Í¾ß ÇÒ ¹è³ÊÀÇ index¸¦ Á¶Á¤ÇÕ´Ï´Ù.
$k = $j - 1;

// ÀÌ index¿¡ ÇØ´çÇÏ´Â ¹è³Ê°¡ ±× ¹è¿­¿¡ ÀÖÀ¸¸é
if ($the_banner[$k]) {

// ÇÊ¿äÇÑ data¸¦ °¡Á®¿Í¼­ ¹è³Ê¸¦ »Ñ¸®°í ³¡³À´Ï´Ù.
$number = $the_banner[$k]["number"];
$width = $the_banner[$k]["width"];
$height = $the_banner[$k]["height"];
$pngClass = ( strpos($the_banner[$k]["img"],"png") )?" class="png24" ":"";

echo $wrapper_left."<a href=\"banner_link.php?number=$number\" target=\"_blank\"><img src="banner_view.php?number=$number" width=$width height=$height border=0 align="absmiddle" $linkScript $pngClass alt="$link_alt" ></a>".$wrapper_right;
}
}
}



À§ ÇÔ¼ö¸¦ inc/function.php °°Àº ÄÚ¾îÆÄÀÏ¿¡ Àû´çÈ÷ ³Ö¾î³õÀ¸½Å ´ÙÀ½ ¾Æ¹« html ÆÄÀÏ¿¡¼­³ª (¿¹¸¦ µé¾î) ÀÌ·± ½ÄÀ¸·Î ¾²½Ã¸é µË´Ï´Ù.

<?php groupped_banners("Ä¿¹Â´ÏƼùȭ¸é", 3, 1, "<div class="slide">", "</div>"); ?>
lorem

<?php groupped_banners("Ä¿¹Â´ÏƼùȭ¸é", 3, 2, "<div class="slide">", "</div>"); ?>
ipsum

<?php groupped_banners("Ä¿¹Â´ÏƼùȭ¸é", 3, 3, "<div class="slide">", "</div>"); ?>
dolor


ÀÌ·¸°Ô ÇÏ¸é ½ÇÁ¦·Î º¸ÀÌ´Â È­¸éÀº ÀÌ·¸°Ô µË´Ï´Ù.


[Ä¿¹Â´ÏƼùȭ¸é 1¹ø°¹è³Ê][Ä¿¹Â´ÏƼùȭ¸é 4¹ø°¹è³Ê][Ä¿¹Â´ÏƼùȭ¸é 7¹ø°¹è³Ê]
lorem

[Ä¿¹Â´ÏƼùȭ¸é 2¹ø°¹è³Ê][Ä¿¹Â´ÏƼùȭ¸é 5¹ø°¹è³Ê]
ipsum

[Ä¿¹Â´ÏƼùȭ¸é 3¹ø°¹è³Ê][Ä¿¹Â´ÏƼùȭ¸é 6¹ø°¹è³Ê]
dolor]]>
Fri, 18 Aug 2017 14:33:15
<![CDATA[ÇØÇǼַç¼Ç ÅëÇÕ°Ë»ö ºÎºÐ °³¼±ÄÚµå]]>
CGI¸ô¿¡¼­ ¼Ö·ç¼Ç ±¸¸ÅÇÏ½Ã°í ³ª¼­ °Ô½ÃÆÇ Ãß°¡ ¼öÁ¤ »èÁ¦ÇÒ ¶§ ÅëÇÕ°Ë»ö ºÎºÐÀ» Á÷Á¢ °íÄ¡¼Å¾ß Çϴµ¥¿ä
(Âü°í: http://www.cgimall.co.kr/happy_faq/board_detail.cgi?db=board_faq&thread=155)
À̺κÐÀ» Á»´õ ü°èÀûÀ¸·Î °íÄ£ ÄÚµåÀÔ´Ï´Ù.

(¾Æ¸¶µµ) lib/function.php ÀÇ ÇØ´çºÎºÐÀ» ¾Æ·¡ ÄÚµå·Î µ¤¾î¾²½Ã°í ÀûÀýÈ÷ ¼öÁ¤ÇØ ¾²½Ã¸é µÇ°Ú½À´Ï´Ù.

todo: ¹è¿­¿ø¼Ò¸¦ ³ÖÀ» ÇÊ¿ä ¾øÀÌ ¾Æ¿¹ °Ô½ÃÆÇ Àüü¸¦ Àоî¿Ã °ÍÀÎÁö ¾î¶²Áö¸¦ °ü¸®ÀÚ¸ðµå¿¡¼­ º¯°æ °¡´ÉÇÏ°Ô

------------


$search_result_type = "1"; #°Ë»öµÈ °á°ú°¡ ¾øÀ»°æ¿ì¿¡µµ ÇØ´ç ÆÄÆ® Ãâ·ÂÇÏ°íÀÚ ÇÒ°æ¿ì 1 ¾Æ´Ò°æ¿ì ºó°ª
$search_keyword = "search_word"; #¼öÁ¤ÇÏÁö¸¶¼¼¿ä. °Ë»ö½Ã ³Ñ¾î¿À´Â °ª ex) search.php?keyword=kkk -> $search_keyword = "keyword";

$the_tables = array(

/**
 * °¢ ¹è¿­Àº °Ë»ö °¡´ÉÇÑ Å×À̺íµéÀÔ´Ï´Ù.
 *
 * 1Ç׿¡´Â À¯ÇüÀ» Àû½À´Ï´Ù. "¾÷¼Ò·Ï", "Ä«Å×°í¸®", "°Ô½ÃÆÇ" 3Á¾ÀÔ´Ï´Ù. ¼Â ´Ù ¾Æ´Ñ ¹º°¡¸¦ ¾²¸é ¾Æ·¡ switch¹®ÀÇ default°¡ ÀÛµ¿ÇÕ´Ï´Ù.
 * 2Ç׿¡´Â "ÅÛÇø´Å±×"¿¡ »ç¿ëµÇ´Â "ÃßÃâű׸í"À» ¾¹´Ï´Ù.
 * 3Ç׿¡´Â À¯Çü¿¡ µû¶ó ²À ÇÊ¿äÇÑ Å×À̺í¸íÀ» Àû¾îÁÝ´Ï´Ù.
 *
 * »õ·Î¿î °Ô½ÃÆÇÀ» ¸¸µé¾ú´Ù¸é? Àû´çÇÑ À§Ä¡¿¡ º¹ºÙÇؼ­ ¹è¿­À» Ãß°¡ÇÕ´Ï´Ù.
 * °Ô½ÃÆÇÀ» ¾ø¾Ö¾ß ÇÑ´Ù¸é? ÇØ´ç ¹è¿­¿ø¼Ò¸¦ ¾ø¾ÖÁÝ´Ï´Ù.
 */

array("¾÷¼Ò·Ï", "¾÷ü"),

array("°Ô½ÃÆÇ", "¸ÀÁý", "eatery"),
array("°Ô½ÃÆÇ", "´ë³ª¹«½£", "noname"),
array("°Ô½ÃÆÇ", "µ¿¿µ»ó", "youtube"),
array("°Ô½ÃÆÇ", "»çÁø°ü", "board_gallery_photo"),
array("°Ô½ÃÆÇ", "´ÜÅåÈ«º¸", "kakaotalks"),
array("°Ô½ÃÆÇ", "°³Àα¤°í", "flyers"),
array("°Ô½ÃÆÇ", "À̺¥Æ®", "events"),
array("°Ô½ÃÆÇ", "ÇȾ÷", "ride"),

array("°Ô½ÃÆÇ", "±¸ÀÎ", "job_openings"),
array("°Ô½ÃÆÇ", "±¸Á÷", "job_seekers"),

array("°Ô½ÃÆÇ", "ÆмÇ", "outfit"),
array("°Ô½ÃÆÇ", "»ç°íÆÈ°í", "deal"),

array("°Ô½ÃÆÇ", "½¦¾î", "bd_share"),
array("°Ô½ÃÆÇ", "·»Æ®", "bd_rent"),
array("°Ô½ÃÆÇ", "°³ÀθŸÅ", "bd_personal"),
array("°Ô½ÃÆÇ", "ºñÁî´Ï½º", "bd_business"),

array("°Ô½ÃÆÇ", "À¯ÇÐ", "inter_school"),
array("°Ô½ÃÆÇ", "À̹Î", "immigration"),
array("°Ô½ÃÆÇ", "¹ý·ü", "legal"),
array("°Ô½ÃÆÇ", "¼¼¹«", "tax"),
array("°Ô½ÃÆÇ", "½É¸®»ó´ã", "counsel"),
array("°Ô½ÃÆÇ", "Åõ¾î", "tour"),
array("°Ô½ÃÆÇ", "Çб³", "school"),
array("°Ô½ÃÆÇ", "¸á¹ø¸¾", "housework"),

array("°Ô½ÃÆÇ", "Çѱ¹´º½º", "news_korean"),
array("°Ô½ÃÆÇ", "È£ÁÖ´º½º", "news_australian"),

array("Ä«Å×°í¸®", "Ä«Å×°í¸®"),
);

// ÇÊ¿äÇÑ ¹è¿­µéÀ» °ø°¥·Î Çϳª¾¿ ¸¸µì´Ï´Ù.
$check_part = $search_table = $search_field = $search_orderby = $search_title_field = $search_date_field = $search_where = $search_view_all_link = array();

// iterator¸¦ ¾²±â À§ÇØ foreach ¾Æ´Ñ for ¹®À» ¾¹´Ï´Ù.
for ($i = 0; $i < count($the_tables); $i++) {

// ¿ì¼± ¸ðµç ¹è¿­ °¢°¢¿¡ ´ëÇÑ °øÅëÀÛ¾÷À» ÇսôÙ.
$key = $the_tables[$i][1];
$check_part[$key] = $i;

// ±×¸®°í ³ª¼­ °¢ ¹è¿­ 1Ç׿¡ ¹¹¶ó°í ½áÀÖ´ÂÁö¿¡ µû¸¥ °¢°³ÀÛ¾÷À» ÇսôÙ.
switch ($the_tables[$i][0]) {

// ¾÷¼Ò·ÏÀÏ ¶§
case "¾÷¼Ò·Ï":
$search_table[$i] = $links;
$search_field[$i] = "title+address+phone+homepage+short_comment+review+build_date+keyword";
$search_orderby[$i] = "number";
$search_title_field[$i] = "title";
$search_date_field[$i] = "links_date";
$search_where[$i] = " AND wait="0" ";
$search_view_all_link[$i] = "price_search.php?action=search&search_word=";
break;

case "°Ô½ÃÆÇ":
// °Ô½ÃÆÇ ¹è¿­ÀÇ ¼Â°Ç×À» ÀÌ¿ëÇؼ­ ÀÏ°ý ÀÛ¼ºÇÕ´Ï´Ù.
$tbname = $the_tables[$i][2];

$search_table[$i] = $DB_Prefix.$tbname;
$search_field[$i] = $search_query_string = "bbs_title+bbs_review";
$search_orderby[$i] = "number";
$search_title_field[$i] = "bbs_title";
$search_date_field[$i] = "bbs_date";
$search_where[$i] = "";
$search_view_all_link[$i] = "bbs_list.php?action=search&search=".$search_query_string."&tb=".$tbname."&keyword=";
break;

case "Ä«Å×°í¸®":
$search_table[$i] = $category_tb;
$search_field[$i] = "category_name";
$search_orderby[$i] = "category_sort";
$search_title_field[$i] = "category_name";
$search_date_field[$i] = "display";
$search_where[$i] = " AND category_name LIKE "%¾÷¼Ò·Ï%" AND display="Y" ";
$search_view_all_link[$i] = "´õº¸±â¸µÅ©¾øÀ½";
break;

default:
// ÇØ´ç ¹è¿­¿ø¼ÒÀÇ 2¹ø° Ç׺ÎÅÍ raw data¸¦ ÀÔ·ÂÇØ ¾²½Ç ¼ö ÀÖ½À´Ï´Ù.
$search_table[$i] = $the_tables[$i][2]; // Äõ¸®µ¹¸± DBÅ×À̺í
$search_field[$i] = $the_tables[$i][3]; // Äõ¸®µ¹¸± Ä÷³µé
$search_orderby[$i] = $the_tables[$i][4]; // Äõ¸® Á¤·ÄÇÒ Ä÷³
$search_title_field[$i] = $the_tables[$i][5]; // Äõ¸®°á°úÀÇ Å¸ÀÌƲÄ÷³
$search_date_field[$i] = $the_tables[$i][6]; // Äõ¸®°á°úÀÇ ³¯Â¥Ä÷³
$search_where[$i] = $the_tables[$i][7]; // ±âŸ Äõ¸®µ¹¸±¶§ ÇÊ¿äÇÑ where¹®
$search_view_all_link[$i] = $the_tables[$i][8]; // ÃßÃâű׿¡¼­ »ç¿ëÇÒ ´õº¸±â ¸µÅ©
break;
}
}
]]>
Fri, 11 Aug 2017 15:05:14
<![CDATA[¸ð¹ÙÀÏ ¹× ¸®½ºÆ®Çü ÅÛÇø´ ÆÄÀÏ¿¡ Àû¿ëÇϸé À¯¿ëÇÑ ellipsis ¼Ò½º]]>

À§¿Í°°ÀÌ Æ¯Á¤ ¼Ò½º³»¿¡ ÆùÆ® ¹× À̹ÌÁöµîÀÌ À߸®´õ¶óµµ ... À¸·Î Ç¥½ÃµÇ°Å³ª ¸ð¹ÙÀϸ¶´Ù º¯°æµÇ´Â ´Ù¾çÇÑ ºê¶ó¿ìÀúµî¿¡¼­

¾ÆÁÖ È¿°úÁÁÀº ¸®½ºÆ® È­¸éÀ» ±¸ÇöÇÒ ¼ö ÀÖ½À´Ï´Ù.

¹æ¹ýÀº ¾ÆÁÖ °£´ÜÇÕ´Ï´Ù.

¸ÕÀú css »ó¿¡¼­ ellipsis È¿°ú¸¦ ÁÙ text-overflow:ellipsis ¼Ò½º¸¦ style À» Àû¿ëÇÕ´Ï´Ù.


<style>
.ellip {word-break:break-all; text-overflow-mode:ellipsis-word; text-overflow-mode:ellipsis; text-overflow-mode:clip; text-overflow:ellipsis; overflow:hidden; white-space:nowrap;}
</style>


ÁÖÀÇÇÏ¼Å¾ß ÇÒ ºÎºÐÀ¸·Ð word-break:break-all À» »ç¿ëÇÏÁö ¾ÊÀ¸½Ç°æ¿ì ÆùÆ®¿µ¿ªÀÇ ¼Ò½º¸¦ ¹®ÀÚ¿­·Î ÀνÄÇÏÁö ¾Ê¾Æ

'...' À̶õ ¹®ÀÚ¿­ÀÌ Ãâ·ÂµÇÁö ¾Ê»ç¿À´Ï ²À ±âÀÔÇØÁֽñ⠹ٶø´Ï´Ù.



ÀÌÈÄ ¹Ý¿µÇÒ ¸®½ºÆ® ÇüÅÂÀÇ ÅÛÇø´ Ç׸ñ¿¡ ¾Æ·¡¿Í °°ÀÌ ¹Ý¿µÇÕ´Ï´Ù.

»ùÇÿ¹Á¦´Â table ¿µ¿ª¿¡ Àû¿ëµÈ ¿¹Á¦·Î ¾î¶°ÇÑ ºê¶ó¿ìÀú¿¡¼­µµ Å©·Î½ÌÀÌ ÈǸ¢ÇÏ°Ô ¹Ý¿µµÇ¸ç, ¼Ò½ºµµ ºñ±³Àû °£´ÜÇÏ¿©

Ãʺ¸Àڵ鵵 »ç¿ëÇϽñ⠿ëÀÇÇϵµ·Ï Â¥¿©Á®ÀÖ½À´Ï´Ù.

À̶§ ¹Ýµå½Ã °¡Àå ¹Ù±ù¿¡ ½×¿©Á®ÀÖ´Â table ¿µ¿ª¿¡ style="table-layout:fixed;" ¸¦ ¼±¾ðÇØÁÖ¼Å¾ß ÇÕ´Ï´Ù.


<table style="width:100%; table-layout:fixed;">
<tr>
<td class="ellip">ÇϴþƷ¡½Å¯ °¡¶ó»ç´ë ±ä±ÛÀ» ÀÔ·ÂÇÏ¿©Áֽñ⠹ٶø´Ï´Ù.ÇϴþƷ¡½Å¯ °¡¶ó»ç´ë ±ä±ÛÀ» ÀÔ·ÂÇÏ¿©Áֽñ⠹ٶø´Ï´Ù.ÇϴþƷ¡½Å¯ °¡¶ó»ç´ë ±ä±ÛÀ» ÀÔ·ÂÇÏ¿©Áֽñ⠹ٶø´Ï´Ù.ÇϴþƷ¡½Å¯ °¡¶ó»ç´ë ±ä±ÛÀ» ÀÔ·ÂÇÏ¿©Áֽñ⠹ٶø´Ï´Ù.</td>
</tr>
</table>


À§¿Í°°Àº »óÅ·Π¸¸µé¾îÁÖ¼Å¾ß Çϸç, <table> ¾È¿¡ <table> ÀÌ ÀÖ´Â »óŶó¸é ¹Ý¿µµÇÁö ¾Ê»ç¿À´Ï Âü°íÇϽñ⠹ٶø´Ï´Ù.





Áñ°Å¿î ÀÎÅͳÝ, À¥È°¿ë¹ýÀ¸·Î ´Ù¾çÇÑ È¿°ú¸¦ ±¸ÃàÇغ¸½Ã±â ¹Ù¶ø´Ï´Ù.^^

°¨»çÇÕ´Ï´Ù.
]]>
Wed, 14 Aug 2013 16:40:34
<![CDATA[ÆÞ °­Á Áøµµ °èȹǥ]]> Mon, 20 Nov 2000 23:48:22 <![CDATA[1. Perl DBI ¼³Ä¡Çϱâ]]>
¿ì¼± perl ¿Í mysqlÀÇ ¿¬µ¿ÀÇ °³³äÀûÀÎ °Í ºÎÅÍ ¼³¸íÀ» ÇÏ°Ú½À´Ï´Ù.
http://www.happycgi.com/index.cgi?action=main&category=µ¥ÀÌŸº£À̽º_â°í/MySQL/MYSQL_ÀÚ·á/APIs/PERL_DBI

À§ URL·Î °¡º¸¸é 4°³ÀÇ ÆÄÀÏÀÌ ¿Ã¶ó¿Í ÀÖ½À´Ï´Ù.
ÀÌ´Â DBI¶õ °ÍÀ¸·Î perlÀÌ ÁØ sql ¸í·É¾îÀ» sql·Î º¸³»ÁÖ´Â ¿ªÈ°À» ÇÕ´Ï´Ù.
´ç¿¬È÷ DBI °¡ ±ò·ÁÀÖÁö ¾ÊÀ¸¸é perl°ú sqlÀº ¼­·Î ¿¬µ¿ÀÌ µÉ¼ö ¾ø°ÚÁÒ?
(¸ðµç ¾ð¾î´Â °ÅÀÇ °°Àº ÇüŸ¦ ÃëÇÕ´Ï´Ù. ¹æ¹ý»óÀ¸·Î ¾à°£¾¿ ´Ù¸£ÁÒ)

DBI ¼³Ä¡´Â ¼­¹öÀÇ root°¡ ÇØ¾ß Çϸç ÀÚ½ÅÀÌ ¼­¹ö¸¦ ¿î¿µÇÏ°í ÀÖÁö ¾ÊÀ»
°æ¿ì¿¡´Â ´ã´ç¼­¹ö°ü¸®ÀÚ´Ô²² ¿¬¶ôÀ» Çؼ­ ÆÞ DBI ¼³Ä¡¸¦ ÇØ´Þ¶ó°í
¿äûÀ» ÇÏ¼Å¾ß ÇÕ´Ï´Ù.
¸¸¾à ¼­¹ö°ü¸®ÀÚ´Ô²²¼­ "±×°Ô ¹¹¿¹¿ä?"  ÇϽŴٸé
È£½ºÆà ȸ»ç¸¦ ¹Ù²Ù½Ã´Â°Ô ³´°Ú½À´Ï´Ù. ^^;;;

¿ì¼± ³×°³ÀÇ ÆÄÀÏÀ» ´Ù¿î ¹Þ½À´Ï´Ù.
http://search.cpan.org ¿¡¼­ ¹ÞÀ¸½Ã¸é µÇ°í, ÃֽŹöÁ¯À» ¹ÞÀ¸½Ê½Ã¿À.
¼­¹öÀÇ /tmp µð·ºÅ丮¿¡ 4°³ÀÇ ÆÄÀÏÀ» ¿Ã¸³´Ï´Ù.
ÅÚ³ÝÀ¸·Î Á¢¼ÓÇÑÈÄ ·çÆ®·Î Àç·Î±äÇÕ´Ï´Ù.
¼³Ä¡ ¼ø¼­´Â
[quote]1. Data-ShowTable-3.3.tar.gz
2. Data-Dumper-2.101.tar.gz
3. DBI-1.13.tar.gz
4. Msql-Mysql-modules-1.2209.tar.gz [/quote]
·Î ÇÏ¸é µË´Ï´Ù.

°¢°¢ÀÇ ¼³Ä¡ ¹ýÀº µ¿ÀÏÇϹǷΠÇѹø¸¸ ¼³Ä¡¹ýÀ» ¾Ë·Áµå¸®°Ú½À´Ï´Ù.
³ª¸ÓÁö´Â °°Àº ¹æ¹ýÀ¸·Î ÇÏ½Ã¸é µË´Ï´Ù.

[quote]1.Data-ShowTable-3.3.tar.gz ÀÇ ¾ÐÃàÀ» DZ´Ï´Ù.
ÅÚ³Ý> tar xvfz Data-ShowTable-3.3.tar.gz

2. ¾ÐÃàÀÌ Ç®¸®¸é¼­ µð·ºÅ丮°¡ »õ·Î »ý±é´Ï´Ù.
3. »ý¼ºµÈ µð·ºÅ丮·Î µé¾î°©´Ï´Ù.
4. perl Makefile.PL À̶ó°í ÀÔ·Â
5. make ¶ó°í ÀÔ·Â
6. make test ¶ó°í ÀÔ·Â
7. make install ¶ó°í ÀÔ·Â
[/quote]
°°Àº ¹æ¹ýÀ¸·Î ³ª¸ÓÁö 3°³ÀÇ ¸ðµâµµ ¼³Ä¡¸¦ ÇÕ´Ï´Ù.

DBI °¡ ¼³Ä¡µÇ¾ú´ÂÁö »ùÇà cgi·Î Å×½ºÆ®¸¦ Çغ¼±î¿ä?
¾Æ·¡´Â test.cgi ÀÔ´Ï´Ù.
º¹»çÇϼż­ Å×½ºÆ®Çغ¸¼¼¿ä.

¿ì¼± mysql ¿¡ ¾ÆÀ̵𸦠test Æнº¸¦ test·Î °¡Á¤À» ÇÏ°í
sql DB À̸§À» testdb
±×¸®°í Å×ÀÌºí ¸íÀº first
Ä÷³Àº name varchar(20), email varchar(20) À¸·Î °¡Á¤ÇÕ´Ï´Ù.
°ªµéÀº

À±¿µ¿õ|webmaster@happycgi.com
¼Õ´Ô |guest@test.com

À̶õ µÎ°³ÀÇ °ªÀÌ ÀÖ´Ù°í °¡Á¤À» Çϱ¸¿ä.

Âü°í·Î sql ¹®¹ýÀ» ¸ð¸£¸é ¿¬µ¿À» ºÒ°¡´ÉÇÏ°ÚÁÒ. ^^

¾Æ·¡´Â »ùÇà cgiÀÔ´Ï´Ù. º¸¸é¼­ ¼³¸íÀ» ÇÏÁÒ.

[code]#!/usr/bin/perl
#########################################################
use DBI; #DBI¶õ ¸ðµâÀ» »ç¿ëÇÑ´Ù°í ¼±¾ðÇÕ´Ï´Ù.
$database = "testdb";
$hostname = "localhost";
$dsn = "DBI:mysql:database=$database;host=$hostname";
$user = "test";
$pw = "test";
$dbh = DBI->connect("$dsn", "$user", "$pw");
#########################################################
print "content-type:text/html\n\n";

#DB Ä¿³ØÆÃÀ» ½ÃµµÇÕ´Ï´Ù.
#À̸§ÀÌ °ø¹éÀÌ ¾Æ´Ñ°ÍµéÀ» ºÒ·¯³À´Ï´Ù.

$sth = $dbh->prepare("select * from first where name is not null or die print "$DBI::errsrt";
$sth->execute();
#@rows = $sth->fetchrow_array ¶õ $sth ¿¡¼­ ¹ÞÀº °ªµéÀ»
#¹è¿­·Î ¹Þ¾Æ º¸°Ú´Ù´Â ¸»ÀÔ´Ï´Ù.
#ÇöÀç Ä÷³ÀÌ µÎ°³´Ï±î ¹è¿­ 0¹ø°ú 1¹øÀ» °¢°¢
#$name À̶õ º¯¼ö¿Í $email À̶õ º¯¼ö·Î ÁöÁ¤À» ÇÏ°í
#Ãâ·ÂÀ» ÇÕ´Ï´Ù.

while (@rows = $sth->fetchrow_array) {
$name = $rows[0];
$email = $rows[1];
print "À̸§ : $name À̸ÞÀÏ : $email
\n";
}
[/code]
À̸§°ú À̸ÞÀÏÀÌ Á¤»óÀûÀ¸·Î Ãâ·ÂÀÌ µÇ¸é DBI°¡ Àß ¼³Ä¡ µÈ°ÍÀÔ´Ï´Ù.
¸¸¾à ¾î¶² ¿À·ù ¸Þ¼¼Áö¸¦ º¸Àδٸé DBI¿¡¼­ Ãâ·ÂµÇ´Â ¿¡·¯ ¸Þ¼¼Áö
ÀÔ´Ï´Ù.
¸Þ¼¼Áö¸¦ Àß º¸½Ã°í ¾î¶»°Ô ¿¡·¯°¡ ³µ´ÂÁö ÆľÇÀ» ÇÑÈÄ ´Ù½Ã
½ÇÇàÀ» ÇÏ¼Å¾ß ÇÕ´Ï´Ù.
À̹ø ù¹ø° °­Á´ ÀÌ·¸°Ô ¸¶Ä¨´Ï´Ù.

ÁÁÀº ÇÏ·çµÇ¼¼¿ä.
³¯¾¾ ¿äÁò ¹«Áö Ã䱺¿ä. ^^

Copyright 1997-2003 HAPPYCGI All Rights Reserved.
]]>
Tue, 21 Nov 2000 00:00:27
<![CDATA[1-1. perl DBI ,DBD(¿À¶óŬ) ¼ÂÆÃÇϱâ]]> Mon, 27 Nov 2000 05:37:30 <![CDATA[pws¿¡¼­ ¼¼ÆȺ¸µå ¼³Ä¡Çϱâ]]> Sun, 14 Jan 2001 07:21:13 <![CDATA[NT¿¡¼­ blat »ç¿ëÇϱâ]]> Sun, 14 Jan 2001 07:47:01 <![CDATA[À©µµ¿ì 2000¼­¹ö¿¡¼­ smtp¸¦ ÀÌ¿ëÇÑ ¸ÞÀÏ ³¯¸®±â (¼¼ÆȺ¸µå¿¹Á¦)]]> Sun, 14 Jan 2001 07:49:34 <![CDATA[ÅؽºÆ®ÆÄÀÏ »èÁ¦ÆÁ]]> Sun, 18 Mar 2001 17:30:45 <![CDATA[¹é±×¶ó¿îµå·ÎÀÇ ½ÇÇà]]> Sun, 25 Mar 2001 14:57:47 <![CDATA[À̸ÞÀÏ Æ÷¿öµù]]> Tue, 3 Apr 2001 02:13:39 <![CDATA[<b>ű׷ΠµÑ·¯½×ÀÎ ¹®ÀÚ¿­ »Ì±â]]> Thu, 5 Apr 2001 13:46:24 <![CDATA[½ºÆ®¸µ¿¡¼­ ƯÁ¤¹®ÀÚ °¹¼ö ¾Ë¾Æ³»±â]]> 0ÀÇ °¹¼ö¸¦ ¼¼´Â ¹æ¹ýÀÌÁÒ.

#!/usr/bin/perl

$i = "1101010001";

$i =~ s/[^0]//g; <--0 ÀÌ¿Ü¿¡´Â ÀüºÎ ¾ø¾Ö ¹ö¸°´Ù.

$len = length($i);

print $len;

À½...Àß µÇ´Â ±º¿ä....^^]]> Thu, 5 Apr 2001 15:56:31 <![CDATA[ÀԷ¹ÞÀº °ªÀÌ ¼ýÀÚÀÎÁö ¹®ÀÚÀÎÁö ±¸ºÐ]]> if( $string = ~ /\d{1,}/ or $string = ~ /d{1,}\.d{1,}/){
  print "¼ýÀÚÀÔ´Ï´Ù <p>\n";
}
±×·±µ¥.. ÇÏ°í³ª¸é... string°ªÀÌ ¹Ù²î´õ±º¿ä. ±×·¯´Ï±î... ÀÌ°É ´Ù¸¥ º¯¼ö¿¡ ³Ö¾î¼­.. ±× º¯¼ö·Î.. °ªÀ» ¾Ë¾Æº¸´Â°Ô ÁÁÀ» °Í °°½À´Ï´Ù.

¹ßÃé : http://www.perlmania.or.kr
]]>
Thu, 5 Apr 2001 15:57:57
<![CDATA[¼ýÀÚ¿¡¼­ Á¤¼ö¸¸ ±¸Çϱâ]]>
¸¸¾à, $a = int (3.141592); ¶ó°í ÇÏ¿´À»¶§, $a¿¡´Â

Á¤¼ö ºÎºÐÀÎ '3' ¸¸ ÃëÇÏ°Ô µË´Ï´Ù.

perlÀº ¹®ÀÚ¿Í ¼ýÀÚ¸¦ ±¸º°ÇÏÁö ¾Ê±â ¶§¹®¿¡ ¼ýÀÚ°¡ µé¾îÀÖ´Â ¹®ÀÚ¿­µµ

°¡´ÉÇÕ´Ï´Ù. $a = int ("3.141592"); µµ ¸Â½À´Ï´Ù.

ex)

5.92 => 5
4.84 => 4
2.7523 => 2
..
..

ÀÚ·áÃâó : http://www.perlmania.or.kr]]>
Thu, 5 Apr 2001 16:27:13
<![CDATA[ÇÑ±Û ÀÚ¸£±â]]>       my $string = shift;
      my $len = shift;
      my $cut = 0;

      while($len != 0) {
              if( ord(substr($string, $cut, 1) ) >= 128 ) {
                      $cut += 2; #korean char & 
              }
              else {
                      $cut++;
              }
              $len--;
              last if ($len == 0);
      }
      return substr($string, 0, $cut);
}

#»ç¿ë¹ý
$a = "12ÆÞ34¸¶56´Ï78¾Æ";
print CutString($a,7);



]]>
Thu, 5 Apr 2001 17:07:06
<![CDATA[¿ìÆí¹øȣã±â¿¡¼­ ±Û¾²±â ÀÔ·Â °­Á¦·Î ¸·±â]]> Thu, 5 Apr 2001 17:09:03 <![CDATA[[html] Å×À̺íÀ» À̻ڰÔ, input ¹Ú½º¸¦ À̻ڰÔ]]> ÄÚµùÇϽǶ§ µðÀÚÀεµ ½Å°æ¸¹ÀÌ ¾²À̽ÃÁÒ ^^
<table> ´ë½Å¿¡ ¾Æ·¡ ű׸¦ ½áº¸¼¼¿ä.
Á»´õ ÀÌ»µÁú°Ì´Ï´Ù.

<table cellspacing=0 cellpadding=2 bordercolorlight="black" bordercolordark="#FFFFFF" bgcolor="#FFFFFF" border=1 >

INPUT ¹Ú½º¸¦ ÀÌ»Ú°Ô ÇØÁÖ´Â ½ºÅ¸ÀÏ ½¬Æ®ÀÔ´Ï´Ù.
¾Æ·¡¸¦ Âü°íÇϼ¼¿ä.

<input type="text" name="phone" size=30 value="" style="border: 1 dashed"  style='font-size: 9pt'>
]]>
Thu, 5 Apr 2001 17:13:21
<![CDATA[[ÀÚ¹Ù½ºÅ©¸³Æ®] html Ãâ·Â´ë½Å ÀÚ¹Ù½ºÅ©¸³Æ®·Î]]> ±Ûµî·ÏÈijª ¼öÁ¤ÈÄ È¤Àº »èÁ¦µî¿¡¼­ Ãâ·ÂÇÒ¶§ °£´ÜÇÑ ÀÚ¹Ù½ºÅ©¸³Æ®·Î
ÇØ°áÇÏ´Â ¹æ¹ýÀÔ´Ï´Ù.
°£´ÜÇÏÁö¸¸ À¯¿ëÇÒ°Ì´Ï´Ù.
Á¦°¡ Áñ°Ü ¾²´Â ¹æ¹ýÀÌÁÒ.

print "<script>\n window.alert('»ç¿ëÀÚ Á¢¼ÓÀ» ÇÏÁö ¾ÊÀ¸¸é Á¢±ÙÇÒ ¼ö ¾ø½À´Ï´Ù.')\n history.go(-1)\n</script>\n";

--> À§ ½ºÅ©¸³Æ®´Â ÀÌÀüÀ¸·Î µ¹¾Æ°¡µµ·Ï


print "<script>\n window.alert('·Î±×¿ÀÇÁµÇ¼Ì½À´Ï´Ù')\n location = \"$admin_url\";  </script>\n";

--> À§ ½ºÅ©¸³Æ®´Â $admin_urlÀÌ ÁöÁ¤ÇÑ À§Ä¡·Î µ¹¾Æ°¡µµ·Ï

]]>
Thu, 5 Apr 2001 17:15:53
<![CDATA[[ÀÚ¹Ù½ºÅ©¸³Æ®] »õâ ÀÚµ¿À¸·Î ²¨Áö±â]]> ÀϹÝÀûÀ¸·Î »õâÀ» ¶ç¿ì°í ³ª¼­´Â â´Ý±â ȤÀº ÀÚ¹Ù½ºÅ©¸³Æ®ÀÇ alert¸¦
ÀÌ¿ëÇؼ­ âÀ» ²ô´Âµ¥ ÀÚ¹Ù½ºÅ©¸³Æ®¸¦ ÀÌ¿ëÇؼ­
ÀÏÁ¤½Ã°£ÈÄ ÀÚµ¿À¸·Î ²¨Áö´Â ¹æ¹ýÀ» ¾Ë¾Æº¾´Ï´Ù.
(»ç½Ç ¾Ë¾Æº¼°Íµµ ¾øÁÒ. ±×³É º¹»çÇؼ­ ¾²½Ã¸é µË´Ï´Ù.)

»õ·Î ¶áâ Áß ²ô°íÀÚ ÇÏ´Â ·çƾ¿¡ ¾Æ·¡¸¦ ³ÖÀ¸¼¼¿ä.
<script>setTimeout ('window.close ()', 1000)</script>

ÁÁÀº ÇÏ·çµÇ¼¼¿ä.
]]>
Fri, 6 Apr 2001 06:04:05
<![CDATA[[html] textarea ºê¶ó¿ìÁ®º° Å©±â ¸ÂÃß±â]]> ´Ã ¹®Á¦²¨¸®¿´ÁÒ?
textarea Å©±â°¡ ºê¶ó¿ìÁ® º°·Î ´Ù¸£°Ô Ãâ·ÂµÇ´Â°Í ¶§¹®¿¡ ¸»ÀÌÁÒ.
(»ç½Ç ÀÌ Æ÷·³µµ Ʋ¸®°Ô ³ª¿Ã°Ì´Ï´Ù. ^^v)

¾Æ·¡ ű׸¦ À¯½ÉÈ÷ º¸¼¼¿ä.
<textarea name="type" cols="25" rows="12" style="border: 1 dashed"  style='font-size: 9pt' style='width:270px;'>

cols=25 ´Â ³×½ºÄÉÀÌÇÁ¿¡¼­ µû¸¨´Ï´Ù.
style='width:270px;' ´Â ÀͽºÇ÷η¯¿¡¼­ µû¸£ÁÒ.

ºê¶ó¿ìÁ®º° textarea Å©±â Á¶Àý ³¡ ^^
]]>
Fri, 6 Apr 2001 06:24:19
<![CDATA[ÀÎÁõµÈ »ç¿ëÀÚÀÇ ID ¾Ë±â]]> Çѵ¿¾È ²ÙÁØÈ÷ ÆÁÀ» ¿Ã¸®°í ÀÖ½À´Ï´Ù. ^^
¾ÆÆÄÄ¡¿¡ ¾ÆÀ̵ð/Æнº¿öµå ÀÔ·ÂÇ϶ó°í ³ª¿À½Ã´Â°Å ¾Æ½ÃÁÒ.
ÀϹÝÀûÀ¸·Î »ç¿ëÀÚ ÀÎÁõÀ̶ó°í ºÎ¸£´Âµ¥¿ä.
ÀÌ ÀÎÁõÀ» Åë°úÇÑ »ç¶÷ÀÇ ¾ÆÀ̵𸦠ÆÞÀÇ È¯°æº¯¼ö·Î ¾Ë¾Æº¾´Ï´Ù.

$ENV{'REMOTE_USER'}

¹«Áö ½±ÁÒ? ^^
]]>
Sat, 7 Apr 2001 23:14:41
<![CDATA[¹è¿­·Î ÆÄÀÏ Àбâ]]> °¡²û ÆÄÀÏ·Î ÇÁ·Î±×·¥À» Â¥´Ù º¸¸é ƯÁ¤ ÆÄÀÏÀ» ¹è¿­¿¡ ´ã¾Æ¼­
¾î¶² È®ÀÎÀ̳ª ÇൿÀ» ÇØ¾ß ÇÒ¶§°¡ Àִµ¥¿ä.
±×¶§ ÆíÇÏ°Ô ¹è¿­·Î ³Ö¾î¼­ üũ¸¦ Çغ¾´Ï´Ù.

open (B,"ÆÄÀϸí");
@allfile = <B>;
close B;

foreach $list (@allfile) {
print "$list";
}

µÎ¹ø° ¹æ¹ýÀº $_ ¸¦ ÀÌ¿ëÇؼ­ Ãâ·Â ȤÀº ÀÛ¾÷^^ ÇÏ´Â ¹æ¹ýÀÔ´Ï´Ù.
open (A,"ÆÄÀϸí");
while (<A>) {
print "$_";
}
close A;

ÁÁÀº ÇÏ·çµÇ¼¼¿ä.

]]>
Sun, 8 Apr 2001 01:50:51
<![CDATA[PERL ¼Ò¼öÁ¡ ÀÚ¸®º° ¹Ý¿Ã¸²]]> °á°ú °ªÀ» $test ¶ó°í ÇÕ´Ï´Ù.
$test = int ((abs($test)/1) + 0.5)*1;
ÇÏ¸é µË´Ï´Ù.
¼Ò¼ö ÇÑÀÚ¸®·Î ÇÒ¶§´Â
$test = int ((abs($test)/0.1) + 0.5)*0.1;
¶ó°í ÇÏ¸é µË´Ï´Ù.
¼Ò½º µÑ° ÀÚ¸®´Â ¸¶Âù°¡Áö·Î
$test = int ((abs($test)/0.01) + 0.5)*0.01;
ÇÏ¸é µÇ°ÚÁÒ ^^
°¨»çÇÕ´Ï´Ù.
ÁÁÀº ÇÏ·çµÇ¼¼¿ä ]]>
Sun, 8 Apr 2001 02:04:25
<![CDATA[email Á¸Àç À¯¹« üũ ÇÔ¼ö]]> if (!eregi("^[a-z0-9]+([\.%!][_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*$", $email)) {
$return = false;
} else {
list($user, $host) = explode("@", $email);
if (checkdnsrr($host, "MX") or checkdnsrr($host, "A")) {
$return = true;
} else {
$return = false;
}
}
return $return;
}


ÀÚ·áÃâó : http://www.tegi.org

]]>
Tue, 10 Apr 2001 03:50:46
<![CDATA[html Çü½ÄÀ¸·Î ¸ÞÀÏ º¸³»±â]]> óÀ½ ÆÞÀ» ¹è¿ì½Ã´Â ºÐµéÀÌ ¸¹ÀÌ Ã£À¸½Ç ¿¹Á¦ÀÔ´Ï´Ù.^^
¾Æ·¡ ±ÛÀ» Âü°íÇϼ¼¿ä.

http://www.happycgi.com/forum/forum_detail.cgi?thread=6000 ]]>
Tue, 10 Apr 2001 06:56:32
<![CDATA[[ÀÚ¹Ù½ºÅ©¸³Æ®]Çѱ۸¸ ÀνÄÇÏ´Â ÀÚ¹Ù½ºÅ©¸³Æ®]]>





ÀͽºÇ÷η¯¿ë ÀÔ´Ï´Ù. ³×½ºÄÉÀÌÇÁ´Â ¾ÆÁ÷ üũ ÇÏÁö ¾Ê¾Ò½À´Ï´Ù.

¾Æ·¡ÀÇ ÅؽºÆ® ÀԷ»óÀÚ¿¡ üũÇÒ ±ÛÀÚ¸¦ ÀÔ·ÂÇÏ°í ¿£ÅÍÅ°¸¦ ´©¸£½Ê½Ã¿À.

ÀÚÀ½À̳ª ¸ðÀ½ Çϳª¸¸ ÀÔ·ÂÇϸé ÇѱÛÀÌ ¾Æ´Ñ °ÍÀ¸·Î ÀνÄÇÕ´Ï´Ù.

(¿¹ : ¤¡, ¤¤, ¤¿, ¤Ã µîµî)


* ÇѱÛÀÚ »Ó ¾Æ´Ï¶ó ¹®ÀÚ¿­µµ Å×½ºÆ® °¡´ÉÇÕ´Ï´Ù.

* ¹®ÀÚ¿­ Áß¿¡ ÀÚÀ½, ¸ðÀ½, ºóÄ­ µîÀÌ ÇѱÛÀÚ¶óµµ ¼¯¿© ÀÖÀ¸¸é ÇѱÛÀÌ ¾Æ´Ñ °ÍÀ¸·Î üũÇÕ´Ï´Ù.





]]>
Fri, 13 Apr 2001 07:03:43
<![CDATA[¾÷µ¥ÀÌÆ® ³¯Â¥ º¸¿©ÁÖ±â]]>
¾î´À ȨÆäÀÌÁö¿¡ °¡º¸¸é ÃÖ±Ù ¾÷µ¥ÀÌÆ® ³¯Â¥¸¦ Àû¾îÁÖ´Â ºÐµéÀÌ °è½ÃÁÒ.

½ºÅ©¸³Æ®¸¦ ÀÌ¿ëÇÏ´Â ºÐµéµµ °è½Ã°ÚÁö¸¸, ´ëºÎºÐÀº Á÷Á¢ Àû¾îÁÖ´Â °ÍÀ¸·Î ¾Ë°í ÀÖ½À´Ï´Ù. (À߸ø ¾Ë¾Ò³ª? ±ÜÀû±ÜÀû...)

PHP¸¦ ÀÌ¿ëÇØ À̸¦ ±¸ÇöÇغ¼±î¿ä?

´ÙÀ½ÀÇ ÇÑÁÙÀ» html ¹®¼­ ³»¿¡ ¾÷µ¥ÀÌÆ® ³¯Â¥¸¦ Ãâ·ÂÇØ¾ß ÇÒ ºÎºÐ¿¡ Ãß°¡Çϱ⸸ ÇÏ¸é ³¡ÀÔ´Ï´Ù.

<? $file = stat(basename($PHP_SELF)); echo date("Y-m-d (h:i:s a)", $file[9]); ?>

³Ê¹« ½Ì°ÌÁÒ...?

stat() ÇÔ¼ö´Â ÆÄÀÏ¿¡ ´ëÇÑ ¿©·¯ Á¤º¸¸¦ °¡Á®¿À´Â ÇÔ¼öÀÔ´Ï´Ù. À§¿¡¼­ º¸¸é $file[9]¶ó°í ÇÑ°Ô º¸ÀÌÁÒ? °á°ú °ªÀÌ ¹è¿­À̱⠶§¹®¿¡ ±×·¸½À´Ï´Ù. ÆÁÀÌ´Ï±î ´Ù¸¥ ¼³¸íÀº »ý·«ÇÏ°í Àú±â ¾²ÀÎ 9¹ø° À§Ä¡ÀÇ °ªÀº ¸¶Áö¸·À¸·Î ¼öÁ¤µÈ ³¯Â¥°ªÀÌ µé¾îÀÖ½À´Ï´Ù.

¾Æ! ±×³É ³¯Â¥°¡ ¾Æ´Ï°í timestamp¶ó´Â °ªÀÌÁÒ. ¼ýÀÚ°¡ ÂÍ Ä¿¿ä... ^^; ±×³É ±×·±°Ô ÀÖ´Ù Çϱ¸ ³Ñ¾î°¡ÁÒ.. (º¹ÀâÇÑ°Ç ¾Æ´Ï°í... 1970³âÀΰ¡? ±×³¯ºÎÅÍ Áö±Ý±îÁöÀÇ Áö³ª°£ ½Ã°£À» ÃÊ·Î ³ªÅ¸³½ °ªÀÔ´Ï´Ù. ÄÊ, ¿­³ª Å©°ÚÁÒ? ...°ÅºÁ...±×·¡¼­ ±×³É ³Ñ¾î°¡Àڴϱñ... -_-;;;)

[^0^ ÀÌ timestamp¸¦ °¡Áö°í ¿©·¯ ÀÏÀ» ÇÒ ¼ö ÀÖÁÒ...]

ÈìÈì...

date() ÇÔ¼ö´Â ´Ùµé Àß ¾Æ½ÃÁÒ? ´ëºÎºÐ ³¯Â¥ ½Ã°£À» Ãâ·ÂÇϴµ¥ ¾²ÁÒ. echo date("Y-m-d"); ¶ó±¸ Çϸé ÇöÀçÀÇ ³â-¿ù-ÀÏÀÌ Ãâ·ÂµÇÀݾƿä. ¿ä³Ñ¿¡ timestamp¸¦ ÀÌ¿ëÇϸé, ±× timestamp¿¡ ÇØ´çÇÏ´Â ÁöÁ¤ÇÑ Çü½ÄÀÇ °á°ú°ªÀ» ¾òÀ» ¼ö ÀÖ¾î¿ä. ÄÊ... ¹®ÀåÀÌ ²¿¿´´Ù... (´Ùµé ÀÌÇØÇϽÃÁ®? ÄÊ... µ¹³¯¾Æ¿Â´ç... @.@)

$PHP_SELF´Â ÇöÀç ¼öÇàÁßÀÎ ÆÄÀÏ ÀÚ±â ÀÚ½ÅÀ» ¶æÇØ¿ä... ¾Æ¹«°÷¿¡³ª Àú ¹®Àå ³ÖÀ¸¸é µ¹¾Æ°¡µµ·Ï ÀÌ·¸°Ô ÇßÁÒ... ¹Ù·Î ÆÄÀϸíÀ» Àû¾îµµ µÇ°Åµç¿ä~ ^^;

echo $PHP_SELF; Çؼ­ Ãâ·ÂÇغ¸¸é ¾Ë°ÚÁö¸¸ °æ·Î Æ÷ÇÔÇØ ÆÄÀϸíÀÌ ³ªÅ¸³ª±â ¶§¹®¿¡ ¿©±â¼­ basename()À» ÅëÇØ ÆÄÀÏ¸í¸¸ ½ï »Ì¾Æ³½ °Å¿¡¿ä. ¹Ý´ë·Î dirname() ÇÔ¼ö´Â µð·ºÅ丮¸í¸¸ ½ï »Ì¾Æ³»ÁÒ. ^^; ÄÑÄÑ...

´Ù½Ã ÇÔ »ìÆ캼±î¿±? Äڵ带 ¿Ã·Á³õ°í,

<? $file = stat(basename($PHP_SELF)); echo date("Y-m-d (h:i:s a)", $file[9]); ?>

¿©±â¼­ óÀ½ ÄÚµå,
$file = stat(basename($PHP_SELF));

¼ø¼­´ë·Î º¸¼¼¿ä. $PHP_SELF´Â ÇöÀç ½ÇÇàÁßÀÎ ÆÄÀÏÀÌ°í (°æ·ÎÆ÷ÇÔ), ÀÌ°ÍÀ» basename ÇÔ¼ö¸¦ ÀÌ¿ëÇØ ÆÄÀÏ¸í¸¸ »Ì¾Æ¼­ stat ÇÔ¼ö¸¦ ÀÌ¿ëÇØ ÆÄÀÏ¿¡ ´ëÇÑ Á¤º¸¸¦ $file¿¡ ÀúÀåÇÕ´Ï´Ù. [¹è¿­º¯¼ö°¡ µÇÁÒ]

µÎ¹ø° ÄÚµå,
echo date("Y-m-d (h:i:s a)", $file[9]);

$file[9]¿¡ ÀúÀåµÈ timestamp¸¦ ÀÌ¿ëÇØ ³â-¿ù-ÀÏ (½Ã:ºÐ:ÃÊ am/pm) Çü½ÄÀ¸·Î Ãâ·ÂÀ» ÇÕ´Ï´Ù. ³Ñ °£´ÜÇÏ°Ô ³¡³µÁÒ? ]]>
Fri, 13 Apr 2001 07:04:58
<![CDATA[Á¤¼ö,¹Ý¿Ã¸²,¿Ã¸²]]> ¹Ý¿Ã¸² ¶Ç´Â ¹«Á¶°Ç ¿Ã¸²À» ÇÏ´Â °æ¿ì°¡ ÀÖ´Ù

1. Á¤¼ö

$test = intval(3.5);

Çϸé $test = 3 À¸·Î Á¤¼ö¸¸À» ÃëÇÑ´Ù

2. ¹Ý¿Ã¸² ÇÔ¼ö

$test = round(3.5);
Çϸé $test=4 ·Î ¹Ý¿Ã¸² ¼ö¸¦ ¹ÝȯÇÑ´Ù.

3. ¿Ã¸²ÇÔ¼ö

$test = ceil(3.4);

$test = 4; ÀÇ °ªÀ» ¹ÝȯÇÑ´Ù.

ÀÚ·áÃâó : http://ychat.sarang.net/]]>
Fri, 13 Apr 2001 07:05:42