mysqliquery 编码

$result = mysqli_query($connection, $query);

$connection = mysqli_connect("host", "user", "password", "database");
mysqli_set_charset($connection, "utf8mb4");

<?php
$host = "localhost";
$user = "your_username";
$password = "your_password";
$database = "your_database";

// 连接到 MySQL 数据库
$connection = mysqli_connect($host, $user, $password, $database);

// 检查连接是否成功
if (!$connection) {
    die("Connection failed: " . mysqli_connect_error());
}

// 设置连接的字符集为 utf8mb4
mysqli_set_charset($connection, "utf8mb4");

// 执行查询
$query = "SELECT * FROM your_table";
$result = mysqli_query($connection, $query);

// 检查查询是否成功
if (!$result) {
    die("Query failed: " . mysqli_error($connection));
}

// 处理结果集
while ($row = mysqli_fetch_assoc($result)) {
    echo $row["column_name"] . "<br>";
}

// 关闭连接
mysqli_close($connection);
?>