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)) {
 
Ïà¹ØÎĵµ£º
ÉùÃ÷£º²¹³ä·ÒëÁËÔÌûÖм¸´¦Î´·Òë´¦¡£
---------------------------------------------------- תÌû¿ªÊ¼ -------------------------------------------------------
PHPÖеÄCURLº¯Êý¿â£¨Client URL Library Function£©
curl_close - ¹Ø±ÕÒ»¸öcurl»á»°
curl_copy_handle - ¿½±´Ò»¸öcurlÁ¬½Ó×ÊÔ´µÄËùÓÐÄÚÈݺ ......
°²×°²½Ö裺
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 ......
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ʱ»á±¨´í ......
OracleÓ¦ÓÃÌåϵ½á¹¹
°üº¬ÈçÏÂÖ÷Ì⣺
¡£¿Í»§¶Ë/·þÎñÆ÷Ìåϵ½á¹¹¼ò½é
¡£¶à²ãÌåϵ½á¹¹¸ÅÊö
¡£OracleÍøÂç·þÎñ¸ÅÊö
1¡£¿Í»§¶Ë/·þÎñÆ÷Ìåϵ½á¹¹¼ò½é
ÔÚOracleÊý¾Ý¿âϵͳÖУ¬Êý¾Ý¿âÓ¦ÓóÌÐòÓëÊý¾Ý¿â±»·ÖΪÁ½²¿·Ö£ºÇ°¶Ë(front-end)»ò³ÆÎª¿Í»§¶Ë(client)£¬ºǫ́(back-end)»ò³ÆÎª·þÎñ¶Ë---Õâ¾ÍÊǿͻ§¶Ë/·þÎñÆ÷Ìåϵ½á¹¹Ãû×ÖµÄÓÉÀ´¡£ ......
OracleÆô¶¯Ê±ÐèÒªµÄ·þÎñ£º
ÔÌûµØÖ·£ºhttp://www.blogjava.net/sidanzhou/archive/2008/03/03/183507.html
×¢£ºSID - Êý¾Ý¿â±êʶ
HOME_NAME - Oracle HomeÃû³Æ£¬ÈçOraHome92¡¢OraHome81
£¨1£©OracleServiceSID
Êý¾Ý¿â·þÎñ£¬Õâ¸ö·þÎñ»á×Ô¶¯µØÆô¶¯ºÍÍ£Ö¹Êý¾Ý¿â¡£Èç¹û°²×°ÁËÒ»¸öÊý¾Ý¿â£¬ËüµÄȱʡÆô¶¯ÀàÐÍΪ×Ô¶¯¡£·þÎñ½ø³ ......