ÈçºÎÔÚ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½øÐн»»¥Ê½²Ù×
Ïà¹ØÎĵµ£º
×÷ΪʵÏÖ¶¯Ì¬ÍøÕ¾µÄ¹¤¾ßÖ®Ò»£¬PHPÒÔÆäÓï·¨¼òµ¥¡¢¸ßЧ¿ìËٺͶÔÊý¾Ý¿âµÄ¹ã·ºÖ§³Ö¶øÉîÊÜÓû§»¶Ó¡£±àдPHP³ÌÐòºÍASPÒ»ÑùÐèÒªÔÚ±¾»úµ÷ÊÔ£¬Îª´ËÐèÒªÅäÖÃһϵ÷ÊÔ»·¾³¡£
Óкܶ෽°¸¿ÉÒÔÑ¡Ôñ£¬ÕâÀïÌṩÁ½ÖÖ½ÏΪ¼òÒ׵ķ½·¨¡£
²»¹ÜÊÇÄÄÖÖ·½·¨£¬¶¼ÐèÒª°²×°PHP¡£Èç¹ûÄãÊÇPHPʹÓÃÕߣ¬Äã¿ÉÄÜÔÚÍøÉÏÕÒ¹ýPHPµÄ°²×°×ÊѶ£¬ËüÃǼ¸ºõ¶¼ËµµÄ ......
array_flip
½»»»Êý×éÖеļüºÍÖµ
$arr1 = array('a'=>1,'b'=>2,'c'=>3,'d'=>4);
$array = array_flip($arr1);
showArr($array);
/*
Array
(
[1] => a
[2] => b
[3] => c
[4] => d
)
*/
array_key_exists
¼ì²é¸ø¶¨µÄ¼üÃû»òË÷ÒýÊÇ·ñ´æÔÚÓÚÊý×éÖÐ(Ò²¿ÉÓÃÓÚ¶ÔÏó ......
×ªÔØµÄPHPÃæÊÔÌâ
1. »ù±¾ÖªÊ¶µã
HTTPÐÒéÖм¸¸ö״̬ÂëµÄº¬Òå:503 500 401 200 301 302¡£¡£¡£
Include require include_once require_once µÄÇø±ð.
PHP/MysqlÖм¸¸ö°æ±¾µÄ½ø»¯Ê·£¬±ÈÈçmysql4.0µ½4.1£¬PHP 4.xµ½5.1µÄÖØ´ó¸Ä½øµÈµÈ¡£
HEREDOC½éÉÜ
д³öһЩphpħ»Ã·½·¨;
һЩ±àÒëphpʱµÄconfigure ²ÎÊý
Ïòphp´«Èë ......
»ù±¾Ë¼Â·£ºÍ¨¹ý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Ö ......