ÈçºÎÔÚ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½øÐн»»¥Ê½²Ù×
Ïà¹ØÎĵµ£º
Linux + Apache2.0 + Mysql + PHP + phpBB3.0
1.°²°ü£º
Apache2.0
#tar -zxf httpd-***.tar.gz -C /usr/local/src/
#cd /usr/local/src/httpd-***
  ......
»ù±¾Ë¼Â·£ºÍ¨¹ýSOCKETÇëÇóÆäËûPHP½Å²½£¬ÊµÏÖPHPµÄ¶à½ø³ÌµÄÒì²½Ö´ÐС£
·Ï»°¾Í²»¶à˵ÁË£¬Çë¿´ÏÂÃæµÄ½Å²½²¢Ö´ÐÐÖ®¡£
<?php
//a.php
function runThread(){
$fp = fsockopen('127.0.0.1', 82, $errno, $errmsg);
fputs($fp, "GET /a.php?act=b\r\n"); //ÕâÀïµÄµÚ¶þ¸ö²ÎÊýÊÇHTTPÐÒéÖй涨µÄÇëÇóÍ·
//²»Ã÷°×µÄÇë¿´RFCÖ ......
ôßÉÏͨ¹ýÔ¤±àÒë²ûÊöµÀ¹²Ïí³Ø×îºóµ½SGA£¬ÕâÀï½øÒ»²½ËµÃ÷Ò»ÏÂSGAÖÐÁíÒ»¸ö´ó¿é£¬Êý¾Ý»º³åÇø£¬Ð¯´øÌá¼°Ò»µãÊý¾ÝÎļþºÍ±í¿Õ¼ä£¬ºóÐø×¨ÃÅ»á˵Ã÷Õâ¿é¡£
Ê×ÏÈÁ˽âÏÂSGAÖÖ´óÖÂÓÐÄÇЩ¶«Î÷£¬ÕâЩ¶«Î÷Ëæ×ÅÊý¾Ý¿â°æ±¾µÄÔö¼Ó»áÓÐËùÔö¼Ó£¬²»¹ý´óÖÂÉÏÓ¦¸ÃÒ»Ö£¬ÕâÒ²ÊÇ»ù±¾ËùÓеÄÌåϵ½á¹¹¶¼»áÃèÊöµÄ¶«Î÷£º
ÔÚÈÏʶÊý¾Ý»º³åÇøÇ°£¬ÏȼÇס¼¸¸ö³ ......
Oracle·¢²¼Ãâ·ÑÊý¾Ý¿â¿ª·¢¹¤¾ßSQL Developer 1.2
2007.09.25 À´×Ô£ºCSDN¡¡ ÄŲ»º° ¹²ÓÐÆÀÂÛ()Ìõ ·¢±íÆÀÂÛ ÊÕ²Ø
Oracle SQL DeveloperÊǼ׹ÇÎĹ«Ë¾Ãâ·ÑÌṩµÄÊý¾Ý¿â¿ª·¢¹¤¾ß£¬¿É°ïÖúÓû§¼ò»¯¿ª·¢¹¤×÷£¬Ìá¸ß±àÖÆºÍµ÷ÊÔSQLºÍPL/SQL´úÂëµÄЧÂÊ¡£ÏÖÔÚ£¬Õâ¸öÃâ·Ñ¹¤ ......
°ì·¨Ò»
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 ......