用PHP从数据库中获取波斯语文本[重复]

Question

This question already has an answer here:

• UTF-8 all the way through 15 answers

I have problem get data from database. Persian words appear as question marks like ???????. How can I avoid this?

Here is my code:

header('Content-Type: text/html; charset=utf-8');
$conn = mysqli_connect("localhost", "somevalue", "somevalue", "somevalue");
$output = array();
$query  = "SELECT * FROM af_home ORDER BY home_id DESC LIMIT 50";
$result = mysqli_query($conn, $query);
if (mysqli_num_rows($result) > 0) {
    while ($row = mysqli_fetch_array($result)) {
        $output[] = $row;
    }
    echo json_encode($output);
}

</div>

Answer 1

make sure that the af_home column charset is UTF-8 from the database