How to solve the garbled problem of php admin

藏色散人
Release: 2023-03-13 22:22:01
Original
2493 people have browsed it

Solution to php admin garbled code: 1. Check the database encoding; 2. Open the "my.ini" file and find the "[client]" part; 3. Add the statement "default-character-set=utf8" That’s it.

How to solve the garbled problem of php admin

The operating environment of this article: windows7 system, phpmyadmin version 4.9.2, DELL G3 computer

How to solve the garbled problem of phpmyadmin?

mysql phpmyadmin garbled code solution

In the project I recently participated in the competition, the background required interaction, and garbled codes appeared when updating the personalized signature.

View database encoding

How to solve the garbled problem of php admin

show variables like 'character%';
Copy after login

Open my.ini and find [client] and add a line

default-character-set=utf8
Copy after login

Find [mysqld] and add this line of code As follows

character_set_server=utf8
init_connect='SET NAMES utf8'
Copy after login

At this time, you can copy the file to the desktop, change it to txt format to forcibly modify the content, then change it back to the ini file format, delete the previous my.ini file, and then put the modified files on the desktop Copy my.ini into it (this series of operations require administrator rights)

In this way, we can check the encoding of the database (we must close the mysql service and close the existing mysql session to ensure that we use the new The character encoding is turned on)

Solution to the completed effect

How to solve the garbled problem of php admin

Recommended learning: "PHP Video Tutorial"

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

Related labels:
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