gpt4 book ai didi

php - utf 8 - PHP 和 MySQLi UTF8

转载 作者:IT王子 更新时间:2023-10-28 23:50:56 24 4
gpt4 key购买 nike

<分区>

我的表字符集是 utf8,它的排序规则是 utf8。现在我有这段代码:

   $mysqli = new mysqli("localhost", "root", "", "Amoozeshgah");

if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());

}
if (!$mysqli->set_charset("utf8")) {
printf("Error loading character set utf8: %s\n", $mysqli->error);
} else {
printf("Current character set: %s\n", $mysqli->character_set_name());
}
mysql_set_charset('utf8');
if ($stmt = $mysqli->prepare("SELECT About_Title FROM Tbl_About WHERE About_Id=?")) {
$city = 8;

/* bind parameters for markers */
$stmt->bind_param("s", $city);

/* execute query */
$stmt->execute();

/* bind result variables */

$result = $stmt->get_result();

/* fetch value */
while ($myrow = $result->fetch_assoc()) {

// use your $myrow array as you would with any other fetch
printf("%s is in district %s\n", $city, $myrow['About_Title']);
print("shod");

}

但输出是:

Current character set: utf8 8 is in district نتمنتشس shod

我能做什么?编辑:我替换了:

if (!$mysqli->set_charset("utf8")) {
printf("Error loading character set utf8: %s\n", $mysqli->error);
} else {
printf("Current character set: %s\n", $mysqli->character_set_name());
}
mysql_set_charset('utf8');

$mysqli->set_charset("utf8")

但没有区别。

24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com