Bagaimana cara menampilan combobox pada form edit?

<pre> echo "&lt;option name='nama_kpa' value=".$data[id_merek]."&gt; ".$data[type]." - ".$data[merek]." - ". $data[pemegang]." &lt;/option&gt;"; </pre>

mash tetep engga ke select pas di form editnya

form edit nya mana?

<img src=' https://www.imageupload.co.uk/images/2018/08/28/db.png '>

ketika pas di klik update data kendaraan otomatis select data dari database berdasarkan id

ya jelas, karena ga di selected di dalam option nya coba gunain Ternary di dalam option nya

<pre> $data[id_merek] == $data_yg_dipilih ? 'selected' : '' </pre>

coba : <pre> echo "&lt;option name='nama_kpa' ". $data[id_merek] == $data_yg_dipilih ? 'selected' : '' ." value=".$data[id_merek]."&gt; ".$data[type]." - ".$data[merek]." - ". $data[pemegang]." &lt;/option&gt;"; </pre>

note : silahkan ubah di bagian ternary nya.

ini ada selectednya tapi ga ke select <pre> &lt;div class="form-group"&gt; &lt;label&gt;Pilih Merek Kendaraan&lt;/label&gt; &lt;select class="form-control input-pill" name="id_merek"&gt; &lt;option&gt;--- Pilih Kendaraan ---&lt;/option&gt; &lt;?php $result = $bbm-&gt;getKendaraan(); while($data1 = $result-&gt;fetch_assoc()){ if ($data1-&gt;id_merek==$data1[id_merek]){ echo "&lt;option value=$data1[id_merek] selected&gt; $data1[id_merek] - $data1[merek] - $data1[pemegang]&lt;/option&gt;"; }else{ echo "&lt;option value=&quot;$data1[id_merek]&quot;&gt;$data1[id_merek] - $data1[merek] - $data1[pemegang]&lt;/option&gt;\n"; } } ?&gt; &lt;/select&gt; </pre>

coba gunain inspect element, apakah di bagian option nya ada selected nya atau ga

btw ini apa? <pre> $data1-&gt;id_merek==$data1[id_merek] </pre> kok sama-sama dari data1 ?? harusnya id_merek yg pas di klik sebelum form edit == id_merek dari query

<pre> nyimak </pre>

liat full controller nya sama viewnya

masih bingung bang @Nandar

Buat memanggil data kendaraannya dari database

<pre> public function getKendaraan() { $db = new Database(); $dbConnect = $db-&gt;connect(); $sql = "SELECT * FROM tbl_kendaraan"; $data = $dbConnect-&gt;query($sql); $dbConnect = $db-&gt;close(); return $data; } </pre>

fungsi menampilkan data kendaraan di selected option <pre> &lt;div class="form-group"&gt; &lt;label&gt;Pilih Merek Kendaraan&lt;/label&gt; &lt;select class="form-control input-pill" name="id_merek"&gt; &lt;option&gt;--- Pilih Kendaraan ---&lt;/option&gt; &lt;?php $result = $bbm-&gt;getKendaraan(); while($data1 = $result-&gt;fetch_assoc()){ if ($data-&gt;id_merek == $data1[id_merek]){ echo "&lt;option value=$data1[id_merek] selected&gt; $data1[id_merek] - $data1[merek] - $data1[pemegang]&lt;/option&gt;"; }else{ echo "&lt;option value=&quot;$data1[id_merek]&quot;&gt;$data1[id_merek] - $data1[merek] - $data1[pemegang]&lt;/option&gt;\n"; } } ?&gt; &lt;/select&gt; </pre>

koding full form update nya aja copas sini gan, biar saya cek. biar saya tau, data yg mau diupdate

<pre> &lt;?php include '/../../class/bbm.php'; $bbm = new bbm(); $data = null; if(isset($_GET['id_bbm'])) { $data = $bbm-&gt;getDetail($_GET['id_bbm']); } ?&gt; &lt;?php if($data) : ?&gt; &lt;section class="content"&gt; &lt;div class="row"&gt; &lt;div class="col-md-12"&gt; &lt;div class="box box-info"&gt; &lt;div class="box-header"&gt; &lt;h3 class="box-title"&gt;Update Data BBM &lt;small&gt;&lt;/small&gt; &lt;/h3&gt; &lt;!-- tools box --&gt; &lt;div class="pull-right box-tools"&gt; &lt;button type="button" class="btn btn-info btn-sm" data-widget="collapse" data-toggle="tooltip" title="Collapse"&gt; &lt;i class="fa fa-minus"&gt;&lt;/i&gt;&lt;/button&gt; &lt;button type="button" class="btn btn-info btn-sm" data-widget="remove" data-toggle="tooltip" title="Remove"&gt; &lt;i class="fa fa-times"&gt;&lt;/i&gt;&lt;/button&gt; &lt;/div&gt; &lt;!-- /. tools --&gt; &lt;/div&gt; &lt;!-- /.box-header --&gt; &lt;div class="box-body pad"&gt; &lt;form action="index.php?page=proses-edit" method="POST"&gt; &lt;input type="hidden" class="form-control" value="&lt;?= $data["id_bbm"] ?&gt;" name="id_bbm" &gt; &lt;div class="form-group"&gt; &lt;label&gt;Input Nama Peminjam&lt;/label&gt; &lt;input type="text" class="form-control" value="&lt;?= $data["Nama_Peminjam"] ?&gt;" name="Nama_Peminjam" placeholder="Input Nama Peminjam" required="Data"&gt; &lt;/div&gt; &lt;div class="form-group"&gt; &lt;label&gt;Pilih Merek Kendaraan&lt;/label&gt; &lt;select class="form-control input-pill" name="id_merek"&gt; &lt;option&gt;--- Pilih Kendaraan ---&lt;/option&gt; &lt;?php $result = $bbm-&gt;getKendaraan(); while($data1 = $result-&gt;fetch_assoc()){ if ($data-&gt;id_merek == $data1[id_merek]){ echo "&lt;option value=$data1[id_merek] selected&gt; $data1[id_merek] - $data1[merek] - $data1[pemegang]&lt;/option&gt;"; }else{ echo "&lt;option value=&quot;$data1[id_merek]&quot;&gt;$data1[id_merek] - $data1[merek] - $data1[pemegang]&lt;/option&gt;\n"; } } ?&gt; &lt;/select&gt;

    </div>
    <div class="form-group">
      <label>Tanggal Peminjaman</label>
      <input type="text" class="form-control tanggal" value="<?= $data["Tanggal_Pinjam"] ?>" placeholder="Input Nama Peminjam" name="Tanggal_Pinjam" required="Tanggal Peminjaman">
    </div>
    <div class="form-group">
      <label>Jumlah BBM</label>
      <input type="text" class="form-control" name="jumlah_bbm" value="<?= $data["jumlah_bbm"] ?>" placeholder="Input Nama Peminjam" required="Tanggal Peminjaman">
    </div>
    <div class="form-group">
      <label>Harga</label>
      <input type="text" class="form-control" name="harga" value="<?= $data["harga"] ?>"placeholder="Input Nama Peminjam" required="Tanggal Peminjaman">
    </div>
    <label>Ketrangan</label>
    <textarea id="editor1" name="Keterangan" rows="10" cols="80">  
      <?= $data["Keterangan"] ?>        
    </textarea>
    <div class="modal-footer">
      <button type="Reset" class="btn btn-secondary" data-dismiss="modal">Reset</button>
      <input type="submit" class="btn btn-primary"  value="Simpan" name="Simpan">
    </div>
  </form>
</div>

&lt;/div&gt; &lt;!-- /.box --&gt;

&lt;/div&gt; &lt;!-- /.col--&gt; &lt;/div&gt;

&lt;/section&gt; &lt;?php endif; ?&gt;

&lt;script&gt; $(function () { // Replace the &lt;textarea id="editor1"&gt; with a CKEditor // instance, using default configuration. CKEDITOR.replace('editor1') //bootstrap WYSIHTML5 - text editor $('.textarea').wysihtml5() }) &lt;/script&gt;

</pre>

native ya ?

coba <pre> echo "&lt;option name='nama_kpa' ". $data[id_merek] == $data1[id_merek] ? 'selected' : '' ." value=".$data1[id_merek]."&gt; ".$data1[type]." - ".$data1[merek]." - ". $data1[pemegang]." &lt;/option&gt;"; </pre> atau

<pre> if ($data[id_merek] == $data1[id_merek]){ echo "&lt;option value=".$data1[id_merek]." selected&gt;".$data1[id_merek]." - ".$data1[merek]." - ".$data1[pemegang]."&lt;/option&gt;"; }else{ echo "&lt;option value=".$data1[id_merek]."&gt;".$data1[id_merek]." - ".$data1[merek]." - ".$data1[pemegang]."&lt;/option&gt;"; } </pre>

coba dan cek pake inspect element di bagian option nya gan

Masih ga muncul gan

ini sudah di inspect element <img src=' https://www.imageupload.co.uk/images/2018/08/28/Sel.png '>

iya saya pake natif :D mash belajar ini juga

njir.. coba codenya taruh di luar select option <pre> $result = $bbm-&gt;getKendaraan(); while($data1 = $result-&gt;fetch_assoc()){ if ($data[id_merek] == $data1[id_merek]){ echo "selected".$data1[id_merek]; }else{ echo "non selected".$data1[id_merek]; } } ?&gt; </pre>

Framework aja gan biar lebih mudah :D

coba ane liat dibagian fungsi insertnya gan controller beserta viewnya

coba ini <pre> &lt;select class="form-control input-pill" name="id_merek"&gt; &lt;option&gt;--- Pilih Kendaraan ---&lt;/option&gt; &lt;?php $result = $bbm-&gt;getKendaraan(); while($data1 = $result-&gt;fetch_assoc()){ if ($data1-&gt;id_merek==$data['id_merek']){ echo "&lt;option value='".$data1['id_merek']."' selected&gt;".$data1['id_merek'] ."-". $data1['merek'] ."-". $data1['pemegang'] ."&lt;/option&gt;"; }else{ echo "&lt;option value='".$data1['id_merek']."'&gt;".$data1['id_merek'] ."-". $data1['merek'] ."-". $data1['pemegang'] ."&lt;/option&gt;\n"; } } ?&gt; &lt;/select&gt; </pre>

masih saja ga bisa bang dian

coba echo aja $data1['id_merek'] sama $data['id_merek']

hasilnya sama ga

masalah ifnya ini

yang ini tampil hasilnya sesuai tapi kendaraan yang lainnya ga tampil

<pre> &lt;select name="propinsi" id="propinsi" class="form-control"&gt; &lt;option&gt;-- Pilih Kendaraan --&lt;/option&gt; &lt;?php $result = $bbm-&gt;getKendaraan(); while($p = $result-&gt;fetch_assoc()){ if ($p["id_merek"]==$data[id_merek]){ echo "&lt;option value=$p[id_merek] selected&gt;$p[merek]&lt;/option&gt;"; }else{ echo "Eror"; } } ?&gt; &lt;/select&gt; &lt;/div&gt; </pre>

coba ini <pre> &lt;select name="propinsi" id="propinsi" class="form-control"&gt; &lt;option&gt;-- Pilih Kendaraan --&lt;/option&gt; &lt;?php $result = $bbm-&gt;getKendaraan(); while($p = $result-&gt;fetch_assoc()){ if ($p["id_merek"]==$data["id_merek"]){ echo "&lt;option value='".$p["id_merek"]."' selected&gt;".$p["merek"]."&lt;/option&gt;"; }else{ echo "&lt;option value='".$p["id_merek"]."'&gt;".$p["merek"]."&lt;/option&gt;"; } } ?&gt; &lt;/select&gt; </pre>

si agan kayanya masih belum paham betul php terutama if else

udah gan udah bisa heheh makash semuanya :D

Terbaik :D