php Öвéѯoracle date ÀàÐÍÊý¾ÝµÄÎÊÌâ?
ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£©º¯Êý»ñÈ¡µ½µÄ¸Ãʱ¼ä×ֶεÄֵȴÊÇ
30-9ÔÂ -09
ÇëÎÊÈçºÎ½«Õâ¸ö¸ñʽµÄ×Ö¶Îת³ÉÉÏÃæµÄ×ֶΣ¬»òÕßÈçºÎÔÚphpÖеĵ½ÉÏÃæ¸ñʽµÄʱ¼ä×ֶΣ¿
ÒòΪÎÒ²éѯʱ²»È·¶¨¸Ãʱ¼ä×ֶε½µ×ÊÇÄÇÒ»¸ö×ֶΣ¬ËùÒÔû·¨ÓÃoracle¿âÖеÄʱ¼äº¯Êý¶ÔÖ¸¶¨µÄ×Ö¶Îת»»£¬×îºÃÄÜÔÚphpÖнøÐÐת»»¡£
Çë¸÷λ°ïæָµãһϣ¬ÕæÐÄÇó½Ì£¬²»Ê¤¸Ð¼¤¡£
Èç¹û´æ´¢Ê±¼äµÄ×Ö¶ÎÓÃintÀàÐ͵ϰ¾Í²»»áÓÐÕâ¸öÎÊÌ⣬²åÈëÊý¾Ý¿âʱ½«Ê±¼äתΪʱ¼ä´Á²åÈ룬¶ÁÈ¡ºóÓÃʱ¼ä´ÁÔÙ»¹ÔΪʱ¼ä£¬ºÇºÇÕâÑù×öµÄÄ¿µÄ¿ÉÒÔÌá¸ß²éѯʱ¼äµÄЧÂÊ¡£Ò²¿ÉÒÔ±ÜÃâÄãÉÏÃæ³öÏÖµÄÇé¿ö£¡
¿â²»ÊÇÎÒ¶¨µÄ£¬ÎÒÖ»ÓвéѯµÄȨÏÞ£¬ËùÒÔÖ»Äܰ´dateÀàÐÍÀ´²éÁË¡£
3Â¥Õý½â
Ïà¹ØÎÊ´ð£º
ÎÒÓÃPHPÀ©Õ¹Cʱ£¬ÓõÄÊÇÔ´ÂëextĿ¼ÏµÄ./ext_skel
×îºó±àÒë×ÜÊDz»ÄÜÉú³ÉÀ©Õ¹Ä£¿éµÄ.so¶¯Ì¬¿â£¬ÎÒÓõİ汾ÊÇ5.3.0£¬
ÕâÊÇÔõô»ØÊ£¬¸ßÊÖ½â´ðÏÂ
²»ÄÜÉú³ÉʱÓÐɶÌáʾÐÅÏ¢£¿
ÔËÐÐÁË/ext_skel --extname=Ä ......
ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬
-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
<?php
/*
¹¦ÄÜ£ºPHPα¾²Ì¬»¯Ò³ÃæµÄʵÏÖ
¾ßÌåÓ÷¨:
ÀýÈçÁ´½ÓΪ:test.php/year/2006/action/_add.html
mod_rewrite();
$yearn= $_GET["year"];//½á¹ûΪ'2006'
......
webclient.phpÎļþ£º
<?php
$arrOptions = array( 'uri'=>'http://10.10.19.111/','location'=>'http://10.10.19.111/webservice/webservice.php','trace' ......