Home 类库下载 PHP类库 Garbled code problem when using php mysql to operate database

Garbled code problem when using php mysql to operate database

Nov 05, 2016 pm 05:10 PM

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.

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

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)