Postingan lainnya
menghitung harga sesuai dengan yang kita pilih
persimi bang, saya punya kendala gimana script untuk menghitung harga sesuai dengan yang kita pilih. pada kasus ini saya ingin menghitung total pendapatan dan total keuntungan sesuai dengan tanggal yang dicari / dipilih
tampilan full (normal gak ada masalah)
tampilan saat tanggal yang kita pilih (total pendapatan dan total laba tidak berubah alias tetap)
sourcode
<html>
<head>
<link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
<script src="https://code.jquery.com/jquery-1.12.4.js"></script>
<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
<script>
$( function() {
$( "#datepicker" ).datepicker({ dateFormat: 'yy-mm-dd' });
$( "#datepicker2" ).datepicker({ dateFormat: 'yy-mm-dd' });
} );
</script>
</head>
<body>
<?php
include "admin/config.php";
$sql = mysqli_query($connect,"SELECT * FROM barang_laku");
$z="0";
if (isset($_POST['cari'])) {
$tgl1=$_POST['tgl1'];
$tgl2=$_POST['tgl2'];
$cari = mysqli_query($connect,"SELECT * FROM barang_laku WHERE tanggal BETWEEN '$tgl1' AND '$tgl2'");
$z="1";
if (mysqli_num_rows($cari)<1) {
$cari = mysqli_query($connect,"SELECT * FROM barang_laku");
}
}
?>
<form action="" method="post">
<center><p>Dari: <input type="text" id="datepicker" name="tgl1">
Sampai: <input type="text" id="datepicker2" name="tgl2"> <input type="submit" value="cari" name="cari"></p></center>
</form>
<center><table border="5" width="1000">
<tr>
<td>Kode Penjualan</td>
<td>Tanggal Penjualan</td>
<td>Nama Barang</td>
<td>Customer</td>
<td>Jumlah</td>
<td>Harga</td>
<td>Laba</td>
</tr><center>
<?php
if ($z=="1") {
?>
<?php
while($row = mysqli_fetch_array($cari))
{
?>
<tr>
<td><?php echo $row["kode"]; ?></td>
<td><?php echo $row["tanggal"]; ?></td>
<td><?php echo $row["nama"]; ?></td>
<td><?php echo $row["customer"]; ?></td>
<td><?php echo $row["jumlah"]; ?></td>
<td>Rp.<?php echo $row["harga"]; ?></td>
<td>Rp.<?php echo $row["laba"]; ?></td>
</tr>
<?php
}
?>
<?php
}
else{
?>
<?php
while($row = mysqli_fetch_array($sql))
{
?>
<?php
}
}
?>
</table>
</body>
<tr>
<td colspan="7">Total Pendapatan</td>
<?php
$x=mysqli_query($connect,"select sum(total_harga) as total from barang_laku");
$xx=mysqli_fetch_array($x);
echo "<td><b> Rp.". number_format($xx['total']).",-</b></td>";
?>
</tr>
<br>
<tr>
<td colspan="7">Total Laba</td>
<?php
$x=mysqli_query($connect,"select sum(laba) as total from barang_laku");
$xx=mysqli_fetch_array($x);
echo "<td><b> Rp.". number_format($xx['total']).",-</b></td>";
?>
</tr>
</html>
mohon pencerahannya ya bang
4 Jawaban:
Sebelum
<?php
$x=mysqli_query($connect,"select sum(total_harga) as total from barang_laku");
$xx=mysqli_fetch_array($x);
echo "<td><b> Rp.". number_format($xx['total']).",-</b></td>";
?>
Sesudah
<?php
if(isset($_POST['tgl1']) && isset($_POST['tgl1'])) {
$tgl1 = $_POST['tgl1'];
$tgl2 = $_POST['tgl2'];
}
$x=mysqli_query($connect,"select sum(total_harga) as total from barang_laku WHERE tanggal BETWEEN '$tgl1' AND '$tgl2'");
$xx=mysqli_fetch_array($x);
echo "<td><b> Rp.". number_format($xx['total']).",-</b></td>";
?>
Coba tambahkan WHERE di query sumnya berdasarkan tanggal seperti sesudah
berhasil bang, tapi tampilan default nya jadi gini
nah cara ngehide total pendapatan dan total laba gimana bang? jadi mereka muncul saat kita ingin mencari tanggal nya.
error_reporting(0) atau dideklarasi dulu variablenya gan
Jawaban Terpilih
<?php
if(isset($_POST['tgl1']) && isset($_POST['tgl1'])) {
$tgl1 = $_POST['tgl1'];
$tgl2 = $_POST['tgl2'];
$x=mysqli_query($connect,"select sum(total_harga) as total from barang_laku WHERE tanggal BETWEEN '$tgl1' AND '$tgl2'");
$xx=mysqli_fetch_array($x);
echo "<td><b> Rp.". number_format($xx['total']).",-</b></td>";
}
?>
coba query sqlnya taruh di dalam if seperti diatas