Home > Article > Backend Development > Sharing of related solutions to PHP displaying MySQL garbled characters_PHP tutorial
Sharing of related solutions to PHP displaying MySQL garbled characters_PHP tutorial
- WBOYOriginal
- 2016-07-15 13:30:40890browse
Problem with MySQL garbled characters displayed in PHP 1. Using PHPmyAdmin to operate the MySQL database, the Chinese characters are displayed normally, but when the MySQL data is displayed on the PHP web page, all Chinese characters become ? symbols.
Symptom: It is normal to input Chinese characters using PHPmyAdmin, but when the PHP web page displays MySQL data, the Chinese characters become ? signs, and there are as many ? signs as there are Chinese characters. Many students have encountered this problem, especially after installing the latest version of Appserv. For this reason, many students gave up PHP and switched to ASP.
Reason: There is no code in the PHP web page to tell MySQL what character set to use to output Chinese characters.
★ Solution to MySQL garbled code displayed in PHP: This is not garbled code. Just add the following code to the head of the PHP web page to tell MySQL to output Chinese characters in UTF8 encoding
<ol class="dp-xml">
<li class="alt"><span><span class="tag"><</span><span> ? mysql_query("SET NAMES UTF8"); </span><span class="tag">?></span><span> </span></span></li>
<li>
<span>你也可以在网页中PHP代码部分直接插入上述代码片段（即去掉两端</span><span class="tag"><</span><span> </span><span class="tag">??></span><span>号）。例如你用Dreamweaver连接数据库，那么可以在头部的连接代码 </span>
</li>
<li class="alt">
<span class="tag"><</span><span> ?php require_once('Connections/connmessage.php'); </span><span class="tag">?></span><span>中加入该代码使其变成 </span>
</li>
<li>
<span class="tag"><</span><span> ? </span></li><li class="alt"><span>php require_once('Connections/connmessage.php'); </span></li><li><span>mysql_query("SET NAMES UTF8"); </span></li><li class="alt"><span class="tag">?></span><span> </span>
</li>
</ol>
Note: If your web page encoding is gb2312, then SET NAMES GB2312. However, the editor strongly recommends that web page encoding, MySQL data table character set, and PHPmyAdmin all use UTF8. For the reason, please see Chapter 1, Section 2 of this site’s PHP tutorial.
PHP displays MySQL garbled code problem 2. An error occurs when entering data with PHPmyAdmin, input is not allowed or garbled code appears
★ PHP displays MySQL garbled code Solution: This is a setting problem. Please install the latest version of PHPmyAdmin or Appserv, open PHPmyAdmin, MySQL character set: UTF-8 Unicode (utf8); MySQL connection proofreading should be utf8_unicode_ci; when creating a new database, please also select utf8_unicode_ci in the finishing column. It is also best to use utf8 as the web page character set. UTF8 is an international standard encoding and a trend. For how to change the web page encoding, please see Chapter 1, Section 2 of this site’s PHP tutorial.
The problem of MySQL garbled characters displayed in PHP 3. The MySQL data table developed on this machine is normal when tested on this machine. However, when uploading using PHPmyAdmin provided by the website space provider, a problem occurs and the upload fails. Especially using foreign PHP space.
★ Solution to MySQL garbled code displayed in PHP: First check the PHPmyAdmin character set settings provided by the website space provider, and make sure that the data table you built and the space are in the same encoding. MySQL does not support gb2312 abroad, and even the latest version of Appserv does not support gb2312. If it is because the encoding is not uniform, you can rebuild the data table, of course using the international standard UTF8.