|
Total related article : 3 |
|
µî·ÏÀÏ: | 2001-05-29 |
½Ã°£: | 22:52:10 |
Á¶È¸¼ö: | 2636 |
from: | 211.33.56.52 |
|
[Áú¹®] perl¿¡¼ mysql¿¬µ¿½Ã.... |
±Û¾´ÀÌ : progkim3 |
|
¾È³çÇϼ¼¿ä... $dbh = DBI->connect("$dsn", "$user", "$pw"); À» ÀÌ¿ëÇØ ¿¬°áµÈ ÈÄ $sth = $dbh->prepare("select * from first where name is not null or die print "$DBI::errsrt"; ÀÇ prepare¶ó´Â ÇÔ¼ö¸¦ ½á¼ ¾È¿¡ sql¹®À» ¼¼úÇÏ¸é µÇ´Â°Ì´Ï±î? ±×·¸°Ô ÇÏ¸é ±× °á°ú¹°ÀÌ sth¿¡ ÀúÀåµÇ´Â°ÍÀ̱¸¿ä?
±ÛŸ¹§... $sth->execute(); ÀÌ°Ç ¹«¾ùÀÎÁö¿ä? ¶ÇÇÑ, $sth->fetchrow_array ÀÌ°Ç ¹«¾ùÀ» ¶æÇմϱî? ÀÚ¼¼È÷ ¼³¸íÇØ ÁÖ¼¼¿ä....--;
|
|
   |
|
µî·ÏÀÏ: | 2001-05-30 |
½Ã°£: | 17:38:20 |
Á¶È¸¼ö: | 2635 |
from: | 211.109.189.47 |
|
[´äº¯] [Áú¹®] perl¿¡¼ mysql¿¬µ¿½Ã.... |
±Û¾´ÀÌ : vopos |
|
¾È³çÇϼ¼¿ä, HappyCGI ÆÀÀÇ voposÀÔ´Ï´Ù.
MySQL Perl DBI/DBD ¸Þ´º¾óÀ» º¸½Ã±â ¹Ù¶ø´Ï´Ù.
http://www.savebaseball.com/mysql/DBD_3.22.X.php3 http://www.mysql.com/doc/P/e/Perl.html
°¨»çÇÕ´Ï´Ù.
- vopos
/=========================================================== ÀÚÁÖ¹¯´Â Áú¹® Æ÷·³°ú Æ÷·³°Ë»öÀ» ÀÌ¿ëÇϼż ºñ½ÁÇÑ Áú¹®ÀÇ ´äº¯ÀÌ ÀÖ´ÂÁö È®ÀÎÇÏ½Ã°í ±Û ¿Ã·ÁÁÖ½Ã±æ ºÎŹµå¸³´Ï´Ù. ============================================================/
|
|
   |
|
µî·ÏÀÏ: | 2001-05-31 |
½Ã°£: | 15:15:42 |
Á¶È¸¼ö: | 2744 |
from: | 211.109.189.47 |
|
      [´äº¯] [Áú¹®] perl¿¡¼ mysql¿¬µ¿½Ã.... |
±Û¾´ÀÌ : HappyCGI |
|
>¾È³çÇϼ¼¿ä... >$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°³ÀÇ °Ë»öµÈ °ªµéÁß ¼øÂ÷ÀûÀ¸·Î ¹è¿·Î ¸Í±×·¯¶ó ±×·±¶æÀÌ ¾Æ´Ò±î¿ä? (¿ª½Ã ¾Ï »ý°¢¾øÀÌ ½á¿Â Å¿À̶ó Àǹ®¾øÀÌ ¾²°í ÀÖ½À´Ï´Ù. ^^)
>ÀÚ¼¼È÷ ¼³¸íÇØ ÁÖ¼¼¿ä....--;
µµ¿òÀÌ µÇ¾úÀ¸¸é ÁÁ°Ú±º¿ä.
|
|
   |