What should I do if the php mysql query results show garbled characters?

If you find that the results are garbled when you use MySQL to query and display the results on the PHP page, then this article may help you.

There are many reasons for garbled characters, such as inconsistent character encoding, inconsistent database and page encoding, incompatible PHP versions, etc. Next we will address these aspects one by one.

1. Inconsistent character encoding

The default character set when MySQL is installed is latin1, and many websites use UTF-8 encoding, which may cause garbled characters in query results. You can use the following command to modify the MySQL encoding:

ALTER DATABASE your_database_name CHARACTER SET utf8;
ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8;

where your_database_name and your_table_name are replaced with your database and data table names respectively.

2. Database and page encodings are inconsistent

If you do not specify a character set when connecting to the database, the query results may use different character sets, resulting in garbled characters. You can use the following command to specify the character set when connecting:

mysqli_set_charset($link, 'utf8');

where $link is the variable name of the database connection, which should be modified according to the actual situation.

3. PHP version is incompatible

In PHP5.5 and below, the mysql_ function is abandoned. It is recommended to use mysqli_ or PDO functions. If you are using the mysql_ function and running it in PHP7 or above, the query results may be garbled. It is recommended to upgrade to mysqli_ or PDO function.

4. Convert character set

Use the iconv() function in PHP to convert characters from one encoding to another. For example, convert GBK encoding to UTF-8 encoding:

$content = iconv('GBK', 'UTF-8', $content);

The above are some precautions to solve the problem of garbled display of MySQL query results in PHP. If you have other questions, please do more research on your own or ask in the community, there are many.

The above is the detailed content of What should I do if the php mysql query results show garbled characters?. For more information, please follow other related articles on the PHP Chinese website!