PHP²éѯÏÔʾSqlServerÖеÄÖÐÎÄ
ÒòΪ¹¤×÷ÐèÒª£¬Êý¾Ý¿âʹÓõÄMS SQL Server2005£¬¶øÄ¬ÈϵÄÅÅÐò¹æÔòÊÇSQL_Latin1_General_CP1_CI_AS¡£´´½¨ÁËÒ»¸ö±í£¬ÒòΪÐèÒª´æ´¢ÖÐÎÄÐÅÏ¢£¬Address×ֶεÄÀàÐÍÊÇnvarchar(255)¡£
´ËʱʹÓÃphpÀ´Á¬½Ósql server£¬Ò³ÃæµÄ±àÂëºÍÎļþµÄ±àÂë¶¼ÊÇUTF-8£¬²éѯ´ËAddress×ֶΣ¬ÏÔʾÔÚÒ³ÃæÉÏÊÇ???Ö®ÀàµÄ¡£Ôõô½â¾ö£¿
ʹÓÃ
iconv('iso-8859-1','utf-8',$address);
ÊÇûÓÐʲôÓô¦µÄ¡£
´ËʱÈç¹ûSQLÒ»Óï¾äÖÐÖ¸¶¨×Ö·ûÅÅÐò¹æÔòΪÖÐÎÄÔÙ½øÐÐת»»Êä³öµÄ²ÅÊÇÕý³£µÄ£º
$query = 'select Address collate Chinese_PRC_CI_AS from A';
$rs = mssql_query($query,$conn) or die ('Query failed: '.$query);
if ($row = mssql_fetch_array($rs))
{
$address = $row[0];
$address = iconv('GBK','UTF-8',$address);
echo $address;
}
»¹ÓÐÆäËü·½·¨Âð£¿
Ïà¹ØÎĵµ£º
¡¡¡¡PHP ÖУ¬Êý¾Ýͨ³£¶¼ÊÇ´æ´¢ÔÚMySQLÊý¾Ý¿âµ±Öеġ£µ«ÊÇÓÐЩʱºò£¬ÎÒÃÇ»¹ÊÇÐèҪʹÓÃPHP¶ÁдһЩ±¾µØÎļþ¡£±ÈÈçÉú³É¾²Ì¬Ò³Ãæ»òÕßÊý¾ÝµÄ±¾µØ»º´æ¡£
¡¡¡¡PHP5+ ÌṩÁËÒ»ÖÖ·½·¨ file_put_contents(file,data,mode,context)£¬Ëü½«Ò»¸ö×Ö·û´®Ð´ÈëÎļþ£¬·µ»ØÐ´Èëµ½ÎļþÄÚÊý¾ÝµÄ×Ö½ÚÊý¡£ºÍÒÀ´Îµ÷Óà fopen()£¬fwr ......
ÅäÖÃspawn-fcgiÆô¶¯
²ÎÊý˵Ã÷:
-f Ö¸¶¨µ÷ÓÃFastCGIµÄ½ø³ÌµÄÖ´ÐгÌÐòλÖ㬸ù¾ÝϵͳÉÏËù×°µÄPHPµÄÇé¿ö¾ßÌåÉèÖÃ
-a °ó¶¨µ½µØÖ·addr
-p °ó¶¨µ½¶Ë¿Úport
-s °ó¶¨µ½unix socketµÄ·¾¶path
-C Ö¸¶¨²úÉúµÄFastCGIµÄ½ø³ÌÊý£¬Ä¬ÈÏΪ5£¨½öÓÃÓÚPHP£©
-P Ö¸¶¨²úÉúµÄ½ø³ÌµÄPIDÎļþ·¾¶
-uºÍ-g FastCGIʹÓÃʲôÉí·Ý£¨-u Óû§ -g Ó ......
phpÊÇÒ»Ãżòµ¥¶øÓÖÇ¿´óµÄÓïÑÔ£¬ËùÓеÄphpÊé¼®¶¼»áÕâÑù˵£¨ËÈÃÎÒ×î°®¿´Ç°ÑÔÄØ£©¡£Èç¹û½«.net¡¢jsp±È×÷µ¶½££¬ÄÇôphp¾ÍÊǸ«Í·¡£Ñ§»á³ÌÒ§½ðµÄÈý°å¸«£¬Ëä²»ÄÜÌìÏÂÎ޵У¬È´¿ÉÒÔ°²ÉíÁ¢Ãü¡£
½ñÌìÔÛÃÇѧϰµÚÒ»°å¸«£¬ÍøÕ¾½»»¥µÄ»ù´¡£ºÇëÇóºÍ»á»°¡£
PHPÖпͻ§¶ËÓë·þÎñÆ÷ÐÅÏ¢µÄ´«µÝÊÇÒÀ¿¿ÇëÇóÓ¦´ðºÍ»á»°±£³ÖʵÏֵ쬶øPHP¶ÔÓÚ ......
index.phpÎļþµÚÒ»ÐоÍÊǰüº¬ÁË
include_once('./common.php');
ÎļþËùÒÔÏȶÔcommon.phpÎļþ½âÎö
<?php
/*
[UCenter Home] (C) 2007-2008 Comsenz Inc.
$Id: common.php 10981 2009-01-14 03:05:20Z liguode $
*/
//¶¨ÒåÒ»¸ö³£Á¿£¬ÓÃÀ´ÔÚÆäËûÒ³ÃæÖУ¬·ÀÖ¹±»¶ñÒâÓû§Ö±½Óµ÷ÓÃÆäËûPHPÎļþ¡£
@def ......
Õâ¸ö©¶´ÑϸñÉÏ˵²¢²»ÊÇ Nginx ºÍ PHP ±¾ÉíµÄ©¶´Ôì³ÉµÄ£¬¶øÊÇÓÉÅäÖÃÔì³ÉµÄ¡£ÔÚÎÒ֮ǰдµÄÐí¶àÅäÖÃÖУ¬¶¼ÆÕ±é´æÔÚÕâ¸ö©¶´¡£
¼òÒ×¼ì²â·½·¨£º
´ò¿ª Nginx + PHP ·þÎñÆ÷ÉϵÄÈÎÒâÒ»ÕÅͼƬ£¬È磺
http://blog.lrenwang.com/test.png
Èç¹ûÔÚͼƬÁ´½Óºó¼ÓÒ»´® /xxx.php £¨xxxΪÈÎÒâ×Ö·û£©ºó£¬È磺
http://blog.lrenwang.com/ ......