Guest User

Untitled

a guest
Jan 14th, 2019
152
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.37 KB | None | 0 0
  1. UTF8 text shows ???? when queried from db
  2. <?php
  3. header("Content-Type: application/json; charset=UTF-8");
  4.  
  5. $server = "";
  6. $username = "";
  7. $password = "";
  8. $database = "";
  9.  
  10. $con = mysql_connect($server, $username, $password) or die ("Could not connect: " . mysql_error());
  11. mysql_select_db($database, $con);
  12.  
  13. $sql = "SELECT * FROM events WHERE id='1' ";
  14. $result = mysql_query($sql) or die ("Query error: " . mysql_error());
  15.  
  16. $records = array();
  17.  
  18. while($row = mysql_fetch_assoc($result)) {
  19. $records[] = $row;
  20. }
  21.  
  22. mysql_close($con);
  23.  
  24. print_r($records);
  25.  
  26. ?>
  27.  
  28. Array
  29. (
  30. [0] => Array
  31. (
  32. [id] => 1
  33. [event] => ????? ?????
  34. [speaker] => ???? ???????
  35. [area] => ???????
  36. [place] => ???? ??????
  37. [addr] => ??? ???? ????????
  38. [datefrom] => 2012-10-05
  39. [dateto] =>
  40. [timefrom] => 19:26:27
  41. [timeto] =>
  42. )
  43.  
  44. )
  45.  
  46. SHOW CREATE DATABASE `your_db_name`
  47.  
  48. rowname varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  49.  
  50. $con = mysql_connect($server, $username, $password) or die ("Could not connect: " . mysql_error());
  51. mysql_select_db($database, $con);
  52.  
  53. mysql_query('SET NAMES utf8');
  54. mysql_query('SET CHARACTER_SET_CLIENT=utf8');
  55. mysql_query('SET CHARACTER_SET_RESULTS=utf8');
  56.  
  57. $sql = "SELECT * FROM events WHERE id='1' ";
  58. $result = mysql_query($sql) or die ("Query error: " . mysql_error());
Add Comment
Please, Sign In to add comment