= 1) {
$where_data[] = "name LIKE '%" . $name . "%'";
}
$username = $_GET['username'];
if (strlen($username) >= 1) {
$where_data[] = "username LIKE '%" . $username . "%'";
}
$status = $_GET['status'];
if (strlen($status) >= 1 && $status != "STATUS") {
$where_data[] = "status = " . $status;
}
$user_type = $_GET['user_type'];
if (strlen($user_type) >= 1 && $user_type != "USER TYPE") {
$where_data[] = "user_type = " . $user_type;
}
if (count($where_data) > 0) {
$where = " WHERE " . implode(" AND ", $where_data);
} else {
$where = " WHERE 1";
}
$result = $db->conn->query("SELECT * FROM `users` $where ORDER BY record_id DESC");
if ($result->num_rows > 0) {
while ($data = $result->fetch_assoc()) {
echo "
";
}
} else {
echo "
NO RESULTS
";
}