Name: php mysql query results utf8mb4_bin encoding to utf-8 for html
Rating: 4 (3854 reviews)

Message:

This question already has answers here:

My Answer:
Yes, you can convert the encoding of the query results from utf8mb4_bin to utf-8 for HTML output. Here is an example of how you can achieve this:

php

// Connect to the database

$mysqli = new mysqli("localhost", "username", "password", "database");



// Set the connection character set to utf8mb4

$mysqli->set_charset("utf8mb4");



// Run your query

$query = "SELECT * FROM table";

$result = $mysqli->query($query);



// Fetch the results and convert the encoding to utf-8

while ($row = $result->fetch_assoc()) {

    foreach ($row as $key => $value) {

        $row[$key] = mb_convert_encoding($value, 'UTF-8', 'utf8mb4');

    }

    // Output the results in HTML

    echo "{$row['column1']}
";

    echo "{$row['column2']}
";

    // Add more columns as needed

}



// Close the connection

$mysqli->close();

This code snippet demonstrates how to fetch the query results and convert the encoding of each value from utf8mb4_bin to utf-8 using the `mb_convert_encoding` function. You can then output the results in HTML as needed.

Rate this post

4 of 5 based on 3854 votes