我有一个循环,我需要在其中获取元素,然后我需要在mysql表中插入每个元素,但这段代码只能插入1个元素。(p.s.变量加载了min4元素)。
为什么我不能用这个循环插入多个元素?
我急需知道。感谢
function addmijloc(){
foreach ($_SESSION["mijloc"] as $check)
{
$sql="INSERT INTO isu_mijloace (`nr_rap_ext_mijl`, `mijloc`) VALUES ('".$_SESSION['nrraport']."', '".$check."')";
if(mysql_query($sql))
{
$mijloace="ok";
}
else
{
echo '<script>alert("Tabela mijloace eronata");</script>';
}
}
}
当您在循环中打印_r($check)时,您是否尝试得到什么结果?
foreach ($_SESSION["mijloc"] as $check=>$value)
{
$sql="INSERT INTO isu_mijloace (`nr_rap_ext_mijl`, `mijloc`) VALUES ('".$_SESSION['nrraport']."', '".$value."')";
mysql_query($sql);
if(mysql_query($sql))
{
$mijloace="ok";
}
else
{
echo '<script>alert("Tabela mijloace eronata");</script>';
}
}