limit_page;
@$start = ($hal-1)*$lim;
@$cari = str_replace("'","\'",$_GET['cari']);
@$field = $_GET['field'];
@$modul = $_GET['modul'];
if (empty($cari)){
$where = '';
} else {
$where = "WHERE $field LIKE '%$cari%' ORDER BY $field";
}
echo '
| No |
Nama Barang |
Harga |
Stok |
Lokasi |
|
';
$query = "SELECT * FROM ypos_barang $where LIMIT $start,$lim";
$data = $mysqli->query($query);
//echo $query;
$row = $data->num_rows;
$no=1+$start;
if ($row > 0) {
while($r=$data->fetch_array()){
echo "
| $no |
$r[nama_barang] |
$r[harga_jual] |
$r[stok] |
$r[lokasi] |
Edit - Delete |
";
$no++;
} // end while
echo '
';
} else {
echo '| Tidak ada |
';
}
//echo "";