33 lines
1.8 KiB
PHP
33 lines
1.8 KiB
PHP
<?php
|
|
include ('../../koneksi.php');
|
|
$id=$_POST['id'];
|
|
$data=pg_query("SELECT j.id,k.nama,j.jarak,k.id FROM sp_jarak j INNER JOIN sp_kota k ON (k.id=j.sp_kota_id) WHERE j.id='$id'");
|
|
while($row=pg_fetch_array($data)) {
|
|
$jarak_id=$row[0];
|
|
$nama=$row[1];
|
|
$jarak=$row[2];
|
|
$kota_id=$row[3];
|
|
}
|
|
?>
|
|
|
|
|
|
<form role="form">
|
|
<div class="form-group">
|
|
<label for="exampleInputEmail1">Nama</label>
|
|
<input type="hidden" value="<?php echo $id; ?>" id="jarak_id">
|
|
<select class="form-control" id="sp_kota_id_jarak">
|
|
<option></option>
|
|
<?php
|
|
$d=pg_query("SELECT id,nama FROM sp_kota ORDER BY id ASC");
|
|
while($r=pg_fetch_array($d)) {
|
|
?>
|
|
<option <?php if ($kota_id==$r[0]) {echo 'selected';} ?> value="<?php echo $r[0]; ?>"><?php echo $r[1]; ?></option>
|
|
<?php } ?>
|
|
</select>
|
|
</div>
|
|
<div class="form-group">
|
|
<label for="exampleInputEmail1">Jarak (km)</label>
|
|
<input type="number" class="form-control" value="<?php echo $jarak; ?>" id="jarak_jarak">
|
|
</div>
|
|
</form>
|