Clash Royale CLAN TAG#URR8PPP

Emoji storage by base64 in Database PHP

Can anybody tell me why I did not get the correct smiley?

In DB I stored:

8J+Yhw==


base64_decoded it is: 😇

base64_decoded

If I try it like this:

echo base64_decode("8J+Yhw==");


It works.

If I try it like this:

$bullet_sql = mysqli_query($con, "SELECT * FROM `products` where pid = $row[products_id] order by wo, sprache, id");



while($bullet = mysqli_fetch_array($bullet_sql))
print base64_decode(trim($bullet[text]));



I got something like that:

= Symbol


I don't know why. If I write:

print trim($bullet[text]);


I get exactly the same text 8J+Yhw==

8J+Yhw==

var_dump($bullet);

print base64_decode(trim($bullet));

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.