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
Ïà¹ØÎĵµ£º
ÎÒÏë×î³õѧϰÊý¾Ý¿âʱ¶¼ÊÇÒÔstudent±í¡¢course±íºÍsc±íΪÀýµÄ°É
Ê×ÏÈ´´½¨ÕâÈýÕÅ±í£º±ØÒªÊ±¿ÉÖØÐ´´½¨Óû§¼°ÃÜÂë²¢µÇ½
»·¾³£ºoracle 10g
declare
vcnt number;
begin
select count(*) into vcnt from user_tables where table_name='SC';
If vcnt = 1 Then
Execute immedi ......
»ù±¾Ë¼Â·£ºÍ¨¹ýSOCKETÇëÇóÆäËûPHP½Å²½£¬ÊµÏÖPHPµÄ¶à½ø³ÌµÄÒì²½Ö´ÐС£
·Ï»°¾Í²»¶à˵ÁË£¬Çë¿´ÏÂÃæµÄ½Å²½²¢Ö´ÐÐÖ®¡£
<?php
//a.php
function runThread(){
$fp = fsockopen('127.0.0.1', 82, $errno, $errmsg);
fputs($fp, "GET /a.php?act=b\r\n"); //ÕâÀïµÄµÚ¶þ¸ö²ÎÊýÊÇHTTPÐÒéÖй涨µÄÇëÇóÍ·
//²»Ã÷°×µÄÇë¿´RFCÖ ......
ʹÓÃpopen½áºÏSHELLÃüÁîÒ²¿ÉÒÔʵÏÖ¶à½ø³Ì²¢·¢±à³Ì¡£
ʵÀýÈçÏ£º
<?php
//b.phpÎļþ
$file = 'testdir/file.txt';
for ($i=0;$i<10;$i++){
$fp = fopen($file,'a+');
fputs($fp, $i.'\r\n');
fclose($fp);
sleep(1);
}
?> ......
1 ORA-12571¡¢ORA-03113¡¢ORA-03114¡¢ORA-01041
ÌØÕ÷£º¿Í»§¶Ë£¨´úÀí»òÓ¦Ó÷þÎñÆ÷£©ÓÐʱ±¨ÕâÀà¶ÏÁ¬´íÎó
ÔÒò£ºÈç¹ûż¶û³öÏÖÒ»´Î£¬Ôò¿ÉÄÜÎªÍøÂçÔÒò»òÓû§Òì³£ÖÐÖ¹£¬Èç¹û¾³£³öÏÖÔòΪ¿Í»§¶ËÓë·þÎñ¶ËµÄ×Ö·û¼¯²»Ò»Ö¡£
´ëÊ©£ºÈç¹ûż¶û³öÏÖ£¬¿ÉÔÚ·þÎñ¶ËµÄÐÒéÅäÖÃÎļþPROTOCOL.ORAÖÐÔö¼ÓÒ»ÐÐ
TC ......
Oracle·¢²¼Ãâ·ÑÊý¾Ý¿â¿ª·¢¹¤¾ßSQL Developer 1.2
2007.09.25 À´×Ô£ºCSDN¡¡ ÄŲ»º° ¹²ÓÐÆÀÂÛ()Ìõ ·¢±íÆÀÂÛ ÊÕ²Ø
Oracle SQL DeveloperÊǼ׹ÇÎĹ«Ë¾Ãâ·ÑÌṩµÄÊý¾Ý¿â¿ª·¢¹¤¾ß£¬¿É°ïÖúÓû§¼ò»¯¿ª·¢¹¤×÷£¬Ìá¸ß±àÖÆºÍµ÷ÊÔSQLºÍPL/SQL´úÂëµÄЧÂÊ¡£ÏÖÔÚ£¬Õâ¸öÃâ·Ñ¹¤ ......