Gmu0VNTg

1<?php
2error_reporting(E_ALL & ~E_NOTICE);
3$servername = "localhost";
4$username = "root";
5$password = "";
6$dbname = "dbTest";
7
8if (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
21mysqli_query($link, $query) or die(mysqli_error($link));
22	
23CREATE TABLE IF NOT EXISTS `tbltest` (`txtName` varchar(244) COLLATE tf8_bin DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
24
25
26INSERT INTO `tbltest` (`txtName`) VALUES
27('ãÍãÏ Úæäí ãÍãæÏ');