How to set encoding in php sql

php sql setting encoding method: first connect to the database through the "mysql_connect" method; then use the "mysql_query("set names utf8");" method to set the encoding method to "utf8".

Recommended: "PHP Video Tutorial"

PHP Set the encoding method when connecting to the Mysql database (the cause of garbled characters One)

Directly upload the code:

Connect to the database:

<?php
   $connect=mysql_connect("服务器","登录的用户名","登录的密码");  
   mysql_select_db("数据库名",$connect);
   mysql_query("set names utf8");   //这里设置编码方式为 utf8 
?>

ps: When I set the encoding method, I wrote mysql_query("set names utf-8") ; When I use wamp encoding locally, there is no problem with the display. Then when I put the system I made on the virtual host of Wanwang, garbled characters appear. Some Chinese characters can be displayed, and some Chinese characters are not?

and other weird characters, I checked that the encoding method of the PHP web page file and the source code are both utf-8. Finally, I found that it was a problem when setting the encoding for the database connection. I struggled with it for a long time. ........

The above is the detailed content of How to set encoding in php sql. For more information, please follow other related articles on the PHP Chinese website!