if(isset($_POST)){
$sql = 'INSERT INTO uu (uu_name,uu_phone) VALUES '
foreach($_POST['uu_name'] as $k => $v){
$sql .= "('$v','".$_POST['uu_number'][$k]."'),"
}
$sql = substr($sql,0,-1)
//执行这条sql语句就可以了
echo $sql
}
?>
在HTML里这样写:1
2
3
4
5
6
<form ........
<input type="text" name="haoma[]" />
<input type="text" name="haoma[]" />
<input type="text" name="haoma[]" />
....
第N个
foreach($_POST['haoma'] as $v){
$sql="insert into haoma values('',$v)"
.......
}
当然这样写一条一条的效率是会慢,再改一下
foreach($_POST['haoma'] as $v){
$values.="('',$v),"
}
$values=substr($values,0,strlen($values)-1)
$sql="insert into haoma values $values"
......
下面的query我就不写了
每两个值组之间要用逗号分隔VALUES
('','$type_id','$user_id','$title','$content','$imgname_a[0]','date(Y-m-d)','$clicktimes','$is_show'),
('','$type_id','$user_id','$title','$content','$imgname_a[1]','date(Y-m-d)','$clicktimes','$is_show'),
('','$type_id','$user_id','$title','$content','$imgname_a[2]','date(Y-m-d)','$clicktimes','$is_show')
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)