用php向数据库里从表单加数据,加入的代码如下:其中$c_name,xingbie,phone,yongliao是char类型,其他是int,如果我加入的c_name是中文的话就没法加到数据库里,只能加字母的高手指点怎么回事
$sql=mysql_query("insert into dingdan(c_name,xingbie,phone,shengao,bichang,lingwei,yaowei,tunwei,yongliao,shuliang)values('$_POST[c_name1]','$_POST[xingbie1]','$_POST[phone1]',$_POST[shengao1],$_POST[bichang1],$_POST[lingwei1],$_POST[yaowei1],$_POST[tunwei1],'$_POST[yongliao1]',$_POST[shuliang1];");
@mysql_fetch_array($sql);
$sql=mysql_query("insert into dingdan(c_name,xingbie,phone,shengao,bichang,lingwei,yaowei,tunwei,yongliao,shuliang)values('$_POST[c_name1]','$_POST[xingbie1]','$_POST[phone1]',$_POST[shengao1],$_POST[bichang1],$_POST[lingwei1],$_POST[yaowei1],$_POST[tunwei1],'$_POST[yongliao1]',$_POST[shuliang1];");
@mysql_fetch_array($sql);
php文件保存格式和编码也用utf-8的试试
拿到语句后粘貼到phpmyadmin里执行,看看报什么错误
mysql_query("set names'gbk'");
就好了