php¡¢json¡¢SQLServer¸ßÊÖ½ø
php¸ßÊÖ½ø ÎÒÔÚºǫ́µÃµ½Ç°Ì¨ÓÃXMLHttpRequest·¢Ë͹ýÀ´µÄJSONÊý¾Ý£¬½âÎöºóÊÇÕý³£µÄ£¬Ìí¼Óµ½SQLServer2000Êý¾Ý¿âÖÐÖ®ºó£¬ÖÐÎľͱäÁË¡£
(´ó¼Ò°ïæ°¡£¬¾ÍÊÇÔÚǰ̨ÓÃajax·¢ËÍJSONÊý¾Ýµ½ºǫ́£¨php´úÂ룩£¬ÔÚͨ¹ýºǫ́´úÂëÖ´ÐÐһЩ¼ì²é£¬½âÎöjsonÊý¾ÝºóÌí¼Óµ½Êý¾Ý¿âÖУ¬Êý¾Ý¿âÖиÕÌí¼ÓµÄÖÐÎÄÊý¾Ý¾Í³ÉÂÒÂëÁË»òÕ߸ù±¾¾ÍÌí¼Ó²»½øÈ¥¡£)
±£Ö¤Ò³Ãæ±àÂëºÍÊý¾Ý¿âÖд洢Êý¾ÝʱµÄ±àÂëÒ»Ö¡£
²»Ò»Ö¾ͻáÂÒÂë¡£
sqlserverµÄ±àÂëÊÇʲô±àÂ룿ÎÒÊÔ¹ýתutf-8£¬ºÍgb2312.µ«¶¼²»Ðа¡£¬¸ßÊÖ°ïÒ»ÏÂæ°¡¡£
sql server ÖÐÎİæÄ¬ÈÏΪgb2312 Äã¿´json´«µ½phpʱºò±àÂëÊÇʲô£¿
ºÃÏñÊÇutf-8 ÎÒÊÔÊÔ
Ïà¹ØÎÊ´ð£º
¸÷λ´óЩ
ÇóÒ»¶Îphp´úÂë
¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ
Õë¶Ô²»Í¬µÄä¯ÀÀÆ÷ÏÔʾ²»Í¬µÄͼƬ
¾ÍÊÇÓÐÒ»ÕÅͼƬ£¬Ö»Ïë¸øie6Óû§¿´µ½
Èç¹ûie7¡¢chrome¡¢firefoxÓû§ä¯ÀÀÔòÏÔʾÁíÍâÒ»ÕÅͼƬ
¼Û¸ñ²»ÒªÌ«ÀëÆ×¾ÍÐÐ ......
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......
´úÂëÈçÏ£º
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' ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......