我遇到了一个巨大的编码问题,更确切地说,是数据库中的条目问题。插入数据时,字符会正确显示。然而,当我尝试更新列时,字符会被误读为其中一个:авдвадва
。同时,当我插入新行时,phpMyAdmin:Кон
中的数据如下所示。
<form action="addItem.php" method="post">
<p>
<label class='title' for="title"> Title</label>
<input type="text" name="title" id="title" class="input"/>
</p>
<p>
<label class='description' for="description"> Description</label>
<textarea name="description" id="description" rows="10" cols="35"></textarea>
</p>
<p>
<input type="submit" class='buttono' name="addEntry" id="addEntry" value="Add New Entry" />
</p>
</form>
这是我的db.php
<?php
class Db {
public $mysql;
function __construct() {
$this->mysql = new mysqli('localhost', 'root', 'password', 'to-do') or die("Unable to connect to database");
}
function delete_by_id($id) {
$query = "DELETE from todo WHERE id = $id";
$result = $this->mysql->query($query) or die("There was a problem");
}
function update_by_id($id, $description) {
$query = "UPDATE todo
SET description = ?
WHERE id = ?";
if ($stmt = $this->mysql->prepare($query)) {
$stmt->bind_param('si', $description, $id);
$stmt->execute();
}
}
}
这是我的addItem.php
<?php
require 'db.php';
$db = new Db();
if (isset($_POST['addEntry'])) {
$query = "INSERT INTO todo VALUES ('', ?, ?)";
if ($stmt = $db->mysql->prepare($query)) {
$stmt->bind_param('ss', $_POST['title'], $_POST['description']);
$stmt->execute();
header('Location: index.php');
}
} else {
die ($db->mysql->error);
}
它怎么了?在执行查询之前,我尝试将字符集设置为UTF-8,但它仍然是一样的(实际上这似乎不是问题所在)。
您必须将mysql连接字符集设置为UTF-8。您可以像这样使用$mysql->set_charset("utf8"):
<?php
class Db {
public $mysql;
function __construct() {
$this->mysql = new mysqli('localhost', 'root', 'password', 'to-do') or die("Unable to connect to database");
if (!$this->mysql->set_charset("utf8")) {
throw new Exception("Error loading character set utf8: " . $this->mysql->error);
}
}
function delete_by_id($id) {
$query = "DELETE from todo WHERE id = $id";
$result = $this->mysql->query($query) or die("There was a problem");
}
function update_by_id($id, $description) {
$query = "UPDATE todo
SET description = ?
WHERE id = ?";
if ($stmt = $this->mysql->prepare($query)) {
$stmt->bind_param('si', $description, $id);
$stmt->execute();
}
}
}