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
Ïà¹ØÎĵµ£º
£¨1£©²éѯC01¿Î³Ì³É¼¨²»ÎªNullµÄѧÉúµÄÐÕÃûºÍ³É¼¨¡£
·ÖÎö£ºÒòÎªÉæ¼°µ½¿Î³Ì³É¼¨ºÍѧÉúÐÕÃû£¬ÐèÒª¶Ôstudent±íºÍsc±í½øÐÐÁ¬½Ó¡£
´úÂ룺
select sname,grade from student,sc where student.sno=sc.sno and c ......
ÔÚÐéÄâ»úRed Hat Enterprise Linux 4 update 4Öа²×°oracle 10.2.0.1
1)²é¿´ÏµÍ³ÄÚ´æ
[root@linux4 ~]# grep MemTotal /proc/meminfo
2)²é¿´½»»»Çø´óС
[root@linux4 ~]# grep SwapTotal /proc/meminfo
3)
²é¿´/tmpĿ¼´óС
[root@linux4 ~]# df -m /tmp
4)²é¿´²Ù×÷ϵͳ°æ±¾
[root@linux4 ~]# cat /etc/issue
5)¼ ......
ÔÚPHPÖÐʹÓùýSESSIONµÄÅóÓÑ¿ÉÄÜ»áÅöµ½Õâôһ¸öÎÊÌ⣬ÔÚijЩ¿Í»§¶ËµçÄÔÉÏSESSION±äÁ¿²»ÄÜ¿çÒ³´«µÝ¡£ÕâÁîÎÒ¿àÄÕÁ˺ÃЩÈÕ×Ó£¬×îÖÕͨ¹ý²é×ÊÁÏ˼¿¼²¢½â¾öÁËÕâ¸öÎÊÌâ¡£ÎÒÈÏΪ£¬³öÏÖÕâ¸öÎÊÌâµÄÔÒòÓÐÒÔϼ¸µã£º
1¡¢¿Í»§¶Ë½ûÓÃÁËcookie
2¡¢ä¯ÀÀÆ÷³öÏÖÎÊÌ⣬ÔÝʱÎÞ·¨´æÈ¡cookie
3¡¢php.iniÖеÄsession.use_trans_sid = 0»òÕß±àÒë ......
ÏÖÔÚ°ÑÔÚIISϰ²×°PHPµÄ¹ý³ÌÏêϸ¼Ç¼ÏÂÀ´±ãÓÚÈÕºóµÄѧϰ£»
ΪÁË·½±ã¸÷λ¶ÁÕßʹÓÃPHP£¬±ÊÕßÑ¡ÔñÁËPHP5.2°æ±¾£¬¶øIISÔòÊÇXPϵͳ×Ô´øµÄIIS 5¡£Ê×ÏÈÎÒÃÇÒª°²×°IIS×é¼þ£¬Ä¬ÈÏÇé¿öÏÂÔÚXPϵͳÊÇûÓа²×°µÄ¡£
¡¡µÚÒ»²½£ºÍ¨¹ý¿ØÖÆÃæ°åµÄÌí¼Ó/ɾ³ýWindows×é¼þÍê³ÉIIS×é¼þµÄ°²×°¹¤×÷¡£
¡¡µÚ¶ ......