mysql插入显示问好

-- 查看数据库字符集
SHOW CREATE DATABASE your_database_name;

-- 修改数据库字符集
ALTER DATABASE your_database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 查看表字符集
SHOW CREATE TABLE your_table_name;

-- 修改表字符集
ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

$mysqli = new mysqli("host", "user", "password", "database");
$mysqli->set_charset("utf8mb4");

$dsn = "mysql:host=host;dbname=database;charset=utf8mb4";
$pdo = new PDO($dsn, "user", "password");

<?php
$mysqli = new mysqli("localhost", "root", "", "test");

// 检查连接
if ($mysqli->connect_error) {
    die("连接失败: " . $mysqli->connect_error);
}

// 设置连接字符集
$mysqli->set_charset("utf8mb4");

// 插入数据
$name = "张三";
$sql = "INSERT INTO users (name) VALUES (?)";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param("s", $name);
$stmt->execute();

echo "新记录插入成功";

$mysqli->close();
?>