The field value written by PHP is garbled

王林
Release: 2023-02-25 14:00:01
Original
2127 people have browsed it

The field value written by PHP is garbled

1. Use phpmyadmin to create the database and data table

When creating the database, please set "Organization" to: " utf8_general_ci" or execute the statement:

CREATE DATABASE `dbname` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
Copy after login

When creating a data table: If the field stores Chinese, you need to set "Organization" to: "utf8_general_ci", if the field stores English or numbers. , the default is fine.

Corresponding SQL statement, for example:

CREATE TABLE `test` (

`id` INT NOT NULL ,

`name` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,

PRIMARY KEY ( `id` )

) ENGINE = MYISAM ;
Copy after login

2. Use PHP to read and write the database

After connecting to the database

$connection = mysqli_connect($host_name, $host_user, $host_pass);
Copy after login

Join:

mysqli_query("set character set 'utf8'");//读库

mysqli_query("set names 'utf8'");//写库
Copy after login

You can read and write the MYSQL database normally.

The environment used is appserv-win32-2.5.10. When installing this package, the default utf8 encoding is used.

When writing the database connection file, write:

$conn = mysqli_connect("$host","$user","$password");

mysqli_query("SET NAMES 'UTF8'");

mysqli_select_db("$database",$conn);
Copy after login

Then when making the page, pay attention to this sentence:

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

In this way, regardless of the Chinese input into the database or the page display, everything will be normal.

In the DW CS4 version, the utf8 page is generated by default. Similarly, if you first write the database connection file, you write:

mysqli_query("SET NAMES &#39;GBK&#39;");
Copy after login

The page should also change accordingly:

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

Recommended tutorial: PHP video tutorial

The above is the detailed content of The field value written by PHP is garbled. 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