只使用while循环一次遍历结果


Looping through results using while loops just once

知道为什么这只循环一次吗?我试图有嵌套面板从DB的每个结果。我知道这里可能有很多不好的做法,但我只是需要它为一门课工作。这永远不会投入生产。

while($row = mysql_fetch_array($result)) {
    echo sizeof($row);
    $resId=$row[reservationId];
    $counter++;
    try {
        $startDate = new DateTime($row[startDate]);
    } catch (Exception $e) {
        echo $e->getMessage();
        exit(1);
    }
    try {
        $endDate = new DateTime($row[endDate]);
    } catch (Exception $e) {
        echo $e->getMessage();
        exit(1);
    }
    echo "
    <div class='"panel-group'" id='"accordion".$counter."'">
    <div class='"panel panel-default'">
    <div class='"panel-heading'">
    <h4 class='"panel-title'"><a class='"panel-toggle'" data-toggle='"collapse'" data-parent='"#accordion".$counter."'" href='"#collapseInner".$counter."'"><label> ".$row[title]." </label> <label class='"pull-right'">".$startDate->format('m-d-Y')."</label></a></h4>
    </div>
    <div id='"collapseInner".$counter."'" class='"panel-body collapse'">
        <div class='"panel-inner'">
    <div class='"col-lg-8'">
    <p><label>Lodging Reservation #:01-".$row[reservationId]."</label></p>
    <p><label>Check In: ".$startDate->format('m-d-Y')."</label></p>
    <p><label>Check Out: ".$endDate->format('m-d-Y')."</label></p>
    </div>
    <div class='"col-lg-4'">
    <button type='"submit'" class='"btn btn-primary btn-lg'" data-toggle='"modal'"
        data-target='"#myModal".$counter."'">
    Edit Reservation</button>
     <!-- Modal -->
        <div class='"modal fade'" id='"myModal".$counter."'" tabindex='"-1'"
        role='"dialog'" aria-labelledby='"myModalLabel'" aria-hidden='"true'">
    <div class='"modal-dialog'">
        <div class='"modal-content'">
    <div class='"modal-header'">
        <button type='"button'" class='"close'" data-dismiss='"modal'" aria
        hidden='"true'">&times; </button>
        <h4 class='"modal-title'" id='"myModalLabel'">Edit Reservation</h4>
        </div>
    <div class='"modal-body'">
    <form method='"post'" action='"../controller/EditLodgingReservation.php?
        rId=".$resId."&counter=".$counter."'">
    <label>Select Dates:</label>
    <div class='"input-group'">
    <div class='"input-group-addon'">
    <i class='"fa fa-calendar'"></i>
    </div>
    <input type='"text'" class='"form-control pull-right'" 
        id='"reservation".$counter."'" name='"reservation".$counter."'">
    </div><!-- /.input group -->
    <label>Select Lodging</label>
    <select multiple='"'" class='"form-control'" id='"lodgingList".$counter."'" 
        name='"lodgingList".$counter."'">
    ";
    $result = getlodging();
    while($row = mysql_fetch_array($result)) {
        echo "<option value=".$row[lodgingId].">".$row[title]." -- $".$row[ratePerDay]." 
          /night</option>";
    }
    echo"
    </select>
    </div>
    <div class='"modal-footer'">
    <button type='"button'" class='"btn btn-default'" data-
        dismiss='"modal'">Close</button>
    <button type='"submit'" class='"btn btn-primary'">Save changes</button></a>
    </div>
     </form>
    </div>
    </div>
    </div>
     <p></p>
     <form method='"post'" action='"../controller/DeleteLodgingReservation.php?
     rId=".$resId."&pId=".$personId."'">
     <button type='"submit'" class='"btn btn-danger btn-lg'">Delete Reservation</button>
     </form>
    </div>
    </div>
    </div>
    </div>
    </div>";    
}
?>

您正在用第二个while循环覆盖第一个$row变量