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)) {
 
Ïà¹ØÎĵµ£º
a:
ΪʲôҪʹÓûº´æ¼¼Êõ£¿ÀíÓɺܼòµ¥£ºÌá¸ßЧÂÊ¡£ÔÚ³ÌÐò¿ª·¢ÖУ¬»ñÈ¡ÐÅÏ¢µÄ·½Ê½Ö÷ÒªÊDzéѯÊý¾Ý¿â£¬³ý´ËÒÔÍ⣬Ҳ¿ÉÄÜÊÇͨ¹ýWeb Services»òÕß±ðµÄijÖÖ·½·¨£¬ÎÞÂÛÄÄÖÖ·½·¨£¬ÔÚ´óÁ¿µÄ²¢·¢·ÃÎÊÃæÇ°£¬ËüÃǶ¼¿ÉÄܳÉΪЧÂʵÄÆ¿¾±£¬ÎªÁ˽â¾öÕâЩÎÊÌ⣬ÈËÃÇÌá³öÁ˺ܶà½â¾ö·½°¸£¬ÆäÖÐÒ» ЩÊÇÀûÓÃÓÅ»¯Èí¼þ£¨È磺APC£¬Eaccelerator£¬ ......
F.1×Ö·ûº¯Êý——·µ»Ø×Ö·ûÖµ
ÕâЩº¯ÊýÈ«¶¼½ÓÊÕµÄÊÇ×Ö·û×åÀàÐ͵IJÎÊý(CHR³ýÍâ)²¢ÇÒ·µ»Ø×Ö·ûÖµ.³ýÁËÌرð˵Ã÷µÄÖ®Íâ,ÕâЩº¯Êý´ó²¿·Ö·µ»ØVARCHAR2ÀàÐ͵ÄÊýÖµ.×Ö·ûº¯ÊýµÄ·µ»ØÀàÐÍËùÊܵÄÏÞÖƺͻù±¾Êý¾Ý¿âÀàÐÍËùÊܵÄÏÞÖÆÊÇÏàͬµÄ,±ÈÈç: VARCHAR2ÊýÖµ±»ÏÞÖÆΪ2000×Ö·û(ORACLE 8ÖÐΪ4000×Ö·û),¶øCHARÊýÖµ±»ÏÞÖÆΪ255×Ö·û(Ô ......
oracleº¯Êý´óÈ«-Êý×Ö´¦Àíº¯Êý
F.3 Êý×Öº¯Êý
º¯Êý½ÓÊÜNUMBERÀàÐ͵IJÎÊý²¢·µ»ØNUMBERÀàÐ͵ÄÊýÖµ.³¬Ô½º¯ÊýºÍÈý½Çº¯ÊýµÄ·µ»ØÖµ¾«È·µ½36λ.ACOS¡¢ASIN¡¢ATAN¡¢ATAN2µÄ½á¹û¾«È·µ½36λ.
l ABS
Óï·¨: ABS(x)
¹¦ÄÜ: µÃµ½xµÄ¾ø¶ÔÖ ......
oracle8i Çý¶¯ ojdbc14.jar Õâ¸öÇý¶¯ÓÐÎÊÌ⣬·ÖҳʱҪÊÖ¶¯ д rownum<m ,Ëü×Ô¶¯³ÉÉúµÄ·ÖÒ³²»ÕýÈ·£¬ÓõÄmysqlµÄtop m
Null value was assigned to a property of primitive °ÑentityÖÐintÀàÐ͸ijÉInteger ¿âÖв»ÉèÖÃnullable
number(9) µÄid ²»ÄÜÓÃInterger,µÃÓÃBigDecimal,Òª²»È»È¡idʱ»á±¨´í ......