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Õ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´ÔÒò£¬ÏÈлÁË¡£
¿Õ¼ä²»Ö§³Ö¡£
»òÕßÄãµÄÕ˺ÅûÓп ......
¸÷λ´óЩ
ÇóÒ»¶Îphp´úÂë
¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ
Õë¶Ô²»Í¬µÄä¯ÀÀÆ÷ÏÔʾ²»Í¬µÄͼƬ
¾ÍÊÇÓÐÒ»ÕÅͼƬ£¬Ö»Ïë¸øie6Óû§¿´µ½
Èç¹ûie7¡¢chrome¡¢firefoxÓû§ä¯ÀÀÔòÏÔʾÁíÍâÒ»ÕÅͼƬ
¼Û¸ñ²»ÒªÌ«ÀëÆ×¾ÍÐÐ ......
µ±ÎÒÓÃPHPÏÂÔØ·þÎñÆ÷ÉϵÄwavÒôÀÖÎļþʱ£¬wavÎļþÄܹ»ÏÂÔØÏÂÀ´£¬²¢ÇÒ´óСÏàͬ£¬µ«ÊÇÈ´²»Äܲ¥·Å¡£µ«ÈôÊÇͨ¹ýÎļþ·þÎñÆ÷¿½±´µ½±¾µØ£¬ÊÇ¿ÉÒÔ²¥·Å¸ÃÎļþµÄ£¬²»ÖªµÀÈçºÎÔÒò¡£Í¨¹ýMD5sum¼ì²â£¬¸ÃÎļþÏÂÔØºóÒѸı䣬²»ÖªµÀÔ ......
ÇëÎÊ£¬ÒÔÏ´úÂ룬Ϊʲô²»¹ÜÓ㿾Ístr_replaceÕâ¸öº¯Êý£¬Ì滻ôÓÐÆð×÷Óã¿
PHP code:
$gg='<script type=\"text/JavaScript\">
alimama_pid=\"mm_14281022_2030060_8250750\";
alima ......