herocj
新手上路
UID 97211
精华
0
积分 5
帖子 3
金钱 5 喜悦币
威望 0
人脉 0
阅读权限 10
注册 2007-8-19
状态 离线
|
[广告]: q
m
mysql_query()l乱码问题,新手卡在这里了
环境:debian linux系统,phpmyadmin,mysql5,php5.
php,mysql乱码是很常见的,所以安装时,我都是用utf8的,phpmyadmin也是utf8的.
mysql的字符集我全部设成UTF8.
就是在my.cnf下在
[client]和[mysqld]添加,default-character-set=utf8,
我是用zend写PHP的,在首选项那,也是选中了utf8字符集,
但是我在php脚本里,用mysql_query()往mysql里插入数据后,用phpmyadmin查看插入数据中文全是乱码
我用PHP显示中文是没问题的,只是在插数据时出问题了,头痛呀,搞了很久,希望有高人帮帮新手呀.....万分感谢...
代码:
<?php
$connection=mysql_connect("localhost","user","password");
if($connection)
{
$query="drop database Books";
mysql_query($query);
$createsql="create database Books";
if(!mysql_query($createsql,$connection))
echo "create database failed!<br>";
else
{
echo "create database sucessfully!<br>";
mysql_select_db("Books",$connection);
$query="create table Computers ( ";
$query.="id int(3) auto_increment not null primary key, ";
$query.="name char(10) not null, ";
$query.="price float default 0,";
$query.="publish_date date)";
echo $query."<br>";
$result=mysql_query($query);
if(!$result)
echo "create table failed!<br>";
else
{
echo "create table sucessfully!<br>";
$query="insert into Computers(name,price,publish_date) ";
$query.="values ('数据结构',20,'200-1-1')";
echo $query."<br>";
$result=mysql_query($query);
if(!$result)
echo "insert data failed!<br>";
else
echo "insert data successfully!<br>";
$query="update Computers ";
$query.="set price=price+2 ";
$query.="where name='数据结构'";
echo $query."<br>";
$result=mysql_query($query);
if(!$result)
echo "update data failed!<br>";
else "update data sucessfully!<br>";
$query="delete from Computers ";
$query.="where name='数据结构'";
echo $query."<br>";
$result=mysql_query($query);
if(!$result)
echo "delete data failed!<br>";
else
echo "delete data successfully!<br>";
}
}
}
?>
|
|
