Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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»º´æ¼¼Êõ½éÉÜ£¡


a:
ΪʲôҪʹÓûº´æ¼¼Êõ£¿ÀíÓɺܼòµ¥£ºÌá¸ßЧÂÊ¡£ÔÚ³ÌÐò¿ª·¢ÖУ¬»ñÈ¡ÐÅÏ¢µÄ·½Ê½Ö÷ÒªÊDzéѯÊý¾Ý¿â£¬³ý´ËÒÔÍ⣬Ҳ¿ÉÄÜÊÇͨ¹ýWeb Services»òÕß±ðµÄijÖÖ·½·¨£¬ÎÞÂÛÄÄÖÖ·½·¨£¬ÔÚ´óÁ¿µÄ²¢·¢·ÃÎÊÃæÇ°£¬ËüÃǶ¼¿ÉÄܳÉΪЧÂʵÄÆ¿¾±£¬ÎªÁ˽â¾öÕâЩÎÊÌ⣬ÈËÃÇÌá³öÁ˺ܶà½â¾ö·½°¸£¬ÆäÖÐÒ» ЩÊÇÀûÓÃÓÅ»¯Èí¼þ£¨È磺APC£¬Eaccelerator£¬ ......

oracleº¯Êý´óÈ« ×Ö·û´¦Àíº¯Êý

F.1×Ö·ûº¯Êý——·µ»Ø×Ö·ûÖµ
ÕâЩº¯ÊýÈ«¶¼½ÓÊÕµÄÊÇ×Ö·û×åÀàÐ͵IJÎÊý(CHR³ýÍâ)²¢ÇÒ·µ»Ø×Ö·ûÖµ.³ýÁËÌرð˵Ã÷µÄÖ®Íâ,ÕâЩº¯Êý´ó²¿·Ö·µ»ØVARCHAR2ÀàÐ͵ÄÊýÖµ.×Ö·ûº¯ÊýµÄ·µ»ØÀàÐÍËùÊܵÄÏÞÖƺͻù±¾Êý¾Ý¿âÀàÐÍËùÊܵÄÏÞÖÆÊÇÏàͬµÄ,±ÈÈç: VARCHAR2ÊýÖµ±»ÏÞÖÆΪ2000×Ö·û(ORACLE 8ÖÐΪ4000×Ö·û),¶øCHARÊýÖµ±»ÏÞÖÆΪ255×Ö·û(Ô ......

oracleº¯Êý´óÈ« Êý×Ö´¦Àíº¯Êý


oracleº¯Êý´óÈ«-Êý×Ö´¦Àíº¯Êý
F.3    Êý×Öº¯Êý
º¯Êý½ÓÊÜNUMBERÀàÐ͵IJÎÊý²¢·µ»ØNUMBERÀàÐ͵ÄÊýÖµ.³¬Ô½º¯ÊýºÍÈý½Çº¯ÊýµÄ·µ»ØÖµ¾«È·µ½36λ.ACOS¡¢ASIN¡¢ATAN¡¢ATAN2µÄ½á¹û¾«È·µ½36λ.
l         ABS
Óï·¨:   ABS(x)
¹¦ÄÜ:   µÃµ½xµÄ¾ø¶ÔÖ ......

ÓÃoracle 8i Êý¾Ý¿âʱÓöµ½µÄÎÊÌâ

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ʱ»á±¨´í ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ