Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <h1>Stok Barang </h1>
- <?php
- include("koneksi.php");
- if(isset($_POST["simpan"]))
- {
- $a=$_POST["kodebrg1"];
- $sqlnya="select * from barang where KodeBrg='$a'";
- $hasil=mysqli_query($koneksinya,$sqlnya);
- echo "<center><table></center>";
- echo "<tr><td>Kode Barang</td><td>Nama Barang</td><td>Stok Awal </td> <td>Stok Jual</td><td>Stok Beli</td><td>Stok Sekarang</td></tr>";
- if(mysqli_num_rows($hasil)>0)
- {
- while($baris=mysqli_fetch_assoc($hasil))
- {
- $a=$baris["KodeBrg"];
- $b=$baris["NamaBrg"];
- // $c=$baris["HargaBeli"];
- // $d=$baris["HargaJual"];
- $e=$baris["Stock"];
- $f=$baris["StokJual"];
- $g=$baris["StokBeli"];
- $h=$e+$g-$f;
- echo "<form action='' method='post'>";
- echo "<tr><td><input type='text' value = '$a' name='kodebrg1'></td>";
- echo "<td><input type='text' value = '$b' name='namabrg1'></td>";
- // echo "<td><input type='text' value = '$c' name='hrgbeli1'></td>";
- // echo "<td><input type='text' value = '$d' name='hrgjual1'></td>";
- echo "<td><input type='text' value = '$e' name='stok1'></td>";
- echo "<td><input type='text' value = '$f' name='stok2'></td>";
- echo "<td><input type='text' value = '$g' name='stok3'></td>";
- echo "<td><input type='text' value = '$h' name='stok3'></td>";
- echo "</form>";
- }
- }
- }
- else{
- $sqlnya="select * from barang order by KodeBrg asc";
- $hasil=mysqli_query($koneksinya,$sqlnya);
- echo "<center><table></center>";
- echo "<tr><td>Kode Barang</td><td>Nama Barang</td><td>Stok Awal </td> <td>Stok Jual</td><td>Stok Beli</td><td>Stok Sekarang</td></tr>";
- if(mysqli_num_rows($hasil)>0)
- {
- while($baris=mysqli_fetch_assoc($hasil))
- {
- $a=$baris["KodeBrg"];
- $b=$baris["NamaBrg"];
- // $c=$baris["HargaBeli"];
- // $d=$baris["HargaJual"];
- $e=$baris["Stock"];
- $f=$baris["StokJual"];
- $g=$baris["StokBeli"];
- $h=$e+$g-$f;
- echo "<form action='' method='post'>";
- echo "<tr><td><input type='text' value = '$a' name='kodebrg1'></td>";
- echo "<td><input type='text' value = '$b' name='namabrg1'></td>";
- // echo "<td><input type='text' value = '$c' name='hrgbeli1'></td>";
- // echo "<td><input type='text' value = '$d' name='hrgjual1'></td>";
- echo "<td><input type='text' value = '$e' name='stok1'></td>";
- echo "<td><input type='text' value = '$f' name='stok2'></td>";
- echo "<td><input type='text' value = '$g' name='stok3'></td>";
- echo "<td><input type='text' value = '$h' name='stok3'></td>";
- echo "</form>";
- }
- }
- }
- echo "</table>";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement