<?php $koneksi = mysqli_connect('localhost','root','','test'); ?>
<script type="text/javascript" src="../jquery.min.js"></script>
<table border="1">
<tr>
<td>Nama</td>
<td>Pekerjaan</td>
</tr>
<?php
$q = "SELECT * FROM user";
$myq = mysqli_query($koneksi, $q);
while($r = mysqli_fetch_assoc($myq)):
?>
<tr>
<td><?php echo $r['nama']; ?></td>
<td>
<select class="status_pekerjaan" id-pegawai='<?php echo $r['id']; ?>' >
<option value=""> - Pilih -</option>
<option value="1" <?php if( $r['pekerjaan']==1) echo 'selected';?> > Admin</option>
<option value="2" <?php if( $r['pekerjaan']==2) echo 'selected';?> > Kebersihan</option>
<option value="3" <?php if( $r['pekerjaan']==3) echo 'selected';?> > Keamanan</option>
<option value="4" <?php if( $r['pekerjaan']==4) echo 'selected';?> > Guru</option>
</select>
</td>
</tr>
<?php endwhile; ?>
</table>
<!-- script update -->
<script type="text/javascript">
$(document).ready( function(){
$('.status_pekerjaan').change(function(){
var id_pegawai = $(this).attr('id-pegawai');
var pekerjaan = $(this).val();
$.ajax({
type :'POST',
url :'update_proses.php',
data :{
id_pegawai : id_pegawai,
pekerjaan : pekerjaan
},
success : function(result){
alert(result);
}
});
});
});
</script>
<!-- END script update -->