Postingan lainnya
Edit Form yang ada Select nya
gan tau cara edit form yang ada select nya agar bisar nampilin value yang diinput nya
<div class="form-group">
<label for="title">Kelompok</label><br>
<?php
include "config/config.php";
$sqlkategori="SELECT * FROM tbl_kelompok_vehicle";
$kategoris=$koneksi->query($sqlkategori);
?>
<select class="form-control" name="id_kelompok_vehicle" style="width:100%;">
<?php foreach ($kategoris as $key => $kategori): ?>
<option value="<?php echo $kategori["id_kelompok_vehicle"]?>"><?php echo $kategori["nama_kelompok_vehicle"]?></option>
<?php endforeach; ?>
</select>
</div>
6 Jawaban:
Select namenya dibuat array gan <pre> <select class="form-control" name="id_kelompok_vehicle[]" style="width:100%;"> </pre> trus dibagian valuenya
<pre> <option value="<?= isset($kategori["id_kelompok_vehicle"])? ':selected' : '' ?>"> </pre> Good luck!
<pre> <div class="content mt-3"> <div class="animated fadeIn"> <div class="row"> <div class="col-lg-12"> <div class="card"> <div class="card-header">Edit Vehicle</div> <div class="card-body card-block"> <!--form-start--> <?php $id_vehicle_asset=$_GET['id_vehicle_asset']; include "config/config.php"; $sql = "SELECT * FROM tbl_vehicle_asset AS A JOIN tbl_brand_vehicle AS B ON B.id_brand_vehicle = A.id_brand_vehicle JOIN tbl_jenis_vehicle AS C ON C.id_jenis_vehicle = A.id_jenis_vehicle JOIN tbl_kelompok_vehicle AS D ON D.id_kelompok_vehicle = A.id_kelompok_vehicle WHERE id_vehicle_asset=$id_vehicle_asset "; $qnews=$koneksi->query($sql); $rownews=$qnews->fetch_assoc(); ?> <form action="include/update/update-vehicle-asset.php" name="forminputtanggal" method="POST" enctype="multipart/form-data"> <input type="hidden" name="id_vehicle_asset" value="<?php echo $rownews['id_vehicle_asset']; ?>"/> <div class="col-lg-6"> <div class="form-group"> <label>Nomor Lambung</label> <input class="form-control" name="nomor_badan_vehicle" value="<?php echo $rownews['nomor_badan_vehicle']; ?>"> </div> <div class="form-group"> <label>Nomor Polisi</label> <input class="form-control" name="nomor_polisi_vehicle" value="<?php echo $rownews['nomor_polisi_vehicle']; ?>"> </div> <div class="form-group"> <label for="title">Merk</label><a href="add-brand-vehicle.php"><i class="menu-icon fa fa-plus-square" style="margin-left:10px;"></i></a><br> <?php include "config/config.php"; $sqlkategori="SELECT * FROM tbl_brand_vehicle"; $kategoris=$koneksi->query($sqlkategori); ?> <select class="form-control" name="id_brand_vehicle" style="width:100%;"> <?php foreach ($kategoris as $key => $kategori): ?> <option value="<?php echo $kategori["id_brand_vehicle"]?>"> <?php echo $kategori["nama_brand_vehicle"]?> </option> <?php endforeach; ?> </select> </div> <div class="form-group"> <label for="title">Jenis</label><a href="add-jenis-vehicle.php"><i class="menu-icon fa fa-plus-square" style="margin-left:10px;"></i></a><br> <?php include "config/config.php"; $sqlkategori="SELECT * FROM tbl_jenis_vehicle"; $kategoris=$koneksi->query($sqlkategori); ?> <select class="form-control" name="id_jenis_vehicle" style="width:100%;"> <?php foreach ($kategoris as $key => $kategori): ?> <option value="<?php echo $kategori["id_jenis_vehicle"]?>" ><?php echo $kategori["nama_jenis_vehicle"]?></option> <?php endforeach; ?> </select> </div> <div class="form-group"> <label>Tipe</label> <input class="form-control" name="tipe_vehicle" value="<?php echo $rownews['tipe_vehicle']; ?>"> </div> <div class="form-group"> <label for="title">Kelompok</label><br> <?php include "config/config.php"; $sqlkategori="SELECT * FROM tbl_kelompok_vehicle"; $kategoris=$koneksi->query($sqlkategori); ?> <select class="form-control" name="id_kelompok_vehicle" style="width:100%;"> <?php foreach ($kategoris as $key => $kategori): ?> <option value="<?php echo $kategori["id_kelompok_vehicle"]?>"><?php echo $kategori["nama_kelompok_vehicle"]?></option> <?php endforeach; ?> </select> </div>
&lt;/div&gt;
&lt;div class="col-lg-6"&gt;
&lt;div class="form-group"&gt;
&lt;label&gt;Tahun&lt;/label&gt;
&lt;input class="form-control" name="tahun_vehicle" value="&lt;?php echo $rownews['tahun_vehicle']; ?&gt;"&gt;
&lt;/div&gt;
&lt;div class="form-group"&gt;
&lt;label&gt;STNK&lt;/label&gt;
&lt;input class="form-control" name="stnk_vehicle" value="&lt;?php echo $rownews['stnk_vehicle']; ?&gt;"&gt;
&lt;/div&gt;
&lt;div class="form-group"&gt;
&lt;label&gt;Nomor Mesin&lt;/label&gt;
&lt;input class="form-control" name="nomor_mesin_vehicle" value="&lt;?php echo $rownews['nomor_mesin_vehicle']; ?&gt;"&gt;
&lt;/div&gt;
&lt;div class="form-group"&gt;
&lt;label&gt;Nomor Rangka&lt;/label&gt;
&lt;input class="form-control" name="nomor_rangka_vehicle" value="&lt;?php echo $rownews['nomor_rangka_vehicle']; ?&gt;"&gt;
&lt;/div&gt;
&lt;div class="form-group"&gt;
&lt;label&gt;Keterangan&lt;/label&gt;
&lt;textarea class="form-control" name="keterangan_vehicle" rows="5" value="&lt;?php echo $rownews['keterangan_vehicle']; ?&gt;"&gt;&lt;/textarea&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;div class="form-actions form-group" style="margin-left:15px;"&gt;
&lt;button type="submit" name="submit" value="submit" class="btn btn-primary btn-sm" onclick="return confirm('Anda Yakin Akan Menyimpan')"&gt;
&lt;i class="fa fa-dot-circle-o"&gt;&lt;/i&gt; SAVE
&lt;/button&gt;
&lt;button type="reset" class="btn btn-danger btn-sm"&gt;
&lt;i class="fa fa-ban"&gt;&lt;/i&gt; Reset
&lt;/button&gt;
&lt;a href="detail-vehicle-asset.php?id_vehicle_asset=&lt;?php echo $rownews['id_vehicle_asset']; ?&gt;"&gt;
&lt;button type="button" class="btn btn-warning btn-sm"&gt;BACK&lt;/button&gt;
&lt;/a&gt;
&lt;/div&gt;
&lt;/form&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;&lt;!-- .animated --&gt;
&lt;/div&gt;&lt;!-- .content --&gt;
&lt;/div&gt;&lt;!-- /#right-panel --&gt; </pre>