UTF-8 characters displaying incorrectly in PHP (when outputting result from MYSQL)

Question

I inserted some data from phpMyAdmin, it seems to be fine on phpMyAdmin image, but when I use PHP output the result from MYSQL, it becomes: image

PHP code:

function showTableRows($db)
{
    $sql = "SELECT * FROM forums ORDER BY id";
    $stmt = $db->prepare($sql);
    $stmt->execute();
    $result = $stmt->fetchAll(PDO::FETCH_ASSOC);

    foreach ($result as $row)
    {
        $forum_id = $row['forum_id'];
        echo '<tr>';
            echo '<td>';
                echo '<a href="viewforum.php?forum='. $forum_id .'">'. $row['name'] .'</a>';
                echo '<br>';
                echo '<small>'. $row['description'] .'</small>';
                ......

MYSQL collation already set to utf8_general_ci
HTML charset already set to utf-8

What am I missing??

Have you tried using `htmlentities` to encode your data before outputting it? — Chris, May 07 '16 at 08:40
I just tried htmlentities($row['name']), but still the same. — user3030712, May 07 '16 at 08:48

score 1 · Accepted Answer · answered May 07 '16 at 08:48

1

This can be because you are missing the charset option when connecting:

example: $dbh = new PDO('mysql:host=localhost;dbname=test;charset=utf-8', etc...

I don't see the connection line in your code, so, I can't know for sure.

answered May 07 '16 at 08:48

Denis Leger

213
2
7

After adding charset=utf8 when connecting, it displays ok now. Thanks. – user3030712 May 07 '16 at 08:57

UTF-8 characters displaying incorrectly in PHP (when outputting result from MYSQL)

1 Answers1