php - for循环在php中不能正常工作

Question

这是我的 for 循环。我想更新那些我隐藏的 designMasterId 记录，但它会自动更新所有记录..

通过这个隐藏的文本框，我尝试传递 designmasterId:

<input type="hidden" name="designMasterId[]" value="{$designArray[sec].designMasterId}">

PHP代码:

   if(isset($_POST['Submit']))
      {
        $recDate       = $_POST['rDtYear']."-".$_POST['rDtMonth']."-".$_POST['rDtDay'];
        $lastProcess   = isset($_POST['processId']) ? $_POST['processId'] : 0;
        $nextProcessId = isset($_POST['nextProcessId']) ? $_POST['nextProcessId'] : 0;

        for($i=0; $i< count($_POST['designMasterId']); $i++)
        {
          $processId       = isset($_POST['processId'][$i]) ? $_POST['processId'][$i] : 0;
          $reciveWet       = isset($_POST['reciveWet'][$i]) ? $_POST['reciveWet'][$i] : 0;
          $designMasterId  = isset($_POST['designMasterId'][$i]) ? $_POST['designMasterId'][$i] : 0;

          $updatePro = "UPDATE process 
                          SET rDate = '".$recDate."',
                              reciveWet = '".$reciveWet."',
                              nextProcessId   = ".$nextProcessId.",
                              processMasterId = ".$nextProcessId.",
                              status = 'I'
                         WHERE designMasterId = ".$designMasterId;
         $updateProRes = mysql_query($updatePro);
         if(!$updateProRes)
          {
            echo "Recive Fail";
          }
          else
          {
            header("Location:processRecive.php");
          }
        }
      }

Answer 1

我已经更新了你的代码，检查它是否适合你..

if(isset($_POST['Submit']))
    {
        $recDate       = $_POST['rDtYear']."-".$_POST['rDtMonth']."-".$_POST['rDtDay'];
        $lastProcess   = isset($_POST['processId']) ? $_POST['processId'] : 0;
        $nextProcessId = isset($_POST['nextProcessId']) ? $_POST['nextProcessId'] : 0;
    for($i=0; $i< count($_POST['designMasterId']); $i++)
    {
      $processId       = (isset($_POST['processId'][$i]) && !empty($_POST['processId'][$i])) ? $_POST['processId'][$i] : 0;
      $reciveWet       = (isset($_POST['reciveWet'][$i]) && !empty($_POST['reciveWet'][$i])) ? $_POST['reciveWet'][$i] : 0;
      $designMasterId  = (isset($_POST['designMasterId'][$i]) && !empty($_POST['designMasterId'][$i])) ? $_POST['designMasterId'][$i] : 0;

      if(isset($designMasterId) && !empty($designMasterId)){
      $updatePro = "UPDATE process 
                      SET rDate = '".$recDate."',
                          reciveWet = '".$reciveWet."',
                          nextProcessId   = ".$nextProcessId.",
                          processMasterId = ".$nextProcessId.",
                          status = 'I'
                     WHERE designMasterId = ".$designMasterId;
     $updateProRes = mysqli_query($updatePro);
     if(!$updateProRes)
      {
        echo "Recive Fail";
      }
      else
      {
        header("Location:processRecive.php");
      }
      }else{
        continue;
      }
        }
      }