我使用php将输入的数据插入到MySQL数据库中。问题是,它在phpmyadmin中显示为外来字符。我已经将我的数据库设置为utf8_hungarian_ci,您可以在这里看到:https://i.gyazo.com/aeca91e44e8f1808bad09584d8e938d7.png
我在我的表单中使用utf 8字符集:
<?php
header('Content-type: text/html; charset=utf-8');
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Add Records Form</title>
</head>
<body>
<form action="insert.php" method="post">
<p>
<label for="firstName">Név:</label>
<input type="text" name="name" id="firstName">
</p>
<p>
<label for="lastName">Foglalkozás:</label>
<input type="text" name="job" id="lastName">
</p>
<p>
<label for="emailAddress">Email:</label>
<input type="text" name="email" id="emailAddress">
</p>
<input type="submit" value="Add Records">
</form>
</body>
</html>我还在我的sql连接器中使用了mysqli_set_charset:
<?php
$link = mysqli_connect("localhost", "root", "", "reg");
// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
// Escape user inputs for security
$name = mysqli_real_escape_string($link, $_REQUEST['name']);
$job = mysqli_real_escape_string($link, $_REQUEST['job']);
$email = mysqli_real_escape_string($link, $_REQUEST['email']);
// attempt insert query execution
$sql = "INSERT INTO cards (name, job, email) VALUES ('$name', '$job', '$email')";
if(mysqli_query($link, $sql)){
echo "Records added successfully.";
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
// close connection
mysqli_set_charset($link, "utf8");
mysqli_close($link);
?>但是我仍然在我的页面上得到这样的结果,比如https://gyazo.com/ab3d40574f0c2162aa6b529651e413b3,ő,ú,ű,a等
编辑:我在我的索引页面上也使用了这个标题:
header('Content-type: text/html; charset=utf-8');发布于 2020-10-12 19:48:25
在关闭连接之前,我必须在最后设置字符集。
https://stackoverflow.com/questions/60276752
复制相似问题