PHP Chinese garbled characters are one of the common problems in PHP development. PHP Chinese garbled characters sometimes occur in the web page itself, some occur in the process of MySQL interaction, and sometimes are related to the operating system. Here is a summary.
1. The first is the encoding of the PHP web page
1. The encoding of the PHP file itself and the encoding of the web page should match
a. If you want to use gb2312 encoding, then PHP should output the header: header("Content-Type: text/html; charset= gb2312"), add To tell the browser what encoding is used for the web page. Currently, XXX mainly uses GB2312 and UTF-8 in Chinese website development.
3. Database connection encoding: refers to the encoding used to transmit data to the database when performing database operations. It should be noted here that it should not be confused with the encoding of the database itself, such as the internal default of MySQL
It is latin1 encoding, which means that Mysql stores data in latin1 encoding, and data transmitted to Mysql in other encodings will be converted into latin1 encoding.
Now that we know where coding is involved in WEB development, we also know the reasons for garbled codes: the above three coding settings are inconsistent. Since most of the various codings are ASCII compatible, English symbols will not appear, and Chinese characters will be unlucky. .
Five. Fight some common error situations and solutions:
1. The database uses UTF8 encoding, and the page declaration encoding is GB2312
, which is the most common cause of garbled characters. At this time, the direct SELECT data in the PHP script will be garbled, and you need to use it before querying: mysql_query("SET
NAMES GBK"); to set the MYSQL connection encoding and ensure that the page declaration encoding is consistent with the connection encoding set here (GBK is an extension of GB2312
). If the page is UTF-8 encoded, you can use: mysql_query("SET NAMES UTF8");
Note that it is UTF8 and not the commonly used UTF-8. If the encoding of the page declaration is consistent with the internal encoding of the database, you do not need to set the connection encoding.
Note: In fact, the data input and output of MYSQL is more complicated than what is mentioned above. There are 2 default encodings defined in the MYSQL configuration file my.ini, which are in [client] default-character-set and default-character-set in [mysqld] To set the encoding used by default for client connections and internal databases respectively. The encoding we specified above is actually the command line parameter when the MYSQL client connects to the server. character_set_client, to tell the MYSQL server what encoding the client data received is, instead of using the default encoding.
2. The page declaration encoding is inconsistent with the encoding of the file itself. This rarely happens because if the encoding is inconsistent, what the artist sees in the browser when creating the page will be garbled characters. More often than not, it is modified after publishing. Some minor bugs are caused by opening the page in the wrong encoding and then saving it. Or you use some FTP software to directly modify files online, such as CuteFTP. Due to incorrect software encoding configuration, the wrong encoding is converted. code.
3. Some friends who rented virtual hosts found that even though the above three encodings were set correctly, there were still garbled characters. For example, the web page is GB2312 Encoded, IE and other browsers always recognize it as UTF-8 when opened. The page HEAD has stated that it is GB2312. Manually modify the browser encoding to GB2312. The subsequent page displays normally. The reason is that the server Apache sets the global default encoding of the server and adds AddDefaultCharset in httpd.conf. UTF-8 . At this time, the server will first send the HTTP header to the browser, and its priority is higher than the encoding declared in the page. Naturally, the browser will recognize it incorrectly. There are two solutions. Administrators should add this to the configuration file of their own virtual machines. AddDefaultCharset GB2312 to override the global configuration, or configure it in .htaccess in your own directory.
Summary: In a word, the best and fastest way to solve the Chinese garbled code in PHP is to make the page declaration code consistent with the internal code of the database. If the page number applied for the page is inconsistent with the internal code of the database, , just set the connection encoding, mysql_query("SET NAMES XXX "); XXX is the connection encoding. It will definitely solve the problem of garbled characters.
The above has introduced a summary of common solutions to Chinese garbled characters in PHP, including relevant content. I hope it will be helpful to friends who are interested in PHP tutorials.