connect_error) {
die("Connection failed to registry DB: " . $conn->connect_error);
}
$search = trim($_GET['q'] ?? '');
$masjids = [];
if ($search !== '') {
$stmt = $conn->prepare("SELECT slug, name, area FROM masjids WHERE is_active = 1 AND (name LIKE ? OR area LIKE ?) ORDER BY name");
$like = "%$search%";
$stmt->bind_param("ss", $like, $like);
} else {
$stmt = $conn->prepare("SELECT slug, name, area FROM masjids WHERE is_active = 1 ORDER BY name");
}
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
$masjids[] = $row;
}
$stmt->close();
$conn->close();
?>
MasjidScreen - Find your masjid's salaah times