contoh program

<?php
include "koneksi.php";

$id=isset($_GET['id'])?$_GET['id']:0;
//===========
$sql="select * from loket where id='$id'";
    $loket=queryData($sql);
/*
     Hasil proses dari
     mysql_query dan mysql_fetch_array
     namun gunakan mysqli jangan mysql lagi
*/
?>
<form>
    <input type='hidden' name='id' value='<?=$loket['id'];?>' />
    <h3><?=$loket['name'];?></h3>
    <select name='status'>
<?php
//================
$selected = $loket['status'];
$sql="select id, nama from loket_status";
$q=query($sql);
/*
    hasil dari mysql_query. Tapi gunakan mysqli
*/
    $select='';
    while($row=fetch($q))
    {
        $select.="<option value='{$row['id']}' ";
        if($selected == $row['id'])
          $select.="selected";

        $select.="/>".$row['name']."</option>\n";

    }
    echo $select;$select='';
?>
    </select>
    <button value='update' />
</form>