Multifield update

form.html

<pre>

<form action="post.php" method="POST">

Kode <input type="text" name="_id[]">

Nama <input type="text" name="_nama[]">

Kode <input type="text" name="_id[]">

Nama <input type="text" name="_nama[]">

Kode <input type="text" name="_id[]">

Nama <input type="text" name="_nama[]">


<input type="submit" value="simpan">

</form>
</pre>

post.php

<?php 

$id		= $_POST['_id'];

$nama	= $_POST['_nama'];

$data = array_combine($id, $nama);

$sql = null;

foreach ($data as $key => $value) {
	
	$sql .="UPDATE table SET nama = ".$value." WHERE id = ".$key;

}

echo $sql;