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, ·Ç³£Ë³Àû, ºÜ¿ì¾Í°²×°ÁË, È»ºó¾¹ý¼òµ¥µÄÅäÖÃ. ½øÈëMySQLµÄ¿ØÖÆÌ¨, ÊäÈëÃÜÂë. È»ºó¾Í˳ÀûµØ½øÈëµ½Á˹¤×÷״̬.
µ«Êǵ±ÎÒµÚ¶þÌì½øÈëMySQLµÄ¿ØÖÆÌ¨, ÊäÈëÃÜÂëʱ, µÎµÄÒ»Éùºó,Õû¸ö¿ØÖÆÌ¨¾ÍÏûʧÁË.ÖØÐÂÊÔÁ˼¸´Î, ÎÊÌâÒÀ¾É. ¾ÍÉÏÍø°Ù¶ÈÒ»ÏÂ,·¢ÏÖÓв»ÉÙÈËÓöµ½Í¬ÑùµÄÎÊÌâ, ºÜ¶àÈ˶¼ËµÊ±my.iniÅäÖôíÎó, ÓÚÊÇ´ò¿ ......
· ÄÚ²¿¹¹¼þºÍ¿ÉÒÆÖ²ÐÔ
o ÌṩÁËÊÂÎñÐԺͷÇÊÂÎñÐÔ´æ´¢ÒýÇæ¡£
--ÊÇ·ñÖ¸Èç¹ûÒª²ÉÓÃÊÂÎñ¹ÜÀí£¬±ØÐëÇл»´æ´¢ÒýÇæ£¿£¿£¿
· Óï¾äºÍº¯Êý
DELETE¡¢INSERT¡¢REPLACEºÍUPDATE·µ»Ø¸ü¸Ä£¨Ó°Ï죩µÄÐÐÊý¡£Á¬½Óµ½·þÎñÆ÷ʱ£¬¿Éͨ¹ýÉèÖ ......
Ê×ÏÈ˵×î¸ù±¾µÄ½â¾ö·½·¨£º
ÊÖ »ú·ÃÎÊʱ£¬»á¸½´ø·¢ËÍuser-agentÐÅÏ¢£¬Õâ¸öÐÅÏ¢ÀïÃæ»áÓÐÊÖ»úºÅÂëÐÅÏ¢£¬ÄÇôÈç¹ûÄÜÈ¡µÃÊÖ»úºÅÂ룬Ôò¿ÉÒԿ϶¨ÊÇͨ¹ýÊÖ»úwap·ÃÎʵġ£µ«ÊÇĿǰÖÐ ¹úÒÆ¶¯ÒѾÆÁ±ÎÁËuser-agentÐÅÏ¢£¬ËùÒÔ»ñÈ¡²»µ½ÊÖ»úºÅÂë¡£ÓйØÏµµÄÅóÓÑ¿ÉÒÔÁªÏµÒƶ¯¹«Ë¾£¬°ÑwapÍøÕ¾·þÎñÆ÷µÄipÌá½»¸øÖйúÒÆ¶¯£¬¼ÓÈë°×Ãûµ¥ ºó¼´¿ÉÈ¡µ ......
<html>
<head>
<script type="text/javascript">
<!--
function confirmDelete()
{
return confirm("Are you sure you wish to delete this entry?");
}
//-->
</script>
</head>
<body>
<% $var1 = 2;%> ......
ÔÎÄÁ´½Ó£ºhttp://www.phpdo.net/index.php/20100410/55.html
ÔÚPHPÖиüÐÂÊý×éµÄÄÚÈÝ¿ÉÒÔÖ±½ÓÖ¸¶¨¼üÃû²¢ÇҶԸüüÃû¸³Öµ¡£ ÀýÈ磺
<?php
$php = array(“php”,”phpdo”,”phpdo.net”);
$php[2] = “www.phpdo.net”;
print_r($php);
&nbs ......