插入多条记录

[dllj]

我有一数据表,有60个字段,通过表单插入记录,如果逐一写
$sql = "INSERT INTO sj (a1,...,a60) VALUES ('$_POST[a1]',...'$_POST[a60]')";
实在太烦,而且容易写错,请问有什么简便的方法???

[mousecat4444]

要是各字段没有逻辑关系呢

[lantersen]

那你可以写一个数组,将它们关联起来,比方说:
$yourFields = array("forInput1"=>"dataField1","forInput2"=>"dataField2","forInput3"=>"dataField3");
foreach($_POST AS $key=>$value)
{
$fields .= "`".$yourFields[$key]."`,";//数据库字段名;
$values .= "'".$value."',";
}
$fields = "(".substr($fields, 0, -1).") ";//除去最后一个逗号
$values = "(".substr($values, 0, -1).")";//除去最后一个逗号
$sql = "INSERT INTO sj ".$fields." VALUES ".$values;

[iasky]

mysql一次不能执行多条sql

[itian]

$sql = "INSERT INTO sj (";
for($i=0;$i<61;$i++)
{
$sql .= "a".$i.",";
}
$sql .= ")";
$sql .= " values ( ";
for($i=0;$i<61;$i++)
{
$var = "a".$i;
$sql .= "'".$_POST[$var]."'";
}
$sql .= ")";

[dlrmq]

<?php
$num=60;
$sql = "INSERT INTO sj (";
for($i=1;$i<=$num;$i++)
{
$sql .= "$dat$i,";
}
$sql=substr("$sql",0,-1);
$sql .= ")";
$sql .= " values ( ";
for($i=1;$i<=$num;$i++)
{
$var ="$dat$i";
$sql .= "'".$_POST[$var]."'".",";
}
$sql=substr("$sql",0,-1);
$sql .= ")";

?>