จะแก้ไขข้อมูลในตารางหลายrecordพร้อมกันโดยใช้submitปุ่มเดียว แต่มันแก้ไขแค่recordสุดท้ายครับ ขอบคุณครับ มือใหม่ครับ

if (isset($_POST['update'])){
        $leavetype = $_POST['leavetype'];
        $hours = $_POST['hours'];
        $fromdate = $_POST['fromdate'];
        $todate = $_POST['todate'];
        $shift = $_POST['shift'];
        $remark = $_POST['remark'];
        $aid = $_POST['aid'];
            $sql = "update tblleaves set LeaveType=:leavetype,hours=:hours,FromDate=:fromdate,ToDate=:todate,Shift=:shift,Remark=:remark,id=:aid where id=:aid";
            foreach ($aid as $aid)
            foreach ($leavetype as $leavetype)
            foreach ($hours as $hours)
            foreach ($fromdate as $fromdate)
            foreach ($todate as $todate)
            foreach ($shift as $shift)
            foreach ($remark as $remark) {
            $query = $dbh->prepare($sql);
            $query->bindParam(':leavetype', $leavetype, PDO::PARAM_STR);
            $query->bindParam(':hours', $hours, PDO::PARAM_STR);
            $query->bindParam(':fromdate', $fromdate, PDO::PARAM_STR);
            $query->bindParam(':todate', $todate, PDO::PARAM_STR);
            $query->bindParam(':shift', $shift, PDO::PARAM_STR);
            $query->bindParam(':remark', $remark, PDO::PARAM_STR);
            $query->bindParam(':aid', $aid, PDO::PARAM_STR);
            $query->execute();
            $msg = "บันทึกสำเร็จ";
        
    }}

<tbody>
        <?php
         $eid = $_SESSION['emplogin'];
         $sql = "SELECT * from tblleaves where HLine=:eid";
         $query = $dbh->prepare($sql);
         $query->bindParam(':eid', $eid, PDO::PARAM_STR);
         $query->execute();
         $results = $query->fetchAll(PDO::FETCH_OBJ);
         $cnt = 1;
         if ($query->rowCount() > 0) {
         foreach ($results as $result) {    ?>


        <tr>
        <td> <b><?php echo htmlentities($cnt); ?></b></td>
        <td><input value="<?php echo htmlentities($result->id); ?>" id="aid" name="aid[]" class="form-control" type="text" readonly required></td>

        <td><?php echo htmlentities($result->PostingDate); ?></td>
        <td><input value="<?php echo htmlentities($result->Ename); ?>" id="emname" name="emname[]" class="form-control" type="text" readonly required></td>

        <td><select name="leavetype[]" class="form-select" aria-label="Default select example">
        <option value="<?php echo htmlentities($result->LeaveType); ?>"><?php echo htmlentities($result->LeaveType); ?></option>
        <option value="ลาป่วย">ลาป่วย</option>
        <option value="ลากิจ">ลากิจ</option>
        <option value="ลาพักร้อน">ลาพักร้อน</option>
        <option value="ลากิจพิเศษ">ลากิจพิเศษ</option>
        <option value="ลาอุปสมบท">ลาอุปสมบท</option>
        <option value="ลาคลอด">ลาคลอด</option>
         </select></td>

        <td><select name="hours[]" class="form-select" aria-label="Default select example">
                                                                    <option value="<?php echo htmlentities($result->hours); ?>"><?php echo htmlentities($result->hours); ?></option>
         <option value="3">3</option>
         <option value="4">4</option>
         <option value="5">5</option>
         <option value="6">6</option>
         <option value="7">7</option>
         <option value="8">8</option>
         </select></td>

         <td><input value="<?php echo htmlentities($result->FromDate); ?>" id="mask1" name="fromdate[]" class="form-control" type="time" required></td>

         <td><input value="<?php echo htmlentities($result->ToDate); ?>" id="mask2" name="todate[]" class="form-control" type="time" required></td>

         <td><select name="shift[]" class="form-select" aria-label="Default select example">
         <option value="<?php echo htmlentities($result->Shift); ?>"><?php echo htmlentities($result->Shift); ?></option>
         <option value="A">A</option>
         <option value="B">B</option>
         </select></td>
          <td>
         <input id="remark" name="remark[]" type="text" value="<?php echo htmlentities($result->Remark); ?>" autocomplete="off" required>
         </td>
         <td><a href="View_attendance.php?del=<?php echo htmlentities($result->id); ?>" onclick="return confirm('Do you want to Cancel');">Cancel</a>
          </td>
          </tr>
    <?php $cnt++; } } ?>

      </tbody>