Advertisement
Guest User

Untitled

a guest
May 24th, 2016
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. <?php
  2. error_reporting(E_ALL & ~E_NOTICE);
  3. $servername = "localhost";
  4. $username = "root";
  5. $password = "";
  6. $dbname = "dbTest";
  7.  
  8. if (isset($_POST['txtName'])) {$txtName= $_POST['txtName'];};
  9.  
  10. $link = mysqli_connect($servername, $username, $password, $dbname) or die("UNable to connect");
  11. $qq1 = "set character_set_server='utf8'";
  12. $qq2 = "set names 'utf8'";
  13.  
  14. //mysqli_query($link, $qq1) or die(mysqli_error($link));
  15. //mysqli_query($link, $qq2) or die(mysqli_error($link));
  16. //$txtName = iconv("UTF-8//TRANSLIT//IGNORE", "Windows-1252//TRANSLIT//IGNORE", $txtName);
  17. //$txtName = iconv("Windows-1256//TRANSLIT//IGNORE", "UTF-8//TRANSLIT//IGNORE", $txtName);
  18.  
  19. $query = "INSERT INTO tblTest Values('$txtName')";
  20.  
  21. mysqli_query($link, $query) or die(mysqli_error($link));
  22.  
  23. CREATE TABLE IF NOT EXISTS `tbltest` (`txtName` varchar(244) COLLATE tf8_bin DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  24.  
  25.  
  26. INSERT INTO `tbltest` (`txtName`) VALUES
  27. ('ãÍãÏ Úæäí ãÍãæÏ');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement