- Beranda
- Komunitas
- Tech
- Programmer Forum
lagi bikin coding yang berelasi tapi gagal...tolong bantu dong gan..
TS
NidaSausanNF
lagi bikin coding yang berelasi tapi gagal...tolong bantu dong gan..
<form method="POST" action="">
Id Transaksi <input type="text" name="id"><br><br>
<?php
$result = mysql_query("select * from data_barang");
$jsArray = "var jenis_barang = new Array();\n";
echo 'Nama Barang <select name="nama_barang">';
echo '<option> </option>';
while ($row = mysql_fetch_array($result)) {
echo '<option value="' . $row['nama_barang'] . '">' . $row['nama_barang'] . '</option>';
$jsArray .= "jenis_barang['" . $row['nama_barang'] . "'] = {name:'" . addslashes($row['jenis_barang']) . "',desc:'".addslashes($row['harga_barang'])."'};\n";
}
echo '</select>';
?><br><br>
Jenis Barang <input type="text" name="jenis_barang" id="jenis_barang"><br><br>
Harga Barang <input type="text" name="harga_barang" id="harga_barang"> <br><br>
Jumlah Beli <input type="text" name="jumlah_beli" id="jumlah_beli"><br><br>
Total Harga <input type="text" name="total_harga" id="total_harga"/><br><br>
Diskon <input type="text" name="diskon" id="diskon"><br><br>
Total Setelah Diskon <input type="text" name="total_diskon" id="total_diskon"><br><br>
Bayar <input type="text" name="bayar" id="bayar"><br><br>
Kembalian <input type="text" name="kembalian" id="kembalian"><br><br>
<input type="submit" name="simpan" value="simpan"> <input type="submit" name="reset" value="reset">
</form>
</pre>
[removed]
<?php echo $jsArray; ?>
function changeValue(id){
document.getElementById('jenis_barang').value = jenis_barang[id].name;
document.getElementById('harga_barang').value = jenis_barang[id].desc;
};
function mulaiHitung(){
Interval = setInterval("hitung()",1);
}
function hitung(){
harga_barang = parseInt(document.getElementById("harga_barang").value);
jumlah_beli = parseInt(document.getElementById("jumlah_beli").value);
total_harga = harga_barang * jumlah_beli;
document.getElementById("total_harga").value=total_harga;
if (total_harga > 100000 && total_harga >=200000) {
diskon = (10/100) * total_harga;
}
document.getElementById("diskon").value=diskon;
total_diskon = total_harga - diskon;
document.getElementById("total_diskon").value=total_diskon;
bayar = parseInt(document.getElementById("bayar").value);
kembalian = bayar - total_diskon;
document.getElementById("kembalian").value=kembalian;
}
function berhentiHitung(){
clearInterval(Interval);
}
[removed]
<?php
if (isset($_POST['simpan'])) {
$id_transaksi=$_POST['id_transaksi'];
$nama_barang=$_POST['nama_barang'];
$jenis_barang=$_POST['jenis_barang'];
$harga_barang=$_POST['harga_barang'];
$jumlah_beli=$_POST['jumlah_beli'];
$total_harga=$_POST['total_harga'];
$diskon=$_POST['diskon'];
$total_diskon=$_POST['total_diskon'];
$bayar=$_POST['bayar'];
$kembalian=$_POST['kembalian'];
$sql=mysql_query("INSERT INTO (id_transaksi, id_barang, jumlah_beli, total_harga, diskon, total_diskon, bayar, kembalian) values (
'$id_transaksi',
'$nama_barang',
'$jenis_barang',
'$harga_barang',
'$jumlah_beli',
'$total_harga',
'$diskon',
'$total_diskon',
'$bayar',
'$kembalian'
) ")or die("Menyimpan Data Gagal");
echo "Data Berhasil Disimpan";
}
?>
nama_barang, jenis_barang, harga_barang itu dari data_barang .. cara menyimpan bagaimana nih sama cari nya juga belum..
<form action="#" method="post" >
<input type="text" name="pencarian" style="height: 28px; width: 200px; margin-left: 800px; " placeholder="Search.........">
<input type="submit" name="cari" value="search" style="height: 30px; width: 60px;">
</form>
<form method="POST" action="">
<table id="example2" class="table table-bordered table-hover">
<thead>
<tr>
<th>Id Transaksi</th>
<th>Nama Barang</th>
<th>Jenis Barang</th>
<th>Harga Barang</th>
<th>Jumlah Beli</th>
<th>Total Harga</th>
<th>Diskon</th>
<th>Total Setelah Diskon</th>
<th>Bayar</th>
<th>Kembalian</th>
</tr>
</thead>
<tbody>
<?php
if (isset($_POST['cari'])) {
$cari=$_POST['pencarian'];
$query=mysql_query("SELECT * FROM transaksi INNER JOIN data_barang ON transaksi.id_barang=data_barang.nama_barang
ON transaksi.id_barang=data_barang.jenis_barang ON transaksi.id_barang=data_barang.harga_barang WHERE transaksi.id_transaksi='$cari'") or die(mysql_error());
}else{
$query=mysql_query("SELECT * FROM transaksi INNER JOIN data_barang ON transaksi.id_barang=data_barang.nama_barang
ON transaksi.id_barang=data_barang.jenis_barang ON transaksi.id_barang=data_barang.harga_barang ");
}
$no=1;
while ($data=mysql_fetch_array($query)) {
?>
<tr>
<td><?php echo $data ['id_transaksi'];?></td>
<td><?php echo $data ['nama_barang']; ?></td>
<td><?php echo $data ['jenis_barang']; ?></td>
<td><?php echo $data ['harga_barang']; ?></td>
<td><?php echo $data ['jumlah_beli']; ?></td>
<td><?php echo $data ['total_harga']; ?></td>
<td><?php echo $data ['diskon']; ?></td>
<td><?php echo $data ['total_diskon']; ?></td>
<td><?php echo $data ['bayar']; ?></td>
<td><?php echo $data ['kembalian']; ?></td>
<td><a href="hapus.php?id_transaksi=<?php echo $data['id_transaksi'];?>">HAPUS</a> |
<a href="edit.php?id_transaksi=<?php echo $data['id_transaksi'];?>">EDIT</a></td>
</tr>
<?php
$no++;
}
?>
</tbody>
</thead>
Id Transaksi <input type="text" name="id"><br><br>
<?php
$result = mysql_query("select * from data_barang");
$jsArray = "var jenis_barang = new Array();\n";
echo 'Nama Barang <select name="nama_barang">';
echo '<option> </option>';
while ($row = mysql_fetch_array($result)) {
echo '<option value="' . $row['nama_barang'] . '">' . $row['nama_barang'] . '</option>';
$jsArray .= "jenis_barang['" . $row['nama_barang'] . "'] = {name:'" . addslashes($row['jenis_barang']) . "',desc:'".addslashes($row['harga_barang'])."'};\n";
}
echo '</select>';
?><br><br>
Jenis Barang <input type="text" name="jenis_barang" id="jenis_barang"><br><br>
Harga Barang <input type="text" name="harga_barang" id="harga_barang"> <br><br>
Jumlah Beli <input type="text" name="jumlah_beli" id="jumlah_beli"><br><br>
Total Harga <input type="text" name="total_harga" id="total_harga"/><br><br>
Diskon <input type="text" name="diskon" id="diskon"><br><br>
Total Setelah Diskon <input type="text" name="total_diskon" id="total_diskon"><br><br>
Bayar <input type="text" name="bayar" id="bayar"><br><br>
Kembalian <input type="text" name="kembalian" id="kembalian"><br><br>
<input type="submit" name="simpan" value="simpan"> <input type="submit" name="reset" value="reset">
</form>
</pre>
[removed]
<?php echo $jsArray; ?>
function changeValue(id){
document.getElementById('jenis_barang').value = jenis_barang[id].name;
document.getElementById('harga_barang').value = jenis_barang[id].desc;
};
function mulaiHitung(){
Interval = setInterval("hitung()",1);
}
function hitung(){
harga_barang = parseInt(document.getElementById("harga_barang").value);
jumlah_beli = parseInt(document.getElementById("jumlah_beli").value);
total_harga = harga_barang * jumlah_beli;
document.getElementById("total_harga").value=total_harga;
if (total_harga > 100000 && total_harga >=200000) {
diskon = (10/100) * total_harga;
}
document.getElementById("diskon").value=diskon;
total_diskon = total_harga - diskon;
document.getElementById("total_diskon").value=total_diskon;
bayar = parseInt(document.getElementById("bayar").value);
kembalian = bayar - total_diskon;
document.getElementById("kembalian").value=kembalian;
}
function berhentiHitung(){
clearInterval(Interval);
}
[removed]
<?php
if (isset($_POST['simpan'])) {
$id_transaksi=$_POST['id_transaksi'];
$nama_barang=$_POST['nama_barang'];
$jenis_barang=$_POST['jenis_barang'];
$harga_barang=$_POST['harga_barang'];
$jumlah_beli=$_POST['jumlah_beli'];
$total_harga=$_POST['total_harga'];
$diskon=$_POST['diskon'];
$total_diskon=$_POST['total_diskon'];
$bayar=$_POST['bayar'];
$kembalian=$_POST['kembalian'];
$sql=mysql_query("INSERT INTO (id_transaksi, id_barang, jumlah_beli, total_harga, diskon, total_diskon, bayar, kembalian) values (
'$id_transaksi',
'$nama_barang',
'$jenis_barang',
'$harga_barang',
'$jumlah_beli',
'$total_harga',
'$diskon',
'$total_diskon',
'$bayar',
'$kembalian'
) ")or die("Menyimpan Data Gagal");
echo "Data Berhasil Disimpan";
}
?>
nama_barang, jenis_barang, harga_barang itu dari data_barang .. cara menyimpan bagaimana nih sama cari nya juga belum..
<form action="#" method="post" >
<input type="text" name="pencarian" style="height: 28px; width: 200px; margin-left: 800px; " placeholder="Search.........">
<input type="submit" name="cari" value="search" style="height: 30px; width: 60px;">
</form>
<form method="POST" action="">
<table id="example2" class="table table-bordered table-hover">
<thead>
<tr>
<th>Id Transaksi</th>
<th>Nama Barang</th>
<th>Jenis Barang</th>
<th>Harga Barang</th>
<th>Jumlah Beli</th>
<th>Total Harga</th>
<th>Diskon</th>
<th>Total Setelah Diskon</th>
<th>Bayar</th>
<th>Kembalian</th>
</tr>
</thead>
<tbody>
<?php
if (isset($_POST['cari'])) {
$cari=$_POST['pencarian'];
$query=mysql_query("SELECT * FROM transaksi INNER JOIN data_barang ON transaksi.id_barang=data_barang.nama_barang
ON transaksi.id_barang=data_barang.jenis_barang ON transaksi.id_barang=data_barang.harga_barang WHERE transaksi.id_transaksi='$cari'") or die(mysql_error());
}else{
$query=mysql_query("SELECT * FROM transaksi INNER JOIN data_barang ON transaksi.id_barang=data_barang.nama_barang
ON transaksi.id_barang=data_barang.jenis_barang ON transaksi.id_barang=data_barang.harga_barang ");
}
$no=1;
while ($data=mysql_fetch_array($query)) {
?>
<tr>
<td><?php echo $data ['id_transaksi'];?></td>
<td><?php echo $data ['nama_barang']; ?></td>
<td><?php echo $data ['jenis_barang']; ?></td>
<td><?php echo $data ['harga_barang']; ?></td>
<td><?php echo $data ['jumlah_beli']; ?></td>
<td><?php echo $data ['total_harga']; ?></td>
<td><?php echo $data ['diskon']; ?></td>
<td><?php echo $data ['total_diskon']; ?></td>
<td><?php echo $data ['bayar']; ?></td>
<td><?php echo $data ['kembalian']; ?></td>
<td><a href="hapus.php?id_transaksi=<?php echo $data['id_transaksi'];?>">HAPUS</a> |
<a href="edit.php?id_transaksi=<?php echo $data['id_transaksi'];?>">EDIT</a></td>
</tr>
<?php
$no++;
}
?>
</tbody>
</thead>
nona212 memberi reputasi
0
929
8
Komentar yang asik ya
Urutan
Terbaru
Terlama
Komentar yang asik ya
Komunitas Pilihan