php+mysql中文乱码，已解决2020年3月

最新推荐文章于 2023-12-22 12:11:39 发布

原创最新推荐文章于 2023-12-22 12:11:39 发布 · 323 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#php #mysql #乱码

本文介绍了解决PHP结合MySQL出现中文乱码的问题，通过添加mysqli_set_charset和header设置字符集为UTF-8，确保数据正确显示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

php+mysql中文乱码，已解决2020年3月

增加这行代码即可：
mysqli_set_charset($conn,“utf8”);

#直接放参考代码

在下面代码中找到mysqli_set_charset($conn,“utf8”);的文章，按照这个这是添加即可，除此之外，记得带开头添加：
header(“Content-type:text/html;charset=utf-8”);
echo …t/html;charset=utf-8">’;这两行具体如下：

代码片.

<?php
	header("Content-type:text/html;charset=utf-8"); 
	echo '<meta http-equiv="content-type" content="text/html;charset=utf-8">';
    //声明变量
    $username = isset($_POST['username'])?$_POST['username']:"";
    $password = isset($_POST['password'])?$_POST['password']:"";
    $re_password = isset($_POST['re_password'])?$_POST['re_password']:"";
    $sex = isset($_POST['sex'])?$_POST['sex']:"";
    $qq = isset($_POST['qq'])?$_POST['qq']:"";
    $email = isset($_POST['email'])?$_POST['email']:"";
    $phone = isset($_POST['phone'])?$_POST['phone']:"";
    $address = isset($_POST['address'])?$_POST['address']:"";

    if($password == $re_password) {
        //建立连接
        $conn = mysqli_connect('localhost','root','123456','loginfacesign');
        //准备SQL语句,查询用户名
        $sql_select="SELECT username FROM User WHERE username = '$username'";
        //执行SQL语句
        $ret = mysqli_query($conn,$sql_select);       
        $row = mysqli_fetch_array($ret);
        //nanKn
        //mysqli_query("set names 'utf8'");
        // 修改数据库连接字符集为 utf8
        //mysqli_set_charset($con,"utf8");
        mysqli_set_charset($conn,"utf8");
        //mysqli_set_db("loginfacesign",$conn);
        //判断用户名是否已存在
        if($username == $row['username']) {
            //用户名已存在，显示提示信息
            header("Location:register.php?err=1");
        } else {

            //用户名不存在，插入数据
            //准备SQL语句
            $sql_insert = "INSERT INTO User(username,password,sex,qq,email,phone,address) VALUES('$username','$password','$sex','$qq','$email','$phone','$address')";
            //执行SQL语句
            mysqli_query($conn,$sql_insert);
            header("Location:register.php?err=3");
        }

        //关闭数据库
        mysqli_close($conn);
    } else {
        header("Location:register.php?err=2");
    }

?>