|
|
ÇöÀçÀ§Ä¡: ¸ÞÀÎ ÇØÇÇÆ÷·³ À¥µðºñ : °Ô½Ã¹° Àбâ |
|
|
  2001-05-31 (15:15:42) from 211.109.189.47 |
|
|
  ÀÛ¼ºÀÎ : HappyCGI |
Á¶È¸¼ö : 2743    |
|
Á¦¸ñ : [´äº¯] [Áú¹®] perl¿¡¼ mysql¿¬µ¿½Ã.... |
>¾È³çÇϼ¼¿ä... >$dbh = DBI->connect("$dsn", "$user", "$pw"); >À» ÀÌ¿ëÇØ ¿¬°áµÈ ÈÄ >$sth = $dbh->prepare("select * from first where name is not null or die print "$DBI::errsrt"; >ÀÇ prepare¶ó´Â ÇÔ¼ö¸¦ ½á¼ ¾È¿¡ sql¹®À» ¼¼úÇÏ¸é µÇ´Â°Ì´Ï±î?
³× ±×·¸½À´Ï´Ù. update³ª delete insert ±¸¹®Àº prepare ´ë½Å do ¸¦ ¾²¸é µÇ±¸¿ä.
>±×·¸°Ô ÇÏ¸é ±× °á°ú¹°ÀÌ sth¿¡ ÀúÀåµÇ´Â°ÍÀ̱¸¿ä?
ÀúÀåÀº ¸»¾¸µå·ÈµíÀÌ do ¸¦ ¾²¼Å¾ß µË´Ï´Ù. ±¸¹®Àº sql ±¸¹®À» ¾È¿¡ ³Ö±¸¿ä.
> >±ÛŸ¹§... $sth->execute(); ÀÌ°Ç ¹«¾ùÀÎÁö¿ä?
mysql¿¡¼ prepare ÇÑ ±¸¹® Áï ÁغñÇؼ Àоî³Â´ø Á¤º¸¸¦ ½ÇÇàÇÑ´Ù. ±× Á¤µµ°¡ ¾Æ´Ò±î¿ä? (±×³É ¾Ï»ý°¢¾øÀÌ ¾´°Å¶ó Àúµµ ½ÇÀº Àß ¸ô¶ó¿ä. ^^)
>¶ÇÇÑ, $sth->fetchrow_array ÀÌ°Ç ¹«¾ùÀ» ¶æÇմϱî?
mysql¿¡¼ ÀÐÀº °ªµéÀÇ ÇÑÁÙ ±×·¯´Ï±î 11°³ÀÇ °Ë»öµÈ °ªµéÁß ¼øÂ÷ÀûÀ¸·Î ¹è¿·Î ¸Í±×·¯¶ó ±×·±¶æÀÌ ¾Æ´Ò±î¿ä? (¿ª½Ã ¾Ï »ý°¢¾øÀÌ ½á¿Â Å¿À̶ó Àǹ®¾øÀÌ ¾²°í ÀÖ½À´Ï´Ù. ^^)
>ÀÚ¼¼È÷ ¼³¸íÇØ ÁÖ¼¼¿ä....--;
µµ¿òÀÌ µÇ¾úÀ¸¸é ÁÁ°Ú±º¿ä.
HappyCGI's SIGN
| °³¹ßÀÚÀÇ ¹Ì´öÀº
°ÔÀ¸¸§(Laziness) ÂüÁö¸»±â(Impatience) ±³¸¸(Hubris) |
|
|
|
¸Þ¸ð |
|
³²°ÜÁø ¸Þ¸ð°¡ ¾ø½À´Ï´Ù.
|
|
   |
|
|