Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÈçºÎÔÚ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

 Linux + Apache2.0 + Mysql + PHP + phpBB3.0
 1.°²°ü£º
   Apache2.0
         #tar -zxf httpd-***.tar.gz -C /usr/local/src/
         #cd /usr/local/src/httpd-***
       ......

PHP¶à½ø³ÌЭ×÷±à³ÌÖ® socket

»ù±¾Ë¼Â·£ºÍ¨¹ý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Ö ......

ORACLE SGAÖ®Êý¾Ý»º³åÇø£¨Data Buffer£©

ôßÉÏͨ¹ýÔ¤±àÒë²ûÊöµÀ¹²Ïí³Ø×îºóµ½SGA£¬ÕâÀï½øÒ»²½ËµÃ÷Ò»ÏÂSGAÖÐÁíÒ»¸ö´ó¿é£¬Êý¾Ý»º³åÇø£¬Ð¯´øÌá¼°Ò»µãÊý¾ÝÎļþºÍ±í¿Õ¼ä£¬ºóÐø×¨ÃÅ»á˵Ã÷Õâ¿é¡£
Ê×ÏÈÁ˽âÏÂSGAÖÖ´óÖÂÓÐÄÇЩ¶«Î÷£¬ÕâЩ¶«Î÷Ëæ×ÅÊý¾Ý¿â°æ±¾µÄÔö¼Ó»áÓÐËùÔö¼Ó£¬²»¹ý´óÖÂÉÏÓ¦¸ÃÒ»Ö£¬ÕâÒ²ÊÇ»ù±¾ËùÓеÄÌåϵ½á¹¹¶¼»áÃèÊöµÄ¶«Î÷£º
ÔÚÈÏʶÊý¾Ý»º³åÇøÇ°£¬ÏȼÇס¼¸¸ö³ ......

Oracle·¢²¼Ãâ·ÑÊý¾Ý¿â¿ª·¢¹¤¾ßSQL Developer 1.2


Oracle·¢²¼Ãâ·ÑÊý¾Ý¿â¿ª·¢¹¤¾ßSQL Developer 1.2
2007.09.25  À´×Ô£ºCSDN¡¡  ÄŲ»º°   ¹²ÓÐÆÀÂÛ()Ìõ ·¢±íÆÀÂÛ    ÊÕ²Ø
Oracle SQL DeveloperÊǼ׹ÇÎĹ«Ë¾Ãâ·ÑÌṩµÄÊý¾Ý¿â¿ª·¢¹¤¾ß£¬¿É°ïÖúÓû§¼ò»¯¿ª·¢¹¤×÷£¬Ìá¸ß±àÖÆºÍµ÷ÊÔSQLºÍPL/SQL´úÂëµÄЧÂÊ¡£ÏÖÔÚ£¬Õâ¸öÃâ·Ñ¹¤ ......

oracle apache phpÂÒÂëÎÊÌâ

°ì·¨Ò»
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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ