Advertisement
gdhami

PHP, MySQL & encoding detection

Jul 3rd, 2013
569
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.86 KB | None | 0 0
  1. $db_handle = mysql_connect('localhost', 'username', 'password');
  2. mysql_select_db('my_db');
  3.  
  4. mysql_set_charset('utf8', $db_handle);
  5.  
  6. // ------ INSERT: First example -------
  7. $s        = "je viens de télécharger et installer le logiciel";
  8. $encoding = mb_detect_encoding($s, 'ASCII,UTF-8,ISO-8859-15', true);
  9. if ($encoding != 'UTF-8') { $s = iconv($encoding, 'UTF-8', $s); }
  10.  
  11. mysql_query("INSERT INTO my_table (post_id, post_subject, post_text) VALUES (1, 'subject 1', '$s')", $db_handle);
  12.  
  13. // ------ INSERT: Second example -------
  14. $s        = "EPrints and العربية";
  15. $encoding = mb_detect_encoding($s, 'ASCII,UTF-8,ISO-8859-15', true);
  16. if ($encoding != 'UTF-8') { $s = iconv($encoding, 'UTF-8', $s); }
  17. mysql_query("INSERT INTO my_table (post_id, post_subject, post_text) VALUES (2, 'subject 2', '$s')", $db_handle);
  18. // -------------
  19.  
  20. mysql_close($db_handle);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement