php¡¢json¡¢SQLServer¸ßÊÖ½ø
php¸ßÊÖ½ø ÎÒÔÚºǫ́µÃµ½Ç°Ì¨ÓÃXMLHttpRequest·¢Ë͹ýÀ´µÄJSONÊý¾Ý£¬½âÎöºóÊÇÕý³£µÄ£¬Ìí¼Óµ½SQLServer2000Êý¾Ý¿âÖÐÖ®ºó£¬ÖÐÎľͱäÁË¡£
(´ó¼Ò°ïæ°¡£¬¾ÍÊÇÔÚǰ̨ÓÃajax·¢ËÍJSONÊý¾Ýµ½ºǫ́£¨php´úÂ룩£¬ÔÚͨ¹ýºǫ́´úÂëÖ´ÐÐһЩ¼ì²é£¬½âÎöjsonÊý¾ÝºóÌí¼Óµ½Êý¾Ý¿âÖУ¬Êý¾Ý¿âÖиÕÌí¼ÓµÄÖÐÎÄÊý¾Ý¾Í³ÉÂÒÂëÁË»òÕ߸ù±¾¾ÍÌí¼Ó²»½øÈ¥¡£)
±£Ö¤Ò³Ãæ±àÂëºÍÊý¾Ý¿âÖд洢Êý¾ÝʱµÄ±àÂëÒ»Ö¡£
²»Ò»Ö¾ͻáÂÒÂë¡£
sqlserverµÄ±àÂëÊÇʲô±àÂ룿ÎÒÊÔ¹ýתutf-8£¬ºÍgb2312.µ«¶¼²»Ðа¡£¬¸ßÊÖ°ïÒ»ÏÂæ°¡¡£
sql server ÖÐÎİæÄ¬ÈÏΪgb2312 Äã¿´json´«µ½phpʱºò±àÂëÊÇʲô£¿
ºÃÏñÊÇutf-8 ÎÒÊÔÊÔ
Ïà¹ØÎÊ´ð£º
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 ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
µ±ÎÒÓÃPHPÏÂÔØ·þÎñÆ÷ÉϵÄwavÒôÀÖÎļþʱ£¬wavÎļþÄܹ»ÏÂÔØÏÂÀ´£¬²¢ÇÒ´óСÏàͬ£¬µ«ÊÇÈ´²»Äܲ¥·Å¡£µ«ÈôÊÇͨ¹ýÎļþ·þÎñÆ÷¿½±´µ½±¾µØ£¬ÊÇ¿ÉÒÔ²¥·Å¸ÃÎļþµÄ£¬²»ÖªµÀÈçºÎÔÒò¡£Í¨¹ýMD5sum¼ì²â£¬¸ÃÎļþÏÂÔØºóÒѸı䣬²»ÖªµÀÔ ......
Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
ÒѾÐÞ¸ÄÁË
£¨1£©PHP.iniÖеÄpost_max_size ºÍupload_max_filesize£¬²¢ÇÒ±£Ö¤ÁËǰÕß´óÓÚºóÕß
£¨2£©Windows\System32\inetsvr\MetaBase.xmlÖеÄAspMaxRequestEntityAllowed
ÐÞ¸ÄÍê±Ïºó£¬ÖØÐÂÆô¶¯ÁËIIS·þÎñ£¬²¢ÇÒ¼Æ ......