php mysql ²ÉÓà utf 8 µÄÅäÖÃ
1¡¢ÔÚÅäÖÃmysqlʵÀýµÄÓïÑÔÑ¡Ïîʱ£¬Ñ¡Ôñutf-8
2¡¢ÔÚhtml,phpÒ³ÃæÖÐ ¼ÓÉÏ <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />£¬Èç¹û²»ÐÐÔÙÔÚ phpÎļþ Æðʼ´¦¼Ó header("Content-Type:text/html;charset=utf-8");
3¡¢ÔÚphpÖÐ×öÊý¾Ý¿âÁ¬½Óʱ£¬ÎÒÓõÄʱpdoµÄÐÎʽ£¬ËùÒÔÔÚ»ñµÃÒ»¸ö Connectionºó£¬½ô½Ó×ÅÖ´ÐÐ $conn->query("set names utf8");
ÏÂÃæÊÇÎҵĻñÈ¡Êý¾Ý¿âÁ¬½ÓµÄ·½·¨:
public static function getConnection(){
$conn = new PDO(self::dsn, self::user, self::password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$conn->query("set names utf8");
return $conn;
}
4¡¢Èç¹ûʹÓÃÃüÁîÐÐÈ¥Á¬½ÓÊý¾Ý¿â×öһЩ²éѯµÄ»°£¬ÇëÏÈÔÚ²éѯǰִÐÐ show variables like '%char%'; ¿´¿´Êä³öµÄÊDz»ÊÇÈçÏÂÃæ:
character_set_client gbk
character_set_connection gbk
character_set_database utf8
character_set_filesystem binary
character_set_results gbk
character_set_server utf8
character_set_system utf8
Èç¹û²»ÊÇ£¬ÇëÏÈÖ´ÐÐ set names gbk;
È»ºóÔÙ×öÒ»°ãµÄ²éѯ¡£
Ïà¹ØÎĵµ£º
½ñÌìÀ´¼òµ¥×ܽáÒ»ÏÂMySQL
µÄ
Ëø»úÖÆ£¬²»Í׵Ļ¶ÓÅÄש£¡
¡¡¡¡1¡¢¶ÔÓÚMySQLÀ´Ëµ£¬ÓÐÈýÖÖËøµÄ¼¶±ð£ºÒ³¼¶¡¢±í¼¶¡¢Ðм¶¡£
¡¡¡¡Ò³¼¶µÄµäÐÍ´ú±íÒýÇæΪBDB¡£
¡¡¡¡±í¼¶µÄµäÐÍ´ú±íÒýÇæΪMyISAM,MEMORYÒÔ¼°ºÜ¾ÃÒÔÇ°µÄISAM¡£
¡¡¡¡Ðм¶µÄµäÐÍ´ú±íÒýÇæΪINNODB¡£
¡¡¡¡2¡¢ÎÒÃÇʵ¼ÊÓ¦ÓÃÖÐÓõÄ×î¶àµÄ¾ÍÊÇÐÐËøÁË¡£
¡¡¡¡Ðм¶ËøµÄÓŵãÈç ......
mysql version 5.1
ÔÚmysql´´½¨±íµÄʱºò¾³£»áÓöµ½´´½¨ÈÕÆÚ×Ö¶ÎÐèÒªÉèÖõ±Ç°Ê±¼äΪĬÈÏÖµµÄʱºò£¬¾ÍÈçsqlserver2000Ò»Ñù£¬°ÑĬÈÏÖµÉèΪgetdate()¼´¿É£¬ÎÒÔÚÍøÉϲéÁËN¾Ã¶¼Ã»Óв鵽ʹÓÃÓÐЧµÄ·½·¨£¬×îºó×Ô¼ºÑо¿ÁËһЩ·½·¨Óë´ó¼Ò·ÖÏí£º
Êý¾Ý¿â£ºtest_db1
´´½¨±í£ºtest_ta1
Á½¸ö×Ö¶ ......
Linux + JDK + Tomcat + MySQL + JDBC °²×°ÊÖ¼Ç
Ò»¡¢Red Hat Linux
1.·ÖÇø
| swap & ......
Ê×ÏÈ˵×î¸ù±¾µÄ½â¾ö·½·¨£º
ÊÖ »ú·ÃÎÊʱ£¬»á¸½´ø·¢ËÍuser-agentÐÅÏ¢£¬Õâ¸öÐÅÏ¢ÀïÃæ»áÓÐÊÖ»úºÅÂëÐÅÏ¢£¬ÄÇôÈç¹ûÄÜÈ¡µÃÊÖ»úºÅÂ룬Ôò¿ÉÒԿ϶¨ÊÇͨ¹ýÊÖ»úwap·ÃÎʵġ£µ«ÊÇÄ¿Ç°ÖÐ ¹úÒƶ¯ÒѾÆÁ±ÎÁËuser-agentÐÅÏ¢£¬ËùÒÔ»ñÈ¡²»µ½ÊÖ»úºÅÂë¡£ÓйØϵµÄÅóÓÑ¿ÉÒÔÁªÏµÒƶ¯¹«Ë¾£¬°ÑwapÍøÕ¾·þÎñÆ÷µÄipÌá½»¸øÖйúÒƶ¯£¬¼ÓÈë°×Ãûµ¥ ºó¼´¿ÉÈ¡µ ......
<?php
//ÉùÃ÷Êý×é±äÁ¿
$arr = array('ÕÅÈý','ÀîËÄ','ÍõÎå','ÀîÃ÷');
//foreachÑ»·±éÀúÊý×é
foreach($arr as $key => $value){
//×¢Òâ“$value”ºó±ØÐëÒªÒ»¸ö¿Õ¸ñ£¬·ñÔòÊä³öµÄ½á¹û²»ÕýÈ·
echo "Öµ$value µÄϱêΪ$key<br/ ......