= 1) {
$where_data[] = "user_id = " . $user_id . "";
}
$stock_name = $_GET['stock_name'];
if ($stock_name >= 1) {
$where_data[] = "stock_name = " . $stock_name . "";
}
$qr_code = $_GET['qr_code'];
if (strlen($qr_code) >= 1) {
$where_data[] = "qr_code LIKE '%" . $qr_code . "%'";
}
$shelf = $_GET['shelf'];
if ($shelf >= 1) {
$where_data[] = "shelf = " . $shelf . "";
}
$row = $_GET['row'];
if ($row >= 1) {
$where_data[] = "record_id = " . $row . "";
}
$date = $_GET['date_time_added'];
if (strlen($date) >= 1) {
$where_data[] = "date_time_added LIKE '%" . $date . "%'";
}
$category = $_GET['category_id'];
if ($category >= 1) {
$where_data[] = "category_id = " . $category . "";
}
if (count($where_data) > 0) {
$where = " WHERE " . implode(" AND ", $where_data);
} else {
$where = " WHERE 1";
}
// echo "SELECT * FROM `stock_items` $where ORDER BY record_id DESC";
$result = $db->conn->query("SELECT * FROM `stock_items` $where ORDER BY record_id DESC");
if ($result->num_rows > 0) {
while ($data = $result->fetch_assoc()) {
echo "
";
}
} else {
echo "
NO RESULTS
";
}