oracle apache phpÂÒÂëÎÊÌâ
°ì·¨Ò»
select * from V$NLS_PARAMETERS
$conn = oci_connect('scott', 'donkey', 'demo', 'zhs16gbk');
while ($dat = oci_fetch_row($cur)) {
print_r(iconv('gb2312', 'utf-8', $dat[0])); //$nickname = mb_convert_encoding($dat[0], 'utf-8', 'gbk');
}
»òÕß $c1 = oci_connect("scott", "tiger", $db, 'UTF8');
°ì·¨¶þ£º
°²×°ºÃ·þÎñÆ÷ºó£¬Óÿͻ§¶Ë¿´·þÎñÆ÷µÄÓïÑÔ
sql>select * from V$NLS_PARAMETERS Where PARAMETER=''NLS_LANGUAGE'';
±ÈÈç½á¹ûÊÇ"SIMPLIFIED CHINESE”
ÔÚApacheÀï¼ÓÈë»·¾³±äÁ¿
export NLS_LANGUAGE="SIMPLIFIED CHINESE"
ÔÚ/etc/init.d/httpdÀï¼ÓÈ룬Դ´úÂë°²×°µÄApacheдһ¸ö½Å±¾µ÷ÓÃapachectl
»òÕßÐèÒª/etc/init.d/httpdÀï¼ÓÈëÀïÒýÈë»·¾³±äÁ¿£¬ÓÉÓÚ±¾»úûÓÐÄǸöÆô¶¯Îļþ£¬ËùÒÔÖ»ÄÜÔÚapachectlÀï¼ÓÈëÈçÏ´úÂ룺
export NLS_LANGUAGE="SIMPLIFIED CHINESE"¡£
·½·¨Èý£ºhttpd.confÀï¼ÓÒ»ÐÐAddDefaultCharset GB2312 /off
·½·¨ËÄ£ºhtmlspecialchars() Ö§³ÖË«×Ö½Ú×Ö·û£¬±ÈÈ纺×Ö
htmlentities()Ö§³Öµ¥×Ö½Ú×Ö·û
·½·¨Î壺apacheµÄÅäÖÃÎļþÒѾ¼ÓÁËAddDefaultCharset GB2312
phpµÄÅäÖÃÎļþÒѾ¼ÓÁË AddDefaultCharset GB2312
Ïà¹ØÎĵµ£º
ÔÚÐéÄâ»úRed Hat Enterprise Linux 4 update 4Öа²×°oracle 10.2.0.1
1)²é¿´ÏµÍ³ÄÚ´æ
[root@linux4 ~]# grep MemTotal /proc/meminfo
2)²é¿´½»»»Çø´óС
[root@linux4 ~]# grep SwapTotal /proc/meminfo
3)
²é¿´/tmpĿ¼´óС
[root@linux4 ~]# df -m /tmp
4)²é¿´²Ù×÷ϵͳ°æ±¾
[root@linux4 ~]# cat /etc/issue
5)¼ ......
ÔÚPHP±à³ÌÖÐ, ÎÒÃǾ³£»áÓöµ½Ò»Ð©Ö±½Ó²úÉúÊä³öµÄº¯Êý, Èçpassthru(),readfile(), var_dump() µÈ. µ«ÓÐʱÎÒÃÇÏë°ÑÕâЩº¯ÊýµÄÊä³öµ¼Èëµ½ÎļþÖÐ,»òÕßÏȾ¹ý´¦ÀíÔÙÊä³ö, »òÕß°ÑÕâЩº¯ÊýµÄÊä³ö×÷Ϊ×Ö·û´®À´´¦Àí.
¡¡¡¡ÕâʱÎÒÃǾÍÒªÓõ½ Output Buffer(Êä³ö»º³å) º¯ÊýÁË.
´¦ÀíÊä³ö»º³åµÄº¯ÊýÖ÷ÒªÓÐÕâô¼¸¸ö:
ob_start() ¿ªÊ¼Ê ......
°²×°WAPMServ5.2.6ºó,ÓÃDreamweaver¿ÉÒÔ±àдºÍµ÷ÊÔPHP
Ê×ÏÈ£ºÒªÏÈÆôwapmserver,Æô¶¯ËùÓзþÎñ
È»ºó £ºÔÚDreamweaverÅäÖÃÕ¾µã£¬¾ßÌå²Ù×÷ÈçÏ£º
ÃèÊöϹؼüµÄ²½Ö裺
Ïȵý¨¸öÕ¾µã È»ºó
¸ß¼¶ Ñ¡Ï£º
·ÖÀࣺ±¾µØÐÅÏ¢
±¾µØ¸ùÎļþ¼Ð £¨Ñ¡ÔñPHPµÄ·¢²¼Îļþ¼Ð£©
Á´½ÓÏà¶ÔÓÚ Õ¾µã¸ùĿ¼
HTTPµØÖ· Http://localhost/
»º´æ Æ ......
oracleÀïµÄ³£ÓÃÃüÁîÏê½â
±¾ÎÄÕë¶ÔoracleÈÕ³£µÄÃûÁî×öÁ˽éÉÜ£¬»¶Ó¸÷λ´óÏÀ¶àÌᱦ¹óÒâ¼ûºÍ¶à¶à²¹³ä£¡
Ò»
ÈÕÖ¾¹ÜÀí
1.forcing log switches
sql> alter system switch logfile;
2.forcing checkpoints
sql> alter system checkpoint;
3.adding online redo log groups
sql> alter database add logfil ......
--21.1 Data Pump¹¤¾ß
Data Pump
´Óoracledatabase 10g¿ªÊ¼ÒýÈëÁËdata pump(Êý¾Ý±Ã)¹¤¾ß£¬ËüÌṩÁËÒ»ÖÖ»ùÓÚ·þÎñÆ÷µÄÊý¾Ýµ¼³öµ¼ÈëʹÓóÌÐò¡£
ËùÓеÄdata pump¶¼×÷Ϊһ¸ö·þÎñÆ÷½ø³Ì£¬Êý¾Ý²»ÔÙ±ØÐëÓÉÒ»¸ö¿Í»§³ÌÐò´¦Àí¡£Data Pump¹¤¾ßµÄµ¼³öºÍµ¼ÈëʵÏÖ
OracleÊý¾Ý¿âÖ®¼äÊý¾ÝµÄ´ ......