mysql utf-8ÂÒÂëÎÊÌâ - PHP / »ù´¡±à³Ì
ÔÚphpmyadminÊäÈëÊý¾Ýºó ͨ¹ýNavicat for MYSQL ´ò¿ª±íºóÓÐÊý¾ÝµÄµØ·½¶¼ÏÔʾBLOB ²¢ÇÒÔÚNavicat ÏÂÎÞ·¨²åÈëÊý¾Ý¡£
PHPÊä³öºóÂÒÂë
ÔÚphpadminÖпÉÒÔ²åÈëÊý¾Ý£¬ÏÔʾÕý³£
×¢£ºPHPÖмÓÁËheader('content-type;text/html;charset=utf-8');ÎÊÌâÒÀ¾É
ÇëÎʸ÷Î»ÎªÊ²Ã´ÄØ£¿ÈçºÎ½â¾ö
лл
phpmyadminÊÇÀϰ汾µÄ£¿£¿£¿
3.2.4
mysql_query("SET NAMES 'utf8'");
ÄØ£¿
Êý¾Ý¿â±àÂëÊÇutf8Âð£¿
Êǵġ£
ÎÒÊÇ´ÓPHPMYADMINÀï²åÈëµÄÊý¾Ý ÔÚNavicat ÀïÏÔʾBLOB £¬ÔÚPHPÀïÊä³öÏÔʾ£¿£¿£¿£¿£¿£¿
²»ÖªµÀÔõô»ØÊÂ
Ŷ£¬ÒÔǰÓö過這樣µÄ問題¡£²»Öª這´ú碼對ÄãÊÇ·ñÓÐ幫Öú¡£
SQL code:
CREATE DATABASE `testing` ;
SQL code:
CREATE TABLE `testing`.`tb_test` (
`id` INT( 255 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE = MYISAM
INSERT INTO `testing`.`tb_test` (
`id` ,
`name`
)
VALUES (
NULL , 'ÄãºÃ£¬ÎÒÊÇ¿¡¡£'
Ïà¹ØÎÊ´ð£º
Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......
ÎÒ×î½üдÁ˸ömailÖ´ÐкóûÓгöÏÖ´íÎóÐÅÏ¢Ö´ÐÐÍê±ÏºóÓÊÏäÀﲢû·¢ËÍÓʼþ£¬Çë¸÷λ°ïÎÒ¿´¿´
ÎÒÓõĵÄÊÇiis smtp
<?php
$to = 'xueyuxia1988@sohu.com';
$subject = 'the subject';
$message = 'hello';
$ ......
Çë½Ì¸ßÊÖ°ïæ£¬session_start£¨£©·ÅÔÚÍⲿµÄÎļþÓà require »ò include °üº¬½øÀ´£¬ÇëÎÊÕâÑù×öºÏÀíÂ𣿣¿´úÂëÔËÐÐÊÇÕý³£µÄ£¬ÕâÑù×öºÏÀíÂ𣿣¿Çë¸ßÊÖÖ¸µã¡£¡£¡£¡£ лл····
require »ò include ......
id name datetime
1 a 2010-05-13 10:15:00
2 b 2010-05-14 09:10:00
3 d 2010-05-14 10:10:00
ÈçºÎ½«¾àÀëĿǰ×î½üµÄÄǸö¼Ç¼µÄname ¸üÐÂΪ¡°x¡±ÄØ
лл¿© °¡ ºÇºÇ
update table_n ......