在mysql数据库插入数据的时候,插入英文是没有问题的,但是只要出现中文就不行
<?php
$host = "127.0.0.1";
$user = "root";
$pass = "123456";
$db = "school";
$connection=mysql_connect($host,$user,$pass) or die("Unable to connect!");
//mysql_select_db($db) or die ("Unable to select database");
$sqlTest = "create DataBase Person";
$sql = "insert into employee values(4,'Yund','男',96)";
if(mysql_db_query("Person",$sql)){
echo("插入数据成功");
}
else{
echo("插入数据失败");
}
?>
谢谢大家了
<?php
$host = "127.0.0.1";
$user = "root";
$pass = "123456";
$db = "school";
$connection=mysql_connect($host,$user,$pass) or die("Unable to connect!");
//mysql_select_db($db) or die ("Unable to select database");
$sqlTest = "create DataBase Person";
$sql = "insert into employee values(4,'Yund','男',96)";
if(mysql_db_query("Person",$sql)){
echo("插入数据成功");
}
else{
echo("插入数据失败");
}
?>
谢谢大家了
注意编码mysql_query("set names uft8")
”能插入吗!!!!