APACHE PHP5 ORACLEÉèÖÃ
ÔÚwindows ÏÂÅäÖÃPHPʹÓÃORACLEÊý¾Ý¿âÒªµã
ÔÚwindowÏ£¬¾³£ÓÃapache + PHP À´×öÓ¦ÓÃƽ̨£¬µ«ÊÇÈç¹ûʹÓÃoracle×öºǫ́Êý¾Ý¿â£¬µ«ÓÖûÓа²×°ÓÐoracle¿Í»§¶Ë£¬ÏÂÃæµÄÅäÖÿÉÒԲο¼
1¡¢ÔÚûÓа²×°oracleµÄ»úÆ÷ÉÏ£¬PHPÎÞ·¨¼ÓÔØphp_oci8.dllÄ£¿é£¬ÔÒòÊÇphp_oci8.dllÒÀÀµµÄÏà¹Ø×é¼þûÓÐÕÒµ½¡£
ÄãÕýÈ·ÉèÖÃÁËextension_dir = "C:\Apache\php\ext\"
²¢ÇÒ´ò¿ªÁË extension=php_oci8.dll
µ«ÊDz鿴apacheµÄÈÕÖ¾£¨ÔÚlogs/error.logÖУ©£¬·¢ÏÖÀàËƵĴíÎó
PHP Warning: PHP Startup: Unable to load dynamic library 'C:\\Apache\\php\\ext\\php_oci8.dll' - \xd5\xd2\xb2\xbb\xb5\xbd\xd6\xb8\xb6\xa8\xb5\xc4\xc4\xa3\xbf\xe9\xa1\xa3\r\n in Unknown on line 0
ÄǾͻáÊÇÉÏÃæÃèÊöµÄÇé¿ö£¬Ê¹ÓÃoracle8À©Õ¹ÐèÒª Oracle ¿Í»§¶Ë¿â¡£Windows Óû§ÐèÒªÖÁÉÙ°æ±¾ºÅΪ 10 µÄ¿â²ÅÄÜʹÓà php_oci8.dll¡£
µ½Õâ¸öµØÖ·ÏÂÔØÐèÒªµÄ°æ±¾ http://www.oracle.com/technology/tech/oci/instantclient/index.html
²»¹ý£¬ÏÂÔØÐèÒªÒ»¸ö×¢²á²Å¿ÉÒÔ£¬Èç¹ûÄãÒѾע²á¹ý£¬ÄÇôµÇ¼¾Í¿ÉÒÔÁË£¬ÄãÏÂÔغóÊÇÒ»¸özip°ü£¬Ö»Ðè°ÑÄǸö°ü½âѹµ½Ò»¸öĿ¼ÖÐ
±ÈÈç c:\oracle_client\ ÄÇô£¬°ÑÕâ¸öµØÖ·¼Óµ½ pathÖм´¿É
µ«ÊÇÕâÑù»¹²»¹»£¬»¹ÐèÒªÉèÖà TNS_ADMIN Õâ¸ö±äÁ¿£¬°ÑÕâ¸ö±äÁ¿µÄÖµÉèÖÃΪ tnsnames.oraÎļþËùÔÚµÄĿ¼¼´¿É¡£
ÏÂÃæÊÇtnsnames.oraµÄÀý×Ó
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
ÏÂÃæÊÇÒ»¸ö²âÊÔÀý×Ó
<?php
$connection = oci_connect("hr", "pass","orcl","UTF8");
$query = "SELECT * from user_tables";
$statement = oci_parse ($connection, $query);
oci_execute ($statement);
// ´òÓ¡Ö´Ðнá¹û
print '<table border="1">';
while($row = oci_fetch_array($statement, OCI_NUM)) {
 
Ïà¹ØÎĵµ£º
Ò»¡¢zend studioµÄÅäÖÃ
1.µ½zendµÄ°²×°Ä¿Â¼ÏÂɾ³ýÁ½¸öÎļþ(¿ÉÓпÉÎÞ.ÖÁÉÙÎÒ²»É¾³ýÒ²²»Òƶ¯¿ÉÒÔ)
ÎҵݲװĿ¼£ºD:\Program Files\Zend\Zend Studio - 7.0.2\plugins\
ɾ³ýµÄÎļþÊÇ£ºcom.zend.php.debug.core_7.0.0.v20090607-1658.jar
&nbs ......
Ç°ÑÔ
PHPÊÇÒ»ÖÖ±»¹ã·ºÊ¹ÓõĽű¾ÓïÑÔ£¬ÓÈÆäÊʺÏÓÚweb¿ª·¢¡£¾ßÓпçƽ̨£¬ÈÝÒ×ѧϰ£¬¹¦ÄÜÇ¿´óµÈÌص㣬¾Ýͳ¼ÆÈ«ÊÀ½çÓг¬¹ý34%µÄÍøÕ¾ÓÐphpµÄÓ¦Ó㬰üÀ¨Yahoo¡¢sina¡¢163¡¢sohuµÈ´óÐÍÃÅ»§ÍøÕ¾¡£¶øÇҺܶà¾ßÃûµÄwebÓ¦ÓÃϵͳ£¨°üÀ¨ bbs,blog,wiki,cmsµÈµÈ£©¶¼ÊÇʹÓÃphp¿ª·¢µÄ£¬Discuz¡¢phpwind¡¢phpbb¡¢vbb¡¢wordpress¡¢boblog µÈµ ......
oracle9iжÔØ
1,ÔÚ·þÎñÖÐÍ£Ö¹oracleµÄËùÓзþÎñ
2,ÔÚ³ÌÐòÁËжװËùÓÐOracle²úÆ·£¬(µ«Universal Installer±¾Éí²»Äܱ»É¾³ý)
3,ɾ³ý×¢²á±í:
(1)ÔËÐÐregeditÑ¡ÔñHKEY_LOCAL_MACHINE\SOFTWARE\ORACLE£¬É¾³ýÕâ¸öÏî
(2)Ñ¡ÔñHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Oracle,ɾ³ýÕâ¸öÏî.
(3),Ñ¡ÔñHKEY_LOCAL_MACHI ......
oracleº¯Êý´óÈ«-Êý×Ö´¦Àíº¯Êý
F.3 Êý×Öº¯Êý
º¯Êý½ÓÊÜNUMBERÀàÐ͵IJÎÊý²¢·µ»ØNUMBERÀàÐ͵ÄÊýÖµ.³¬Ô½º¯ÊýºÍÈý½Çº¯ÊýµÄ·µ»ØÖµ¾«È·µ½36λ.ACOS¡¢ASIN¡¢ATAN¡¢ATAN2µÄ½á¹û¾«È·µ½36λ.
l ABS
Óï·¨: ABS(x)
¹¦ÄÜ: µÃµ½xµÄ¾ø¶ÔÖ ......
°²×°²½Ö裺
1. °²×°JDK£¬°²×°·½·¨¼û
Ubuntu
10.04ϵĴSUN JAVA¿ª·¢»·¾³
½â¾öÖÐÎÄÂÒÂëÎÊÌ⣬ÔÚjreĿ¼ÏÂ×ÖÌåĿ¼Öн¨Á¢"fallback"Ŀ¼£¬È»ºócopy»òÕßlinkÄãϲ»¶µÄ×ÖÌåÖÁĿ¼ÏÂ.
2. °²×°±ØÒªµÄÈí¼þ°ü
11gËùÐèÒªµÄÈí¼þ°ü²¢²»¶à£¬Ö»Òª°²×°build-essential,rpm,libaio,ksh,libtool,libstdc++5
sudo apt-get install ......