PHP ÖÐʹÓÃoracle »·¾³ÅäÖÃ
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 Êý¾Ý¿âÁ¬½ÓµÄ×î¼òµ¥·½Ê½£¬ËüÖ»ÐèÒª°²×°Èý¸ö¿â¡£
PHP ·ÃÎÊ Oracle µÄµ±Ç° API ËùʹÓÃµÄ Instant Client ¿â³Æ×÷ OCI8.£¨´Ë C ½Ó¿ÚµÄÃû³Æ×îÔçÊÇÔÚ Oracle8 ÖÐÒýÈëµÄ¡££©PHP Oracle 8 º¯Êý ¿ÉÒÔÖ±½Óµ÷Óà Oracle 8.1.7¡¢9.x »ò 10.x£¬»òÕßÒ²¿ÉÒÔΪÁË·½±ãÆð¼û£¬Ê¹ÓÿÉÑ¡µÄ³éÏóÀ࣬Èç PEAR MDB2 ºÍ ADOdb¡£
Instant Client Ò²¿ÉÒÔʹÓÃÀϰ汾µÄ PHP“oracle”À©Õ¹£¬µ«Ëüµ÷Óò»ÔÞ³ÉʹÓÃµÄ Oracle API¡£PHP ½ç»ò Oracle ½¨Ò鲻ҪʹÓôËÀ©Õ¹½øÐÐеĿª·¢¡£
ÒªÔÚ Apache ÉϽ« Instant Client Óë PHP 4 »ò Á¬Óã¬Çë×ñÑÒÔϲ½Öè¡£ÐèÒªÒ»¸öÏÖÓÐµÄ Oracle Êý¾Ý¿â£»Instant Client ²»Ìṩ Oracle Êý¾Ý¿â¡£Í¨³£Çé¿öÏ£¬´ËÊý¾Ý¿â½«Î»ÓÚÆäËû¼ÆËã»úÉÏ¡£Èç¹ûÊý¾Ý¿âλÓÚ±¾µØ£¬Ôò Oracle ×é¼þÒ»°ãÔçÒÑ¿ÉÓ㬴Ӷø²»ÐèÒª Instant Client¡£
Èí¼þÐèÇó£º
Èí¼þ
¸½×¢
Oracle Instant Client
ÏÂÔØ“Instant Client Package - Basic”¡£ÔÚ Linux ÉÏ£¬»¹Ó¦ÏÂÔØ“Instant Client Package - SDK”¡£
Apache HTTPD Server
PHP ½çÈÔÍÆ¼ö Apache 1.3
PHP — PHP ³¬Îı¾´¦ÀíÆ÷
4.3 °æ»ò¸ü¸ß°æ±¾
ÔÚ Windows ÉÏÆôÓà PHP OCI8 À©Õ¹
Instant Client ¶þ½øÖÆÎļþÊÇ PHP µÄ Windows Ô¤¹¹½¨¶þ½øÖÆÎļþµÄ²¹³ä¡£
ÏÂÔØ PHP ¶þ½øÖÆÑ¹ËõÎļþ£¨²»Êǰ²×°³ÌÐò°æ±¾£©ºÍ Apache¡£°´ÕÕ PHP ÊÖ²áÖÐµÄ Windows ϵͳÉϵݲװ°²×°ËüÃÇ¡£OTN µÄ¿ª·ÅÔ´´úÂ뿪·¢ÈËÔ±ÖÐÐİüº¬ÓÐÓñ³¾°×ÊÁϵÄÁ´½Ó£¬Èç“ÔÚ Windows 2000/XP Éϰ²×° Oracle¡¢PHP ºÍ Apache”£¬Ëü½éÉÜÁËÈçºÎ°²×°´«Í³¡¢ÍêÕûµÄ Oracle 10g °æ±¾£¨Instant Client ²»ÐèÒª´Ë°æ±¾£©¡£
¼ÌÐø²Ù×÷֮ǰ¼ì²é PHP ÊÇ·ñÕý³£ÔËÐС£´Ë½×¶ÎδÆôÓà Oracle Ö§³Ö¡£
´Ó OTN µÄ Instant Client Ò³ÃæÏÂÔØÓÃÓÚ Windows µÄ Instant Client Basic ³ÌÐò°ü¡£´ËѹËõÎļþµÄ´óС´óԼΪ 30MB¡£
´´½¨Ò»¸ö×ÓĿ¼£¨ÀýÈ磬c:\instantclient10_1£©£¬È»ºó´ÓѹËõÎļþÖи´ÖÆÒÔÏ¿⣺
oraociei10.dll
orannzsbb10.dll
oci.dll
ÕâÈý¸öÎļþµÄ×Ü´óС´óԼΪ 80MB¡£
ҪʹÓà PHP Àϰ汾µÄ“oracle”À©Õ¹£¨ÔÚ php.in
Ïà¹ØÎĵµ£º
×÷ΪʵÏÖ¶¯Ì¬ÍøÕ¾µÄ¹¤¾ßÖ®Ò»£¬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ÖÐʹÓùýSESSIONµÄÅóÓÑ¿ÉÄÜ»áÅöµ½Õâôһ¸öÎÊÌ⣬ÔÚijЩ¿Í»§¶ËµçÄÔÉÏSESSION±äÁ¿²»ÄÜ¿çÒ³´«µÝ¡£ÕâÁîÎÒ¿àÄÕÁ˺ÃЩÈÕ×Ó£¬×îÖÕͨ¹ý²é×ÊÁÏ˼¿¼²¢½â¾öÁËÕâ¸öÎÊÌâ¡£ÎÒÈÏΪ£¬³öÏÖÕâ¸öÎÊÌâµÄÔÒòÓÐÒÔϼ¸µã£º
1¡¢¿Í»§¶Ë½ûÓÃÁËcookie
2¡¢ä¯ÀÀÆ÷³öÏÖÎÊÌ⣬ÔÝʱÎÞ·¨´æÈ¡cookie
3¡¢php.iniÖеÄsession.use_trans_sid = 0»òÕß±àÒë ......
Oracle RAC Workload Management:
service usage preferred instances available instances prority response time warning/critical
ERP &nb ......
ôßÉÏͨ¹ýÔ¤±àÒë²ûÊöµÀ¹²Ïí³Ø×îºóµ½SGA£¬ÕâÀï½øÒ»²½ËµÃ÷Ò»ÏÂSGAÖÐÁíÒ»¸ö´ó¿é£¬Êý¾Ý»º³åÇø£¬Ð¯´øÌá¼°Ò»µãÊý¾ÝÎļþºÍ±í¿Õ¼ä£¬ºóÐø×¨ÃÅ»á˵Ã÷Õâ¿é¡£
Ê×ÏÈÁ˽âÏÂSGAÖÖ´óÖÂÓÐÄÇЩ¶«Î÷£¬ÕâЩ¶«Î÷Ëæ×ÅÊý¾Ý¿â°æ±¾µÄÔö¼Ó»áÓÐËùÔö¼Ó£¬²»¹ý´óÖÂÉÏÓ¦¸ÃÒ»Ö£¬ÕâÒ²ÊÇ»ù±¾ËùÓеÄÌåϵ½á¹¹¶¼»áÃèÊöµÄ¶«Î÷£º
ÔÚÈÏʶÊý¾Ý»º³åÇøÇ°£¬ÏȼÇס¼¸¸ö³ ......