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²ËÄñ£¬Èç¹ûÄ㣺
1. ²»»áÀûÓÃÈçphpDocÕâÑùµÄ¹¤¾ßÀ´Ç¡µ±µØ×¢ÊÍÄãµÄ´úÂë
2. ¶ÔÓÅÐãµÄ¼¯³É¿ª·¢»·¾³ÈçZend Studio»òEclipse PDTÊÓ¶ø²»¼û
3. ´ÓδÓùýÈκÎÐÎʽµÄ°æ±¾¿ØÖÆÏµÍ³£¬ÈçSubclipse
4. ²»²ÉÓÃijÖÖ±àÂëÓëÃüÃû±ê×¼£¬ÒÔ¼°Í¨ÓÃÔ¼¶¨£¬²»ÄÜÔÚÏîÄ¿¿ª·¢ÖÜÆÚÀï¹á³¹Âäʵ
5. ²»Ê¹ÓÃͳһ¿ª·¢·½Ê½
6. ²»×ª»»£¨»ò£©Ò²² ......
ÉùÃ÷£º²¹³ä·ÒëÁËÔÌûÖм¸´¦Î´·Òë´¦¡£
---------------------------------------------------- תÌû¿ªÊ¼ -------------------------------------------------------
PHPÖеÄCURLº¯Êý¿â£¨Client URL Library Function£©
curl_close - ¹Ø±ÕÒ»¸öcurl»á»°
curl_copy_handle - ¿½±´Ò»¸öcurlÁ¬½Ó×ÊÔ´µÄËùÓÐÄÚÈݺ ......
Ô¤ÆÚ×¼±¸£º
Ò»¸ö139ÓÊÏ䣬ÊÕµ½Óʼþºó£¬¿ÉÒÔÃâ·Ñ¸øÄã¶ÌÐÅÌáÐÑ¡£Èç¹ûÄã²»ÐèÒª¶ÌÐÅÌáÐѹ¦ÄÜ£¬ÓÃʲôÓÊÏä¶¼¿ÉÒÔ
ÁíÍâÒ»¸ö¿ÉÒÔÔËÐÐPHPÎļþµÄWeb·þÎñÆ÷£¨Ï൱ÓÚ¼à¿Ø·þÎñÆ÷£©£¬ÏÖÔÚÃâ·ÑµÄPHPÍøÕ¾¿Õ¼äºÜ¶à£¬ÉÏÍøËÑËÑ¡£Èç¹û½«PHP¼à¿ØÎļþ·Åµ½Äã×Ô¼ºµÄ·þÎñ
Æ÷ÉÏ£¬Õâ¸ö¼à¿ØÎļþÒ²¾ÍµÈÓÚ°ÚÉ裬·þÎñÆ÷¹ÒµôÁË£¬ËüÒ²ÎÞ·¨ÔËÐÐÁË£¬ÔõÃ´Ä ......