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²»ÊǺÜÁ˽â дÁ˸ö¼òµ¥µÄÀý×Ó
ÏÖÓÃc#µ÷ÓÃphpдµÄ webservice£¨soap WSDL£©iis6.0+php5.2.8
webserviceÈçÏÂ
<?php
class WebService
{
public function Logout()
{
//header('Co ......
¸÷λ´óÏÀ
ÇóÒ»¶Îphp´úÂë
¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ
Õë¶Ô²»Í¬µÄä¯ÀÀÆ÷ÏÔʾ²»Í¬µÄͼƬ
¾ÍÊÇÓÐÒ»ÕÅͼƬ£¬Ö»Ïë¸øie6Óû§¿´µ½
Èç¹ûie7¡¢chrome¡¢firefoxÓû§ä¯ÀÀÔòÏÔʾÁíÍâÒ»ÕÅͼƬ  ......
ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´ÔÒò£¬ÏÈлÁË¡£
¿Õ¼ä²»Ö§³Ö¡£
»òÕßÄãµÄÕ˺ÅûÓп ......
´úÂëÈçÏ£º
function uc_get_user($username, $isuid=0) {
$return = call_user_func(UC_API_FUNC, 'user', 'get_user', array('username'=>$username, 'isuid'=>$isuid));
return UC_CONNECT == 'mysql' ......