Home > Backend Development > PHP Problem > How to solve database php garbled code

How to solve database php garbled code

藏色散人
Release: 2023-02-28 22:20:01
Original
2336 people have browsed it

How to solve database php garbled code

How to solve the garbled database php?

Recently I am using Apache php MySql to practice website writing. During the process of storing data, the Chinese entered in the HTML form is stored in the database through php and is displayed as garbled characters. I searched on Baidu and found various opinions. Yes, I was really worried, but I still saw some useful information, that is, whether it is Chinese, English or other characters, the encoding format is set to utf8.

Recommended: "PHP Tutorial"

1. Add this sentence to the html code:

How to solve database php garbled code

Figure 1

How to solve database php garbled code

Figure 2

2 . If you forget to set this attribute when creating the table, don't worry. There is another way. First, select the table whose attributes you want to modify, click Operations to modify its attributes, and at the same time, you can check changeall column and confirm, as shown in Figure 2. In order to further ensure that no garbled characters appear, you can also add utf8-general-ci to some fields or all fields in the table. Specific operation: Click the table that needs to be modified (tb_product)->Structure->check all->change, and then set the Collation of each field individually. As shown in Figure 3.

How to solve database php garbled code

Figure 3

Note: If you do not select encoding as utf8-general-ci for the entire table, but only for the table Some fields are set to utf8-general-ci format. If you check the table attributes through Operation, you will still see that the encoding of the entire table is: For example, if the format is gbk-chinese-ci, if the Html encoding is utf8, it will still be Garbled characters appear, so the most important thing is to set the Collation of the entire table to utf8-general-ci. As shown in Figure 4 and Figure 5, although pro_name and pro_producer appear to be utf8-general-ci encoded in Figure 4, by looking at the encoding of the entire table, it is still in gbk format. The encoding is inconsistent, so it is possible that garbled characters will still appear in the table.

Okay, let’s summarize, to make a long story short, four points:

1. If you write php or html code in zend studio, first change the display encoding format of the created project to utf8 format;

2. Use in html to display the encoding format of the web page to be written;

3. When connecting to the database, after selecting a database (not a table), use mysql_qurry("set names utf8");

4. When creating the database mentioned above, change the entire table The encoding format is set to utf8-general-ci.

How to solve database php garbled code

Picture 4

How to solve database php garbled code

Picture 5

The above is the detailed content of How to solve database php garbled code. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
php
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template