Home > 类库下载 > PHP类库 > body text

Garbled code problem when using php mysql to operate database

高洛峰
Release: 2016-11-05 17:10:35
Original
1970 people have browsed it

When I was learning PHP and MySQL, when I used PHP to operate MySQL to insert data, I found that the Chinese characters were often garbled. When creating the database and database table, utf-8 encoding was specified. At the beginning, the html page was not set to utf-8 encoding. After setting the html page to

<meta http-equiv="content-Type" content="text/html;charset=UTF8">
Copy after login

and adding

header("Content-type:text/html; charset=utf-8");
Copy after login

to the PHP code, I found that the Chinese inserted into the database was still garbled.

I was puzzled and found out that after connecting to the database, I need to display and set the connection to use utf-8 encoding. . . .

<?php
$sqldb = new mysqli("localhost", "root", "", "project");
if (mysqli_connect_errno())
{
    printf("Connect failed:%s\n", mysqli_connect_error());
    exit();
}
mysqli_query($sqldb, "set names utf8"); //utf8 设为对应的编码
...
mysqli_close($sqldb);
?>
Copy after login

Mysqli uses latin-1 encoding by default. When your page is encoded in utf-8, the page will be garbled.

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 Recommendations
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template