php+oracleÒ»¸ö¼òµ¥µÄ²éѯÎÊÌâ
Á¬½ÓÀàÀïÃæµÄsearchº¯Êý function Search($sql) { echo $sql; $sql = $this->ParseSQL($sql); if(oci_execute($sql, OCI_DEFAULT)) { while($row = oci_fetch_array($sql)) { $result[] = $row; } oci_free_statement($sql); if(isset($result)) { return $result; } else { $result = array(); return $result; } } else { oci_free_statement($sql); } } ÎÒÔÚÒ³ÃæÀïÃæµ÷Ó㺠ÏÈʵÀýÁ¬½ÓÀà¡£¡£È»ºóµ÷ÓÃsearchº¯Êý ÓÃÒ»¸ö±äÁ¿$values½ÓÊÜ·µ»ØµÄ½á¹û¼¯ È»ºóÊä³öÖµ echo $values[0]['NAME']£» ΪʲôÊä³öÒÔºóµÄֵȴÊÇ sqlÓï¾ä+NAMEµÄÖµ°¡£¡£¡ È磺select NAME,PHOTO,CITY,TWO from TB_COMPANY where ID=59170570 ÄϾ©ÊÐ
ÕâôÀäÇ壿£¿ ɳ·¢µÃ×Ô¼º×ø£¡£¡£¡ ×Ô¼º¶¥ÉÏÈ¥£¡£¡ ÔÚµÚ¶þÒ³°¡£¬£¬¶¥¶¥¡£¡£¡£ÉϵÚÒ»Ò³¡£¡£ ѰÇó°ïÖú£¡£¡ ´ó¸ç£¬phpµÄÎÊÌ⣬Äã·¢µ½ASP.net°å¿éÀ´ÁË£¬Äܲ»ÀäÇåô¡£¡£¡£¡£ ¿ÉÊÇ·¢µ½php°æ£¬Ò²Ò»ÑùµÄÀäÇå°¡ ËùÒÔÀ´ÅöÅöÔËÆø lzϲ»¶È¥Âóµ±ÀÍÂòÉÏУ¼¦¿é³ÔÒýÓà lzϲ»¶È¥Âóµ±ÀÍÂòÉÏУ¼¦¿é³Ô ??? ÎÒ²»Ï²»¶µÄ£¡£¡
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿ 1 ¿ÉÒÔɾ³ý 2 ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÎÒ¸ÕѧϰphpÇëÎÊ£¬Èç¹ûÎÒ°ÑphpÎļþÉÏ´«ÖÁ·þÎñÆ÷ºó£¬ÀýÈçhttp://www.****.com/cast.phpÕâ¸öÎļþ»á²»»á±»±ðÈËÏÂÔØ»ò¸´Öư¢£¿ ¿ÉÒÔ±»ÏÂÔØ£¬Ò²¿ÉÒÔ²»±»ÏÂÔØ£¬¿´web·þÎñÆ÷¶Ô¸ÃÎļþȨÏÞµÄÅäÖà ¿´Äã¶ÔÎļþȨÏÞµÄÉèÖà ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......