Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
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>