Postingan lainnya

Isi dari tabel tidak muncul

Permisi sebelumnya. Selamat malam. Saya minta izin untuk bertanya. Kenapa isi dari tabelnya tidak ada (sebelumnya ada)? Kira-kira salah dimananya? mohon sekiranya dibantu. Terima kasih. Berikut ini source kodenya :

 <html>
<head>
<title>Warteg Online</title>
<link href="../../css/bootstrap.min.css" rel="stylesheet">
<link rel="stylesheet" href="../../font-awesome/css/font-awesome.min.css">
</head>
<body>

<script src="../../js/jquery.min.js"></script>
<script src="../../js/bootstrap.min.js"></script>

<style>
*{
	padding:0px;
	margin:0px;
}
.col-md-1{
	background-color:#009999;
	height:100%;
	color:#FFFFFF;
	width:20%;
	float:left;
}
.list-group-item{
	background-color:#009999;
	border:none;
	font-size:18px;
}
.list-group a{
	color:#FFFFFF;
}
.col-md-11{
	width:80%;
	float:right;
}
.btn-primary{
	margin-top:2%;
	margin-bottom:2%;
}
.add{
	margin-top:2%;
	margin-bottom:2%;
	float:left;
}
.cari{
	margin-top:2.5%;
	margin-bottom:2%;
	margin-left:70%;
	clear:both;
}

</style>
<!-- Sidebar Fix -->
<div class="container-fluid">
	<div class="row">
    	<div class="col-md-1">
			<center><h1>Warteg Bahari</h1></center>
            <hr>
            <div class="list-group">
            <a href="../dashboard/home_admin.php" class="list-group-item">Dashboard</a>
            <a href="#" class="list-group-item">Stok Makanan Dan Minuman</a>
            <a href="#" class="list-group-item">Catatan Penjualan</a>
            <a href="../../index.php" class="list-group-item">Exit</a>
</div>
	</div>
<!-- halaman utama -->
<div class="col-md-11">
	<a class="btn btn-primary add" data-target="#modalAdd" data-toggle="modal">Add Data</a>

   <form action="stok_makan_minum.php" method="post">
   	<input type="text" name="cari" class="cari" placeholder="Mencari Menu">
   </form>


   <table class="table table-striped">
	<tr>
    	<th>ID Menu</th>
        <th>Nama Menu</th>
        <th>Jenis Menu</th>
        <th>Stok</th>
        <th>Harga</th>
        <th>Aksi</th>
    </tr>
<?php
	include "koneksi.php";

		$query_mysql=mysql_query("Select*from daftar_menu")or die(mysql_error());

if(isset($_POST['cari'])){
	$cari=$_POST['cari'];
	$query_mysql="SELECT * FROM  daftar_menu
	where nm_menu like '%$cari%'  ";
}

$result=mysql_query($query_mysql) or die(mysql_error());


		while($data= mysql_fetch_array($result)){
		?>
        <tr>
        	<td><?php echo $data -> id_menu ;?></td>
            <td><?php echo $data -> nm_menu ;?></td>
            <td><?php echo $data -> jn_menu ;?></td>
            <td><?php echo $data -> stok ;?></td>
            <td><?php echo $data -> hrg_menu ;?></td>
            <td>
			<a href="#" class='open_modal' id='<?php echo $data['id_menu']; ?>'><i class="fa fa-edit"></i></a>
			<a href="hapus.php?id_menu=<?php echo $data['id_menu']; ?>" onClick="return confirm('Apakah anda yakin akan menghapus data ini?')"><i class="fa fa-eraser"></i></a>
			</td>
        </tr>
        <?php } ?>
	</table>
</div>

<!-- Modal Tambah -->
<div id="modalAdd" class="modal fade" role="dialog">
	<div class="modal-dialog" role="document">
    	<div class="modal-content">

        <div class="modal-header">
        <button type="button" class="close" data-dismiss="modal">×</button>
        <h4 class="modal-title" id="myModalLabel"><center>Menambah Menu</center></h4>
        </div>

        <div class="modal-body">
        	<form action="insert.php" method="post">
  		<div class="form-group">
    		<label>ID Menu :</label>
    		<input type="text" name="id_menu" class="form-control" required>
  		</div>
	    <div class="form-group">
    		<label>Nama Menu :</label>
    		<input type="text" name="nm_menu" class="form-control" required>
  		</div>
  		<div class="form-group">
  			<label>Jenis Menu :</label>
    		<select name="jn_menu">
    		<option value="nasi putih">Nasi Putih</option>
    		<option value="sayur mayur">Sayur Mayur</option>
    		<option value="lauk nabati">Lauk Nabati</option>
    		<option value="lauk hewani">Lauk Hewani</option>
			<option value="gorengan">Gorengan</option>
    		<option value="minuman">Minuman</option>
    		</select>
  		</div>
  		<div class="form-group">
  			<label>Stok Menu :</label>
    		<input type="radio" name="stok" value="Tersedia">Tersedia
            <input type="radio" name="stok" value="Habis">Habis
  		</div>
  		<div class="form-group">
  			<label>Harga Menu :</label>
    		<input type="text" name="hrg_menu" class="form-control" required>
  		</div>
  		<div class="form-group">
  			<label>Keterangan :</label>
    		<input type="text" name="keterangan" class="form-control input-group-lg" id="inputlg" required>
  		</div>
  		<div class="form-group">
  			<label>Gambar :</label>
    		<input type="file" name="gambar" class="form-control" required>
  		</div>
  			<input type="submit" class="btn btn-primary" value="Submit">
      	</form>
		</div>

</div>
	</div>
   		</div>
<!-- Batas Modal Tambah -->

<!-- Modal Edit -->
<div id="modalEdit" class="modal fade" role="dialog">

<!-- Batas Modal Edit -->

<script type="text/javascript">
   $(document).ready(function () {
   $(".open_modal").click(function(e) {
      var x = $(this).attr("id_menu");
		   $.ajax({
    			   url: "edit_makan_minum.php",
    			   type: "GET",
    			   data : {id_menu: x,},
    			   success: function (ajaxData){
      			   $("#modalEdit").html(ajaxData);
      			   $("#modalEdit").modal('show',{backdrop: 'true'});
      		   }
    		   });
        });
      });
</script>
</body>
</html>

php

@RafliSaputra48

38 Kontribusi 0 Poin

Diperbarui 6 tahun yang lalu

2 Jawaban:

untuk menampilkan coba saja dirubah script pada pemanggilan databasenya di rubah seperti ini. ".$data[id_menu]." ".$data[nm_menu]." ".$data[jn_menu]." ".$data[stok]." ".$data[hrg_menu]."

@any074

3 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

makasih gan udh bisa..

@RafliSaputra48

38 Kontribusi 0 Poin

Dipost 6 tahun yang lalu