尝试发送数组时仅插入最后一行

我有一个包含表单输入字段的表,其中的值来自数据库。现在我想在数据库中的一个新表中提交这些值。但当我按下提交按钮时,只插入最后一行!我犯了什么错误?请帮忙。

数据获取代码:

<?php
        if (isset($_POST['show'])) {

            $class = $_POST["Class"];
            $sql = "SELECT * FROM students WHERE Class='$class'  ORDER BY Roll ";
            $result = $conn->query($sql);

            if ($result->num_rows > 0) {
                // output data of each row
                ?>

<form action="" method="POST">
 <table class="table table-bordered table-hover" style="width: 85%;text-align: center">

         <tr >
           <th>Roll</th>
           <th>Student's Name</th>
           <th>Attendance</th>

</tr>
    <?php while ($row = $result->fetch_assoc()) { ?>
          <tr>
      <td><input value="<?php echo $row['Roll']; ?>" name="Roll[]" readonly required=""/></td>
      <td><input value="<?php echo $row['Name']; ?>" name="Name[]" readonly required=""/></td>
       <td><select name="Status[]">
              <option value="0">0</option>
              <option value="1">1</option>
              </select></td>

       </tr>

   <?php } ?>

 </table>
<input type="submit" name="save" value="Save" style="width: 50%;margin-left: 20%">

</form>

 <?php
} else {
$message = "Sorry! No result!";
 echo "<script type='text/javascript'>alert('$message');</script>";
            }
  $conn->close();
}
?>

数组插入代码:

<?PHP
if (isset($_POST["save"])) {

foreach ($_POST["Roll"] as $rec => $value) {
$Roll = $_POST["Roll"][$rec];

$Name = $_POST["Name"][$rec];
$Status = $_POST["Status"][$rec];
$Date = date('Y-m-d');
$sql = "INSERT INTO `attendance`(`id`, `Date`, `Roll`, `Name`, `Status`) VALUES ('','$Date','$Roll','$Name','$Status')";


}
if ($conn->query($sql) === TRUE) {
 $message = "Saved !";
echo "<script type='text/javascript'>alert('$message');</script>";
} else {
 echo "Error: " . $sql . "<br>" . $conn->error;
 }
}
?>