How to set the database encoding method in php

In PHP, you can use the mysql_query() function to set the encoding method of the mysql database; the specific method is: add the "mysql_query("set names encoding method");" code after the mysql_connect() statement.

The operating environment of this tutorial: windows7 system, PHP7.1 version, DELL G3 computer

In PHP, you can use the mysql_query() function To set the encoding method of mysql database.

When PHP connects to the database, that is, after mysql_connect(), use the mysql_query() function to set the encoding method.

Example: Set the encoding method to utf8

<?php
   $connect=mysql_connect("服务器","登录的用户名","登录的密码");  
   mysql_select_db("数据库名",$connect);
   mysql_query("set names utf8");   //这里设置编码方式为 utf8 
?>

It is best to use utf-8 for the web page character set. UTF-8 is an international standard encoding and a trend.

If your web page encoding is gb2312, that is SET NAMES GB2312. However, it is strongly recommended that web page encoding, MySQL data table character set, and PHPmyAdmin all use UTF-8. Note:

The mysql_query("set names 'coding'"); encoding added before the PHP program that needs to perform database operations must be consistent with the PHP encoding. If the PHP encoding is gb2312, then the mysql encoding is gb2312. If it is utf-8, then the mysql encoding is utf8, so that there will be no garbled characters when inserting or retrieving data

Recommended learning: "PHP Video Tutorial"

The above is the detailed content of How to set the database encoding method in php. For more information, please follow other related articles on the PHP Chinese website!