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