见鬼的问题??insert insert into ddupaoon (Apname,Asex,Aage,Aschool,AmailP,Acontent) values ('aa','ba','ca','da','ea','fa')数据打印正确阿 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Asex,Aage 你定义的是int类型插入的时候是 'ba','ca'。类型不匹配 insert into ddupaoon (Apname,Asex,Aage,Aschool,AmailP,Acontent) values ('1','2','3','4','5','6')也不行 Column count doesn't match value count at row 1报这个错误,我疯了,好多年了,第一次 insert into ddupaoon(Apname,Asex,Aage,Aschool,AmailP,Acontent) values( '1 ', '2 ', '3 ', '4 ', '5 ', '6 ') ddupaoon后面不要有空格还可以直接在mysql中执行这条语句验证一下 换成这种写法insert into ddupaoon set Apname='1',Asex='2' .... insert into ddupaoon (Apname) set Apname = '11df'不行,为什么? 如果刚才我说的方法可以的话,那我肯定你是字段与values不匹配 if (!$con){ die('Could not connect: ' . mysql_error());}mysql_select_db("localhost ", $con);$sql = "insert into ddupaoon (Apname,Asex,Aage,Aschool,AmailP,Acontent) values ('". $oApname ."','".$oAsex."','".$oAage."','".$oAschool."','".$oAmailP."','".$oAcontent."')";echo $sql;if(!mysql_query($sql)){ echo "<script> alert('成功');</script>";}mysql_close($con);我不执行 mysql_query ????? $sql = "insert into ddupaoon (Apname,Asex,Aage,Aschool,AmailP,Acontent) values ( ' ". $Apname . " ', ' ".$Asex. " ', ' ".$Aage. " ', ' ".$Aschool. " ', ' ".$AmailP. " ', ' ".$Acontent. " ') "; mysql语句语法错误,每个字段名应加上"Tab"键上面的单引号,试一试! 不行,是不是数据库 的问题,大侠解释下mysql5 如果上面那么多都不行,就应该是编码的问题。$Apname = addslashes(trim($_POST[ "aname "])); $Asex = addslashes(trim($_POST[ "asex "])); $Aage = addslashes(trim($_POST[ "aage "])); $Aschool = addslashes(trim($_POST[ "ashool "])); $AmailP = addslashes(trim($_POST[ "amail "])); $Acontent = addslashes(trim($_POST[ "acontent "])); $Apname = iconv("gb2312","utf-8",$Apname);//$Apname = iconv("gb2312","utf-8",$Apname);$Asex = iconv("gb2312","utf-8",$Asex);$Aage = iconv("gb2312","utf-8",$Aage);$Aschool = iconv("gb2312","utf-8",$Aschool);$AmailP = iconv("gb2312","utf-8",$AmailP); 你將my.ini裡的sql-mode語句用#注釋掉。然後再重啟MYSQL試試看。還有在insert時,values()裡整數應該是不帶任何引號吧。 我尝试过得方法:1:sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" //原来的sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" //我做过的修改不行2:sql 语句打印正确,我在 myadmin 里做过测试3:字符编码,我用的是 utf8 的编码,在得到数据的时候,正确但是就是 mysql_query 不执行 <?php$con = mysql_connect("localhost","root","123456");//Aid Apname Asex Aage Aschool AmailP Acontent$oApname = addslashes(trim($_POST["aname"]));$oAsex = addslashes(trim($_POST["asex"]));$oAage = addslashes(trim($_POST["aage"]));$oAschool = addslashes(trim($_POST["ashool"]));$oAmailP = addslashes(trim($_POST["amail"]));$oAcontent = addslashes(trim($_POST["acontent"]));if (!$con){ die('Could not connect: ' . mysql_error());}mysql_select_db("localhost ", $con);$sql = "insert into ddupaoon (Apname,Asex,Aage,Aschool,AmailP,Acontent) values ('". $oApname ."','". $oAsex ."','". $oAage ."','". $oAschool ."','". $oAmailP ."','". $oAcontent ."')";echo $sql;if(!mysql_query($sql)){ echo "<script> alert('成功');</script>";}mysql_close($con);?>这是代码 $sql = "insert into ddupaoon (Apname,Asex,Aage,Aschool,AmailP,Acontent) values ( ' ". $oApname . " ', ' ". $oAsex . " ', ' ". $oAage . " ', ' ". $oAschool . " ', ' ". $oAmailP . " ', ' ". $oAcontent . " ') "; 这个肯定是正确的,我用他得到的数据,在 myadmin 里执行,没有问题 内容上下分页 php sqlite 请教php socket的问题 问一个关于GD库安装的问题 div的问题 急:PHP读取excel时遇到问题 寻兼职PHP开发人员,开发一套共享软件在线注册系统 请求:在winXP下安装apache下为什么安装不了! 在lycos.co.uk装紫桐的vbb229为什么总会出现问题? discuz伪静态问题 一台机器可以装两个PHP么,版本不同 请问用PHP怎么实现请求转发啊?
插入的时候是 'ba','ca'。类型不匹配
报这个错误,我疯了,好多年了,第一次
ddupaoon后面不要有空格还可以直接在mysql中执行这条语句验证一下
insert into ddupaoon set Apname='1',Asex='2' ....
{
die('Could not connect: ' . mysql_error());
}mysql_select_db("localhost ", $con);$sql = "insert into ddupaoon (Apname,Asex,Aage,Aschool,AmailP,Acontent) values ('". $oApname ."','".$oAsex."','".$oAage."','".$oAschool."','".$oAmailP."','".$oAcontent."')";echo $sql;
if(!mysql_query($sql)){
echo "<script> alert('成功');</script>";
}
mysql_close($con);
我不执行 mysql_query ?????
mysql语句语法错误,每个字段名应加上"Tab"键上面的单引号,试一试!
$Apname = addslashes(trim($_POST[ "aname "]));
$Asex = addslashes(trim($_POST[ "asex "]));
$Aage = addslashes(trim($_POST[ "aage "])); $Aschool = addslashes(trim($_POST[ "ashool "])); $AmailP = addslashes(trim($_POST[ "amail "])); $Acontent = addslashes(trim($_POST[ "acontent "]));
$Apname = iconv("gb2312","utf-8",$Apname);
//$Apname = iconv("gb2312","utf-8",$Apname);
$Asex = iconv("gb2312","utf-8",$Asex);
$Aage = iconv("gb2312","utf-8",$Aage);
$Aschool = iconv("gb2312","utf-8",$Aschool);
$AmailP = iconv("gb2312","utf-8",$AmailP);
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" //原来的
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" //我做过的修改不行2:
sql 语句打印正确,我在 myadmin 里做过测试3:
字符编码,我用的是 utf8 的编码,在得到数据的时候,正确但是就是 mysql_query 不执行
$con = mysql_connect("localhost","root","123456");
//Aid Apname Asex Aage Aschool AmailP Acontent$oApname = addslashes(trim($_POST["aname"]));
$oAsex = addslashes(trim($_POST["asex"]));
$oAage = addslashes(trim($_POST["aage"]));$oAschool = addslashes(trim($_POST["ashool"]));$oAmailP = addslashes(trim($_POST["amail"]));$oAcontent = addslashes(trim($_POST["acontent"]));if (!$con)
{
die('Could not connect: ' . mysql_error());
}mysql_select_db("localhost ", $con);$sql = "insert into ddupaoon (Apname,Asex,Aage,Aschool,AmailP,Acontent) values ('". $oApname ."','". $oAsex ."','". $oAage ."','". $oAschool ."','". $oAmailP ."','". $oAcontent ."')";echo $sql;
if(!mysql_query($sql)){
echo "<script> alert('成功');</script>";
}
mysql_close($con);
?>
这是代码
这个肯定是正确的,我用他得到的数据,在 myadmin 里执行,没有问题