CODEWITHSUNDEEP
phpmysql
Mehmet Altıntaş
Mehmet Altıntaş

Reputation: 35

PHP MYSQL encoding issue ( Turkish Characters )

core.php

$con=mysqli_connect("localhost","root","","mmogezgini");
header('Content-Type: text/html; charset=utf-8');

gamelisti.php

$result = mysqli_query($con,"SELECT * FROM games");
while($row = mysqli_fetch_array($result))
  {
?>
HTML CODES
<?php echo $row['game_name']; ?>
HTML CODES
<?php }
mysqli_close($con);
?>

i use turkish characters like "ö,ç,ğ,ı" i see these correctly in database but when i select them from database and show with php echo they looks like question mark=(?) my encoding on database utf8_general_ci

Upvotes: 0

Views: 4425

Answers (1)

speccode
speccode

Reputation: 1562

  1. Double check your HTML encoding.
  2. http://php.net/manual/en/mysqli.set-charset.php (just after you connect to DB: mysqli_set_charset($con, 'utf8');
  3. Are you using prepared statements? (not related but important).

Upvotes: 7

Related Questions