21,886
社区成员
发帖
与我相关
我的任务
分享
<?php
header("Content-type:text/html;Charset=UTF-8;");
$link=mysql_connect("localhost","root","123456") or die("无法连接服务!");
mysql_select_db("codegbk",$link) or die("数据库无法选择");
mysql_query("set names utf8");
$rs = mysql_query("select *from user",$link);
$sql = "insert into user values(default,'测试乱码')";
mysql_query($sql);
while($row = mysql_fetch_array($rs)){
echo $row["username"]."<br/>";
}
?>
mysql_connect();
mysql_select_db('test');
mysql_query('DROP TABLE IF EXISTS `mb`);
$sql = <<< SQL
CREATE TABLE `mb` (
`ch` varchar(10) NOT NULL,
`val` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
SQL;
mysql_query($sql);
function save($charset, $text) {
mysql_query("set names $charset");
mysql_query("insert into mb values ('$charset', '$text')");
}
function load($charset) {
mysql_query("set names $charset") or die(mysql_error());
$rs = mysql_query('select * from mb');
while($row = mysql_fetch_assoc($rs)) {
list($hex) = unpack('H*0', $row[val]);
echo "$charset $row[ch] : $row[val] $hex<br>";
}
}
$s = "漢字";
save('gbk', $s);
save('utf8', iconv('gbk', 'utf-8', $s));
save('big5', iconv('gbk', 'big5', $s));
load('gbk');
load('utf8');
load('big5');
function binhex($str) {
$hex = "";
$i = 0;
do {
$hex .= sprintf("%02x", ord($str{$i}));
$i++;
}
while ($i < strlen($str));
return $hex;
}