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´úÂë
¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ
Õë¶Ô²»Í¬µÄä¯ÀÀÆ÷ÏÔʾ²»Í¬µÄͼƬ
¾ÍÊÇÓÐÒ»ÕÅͼƬ£¬Ö»Ïë¸øie6Óû§¿´µ½
Èç¹ûie7¡¢chrome¡¢firefoxÓû§ä¯ÀÀÔòÏÔʾÁíÍâÒ»ÕÅͼƬ  ......
¸÷λ´óЩ
ÇóÒ»¶Îphp´úÂë
¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ
Õë¶Ô²»Í¬µÄä¯ÀÀÆ÷ÏÔʾ²»Í¬µÄͼƬ
¾ÍÊÇÓÐÒ»ÕÅͼƬ£¬Ö»Ïë¸øie6Óû§¿´µ½
Èç¹ûie7¡¢chrome¡¢firefoxÓû§ä¯ÀÀÔòÏÔʾÁíÍâÒ»ÕÅͼƬ
¼Û¸ñ²»ÒªÌ«ÀëÆ×¾ÍÐÐ ......
ÎÒ¸ÕѧϰphpÇëÎÊ£¬Èç¹ûÎÒ°ÑphpÎļþÉÏ´«ÖÁ·þÎñÆ÷ºó£¬ÀýÈçhttp://www.****.com/cast.phpÕâ¸öÎļþ»á²»»á±»±ðÈËÏÂÔØ»ò¸´Öư¢£¿
¿ÉÒÔ±»ÏÂÔØ£¬Ò²¿ÉÒÔ²»±»ÏÂÔØ£¬¿´web·þÎñÆ÷¶Ô¸ÃÎļþȨÏÞµÄÅäÖÃ
¿´Äã¶ÔÎļþȨÏÞµÄÉèÖÃ
......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......
ÇëÎÊ
object(Helper_Uploader_File) {
protected '_file' => array(
'name' => string '4_¹âÓ°_1.jpg' (length=14)
'type ......