PHP operates MYSQL garbled code and uses SET NAMES utf8 to correct it_PHP tutorial

Write it down first so that you don’t have to remember it and look for it everywhere later!

When PHP operates the database, the data in the database is encoded in UTF8. When it is read out, all that is displayed is garbled question marks . I found some information and it turned out that I was reading it. Make encoding settings before:

create table tablename

(
id int not null auto_increment,
title varchar(20) not null,
contnet varchar(300) defalut null,
primary key ('id')
)begin =MyISAM DEFAULT CHARSET =UTF8;

Execute before inserting data:

mysql_query("SET NAMES utf8");

Then mysql_query("insert into tablename....")

Execute before reading data:

mysql_query("SET NAMES utf8");

Then mysql_query("select * from tablename")

Note: The encoding read here is the output after re-encoding the original encoded content. For example, the page where the output content is located is GBK encoded, then the page display will also be garbled when reading, so before querying Execute mysql_query("SET NAMES gbk"), and the GBK encoded text content

Reprinted from: http://www.cnblogs.com/zazl/