Opencart Türkiye Destek Sitesi ,E-Ticaret Yazılımı Destek Paylaşım Forumu

1 php sayfası yaptım ve veri tabanından tabloları çekiyorum herşey sorunsuz ama tr karakter hatası alıyorum bunu nasıl aşabilirim.

çıktı sonucu: http://www.dropturkiye.com/123.php

<?php
$user = "xxxxx"; //veritabaný kullanýcý adý
$pwd = "xxxxx"; //veritabaný þifresi
$host = "xxxxx"; //mysql server
$db = "xxxxx"; //veritabaný adý


$conn = mysqli_connect($host,$user,$pwd, $db);

$sonuc = mysqli_query($conn, "SELECT joda.customer.email, joda.order.shipping_firstname,joda.order.shipping_lastname,joda.order.shipping_c​ompany,joda.order.shipping_address_1,joda.order.shipping_address_2,joda.order.sh​ipping_city,joda.order.shipping_postcode,joda.order.shipping_zone,joda.order.shi​pping_method,joda.order.comment, GROUP_CONCAT(
CONCAT(
joda.order_product.name,', Adet: ',joda.order_product.quantity ,', Fiyat: ',cast(joda.order_product.price as decimal (10,2)),' TL',' , Toplam: ',cast(joda.order_product.total as decimal (10,2)),'TL') SEPARATOR '<br>-' )
as Pname from customer,joda.order,joda.order_product where customer.customer_id=joda.order.customer_id AND joda.order.order_id=joda.order_product.order_id AND joda.order.order_status_id = 2 GROUP BY joda.order.order_id");

if(mysqli_num_rows($sonuc)!=0){
echo'
<div class="container-fluid">
<div class="table-responsive">
<table class="table" align="center" style=" border:#25120b; border:double; align:center; font-size:9pt " >
<tr class="ranking">
<tr>
<th>Email</th>
<th>Adi</th>
<th>Soyadi</th>
<th>Sirket</th>
<th>Adres 1</th>
<th>Adres 2</th>
<th>Ilce</th>
<th>Posta Kodu</th>
<th>Sehir</th>
<th>Gonderi Turu</th>
<th>Yorum</th>
<th style="width:2000px">Urun Bilgisi</th>

</tr>
';

while($oku = mysqli_fetch_array($sonuc)){
echo '
<tr>
<td bgcolor="#d6d6c2"><font face="Tahoma, Geneva, sans-serif">'.$oku['email'].'</font></td>
<td bgcolor="#d6d6c2"><font face="Tahoma, Geneva, sans-serif">'.$oku['shipping_firstname'].'</font></td>
<td bgcolor="#d6d6c2"><font face="Tahoma, Geneva, sans-serif">'.$oku['shipping_lastname'].'</font></td>
<td bgcolor="#d6d6c2"><font face="Tahoma, Geneva, sans-serif">'.$oku['shipping_company'].'</font></td>
<td bgcolor="#d6d6c2"><font face="Tahoma, Geneva, sans-serif">'.$oku['shipping_address_1'].'</font></td>
<td bgcolor="#d6d6c2"><font face="Tahoma, Geneva, sans-serif">'.$oku['shipping_address_2'].'</font></td>
<td bgcolor="#d6d6c2"><font face="Tahoma, Geneva, sans-serif">'.$oku['shipping_city'].'</font></td>
<td bgcolor="#d6d6c2"><font face="Tahoma, Geneva, sans-serif">'.$oku['shipping_postcode'].'</font></td>
<td bgcolor="#d6d6c2"><font face="Tahoma, Geneva, sans-serif">'.$oku['shipping_zone'].'</font></td>
<td bgcolor="#d6d6c2"><font face="Tahoma, Geneva, sans-serif">'.$oku['shipping_method'].'</font></td>
<td bgcolor="#d6d6c2"><font face="Tahoma, Geneva, sans-serif">'.$oku['comment'].'</font></td>
<td bgcolor="#d6d6c2"><font face="Tahoma, Geneva, sans-serif">'.$oku['Pname'].'</font></td>

</tr>
</tr>

';
}
echo '</table></div></div>';
}else{
echo "Hic Kayit Yok";
}
mysqli_close($conn);
?>

Sorun çözülmüştür.

çözümü:

$conn = mysqli_connect($host,$user,$pwd, $db);
altına
mysqli_set_charset($conn,"utf8");

ekleyince sorun çözülüyor.