这个代码要怎样改? 本帖最后由 suogayz 于 2013-01-19 13:49:03 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 刚才写错了,17行处的内容是$sql="SELECT name FROM table2006 WHERE name='$name'"; <?php$time1=time();mysql_select_db("table", $con);$file="addtest.txt";$txt=file($file);$lineArr = explode("\n",$txt);$length = count($lineArr);echo "文件 <b>$file</b> 一共有 <b>$length</b> 个数据 </br>正在完成数据 <b>添加/修改</b> 操作";for($i=0;$i < $length;$i++){ list($number,$name,$gender,$regdate,$January) = explode("|",$lineArr[$i]); if(empty($name)) continue; $sql="SELECT name FROM table2006 WHERE name='$name' "; $query = @mysql_query($sql); $row=mysql_fetch_row($query); if(empty($row)){ $sql1= "INSERT INTO table2006 (number,name,gender,regdate,January) VALUES ('$number','$name','$gender','$regdate''$January') ; "; $query1 = @mysql_query($sql1); } else { $sq2="UPDATE table2006 SET January = '$January' WHERE name = '$name' "; $query2 = @mysql_query($sql2); } if($error=mysql_error()){ echo "<p> $error </p>"; }}$time2=time();$usedtime=$time2-$time1;echo "添加/修改 数据共使用时间 <b>$usedtime</b> 秒。";?> Column count doesn't match value count at row 1是说:字段列表数与数据列表数不一致你两次贴出的代码都是$sql1= "INSERT INTO table2006 (number,name,gender,regdate,January) VALUES ('$number','$name','$gender','$regdate''$January') ; ";显然不是贴出时贴漏了$sql1= "INSERT INTO table2006 (number,name,gender,regdate,January) VALUES ('$number','$name','$gender','$regdate','$January') ; ";少了一个逗号 下面这个代码作用是什么? php只能做中小型的规模? 下面的图片路径正确,用绝对地址为什么不能显示啊? session过期重定向问题! 隐藏数组对象的方法? ajaxFileUpload 上传不了文件 apache 支持 php kingerq(多菜鸟) 来看你教我的程序. 为什么我的MYSQL安装好后在win98下无法使用 PHP无法保存数据到本地 url参数穷举测试怎么写 $_SERVER['REMOTE_HOST']问题!求大牛指导一二
$time1=time();
mysql_select_db("table", $con);
$file="addtest.txt";
$txt=file($file);
$lineArr = explode("\n",$txt);
$length = count($lineArr);echo "文件 <b>$file</b> 一共有 <b>$length</b> 个数据 </br>正在完成数据 <b>添加/修改</b> 操作";
for($i=0;$i < $length;$i++)
{
list($number,$name,$gender,$regdate,$January) = explode("|",$lineArr[$i]);
if(empty($name)) continue;
$sql="SELECT name FROM table2006 WHERE name='$name' ";
$query = @mysql_query($sql);
$row=mysql_fetch_row($query);
if(empty($row)){
$sql1= "INSERT INTO table2006 (number,name,gender,regdate,January) VALUES ('$number','$name','$gender','$regdate''$January') ; ";
$query1 = @mysql_query($sql1);
} else {
$sq2="UPDATE table2006 SET January = '$January' WHERE name = '$name' ";
$query2 = @mysql_query($sql2);
} if($error=mysql_error()){
echo "<p> $error </p>";
}
}
$time2=time();
$usedtime=$time2-$time1;
echo "添加/修改 数据共使用时间 <b>$usedtime</b> 秒。";
?>
$sql1= "INSERT INTO table2006 (number,name,gender,regdate,January) VALUES ('$number','$name','$gender','$regdate''$January') ; ";
显然不是贴出时贴漏了
$sql1= "INSERT INTO table2006 (number,name,gender,regdate,January) VALUES ('$number','$name','$gender','$regdate','$January') ; ";
少了一个逗号