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