EDIT BAWAH PROSES
<?php
$id = $_GET['id'];
$qr_trans = mysqli_query($cx,"SELECT * FROM t_sewa WHERE kode_sewa='".$id."'");
while($rc_trans = mysqli_fetch_array($qr_trans)){
$kode_penyewa = $rc_trans['kode_penyewa'];
$tgl_sewa = $rc_trans['tgl_sewa'];
$kode_mobil = $rc_trans['kode_mobil'];
$kode_supir = $rc_trans['kode_supir'];
$lama_sewa = $rc_trans['lama_sewa'];
$potongan = $rc_trans['pot_sewa'];
}
?>
<h3 align="center">Input Transaksi</h3>
<form method="POST" action="proses_edit_trans.php">
<table align="center" width="35%" cellspacing="0" cellpadding="10" border="1">
<tr>
<td>
<p>Kode Sewa<br>
<input value="<?=$id;?>" type="text" name="kode_sewa"></p>
<p>Data Penyewa<br>
<select name="kode_penyewa">
<?php
$qr_penyewa = mysqli_query($cx,"SELECT * FROM m_penyewa");
while($rc_penyewa = mysqli_fetch_array($qr_penyewa)){
if($kode_penyewa == $rc_penyewa['kode_penyewa']){
$slc = 'selected';
}else{
$slc = '';
}
?>
<option <?=$slc;?> value="<?=$rc_penyewa['kode_penyewa']?>">
<?=$rc_penyewa['kode_penyewa']?> |
<?=$rc_penyewa['nama_penyewa']?>
</option>
<?php
}
?>
</select></p>
<p>Tanggal Sewa<br>
<input value="<?=$tgl_sewa;?>" type="date" name="tanggal"></p>
<p>Data Mobil<br>
<select name="kode_mobil">
<?php
$qr_mobil = mysqli_query($cx,"SELECT * FROM m_mobil");
while($rc_mobil = mysqli_fetch_array($qr_mobil)){
if($kode_mobil == $rc_mobil['kode_mobil']){
$slc_mb = 'selected';
}else{
$slc_mb = '';
}
?>
<option <?=$slc_mb;?> value="<?=$rc_mobil['kode_mobil'];?>">
<?=$rc_mobil['kode_mobil'];?> |
<?=$rc_mobil['nopol_mobil'];?> |
<?=$rc_mobil['merk_mobil'];?>
</option>
<?php
}
?>
</select></p>
<p>Kode Supir<br>
<select name="kode_supir">
<?php
$qr_supir = mysqli_query($cx,"SELECT * FROM m_supir");
while($rc_supir = mysqli_fetch_array($qr_supir)){
if($kode_supir == $rc_supir['kode_supir']){
$slc_sp = 'selected';
}else{
$slc_sp = '';
}
?>
<option <?=$slc_sp;?> value="<?=$rc_supir['kode_supir'];?>">
<?=$rc_supir['kode_supir'];?> |
<?=$rc_supir['nama_supir'];?>
</option>
<?php
}
?>
</select></p>
<p>Lama Sewa<br>
<input value="<?=$lama_sewa;?>" type="number" name="lama_sewa"> Hari</p>
<p>Potongan Harga<br>
<input value="<?=$potongan;?>" type="number" name="potongan"></p>
<center>
<input type="submit" name="submit">
</center>
</td>
</tr>
</table>
</form>
Tidak ada komentar:
Posting Komentar