php - 插入有条件的多行

Question

我正在使用 foreach() 循环插入多行数据。但如果它的值为税收或折扣，我不想插入特定的行。我该怎么做。

我的代码:

<?php
if(isset($_POST['finalsave']))
{
  foreach ($_POST['descr'] as $key => $descr)
  {
    $dept = mysql_real_escape_string($_POST['category']);
    $idate = mysql_real_escape_string($_POST['idate']);
    $desc1 = mysql_real_escape_string($descr);
    $tags = mysql_real_escape_string($_POST['name'][$key]);
    $location = mysql_real_escape_string($_POST['location'][$key]);
    $war = mysql_real_escape_string($_POST['war'][$key]);
    $qty = mysql_real_escape_string($_POST['qty'][$key]);
    $rate = mysql_real_escape_string($_POST['rate'][$key]);
    $finalamt = mysql_real_escape_string($_POST['finalamt'][$key]);

    $sql2 = ("INSERT INTO `project`.`master_inventory` (`category`, `idate`, `descr`, `name`, `location`,  `war`, `qty`, `rate`, `finalamt`)
      VALUES ('".$dept."','".$idate."','".$desc1."','".$tags."','".$location."','".$war."','".$qty."','".$rate."','".$finalamt."')");
    $sqlins = mysql_query($sql2);
    //echo $sql2;
  }
}
?>

Answer 1

希望对您有所帮助。

 foreach ($_POST['descr'] as $key => $descr)
  {
    if(($descr !="tax")||($descr !="discount"))
    {
       //Write your logic here
    }
}