¹ØÓÚmysqlдÈëÖÐÎijöÏÖÂÒÂëµÄÎÊÌâ - PHP / »ù´¡±à³Ì
Çë½ÌÎÊÌ⣺ mysqlÊÇutf-8ÐÎʽ£¬ÎÒÔÚ±àÐ´ÍøÒ³´úÂëʱÓõÄÊÇgb2312£¬ÇëÎÊÈçºÎÏòÊý¾Ý¿âдÈëÖÐÎĺÍÏòÒ³ÃæÊä³öÖÐÎĵÄʱºò£¬ÊÇÕý³£µÄ£¬¶ø²»»á³öÏÖÂÒÂë¡£
½¨ÒéÄãǰ̨ºÍºǫ́±£³Ö±àÂëÒ»Ö Êý¾Ý¿âдÈëÖÐÎÄ mysql_query("set names utf8"); ÏòÒ³ÃæÊä³öÖÐÎÄ <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> ÄãÕâ¸öµØ·½¿ÉÒÔʹÓÃiconv("UTF-8","GB2312",$str); ת»»Ò»Ï mysql_query("set names 'utf8'");ÒýÓà ½¨ÒéÄãǰ̨ºÍºǫ́±£³Ö±àÂëÒ»Ö Êý¾Ý¿âдÈëÖÐÎÄ mysql_query("set names utf8"); ÏòÒ³ÃæÊä³öÖÐÎÄ <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> ÄãÕâ¸öµØ·½¿ÉÒÔʹÓÃiconv("UTF-8","GB2312",$str); ת»»Ò»Ï up mb_convert_encodingÒ²¿ÉÒÔ±àÂëת»»ÒýÓà ½¨ÒéÄãǰ̨ºÍºǫ́±£³Ö±àÂëÒ»Ö Êý¾Ý¿âдÈëÖÐÎÄ mysql_query("set names utf8"); ÏòÒ³ÃæÊä³öÖÐÎÄ <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> ÄãÕâ¸öµØ·½¿ÉÒÔʹÓÃiconv("UTF-8","GB2312",$str); ת»»Ò»Ï + Æä實°´ÕÕµÀÀí來說 ÊDz»會亂碼µÄ... Òò為utf-8µÄ範圍´ó過gb2312 µ«ÊǺÜ遺º¶mysql沒ÓÐutf-8 Ö»ÓÐutf8...兩ÕßÊÇÓвî別µÄ... {{-
Ïà¹ØÎÊ´ð£º
ÎÒ¸ÕѧϰphpÇëÎÊ£¬Èç¹ûÎÒ°ÑphpÎļþÉÏ´«ÖÁ·þÎñÆ÷ºó£¬ÀýÈçhttp://www.****.com/cast.phpÕâ¸öÎļþ»á²»»á±»±ðÈËÏÂÔØ»ò¸´Öư¢£¿ ¿ÉÒÔ±»ÏÂÔØ£¬Ò²¿ÉÒÔ²»±»ÏÂÔØ£¬¿´web·þÎñÆ÷¶Ô¸ÃÎļþȨÏÞµÄÅäÖà ¿´Äã¶ÔÎļþȨÏÞµÄÉèÖà ......
CREATE DATABASE ADDRESSLIST; USE ADDRESSLIST; DROP TABLE IF EXISTS FRIEND; CREATE TABLE FRIEND (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY , FRIEND_NAME VARCHAR(20) NOT N ......
Çë¸ßÊÖÃǸø½éÉܼ¸±¾ºÃÊ飡 ÊÖ²áºÜÖØÒªµÄàÞ£¡~ ÎÒ¶¼ÊÇÐÂÊÖ Ò»Æë¼ÓÓÍ Ò»°ã¶¼ÊÇÊÖ²áµÄÀ²£¬ÔÙ¼ÓÉÏÒ»±¾ÊµÀý½²½â php´ÓÈëÃŵ½¾«Í¨ Õâ±¾ÊéÀïÓкöà´íµÄµØ·½¡£ È¥ÂòÊ¥¾°É£¬ÄDZ¾Ê黹²»´í£¬ÁíÍâÄǸö18.8MµÄÊÖ²áÒ ......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£ MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10. ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......
1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿ 2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......