update_simultan.php

<?php
error_reporting(E_ALL ^ (E_NOTICE | E_WARNING)); //hilangkan eror
ini_set('max_execution_time', 0); // max execution
$conn = new mysqli("localhost", "root", "", "kristiandes"); //sesuaikan database

$n = $_POST['n'];
for ($i=1; $i<=$n; $i++)
{
   
   $id_sim = $_POST['id_sim'.$i];
   $nilai_ujian_sim  = $_POST['nilai_ujian_sim'.$i];

   $query = "UPDATE simultan_data SET nilai_ujian_sim = '$nilai_ujian_sim' WHERE id_sim = '$id_sim'";
   mysqli_query($conn,$query);

}

?>
<form name="form1" method="post" action="">
	<!-- HEADER LAYOUT -->

<h1>kristiandes.com</h1>

	<!-- END HEADER LAYOUT -->
	<!-- HEADER TABLE -->
	<input type="submit" value="Simpan" name="submit"/>
	<hr>
			<table border=1 width="30%">
				<tr>
							<th>Nama</th>
							<th>Nilai</th>
				</tr>

	<!-- END HEADER TABLE -->
	<!-- BODY TABLE -->
<?php

$i = 1;
$ssql="SELECT * FROM simultan_data";
$hasil = mysqli_query($conn,$ssql);
while($rowac = mysqli_fetch_array($hasil))

{
	if(!$rowac)
	{
echo "data kosong";
	}
	else {
		//Fetch the details
		$i++;
		$id_sim = $rowac['id_sim'];
		$nama_sim = $rowac['nama_sim'];
		$nilai_ujian_sim = $rowac['nilai_ujian_sim'];
   echo "<tr><td>$nama_sim</td>";
		?>
		<td><input name="id_sim<?php echo $i; ?>" type="hidden" id="id_sim" value="<?php echo $id_sim; ?>" size="1">
		<input name="nilai_ujian_sim<?php echo $i; ?>" type="text" id="nilai_ujian_sim" value="<?php echo $nilai_ujian_sim; ?>" size="1">
		</td>
<?php
echo "</tr>";
}
}
$jumMhs = $i;
?>
<input type="hidden" name="n" value="<?php echo $jumMhs ?>" />
<?php
mysqli_close($conn);
?>
<!-- END BODY TABLE -->
</table>
</form>