mysql 循环insert
我的表格有20行5列。例如 用户输入3行，我就得插入三行，输入五行就得插入五行。我用foreach嵌套了四次取道了用户输入的信息，可是要循环许多遍，原本只两条记录入库，现在要48条数据入库，可怎莫办呀？有没有更好的方法呀？
$items1 = array($name001=>$_POST['name001'],$name002=>$_POST['name002'],$name003=>$_POST['name003']);
$items2 = array($amount001=>$_POST['amount001'],$amount002=>$_POST['amount002'],$amount003=>$_POST['amount003']);
$items3 = array($unitprice001=>$_POST['unitprice001'],$unitprice002=>$_POST['unitprice002'],$unitprice003=>$_POST['unitprice003']);
$items4 = array($amountprice001=>$_POST['amountprice001'],$amountprice002=>$_POST['amountprice002'],$amountprice003=>$_POST['amountprice003']);
$items5 = array($tax1=>$_POST['tax1'],$tax2=>$_POST['tax2'],$tax3=>$_POST['tax3']);
$items = $items1+$items2+$items3+$items4+$items5;
foreach($items1 as $key1=>$value1)
{
echo $key1.":".$value1."<br />";
if($value1!=""){
foreach($items2 as $key2=>$value2)
{
echo $key2.":".$value2."<br />";
if($value2!=""){
foreach($items3 as $key3=>$value3)
{
echo $key3.":".$value3."<br />";
if($value3!=""){
foreach($items4 as $key4=>$value4)
{
echo $key4.":".$value4."<br />";
if($value4!=""){
foreach($items5 as $key5=>$value5)
{
echo $key5.":".$value5."<br />";
if($value5!=""){
$sql9="INSERT INTO MitumoriDetails(Name,Amount,UnitPrice,AmountPrice,TaxRate)values($value1,$value2,$value3,$value4,$value5)";
print $sql9;
}
}
}
}
}
}
}
}
}
} |