How PHP solves Chinese garbled data stored in MySQL

How does PHP solve the problem of Chinese garbled data stored in MySQL? This article mainly introduces the common Chinese garbled code problems in PHP+MySQL storage data, summarizes and analyzes the common Chinese garbled code problems in PHP+mysql, and provides solutions for your reference. Friends in need can refer to it. I hope it will be helpful to everyone.

The details are as follows:

Common reasons for Chinese garbled characters in PHP+MySQL:

1. The encoding of the MYSQL database is utf8, which is the same as that of the PHP web page Inconsistent encoding formats will cause Chinese garbled characters in MYSQL.

2. When using MYSQL to create a table or select a field, the type set is not utf8, and the web page encoding is not utf8, which may also cause MYSQL Chinese garbled characters.

3. Character set of the PHP page The encoding is inconsistent with the database.

4. PHP connects to the MYSQL database. The operation is to set the encoding specified by the statement and the page encoding. The PHP page encoding is inconsistent.

5. If the encoding of the HTML page submitted by the user is inconsistent with the encoding of the page that displays the data, it will definitely cause the PHP page to be garbled.

Methods to solve the problem of Chinese garbled characters:

1. Web page encoding settings. Generally, add the attribute:

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

to the file header in the HTML code to ensure that the web page is encoded in "utf-8".

2. PHP code settings. Add the following code at the beginning of the php code:

header("Content-type: text/html;charset=utf-8");

and the encoding method of the saved file is required to be utf-8 (you can use EditPlus to open the settings, as shown below), thus ensuring that the file is also utf-8 encoded .

3. The Chinese part stored in the fields of the table in the database must be set to the utf8_general_ci type.

4. When PHP connects to the database for operation, it is necessary to set the field type of the operation to utf8. The setting method is as follows:

mysql_connect('localhost','user','password');
mysql_select_db('db');
mysql_query("set names utf8"); //**设置字符集***
mysql_query(要执行的sql语句);

Related recommendations:

php sql anti-injection program code

php Three things you need to know about database development

Quick solution to php pdo oracle Chinese garbled characters

The above is the detailed content of How PHP solves Chinese garbled data stored in MySQL. For more information, please follow other related articles on the PHP Chinese website!