Polskie znaki w PHP

Question

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ć?

Answer 1

w MySQLi jest $mysqli->set_charset("utf8") do ustawiania. nie wiem czego używasz do komunikacji z bazą

Comments

Własnej klasy

<?php

	//ini_set('display_errors', 0);

	class Request {

		private $connection;

		function __construct($host, $user, $pass, $name) {
			try {
				$this->connection = new mysqli($host, $user, $pass, $name);
				if ($this->connection -> connect_errno != 0) 
					throw new Exception($this->connection -> connect_errno);
			} catch (Exception $e) {
				echo $e;
			}
		}

		function executeQuery($query) {
			$this->connection->query('SET NAMES utf8');
			$this->connection->query('SET CHARACTER_SET utf8_unicode_ci');
			if ($result = $this->connection->query($query))
				return $result;
			else return NULL;
			$this->disconnect();
		}

		function executeUpdate($query) {
			$this->connection->query('SET NAMES utf8');
			$this->connection->query('SET CHARACTER_SET utf8_unicode_ci');
			if ($this->connection->query($query)) {
				return true;
			} else return false;
			$this->disconnect();
		}

		function getMinimalId($table) {
			$query = "SELECT id FROM " . $table;
			if ($result = $this->connection->query($query)) {
				$row = $result->fetch_assoc();
				return $row['id'];
			} else return 0;
			$this->disconnect();
		}

		function getLastId($table) {
			$query = "SELECT MAX(id) FROM " . $table;
			if ($result = $this->connection->query($query)) {
				$row = $result->fetch_assoc();
				return $row['MAX(id)'];
			} else return 0;
			$this->disconnect();
		}

		function getNextId($id, $table) {
			$found = false;
			$ids = $id;
			while ($found == false) {
				$ids++;
				$query = "SELECT id FROM " . $table . " WHERE id='$ids'";
				if ($result = $this->connection->query($query)) {
					if ($result->num_rows == 1) {
						$found = true;
						$row = $result->fetch_assoc();
						$foundid = $row['id'];
						$result->free_result();
						return $foundid;
					}
				}
			}

			return null;
		}

		function disconnect() {
			$this->connection->close();
		}

	}

 

---

to w konstruktorze po poprawnym połączeniu ustaw

$connection->set_charset("utf8")

---

Dlaczego zrywasz połączenie po zapytaniu?

nie będziesz mógł wykonać ponownie zapytania.

Powinieneś zrywać połączenie w destruktorze

---

EDIT: Polskie znaki raczej się ładują, tylko jak mam o taki fragment rekordu: "posługujące", to w resulcie widzę: "posługuj�".

---

Dodaj

https://www.w3schools.com/tags/att_meta_charset.asp

i zapisz plik w UTF-8

---

Dalej się nie pokazuje.