ÈçºÎÔÚPHPÖÐʹÓÃOracleÊý¾Ý¿â
http://www.builder.com.cn/2007/1027/583048.shtml
ÔÚphp3.0ÒÔÉϰ汾ÖУ¬phpÄÚÖÃÁ˼¸ºõĿǰËùÓеÄÊý¾Ý¿â´¦Àíº¯Êý£¬°üÀ¨Oracle;ÔÚ±¾ÎÄÖÐÎÒÃÇͨ¹ýÒ»¸öʵÀýÀ´½éÉÜÁËÈçºÎʹÓÃÕâЩº¯ÊýÀ´²Ù×÷OracleÊý¾Ý¿â¡£
PHPÌṩÁË2´óÀàAPI(Ó¦ÓóÌÐò½Ó¿Ú)À´²Ù×÷OracleÊý¾Ý¿â¡£Ò»¸öÊDZê×¼µÄOracle´¦Àíº¯Êý(ORA) ÁíÒ»¸öÊÇOracle 8µ÷Óýӿں¯Êý(OCI8). ºóÕßÖ»ÄÜÔÚOracle 7»ò8°æ±¾ÉÏʹÓᣠÓÉÓÚOCI8 ÌṩÁ˺ܶàÓÅ»¯Ñ¡ÏÒò´ËÖ»ÒªÓпÉÄܾÍÓ¦¸Ã²ÉÓà OCI8 ½Ó¿Ú¡£ÕâÀïÎÒÃÇ·Ö±ðÓÃÕâ¶þÖÖº¯Êý¼¯½øÐÐÁËÑÝʾ¡£
Ê×Ïȱ¾ÎĵÄǰÌá¼ÙÉèÄãÒѾװºÃÁË OracleÊý¾Ý¿â»·¾³ ºÍ PHP ¿ª·¢»·¾³. Èç¹û²»¶®Ò²Ã»¶à´ó¹ØÏµ£¬ÍøÉÏÓкܶàÏà¹ØµÄºÃÎÄÕ¿ÉÒԲο¼¡£
µÚÒ»²½£º´´½¨ Ò»¸öʵÑéÓõÄÊý¾Ý¿â
Õâ¸öÎÊÌâÄã¿ÉÒÔÇëÄãµÄÊý¾Ý¿â¹ÜÀíÔ±»ò²Î¿¼OracleÓû§ÊֲᴦÀí£¬ÕâÀï²»Ôٶི
Óà ORA ½¨Á¢Êý¾Ý±í
¼´Ê¹ÄãÒѾ´´½¨ºÃÁËÊý¾Ý±í£¬Ò²Çë¿´¿´±¾¶ÎÎÄ×Ö¡£Ëü¿ÉÒÔ¸æËßÄãÈçºÎÓÃPHP+SQLµÄ¼¼Êõ²Ù×÷Oracle
ÔÚ±¾ÀýÖÐÎÒÃÇ´´½¨ÁËÒ»¸öÓÃÓÚ´æ·Å¸öÈËemailµÄÊý¾Ý±í
Ïà¹ØPHP´úÂë:
PutEnv("ORACLE_SID=ORASID");
$connection = Ora_Logon ("username", "password");
if ($connection == false){
echo Ora_ErrorCode($connection).": ".Ora_Error($connection)."
";
exit;
}
$cursor = Ora_Open ($connection);
if ($cursor == false){
echo Ora_ErrorCode($connection).": ".Ora_Error($connection)."
";
exit;
}
$query = "create table email_info " .
"(fullname varchar(255), email_address varchar(255))";
$result = Ora_Parse ($cursor, $query);
if ($result == false){
echo Ora_ErrorCode($cursor).": ".Ora_Error($cursor)."
";
exit;
}
$result = Ora_Exec ($cursor);
if ($result == false){
echo Ora_ErrorCode($cursor).": ".Ora_Error($cursor)."
";
exit;
}
Ora_Commit ($connection);
Ora_Close ($cursor);
Ora_Logoff ($connection);
?>
ΪÁË´¦ÀíOracleÊý¾Ý¿â£¬ÎÒÃÇÊ×ÏÈÒªºÍOracle½¨Á¢Ò»¸öÁª½á¡£
Óï·¨ÊÇ Ora_Logon (user, password),·µ»ØÒ»¸öconnectID..
ÌáÐÑ: ÔÚ´Ë֮ǰÎÒÃÇ»¹±ØÐëÉèÖû·¾³±äÁ¿: ORACLE_SIDµÄÖµ.
ÏÖÔÚ£¬ÎÒÃÇ¿ÉÒÔͨ¹ý¸ÃÁª½áµÄ ID¶ÔOracle½øÐн»»¥Ê½²Ù×
Ïà¹ØÎĵµ£º
ʹÓÃpopen½áºÏSHELLÃüÁîÒ²¿ÉÒÔʵÏÖ¶à½ø³Ì²¢·¢±à³Ì¡£
ʵÀýÈçÏ£º
<?php
//b.phpÎļþ
$file = 'testdir/file.txt';
for ($i=0;$i<10;$i++){
$fp = fopen($file,'a+');
fputs($fp, $i.'\r\n');
fclose($fp);
sleep(1);
}
?> ......
ôßÉÏͨ¹ýÔ¤±àÒë²ûÊöµÀ¹²Ïí³Ø×îºóµ½SGA£¬ÕâÀï½øÒ»²½ËµÃ÷Ò»ÏÂSGAÖÐÁíÒ»¸ö´ó¿é£¬Êý¾Ý»º³åÇø£¬Ð¯´øÌá¼°Ò»µãÊý¾ÝÎļþºÍ±í¿Õ¼ä£¬ºóÐø×¨ÃÅ»á˵Ã÷Õâ¿é¡£
Ê×ÏÈÁ˽âÏÂSGAÖÖ´óÖÂÓÐÄÇЩ¶«Î÷£¬ÕâЩ¶«Î÷Ëæ×ÅÊý¾Ý¿â°æ±¾µÄÔö¼Ó»áÓÐËùÔö¼Ó£¬²»¹ý´óÖÂÉÏÓ¦¸ÃÒ»Ö£¬ÕâÒ²ÊÇ»ù±¾ËùÓеÄÌåϵ½á¹¹¶¼»áÃèÊöµÄ¶«Î÷£º
ÔÚÈÏʶÊý¾Ý»º³åÇøÇ°£¬ÏȼÇס¼¸¸ö³ ......
°ì·¨Ò»
select * from V$NLS_PARAMETERS
$conn = oci_connect('scott', 'donkey', 'demo', 'zhs16gbk');
while ($dat = oci_fetch_row($cur)) {
print_r(iconv('gb2312', 'utf-8', $dat[0])); //$nickname = mb_convert_encoding($dat[0], 'utf-8', 'gbk');&n ......
http://www.oracle.com/technology/global/cn/pub/notes/technote_php_instant.html
Ϊ Linux ºÍ Windows °²×° PHP ºÍ Oracle 10g Instant Client
×÷ÕߣºChristopher Jones£¬¼×¹ÇÎĹ«Ë¾µÄ×Éѯ¼¼ÊõÈËÔ±
·¢²¼ÈÕÆÚ£º2004 Äê 12 ÔÂ
Oracle 10g Instant Client£¨Ãâ·ÑÏÂÔØ£©ÊÇPHP ÓëÔ¶³Ì Oracle Êý¾Ý¿âÁ¬½ÓµÄ×î¼òµ¥·½Ê½£¬Ëü ......