How to solve PHP + MySQL garbled characters

Have you ever encountered character garbled characters when using PHP + MYSQL? How did you solve this problem? Here we provide a solution.

 

Add a set names UTF8 clause after mysql_connect to eliminate garbled characters in the UTF8 database. set names gbk is used for GBK databases. The Code is as follows:

 
 


  
  
$ Mysql_mylink = mysql_connect ($ mysql_host, $ mysql_user, $ mysql_pass );

  
  
Mysql_query ("set names 'gbk '");

 
 

The database character set is UTF-8.

The connection statement uses this

 
 


  
  
Mysql_query ("set names 'utf8 '");

  
  
Mysql_query ("set character set UTF8 ");

  
  
Mysql_query ("SET CHARACTER_SET_RESULTS = utf8 '");

  
  
 

 
 

Recommended by editors]