if ($search) {
$keywords = preg_split('/\s+/', strtolower(trim($search)));
$searchClauses = [];
foreach ($keywords as $word) {
$searchClauses[] = "(LOWER(org_name) LIKE ? OR LOWER(country) LIKE ? OR LOWER(org_extra_info) LIKE ? OR LOWER(org_category) LIKE ? OR LOWER(location) LIKE ?)";
// Push the same word 5 times for 5 fields
for ($i = 0; $i < 5; $i++) {
$params[] = "%$word%";
$types .= "s";
}
}
$query .= $is_featured !== null ? " AND" : " WHERE";
$query .= " (" . implode(" AND ", $searchClauses) . ")";
}