arabic font not convert when i fetch with mysqli command

Question

hi there I made i database in mysql with collation utf_unicode_ci ; my code is

<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /></head>
<?php
$db=mysqli_connect("localhost","saeb","123456");
if (!$db)
echo "not connected";
mysqli_select_db($db,'publisher');
$select_book="select * from books";
$result = mysqli_query($db,"$select_book");
$num=mysqli_num_rows($result);
$i=1;
while($i<=$num){
$row=mysqli_fetch_array($result);
    // printf ("%s (%s)\n",$row[0],$row[1]);
    echo "<br>";
echo $row['auther'];
$i++;
}

// for ($i=0; $i <$num ; $i++) {
//   $row=mysqli_fetch_array($result);
//   echo "<br>";
//   echo $row['isbn'];
//   # code...
// }
// var_dump(mysqli_get_charset($db));

 ?>
</html>

but what I see is (i dont know what i must to execute php code in english)

sepidnam ???????? Tanenbaum Abbasnejad

where is problem?why arabic texts converted to ???? ? http://axbabak.ir/uploads/ec1.png http://axbabak.ir/uploads/ec2.png

yep . that is . tnx for so fast responding. – Saeb Molaee Feb 12 '16 at 20:04 — Saeb Molaee, Feb 12 '16 at 20:04
you're welcome. question was marked as a duplicate. – Funk Forty Niner Feb 12 '16 at 20:11 — Funk Forty Niner, Feb 12 '16 at 20:11

score 2 · Accepted Answer · answered Feb 12 '16 at 19:52

2

after mysqli_connect do mysqli_set_charset($db, 'utf8mb4');
also.. just a guess: try utf8mb4_unicode_ci instead (full unicode support)

answered Feb 12 '16 at 19:52

Brad Kent

4,982
3
22
26

that was too fasr. tnx. it works – Saeb Molaee Feb 12 '16 at 20:00
a question what is deffrent 8fm4 with full unicode? i didnt use that but i want know diffrence. – Saeb Molaee Feb 12 '16 at 20:01
@SaebMolaee see http://stackoverflow.com/questions/30074492/what-is-the-difference-between-utf8mb4-and-utf8-charsets-in-mysql – Brad Kent Feb 12 '16 at 21:09

arabic font not convert when i fetch with mysqli command

1 Answers1