php mssql ²éѯ×Ö¶ÎÄÚÈÝʱֻµÃµ½Ò»²¿·ÖÄÚÈÝ??????
СµÜÎÒÓÃphpÁ¬½ÓmssqlµÄʱºò£¬ÔÚ²éѯij¸öÊý¾ÝµÄ×Ö¶Îʱ£¬·¢ÏÖÖ»µÃµ½Á˸Ã×Ö¶ÎÒ»²¿·ÖÄÚÈÝ¡£
¸Ã×Ö¶ÎÔÚÊý¾ÝÖеÄÀàÐÍΪtext,ÎÒÓõÄÊÇpdoÁ¬½ÓÊý¾Ý¿â.....
ÎҵIJâÊÔ´úÂëÈçÏÂ:
PHP code:
$db=new PDO("mssql:host=localhost;dbname=t001",'trssj','trssj');
$result=$db->query("select * from ddiurnal where idd=827900");
foreach ($result as $row){
foreach ($row as $k=>$val){
echo iconv("gb2312",'utf-8',$val);
//echo $val;
echo "---------------------------------------";
}
}
1£ºÊDz»ÊDZàÂëÎÊÌâÔì³ÉµÄ¡£
2£ºÊDz»ÊÇtext×Ö¶ÎÄÚÈÝÓÐÐ©ÌØÊâ×Ö·ûÔì³ÉtextÄÚÈݽضϣ¿
iconvº¯Êý¶ÔÓÚһЩÉúƧµÄ×Ö·û¿ÉÄÜ»áÎÞ·¨×ªÂ룬µ¼ÖÂתÂëÖÕÖ¹¡£
°Ñ
echo iconv("gb2312",'utf-8',$val);
¸Ä³É
echo iconv("gb2312",'utf-8//IGNORE'',$val);
¶à´òÁ˸öÒýºÅ···
echo iconv("gb2312",'utf-8//IGNORE',$val);
²»ÊDZàÂëÎÊÌâŪµÄ
Èç¹ûÎÒ°ÑiconvÕâ¸öº¯Êý¸Éµô£¬ÎÒ²»¶ÔËû½øÐÐתÂ룬Ëû»¹ÊÇÒ»ÑùµÄÖ»ÏÔʾһ²¿·ÖÊý¾Ý
ºóÃæÃ»ÓÐʲôµÄÌØÊâ×Ö·û
ÎÒÒÔΪͬÊÂ˵ÕâÊÇpdoÁ¬½ÓµÄÒ»¸öbug,Õâ¸öÊÇÍøÖ·:
http://bugs.php.net/bug.php?id=38805&edit=3
ÐÞ¸ÄPHP.INIÀï¶ÔÓ¦MSSQLÄÇ¿é
ºÃÏóÓиö4048°É»¹ÊǶàÉÙ,¼ÇµÄ²»ÊǺÜÇå³þÁË,°ÑËû¸ÄµÄ´ó´óµÄ,¾ÍºÃÁË
{{-
Ïà¹ØÎÊ´ð£º
µ±ÎÒÓÃPHPÏÂÔØ·þÎñÆ÷ÉϵÄwavÒôÀÖÎļþʱ£¬wavÎļþÄܹ»ÏÂÔØÏÂÀ´£¬²¢ÇÒ´óСÏàͬ£¬µ«ÊÇÈ´²»Äܲ¥·Å¡£µ«ÈôÊÇͨ¹ýÎļþ·þÎñÆ÷¿½±´µ½±¾µØ£¬ÊÇ¿ÉÒÔ²¥·Å¸ÃÎļþµÄ£¬²»ÖªµÀÈçºÎÔÒò¡£Í¨¹ýMD5sum¼ì²â£¬¸ÃÎļþÏÂÔØºóÒѸı䣬²»ÖªµÀÔ ......
ÒѾÐÞ¸ÄÁË
£¨1£©PHP.iniÖеÄpost_max_size ºÍupload_max_filesize£¬²¢ÇÒ±£Ö¤ÁËǰÕß´óÓÚºóÕß
£¨2£©Windows\System32\inetsvr\MetaBase.xmlÖеÄAspMaxRequestEntityAllowed
ÐÞ¸ÄÍê±Ïºó£¬ÖØÐÂÆô¶¯ÁËIIS·þÎñ£¬²¢ÇÒ¼Æ ......
µÃµ½¿Í»§¶ËIPÀÏÎÊÌâÁË£¬µ«Õâ´Î»·¾³Óе㲻һÑù£¨ ¿Í»§ÊÇÕâÑùµÄ»·¾³Ã»°ì·¨£¬ËµBTµÄÇëÆ®¹ý :) £©¡£
win2k3¸Ãϵͳ£¨Ï³ÆÏµÍ³A£©ÉÏ×°ÁËVMware Server£¬VMÏÂÓиöwin2k3ϵͳ(ϳÆÏµÍ³B)¡£
ϵͳA£ºÖ±½ÓÁ¬½Ó¹«Íø¡£Óй«ÍøI ......
°²×°ÁËAPHACHE
¿ÉÊÇÔËÐÐÍøÒ³Ê²Ã´¶¼Ã»ÓÐ
¼±
»¹ÏëÇëÎÊÏÂ,JSP.PHP.ASP.NET ÄǸö¹¤×ʸ߰¡,
»ØÌû¾Í¼Ó·Ö
»¹Òª×°php5
×öµÃºÃ£¬Äĸö¹¤×ʶ¼¸ß¡£
http://download.csdn.net/source/1712990 Õâ¸öÀïÃæÓÐÕû¸öPHPµÄ° ......