Home  >  Article  >  Backend Development  >  What to do if data inserted into php7.0 is garbled

What to do if data inserted into php7.0 is garbled

hzc
hzcOriginal
2020-06-10 14:37:181974browse

What to do if data inserted into php7.0 is garbled

What to do when php7.0 inserts garbled data:

php7 The reason why garbled data is inserted into the mysql database is because the encoding format is different.

So in order to solve this problem, we need to build a new table and ensure that the encoding format is unified when inserting.
If you insert data normally in MySQL, then it is a PHP operation error, so we need to set up the database For the encoding format during operation, you can add these two lines of code:

//php7
mysqli_query($connect, "set character set 'utf8'");//读库 
mysqli_query($connect,"set names 'utf8'");//写库
//php5
mysql_query("set character set 'utf8'");//读库 
mysql_query("set names 'utf8'");//写库
————————————————
版权声明:本文为CSDN博主「babulongbo」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/babulongbo/article/details/78472064

Recommended tutorial: "php tutorial"

The above is the detailed content of What to do if data inserted into php7.0 is garbled. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn