PHP cyrillic is encoded when echoing in db query

Asked Jul 02 '22 at 20:19

Active Jul 02 '22 at 20:23

Viewed 13 times

I've got php function like that:

while($row = mysqli_fetch_array($result)){
  echo '<span style="font-size: 10pt;">Альбом: ' .$row['album'].'<br /></span>';
  echo '<span style="font-size: 10pt;">Рік: ' .$row['release_year'].'<br /></span>';
  echo '<span style="font-size: 10pt;">Країна: ' .$row['country'].'<br /></span>';
  echo '<span style="font-size: 10pt;">Жанр: ' .$row['genre'].'<br /></span>';
}

output:

РђР»СЊР±РѕРј: Away From the Sun
Р С–Рє: 2001
РљСЂР°С—РЅР°: Germany
Р–Р°РЅСЂ: Rock

Why is this happening?

edited Jul 02 '22 at 20:23

user3783243

5,368
5
22
41

asked Jul 02 '22 at 20:19

Stack1233

Document's header has charset to utf8? – user3783243 Jul 02 '22 at 20:22
@user3783243 yep. As you can see - problem's with HTML text as `Альбом` – Stack1233 Jul 02 '22 at 20:23
data from DB is echoing normally – Stack1233 Jul 02 '22 at 20:23
Yes, noticed it wasnt db/mysql related after first comment so removed it. Can you show how HTML headers are being sent and which they are? Proper MVCE would have been `echo 'Альбом';` gives `РђР»СЊР±РѕРј`. The other content and tags cluttered the issue. – user3783243 Jul 02 '22 at 20:23
@user3783243 sorry I misunderstood you. I thought that you meant that sql query should be set with utf-8 – Stack1233 Jul 02 '22 at 20:26
`` helped! – Stack1233 Jul 02 '22 at 20:27

PHP cyrillic is encoded when echoing in db query

0 Answers0