For循环只循环一次 - For loop only loop one time

For loop only loop one time

本文关键字：循环一次 For | 更新日期: 2023-09-27

我有这个代码，假设循环5次，但它只循环一次。如何确保循环5次?

for ($i = 0; $i < 5;)
    {
      $sql6 = "SELECT * FROM at_agent_management WHERE piam_reg = '$checkedValuesarr[$i]'";
        $result6 = mysql_query($sql6); 
        while($row6 = mysql_fetch_array($result6)){
            $reg = $row6['piam_reg'];
            $date =  $row6['piam_date'];
            $agency =  $row6['agency_name'];
            $branch =  $row6['branch'];
            $category =  $row6['agent_category'];
            //$template_id =  $reg_count;
            $sql7 = "INSERT INTO at_agent_view_receipant(piam_reg, piam_date, agency_name, branch, agent_category, template_id) VALUES ('$reg', '$date', '$agency', '$branch', '$category', '$reg_count')";
            $result7 = mysql_query($sql7); 
        }

         $i++;
    }

从你写的逻辑来看，有一个复选框值数组，您希望在Query中使用该值。您可以尝试使用Foreach循环，如下所示

<?
$checkedValuesarr=array("1","2","3","4","5");
foreach ($checkedValuesarr as $checkValue)
{
    $sql6 = "SELECT * FROM at_agent_management WHERE piam_reg = '".$checkValue."'";
        $result6 = mysql_query($sql6); 
        while($row6 = mysql_fetch_array($result6)){
            $reg = $row6['piam_reg'];
            $date =  $row6['piam_date'];
            $agency =  $row6['agency_name'];
            $branch =  $row6['branch'];
            $category =  $row6['agent_category'];
            //$template_id =  $reg_count;
            $sql7 = "INSERT INTO at_agent_view_receipant(piam_reg, piam_date, agency_name, branch, agent_category, template_id) VALUES ('$reg', '$date', '$agency', '$branch', '$category', '$reg_count')";
            $result7 = mysql_query($sql7); 
        }
}?>