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">
and adding
header("Content-type:text/html; charset=utf-8");
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); ?>
Mysqli uses latin-1 encoding by default. When your page is encoded in utf-8, the page will be garbled.

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function

Dreamweaver Mac version
Visual web development tools

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

SublimeText3 Mac version
God-level code editing software (SublimeText3)

mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),
