½ÃÀÛÆäÀÌÁö·Î Áñ°Üã±âÃß°¡
·Î±×ÀÎ
ȸ¿ø°¡ÀÔ l Ã⼮üũ l ¸¶ÀÌÆäÀÌÁö l CGIMALL
ÀÚ·á½Ç »çÀÌÆ®µî·Ï ·©Å·100 ÇÁ·Î±×·¥¸®ºä °ü¸®ÀÚÃßõÀÚ·á Ãʺ¸°¡À̵å
Ä¿¹Â´ÏƼ
Àüü ÆîÃ帱â
Äü¸Þ´º¸µÅ© jquery , CSS , PHP , Javascript , ¹«·áÆùÆ® , ASP
»ó¼¼°Ë»ö
Ȩ > Ä¿¹Â´ÏƼ > Áú¹®°ú´äº¯ »ó¼¼º¸±â
Ä¿¹Â´ÏƼ ±¸Àα¸Á÷
»çÀÌÆ®µî·Ï
Ŭ¶ó¿ìµåű×
Javascript
PHP
asp
CSS
html
mysql
jquery
image
Mobile
API
slide
°Ô½ÃÆÇ
¸Þ´º
ÇöÀçÁ¢¼ÓÀÚ ¸í »õ·Î°íħ
°Ô½ÃÆÇŸÀÌƲ Áú¹®°ú´äº¯ / »ó¼¼º¸±â
Æ®À§ÅÍ·Î º¸³»±â
Ãßõ¼ö 145 | Á¶È¸¼ö 2,757 | µî·ÏÀÏ 2004-06-22 01:12:45

´Ð³×ÀÓ

pstokyo

À̸ÞÀÏ

pstokyo@dicer.org

Á¦¸ñ

perl·Î § cgi¿¡¼­ ¿ø°Ý dbÁ¢¼ÓÇÏ´Â ¹æ¹ýÀº?
³»¿ë

Àоî Áּż­ °¨»çµå¸®±¸¿ä

ÀúÈñ°¡ web¼­¹ö¶û db¼­¹ö¸¦ ºÐ¸® Çß½À´Ï´Ù.

µû¶ó¼­ cgiºÎºÐ¿¡ ¹Ù²ã ÁÙ·Á±¸ Çϴµ¥¿ä.

Á¢¼ÓÇÏ´Â ºÎºÐÀº

use DBI;
$ENV{'ORACLE_HOME'} = '/oracle/app/oracle/product/8.1.7';
$ENV{TWO_TASK}      = 'dbaaa';
$dbh=DBI->connect("dbi:Oracle:aaa","scott","tiger") || die "Cannot connect\n";
$sth=$dbh->prepare(qq|select * from ccc order by bbb|);
$sth->execute();

ÀÌ·¸½À´Ï´Ù. dbaaa¶ó´Â tnsnames ¶ó´Â°Ç ÀÌ¹Ì ¼³Á¤ÇØ µÎ¾ú±¸¿ä., ¸®½º³Ê·Î Å×½ºÆ® ÇßÀ»¶§µµ Àß µË´Ï´Ù.

À̺κп¡¼­ ccc¶ó´Â Å×À̺íÀ» dbaaa¶ó´Â ¼­¹ö¿¡ °ÍÀ» »ç¿ëÇÒ·Á¸é ¾î¶² ºÎºÐÀ» Ãß°¡ÇؾߵÅÁÒ?

¿ø°Ýdb¿¡ Á¢¼ÓÇÏ´Â°Ç ¼Ò½º°¡ Àß ¾ø¾î¼­ Áú¹®¿Ã¸³´Ï´Ù.

ÁÁÀº ÇÏ·ç µÇ½Ã±¸¿ä. ¿°Ä¡ºÒ±¸ÇÏ°í ÁÁÀº ´äº¯ ºÎŹµå¸³´Ï´Ù ²Ù¹÷ ('')(..)('')

 

Ãßõ½ºÅ©·¦¼Ò½ºº¸±â ¸ñ·Ï
ÀÌÀü°Ô½Ã±Û À©µµ¿ì¿Í ¸®´ª½º ¼­¹öÀÇ Àå´ÜÁ¡Àº¿©? 2004-06-21 16:58:10
´ÙÀ½°Ô½Ã±Û ½ºÅ©¸³Æ® °í¼ö´Ôµé..Æ®¸®Çà ÄÞº¸¿ä... 2004-06-22 13:48:09