r4ndi04

proses

Jan 6th, 2016
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.08 KB | None | 0 0
  1. <?php
  2. include "../../config/koneksi.php";
  3. $op=isset($_GET['op'])?$_GET['op']:null;
  4. if($op=='barang'){
  5.     echo "<thead>
  6.                 <tr>
  7.                     <th>Kode Barang</th>
  8.                     <th>Nama Barang</th>
  9.                     <th>Harga Jual</th>
  10.                     <th>Harga Terjual</th>
  11.                     <th>Potongan</th>
  12.                     <th>Qty</th>
  13.                     <th>Subtotal</th>
  14.                     <th>Aksi</th>
  15.                 </tr>
  16.             </thead>";
  17.     $query = mysql_query("select * from tblsementara order by idsementara DESC");
  18.     $total=mysql_fetch_array(mysql_query("select sum(subtotal) as total from tblsementara"));
  19.     while($r=mysql_fetch_array($query)){
  20.         echo '<tr>
  21.                     <td>$r[kd_brg]</td>
  22.                     <td>$r[nm_brg]</td>
  23.                     <td>$r[hrg_jual]</td>
  24.                     <td>$r[hrg_terjual]</td>
  25.                     <td>$r[potongan]</td>
  26.                     <td>$r[qty]</td>
  27.                     <td>$r[subtotal]</td>
  28.                     <td>
  29.                         <a class="btn btn-danger" href="proses.php?op=hapus&id=$r[idsementara]" id="hapus" data-toggle="tooltip" data-placement="top" title="Hapus"><span class="glyphicon glyphicon-trash"></span></a>
  30.                     </td>
  31.                 </tr>';
  32.     }
  33.     echo"<tr>
  34.                     <td colspan='6'>Total</td>
  35.                     <td colspan='7'>$total[total]</td>
  36.                 </tr>";
  37. ?>
Add Comment
Please, Sign In to add comment