Bahamas Voter Search

connect_error) { die("

Database connection failed: " . $conn->connect_error . "

"); } if (!empty($_GET['first_name']) || !empty($_GET['last_name'])) { $first = trim($_GET['first_name']); $last = trim($_GET['last_name']); $sql = "SELECT voter_cardnum, first_name, last_name, date_of_birth, home_street_name, constituency_id FROM voters_all_bahamas WHERE 1=1"; $params = []; $types = ""; if ($first !== "") { $sql .= " AND first_name LIKE ?"; $params[] = "%$first%"; $types .= "s"; } if ($last !== "") { $sql .= " AND last_name LIKE ?"; $params[] = "%$last%"; $types .= "s"; } $stmt = $conn->prepare($sql); if (!empty($params)) { $stmt->bind_param($types, ...$params); } $stmt->execute(); $result = $stmt->get_result(); echo "

Search Results:

"; if ($result->num_rows > 0) { echo ""; echo ""; while ($row = $result->fetch_assoc()) { echo ""; } echo "

Voter Card #	First Name	Last Name	Date of Birth	Street	Constituency
".htmlspecialchars($row['voter_cardnum'])."	".htmlspecialchars($row['first_name'])."	".htmlspecialchars($row['last_name'])."	".htmlspecialchars($row['date_of_birth'])."	".htmlspecialchars($row['home_street_name'])."	".htmlspecialchars($row['constituency_id'])."

"; } else { echo "

No results found.

"; } } $conn->close(); ?>