无法使用适当的字符集更新列


Unable to update column with appropriate charset

我遇到了一个巨大的编码问题,更确切地说,是数据库中的条目问题。插入数据时,字符会正确显示。然而,当我尝试更新列时,字符会被误读为其中一个:авдвадва。同时,当我插入新行时,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();
         }
    }
}