>$dbh=DBI->connect("DBI:mysql:ppp", "ppp","ppp");
>$sth=$dbh->prepare("SELECT * FROM a");
>$sth=$dbh->execute;
>$sth=$dbh->finish;
>$dbh->disconnect;
>
>¶ó´Â ÇÁ·Î±×·¥À» ÀÛ¼ºÇÏ°í.... ½ÇÇàÇϸé... ¾Æ¹«·± Ãâ·Â°á°úµµ
>Ç¥½Ã µÇÁö ¾Ê´Âµ¥¿ä....
>select * from a; ÇÑ ÀڷḦ È­¸é¿¡ Ãâ·ÂÇϱâ À§ÇÏ¿© ÀúÀåµÇ´Â °ø°£Àº..
>¾ø´ÂÁö¿ä? ¾î¶»°Ô ÇØ¾ß Ãâ·ÂµÇ´Â °ÅÁÒ?


¾È³çÇϼ¼¿ä, HappyCGI ÆÀÀÇ voposÀÔ´Ï´Ù.

´ÔÀÇ Äڵ忡´Â °á°ú°ªÀ» Ãâ·ÂÇÏ´Â ºÎºÐÀÌ ¾ø±â ¶§¹®ÀÔ´Ï´Ù.

SQL¹®ÀÇ °á°ú°¡ $sth·Î ÀúÀåÀÌ µÇ´Âµ¥ Perl DBI ÇÔ¼ö Áß¿¡ °á°ú°ªÀ» ÇϳªÇϳª¾¿
Ãâ·ÂÇÏ´Â ±â´ÉÀ» È°¿ëÇؾߵ˴ϴÙ.

¿¹)

my @row;
while(@row = $sth->fetchrow_array) {
    print "$row[0] $row[1]\n";
}


¿©±â¼­´Â fetchrow_array ÇÔ¼ö¿Í while ¹®À» ÀÌ¿ëÇؼ­ °á°ú°ªÀ» ¸ðµÎ Ãâ·ÂÇÏ´Â ¿¹
Á¦ÀÔ´Ï´Ù. ±× ¿Ü¿¡µµ ¿©·¯ ÇÔ¼ö°¡ ÀÖÀ¸´Ï±î Âü°íÇϼ¼¿ä.

http://www.savebaseball.com/mysql/DBD_3.22.X.php3


°¨»çÇÕ´Ï´Ù.

- vopos

/----------------------------------------------------------------------------------------------------
ÀÚÁÖ¹¯´Â Áú¹® Æ÷·³°ú Æ÷·³°Ë»öÀ» ÀÌ¿ëÇϼż­ ºñ½ÁÇÑ Áú¹®ÀÇ ´äº¯ÀÌ ÀÖ´ÂÁö
È®ÀÎÇÏ½Ã°í ±Û ¿Ã·ÁÁÖ½Ã±æ ºÎŹµå¸³´Ï´Ù.
----------------------------------------------------------------------------------------------------/