php - 在 1 个 while 循环中获取两个数组(不工作)

Question

我正在尝试从两个查询中获取数组。结果只得到第一个索引。

while(($row2 = mysql_fetch_array($query1)) && ($index = mysql_fetch_array($query2)))
{
   $leaveID = $row2['leaveID'];
   $personID = $index['personID'];
   $Person_Type = $index['Person_Type'];

   if ($Person_Type == 'Regular') 
   {
      $Sick_Remaining_Days = 10 - $Sick_Total_Days;
   }else{
      $Sick_Remaining_Days = 5 - $Sick_Total_Days;
   }    

   echo "<tr>";
   echo ($leaveID == $personID) ? "<td>$Sick_Remaining_Days</td>" : "<td>--</td>";
   echo "</tr>"; 
}

Answer 1

假设两个查询都可以，我会根据您的需要提供两种循环查询的方法。希望其中之一能有所帮助。

<?php
$arrayRowA = array();
$arrayRowB = array();
while($row = mysql_fetch_array($query1)){$arrayRowA[] = $row;}
while($row = mysql_fetch_array($query2)){$arrayRowB[] = $row;}


// Loop through two arrays in a square way (every combination of both arrays)
foreach($arrayRowA as $keyA => $objectA){
    foreach($arrayRowB as $keyB => $objectB){
        $leaveID        = $objectA['leaveID'];
        $personID       = $objectB['personID'];
        $Person_Type    = $objectB['Person_Type'];

        if($Person_Type == 'Regular') 
        {
            $Sick_Remaining_Days = 10 - $Sick_Total_Days;
        }else{
            $Sick_Remaining_Days = 5 - $Sick_Total_Days;
        }    

        echo "<tr>";
        echo ($leaveID == $personID) ? "<td>$Sick_Remaining_Days</td>" : "<td>--</td>";
        echo "</tr>"; 
    }
}


// Loop through two arrays in a linear way (one to one)
foreach($arrayRowA as $keyA => $objectA){
    if(isset($arrayRowB[$keyA])){
        $objectB        = $arrayRowB[$keyA];
        $leaveID        = $objectA['leaveID'];
        $personID       = $objectB['personID'];
        $Person_Type    = $objectB['Person_Type'];

        if($Person_Type == 'Regular') 
        {
            $Sick_Remaining_Days = 10 - $Sick_Total_Days;
        }else{
            $Sick_Remaining_Days = 5 - $Sick_Total_Days;
        }    

        echo "<tr>";
        echo ($leaveID == $personID) ? "<td>$Sick_Remaining_Days</td>" : "<td>--</td>";
        echo "</tr>"; 
    }
}
?>