Witam, mam bazę danych, gdzie wszystko jest kodowane w utf8_general_ci i taki kod PHP:
<?php
require_once("database_config.php");
require_once("request.class.php");
$req = new Request($db_host, $db_user, $db_pass, $db_name);
$query = "SELECT * FROM tabela ORDER BY data DESC";
$req->executeUpdate("SET NAMES utf8");
$req->executeUpdate("SET CHARACTER_SET utf8_general_ci");
$result = $req->executeQuery($query);
$black = true;
for ($i = 0; $i <= $result->num_rows - 1; $i++) {
$row = $result->fetch_assoc();
$title = $row['tytul'];
$id = $row['id'];
$title = mb_substr($title, 0, 22) . ' <a href="#" class="link">...</a>';
if ($black == true) {
echo '<div class="col-12 bg-dark-hover">' . $title .
'<div class="float-right"><span class="border icons text-warning" panel-action="edit" panel-id="' . $id . '"><i class="icon-pencil"></i></span>
<span class="border icons text-danger" panel-action="delete" panel-id="' . $id . '"><i class="icon-cancel"></i></span></div></div>';
$black = false;
}
else {
echo '<div class="col-12 information-light">' . $title .
'<div class="float-right"><span class="border icons text-warning" panel-action="edit" panel-id="' . $id . '"><i class="icon-pencil"></i></span>
<span class="border icons text-danger" panel-action="delete" panel-id="' . $id . '"><i class="icon-cancel"></i></span></div></div>';
$black = true;
}
}
Polskie znaki zastępuje �. Ten plik jest ładowany ajaxem do strony HTML. Jak to naprawić?