= 1) {
$where_data[] = "tool_name = " . $tool_name . "";
}
$brand = $_GET['brand'];
if ($brand >= 1 && $brand != "Brand") {
$where_data[] = "brand = " . $brand;
}
$qr_code = $_GET['qr_code'];
if (strlen($qr_code) >= 1) {
$where_data[] = "qr_code LIKE '%" . $qr_code . "%'";
}
$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 `tools` $where ORDER BY record_id DESC";
$result = $db->conn->query("SELECT * FROM `tools` $where ORDER BY record_id DESC");
if ($result->num_rows > 0) {
while ($data = $result->fetch_assoc()) {
echo "
";
}
} else {
echo "
NO RESULTS
";
}