Several PHP Chinese garbled problems are worth noting

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

The best and fastest solution is that the encoding declared by the page is consistent with the internal encoding of the database. If the page number applied for the page is inconsistent with the internal encoding of the database, set the connection encoding, mysql_query("SET NAMES KKK "); KKK is the connection encoding. It can definitely solve the problem of garbled characters.

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 the static page, the encoding format of all files is ANSI, available Open Notepad, save as, select encoding as ANSI, and overwrite the source file. b. If you want to use utf-8 encoding, then php should output the header: header("Content-Type: text/html; charset=utf-8"), and add , the encoding format of all files is utf-8. Saving as utf-8 may be a bit troublesome. Generally, utf-8 files will have BOM at the beginning. If you use session, there will be problems. You can use editplus to save. In editplus, go to Tools->Parameter Selection->File-> UTF-8 signature, select Always delete, then save to remove the BOM information.

2. PHP itself is not Unicode, all functions such as substr must be changed to mb_substr (mbstring extension needs to be installed); or use iconv to transcode.

2. Data interaction between PHP and Mysql

The encoding of PHP and the database should be consistent

1. Modify the mysql configuration file my.ini or my.cnf. It is best to use utf8 encoding for mysql [mysql] default-character-set=utf8 [mysqld] default-character-set=utf8 default-storage-engine=MyISAM Add under [mysqld]: default-collation=utf8_bin init_connect='SET NAMES utf8'

2. Add mysql_query(" before the PHP program that needs to perform database operations. set names 'encoding'");, the encoding is consistent with the PHP encoding. If the PHP encoding is gb2312, then the mysql encoding is gb2312. If it is utf-8, then the mysql encoding is utf8, so that there will be no garbled characters when inserting or retrieving data

Three. PHP is related to the operating system. The encoding of Windows and Linux is different. In the Windows environment, if the parameters are utf-8 encoded when calling PHP functions, errors will occur, such as move_uploaded_file(), filesize(), readfile(), etc. These functions are often used when processing uploads and downloads. The following error may occur when calling: Warning: move_uploaded_file()[function.move-uploaded-file]: failed to open stream: Invalid argument in ... Warning: move_uploaded_file()[function.move-uploaded-file]:Unable to move '' to '' in ... Warning: filesize() [function.filesize]: stat failed for ... in ... Warning: readfile( ) [function.readfile]: failed to open stream: Invalid argument in .. Although these errors will not occur when using gb2312 encoding in a Linux environment, the saved file name will be garbled and the file cannot be read. In this case, you can first The parameters are converted into the encoding recognized by the operating system. The encoding conversion can be mb_convert_encoding (string, new encoding, original encoding) or iconv (original encoding, new encoding, string), so that the file name saved after processing will not be garbled, and Files can be read normally, and files with Chinese names can be uploaded and downloaded. In fact, there is a better solution, which is to completely separate from the system, and there is no need to consider the encoding of the system. You can generate a sequence of only letters and numbers as the file name, and save the original name with Chinese characters in the database. In this way, there will be no problem when calling move_uploaded_file(). When downloading, you only need to change the file name to the original name with Chinese characters. Chinese name. The code to implement downloading is as follows header("Pragma: public"); header("Expires: 0"); header("Cache-Component: must-revalidate, post-check=0, pre-check=0"); header( "Content-type: $file_type"); header("Content-Length: $file_size"); header("Content-Disposition: attachment; filename="$file_name""); header("Content-Transfer-Encoding: binary "); readfile($file_path); $file_type is the type of file, $file_name is the original name, and $file_path is the address of the file saved on the service.



Four. Let