php - UTF-8 Turkish Character on osCommerce -
i installed oscommerce v2.2 rc2 on http://www.cwcenerji.com. problem left column (categories.php)
in database category name "türkçe kategori" on front side see t�rk�e kategori
i tried few things, database charset utf-8 couldn't handle.
here categories.php;
<div class="title"> <img src="theme/images/icons/category.png" alt="kategoriler"/> <p>kategorİler</p> </div> <div class="detail"> <ul class="categorytype"> <?php $query = mysql_query("select * categories parent_id = 0"); $i = 0; while($row = mysql_fetch_array($query)) { $cat[$i] = $row; $cat[$i]['categories_name'] = mysql_result(mysql_query("select categories_name categories_description language_id = 1 , categories_id = '".$row['categories_id']."'"), 0); $i++; } if(isset($session_id)) { $cate = "&oscsid=$session_id"; } else { $cate = ""; } foreach($cat $val) { //echo $val['categories_id']; $sub_query = mysql_query("select * categories parent_id = '".$val['categories_id']."'"); echo '<li><a href="#"> <img src="theme/images/icons/stars.png" alt="yıldız"/><span><b>'.$val['categories_name'].'</b></span></a> </li>'; while($sub_row = mysql_fetch_array($sub_query)) { echo '<li><a href="#"> <img src="theme/images/icons/stars.png" alt="yıldız"/><a href="kategori.php?cpath='.$val['categories_id'].'_'.mysql_result(mysql_query('select categories_id categories_description categories_id = '.$sub_row['categories_id'].' , language_id = 1'),0).$cate.'"><span>'.mysql_result(mysql_query('select categories_name categories_description categories_id = '.$sub_row['categories_id'].' , language_id = 1'),0).'</span></a> </li>'; } } ?>
here solution;
i've added these lines on categories.php (under
mysql_query("set names 'utf8'"); mysql_query("set character set utf8"); mysql_query("set collation_connection = 'utf8_turkish_ci'");
Comments
Post a Comment