Menampilkan data php oop error

Guys mohon maaf yak, ini saya nampilin data dengan php oop saya lampirkan full script disini karena anehnya, ketika saya taruh looping di table, trus dri table kebawah itu scriptnya gak muncul sampai footer yang ke include aja ngilang jadi mohon saran y

<?php include 'template_part/header/header-tab.php';?>
<?php include 'db.data.php';?>
<?php include 'inc/functions.php';?>

<div class="col-md-12 col-xs-12" style="margin-top:10px">
  <div class="row" style="margin-left:10px;margin-bottom:10px">
    <div class="col-md-4">
      <h5 style="border-bottom:1px solid grey;">Input Barang :</h5>
      <form action="inptbarang.php" method="post">
        <div class="form-group">
          <label>Nama barang</label>
          <input type="text" name="nm" class="form-control form-control-sm" placeholder="Example input">
        </div>
        <div class="form-group">
          <label>Keterangan</label>
          <input type="text" name="kt" class="form-control form-control-sm" placeholder="Another input">
        </div>
        <div class="form-group">
          <label>Harga Barang</label>
          <input type="text" name="hrg" class="form-control form-control-sm" placeholder="Format : 1000000 / 1500000">
        </div>
        <div class="form-group">
          <label>Jumlah barang</label>
          <input type="number" name="jml" class="form-control form-control-sm" placeholder="Example input">
        </div>	public function fetch_multiple($sql){
		$data="";
		$result = mysqli_query($this->mysqli,$sql);
		while($row = mysqli_fetch_array($result)){
			$data[] = $row;
		}
		return $data;
	}
        <div class="form-group">
          <label>Tahun Pembuatan</label>
          <input type="text" name="thn" class="form-control form-control-sm" placeholder="Another input">
        </div>
        <div class="form-group">
          <label>Kondisi Barang</label>
          <select class="custom-select" name="knds">
            <option selected>Plih Kondisi barang</option>
            <option value="B">Baik</option>
            <option value="TB">Tidak Baik</option>
          </select>
        </div>
        <input type="hidden" name="act" value="add-data">
        <button type="submit" class="btn btn-primary" id="tombol-simpan" style="margin-top:10px;float:right">Input Data barang</button>
      </form>
    </div>
    <div class="col-md-8">
      </form>
      <h5 style="border-bottom:1px solid grey;">Data Barang:</h5>
      <div class="rightss">
        <form class="form-inline my-2 my-lg-0" action="cari.php" method="post">
          <input class="form-control mr-sm-2" type="search" placeholder="Search" aria-label="Search">
          <button class="btn btn-outline-success my-2 my-sm-0" type="submit">Search</button>
      </div>
      <div class="clearfix"></div>
      <div class="pesan" style="display:none;">
        <div class="alert alert-success alert-dismissible fade show" role="alert">
          <p id="pesan"></p>
          <button type="button" class="close" data-dismiss="alert" aria-label="Close">
            <span aria-hidden="true">×</span>
          </button>
        </div>
      </div>
      <table class="table table-bordered table-striped table-condensed datatables">
        <thead>
          <th>Kode Barang</th>
          <th>Nama Barang</th>
          <th>Jumlah</th>
          <th>Kondisi</th>
          <th>Status</th>
        </thead>
        <tbody>
          <?php
          $total = $db->num_rows("select kd_brng from brng_pbo");
          $data_ctn = $db->fetch_multiple('select kd_brng,nm_brng,qty,knds from brng_pbo');

          if(is_array($data_ctn))
          {
            foreach ($data_ctn as $ctn)
            {
              $kd = $ctn['kd_brng'];
              $nm = $ctn['nm_brng'];
              $qty = $ctn['qty'];
              $knds = $ctn['knds'];
              $sts = $ctn['status'];
              ?>
          <tr>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
          </tr>
          	<?php
          }}
          ?>
        </tbody>
      </table>
    </div>
  </div>
</div>
<?php include'template_part/footer/footer.php';?>

ini Hasil Code diatas

ini tanpa code php

jadinya saya bingung errornya itu dmn

saya include untuk function fetch_multiplenya

	public function fetch_multiple($sql){
		$data="";
		$result = mysqli_query($this->mysqli,$sql);
		while($row = mysqli_fetch_array($result)){
			$data[] = $row;
		}
		return $data;
	}

avatar maszgalang
@maszgalang

297 Kontribusi 80 Poin

Diperbarui 4 tahun yang lalu

Tanggapan

cek buka tutup phpnya ada belum ditulis

Udh semua saya chek udh ketutup semua

coba di print_r $row,dan tampilkan erro message

2 Jawaban:

<pre> &lt;?php include 'template_part/header/header-tab.php';?&gt; &lt;?php include 'db.data.php';?&gt; &lt;?php include 'inc/functions.php';?&gt;

&lt;div class="col-md-12 col-xs-12" style="margin-top:10px"&gt; &lt;div class="row" style="margin-left:10px;margin-bottom:10px"&gt; &lt;div class="col-md-4"&gt; &lt;h5 style="border-bottom:1px solid grey;"&gt;Input Barang :&lt;/h5&gt; &lt;form action="inptbarang.php" method="post"&gt; &lt;div class="form-group"&gt; &lt;label&gt;Nama barang&lt;/label&gt; &lt;input type="text" name="nm" class="form-control form-control-sm" placeholder="Example input"&gt; &lt;/div&gt; &lt;div class="form-group"&gt; &lt;label&gt;Keterangan&lt;/label&gt; &lt;input type="text" name="kt" class="form-control form-control-sm" placeholder="Another input"&gt; &lt;/div&gt; &lt;div class="form-group"&gt; &lt;label&gt;Harga Barang&lt;/label&gt; &lt;input type="text" name="hrg" class="form-control form-control-sm" placeholder="Format : 1000000 / 1500000"&gt; &lt;/div&gt; &lt;div class="form-group"&gt; &lt;label&gt;Jumlah barang&lt;/label&gt; &lt;input type="number" name="jml" class="form-control form-control-sm" placeholder="Example input"&gt; &lt;/div&gt; &lt;?php public function fetch_multiple($sql){ $data=""; $result = mysqli_query($this-&gt;mysqli,$sql); while($row = mysqli_fetch_array($result)){ $data[] = $row; } return $data; } ?&gt; &lt;div class="form-group"&gt; &lt;label&gt;Tahun Pembuatan&lt;/label&gt; &lt;input type="text" name="thn" class="form-control form-control-sm" placeholder="Another input"&gt; &lt;/div&gt; &lt;div class="form-group"&gt; &lt;label&gt;Kondisi Barang&lt;/label&gt; &lt;select class="custom-select" name="knds"&gt; &lt;option selected&gt;Plih Kondisi barang&lt;/option&gt; &lt;option value="B"&gt;Baik&lt;/option&gt; &lt;option value="TB"&gt;Tidak Baik&lt;/option&gt; &lt;/select&gt; &lt;/div&gt; &lt;input type="hidden" name="act" value="add-data"&gt; &lt;button type="submit" class="btn btn-primary" id="tombol-simpan" style="margin-top:10px;float:right"&gt;Input Data barang&lt;/button&gt; &lt;/form&gt; &lt;/div&gt; &lt;div class="col-md-8"&gt; &lt;/form&gt; &lt;h5 style="border-bottom:1px solid grey;"&gt;Data Barang:&lt;/h5&gt; &lt;div class="rightss"&gt; &lt;form class="form-inline my-2 my-lg-0" action="cari.php" method="post"&gt; &lt;input class="form-control mr-sm-2" type="search" placeholder="Search" aria-label="Search"&gt; &lt;button class="btn btn-outline-success my-2 my-sm-0" type="submit"&gt;Search&lt;/button&gt; &lt;/div&gt; &lt;div class="clearfix"&gt;&lt;/div&gt; &lt;div class="pesan" style="display:none;"&gt; &lt;div class="alert alert-success alert-dismissible fade show" role="alert"&gt; &lt;p id="pesan"&gt;&lt;/p&gt; &lt;button type="button" class="close" data-dismiss="alert" aria-label="Close"&gt; &lt;span aria-hidden="true"&gt;&times;&lt;/span&gt; &lt;/button&gt; &lt;/div&gt; &lt;/div&gt; &lt;table class="table table-bordered table-striped table-condensed datatables"&gt; &lt;thead&gt; &lt;th&gt;Kode Barang&lt;/th&gt; &lt;th&gt;Nama Barang&lt;/th&gt; &lt;th&gt;Jumlah&lt;/th&gt; &lt;th&gt;Kondisi&lt;/th&gt; &lt;th&gt;Status&lt;/th&gt; &lt;/thead&gt; &lt;tbody&gt; &lt;?php $total = $db-&gt;num_rows("select kd_brng from brng_pbo"); $data_ctn = $db-&gt;fetch_multiple('select kd_brng,nm_brng,qty,knds from brng_pbo');

      if(is_array($data_ctn))
      {
        foreach ($data_ctn as $ctn)
        {
          $kd = $ctn[&#039;kd_brng&#039;];
          $nm = $ctn[&#039;nm_brng&#039;];
          $qty = $ctn[&#039;qty&#039;];
          $knds = $ctn[&#039;knds&#039;];
          $sts = $ctn[&#039;status&#039;];
          ?&amp;gt;
      &amp;lt;tr&amp;gt;
        &amp;lt;td&amp;gt;&amp;lt;/td&amp;gt;
        &amp;lt;td&amp;gt;&amp;lt;/td&amp;gt;
        &amp;lt;td&amp;gt;&amp;lt;/td&amp;gt;
        &amp;lt;td&amp;gt;&amp;lt;/td&amp;gt;
        &amp;lt;td&amp;gt;&amp;lt;/td&amp;gt;
      &amp;lt;/tr&amp;gt;
      	&amp;lt;?php
      }}
      ?&amp;gt;
    &amp;lt;/tbody&amp;gt;
  &amp;lt;/table&amp;gt;
&amp;lt;/div&amp;gt;

&lt;/div&gt; &lt;/div&gt; &lt;?php include'template_part/footer/footer.php';?&gt; </pre>

cba itu, kmu ada error di kodenya

avatar ashleenanh46
@ashleenanh46

21 Kontribusi 5 Poin

Dipost 4 tahun yang lalu

Tanggapan

Dipindah kesitu fetch mutiplenya?

iy di code ini emang ada errornya gmn ya errornya?

Jawaban Terpilih

Case close harusnya variable datanya saat dibuat harus berbentuk array()

<pre> $data=[];

//jadi bisa digunakan sebagai array

$data[] = $row; </pre>

avatar maszgalang
@maszgalang

297 Kontribusi 80 Poin

Dipost 4 tahun yang lalu

Login untuk ikut Jawaban