<?php

$username = "root";
$password = "";
$dbname = "1_wybory";
header('Content-Type: text/html; charset=utf-8');

$conn = mysqli_connect("localhost", $username, $password, $dbname);

if (!$conn) {
  die("Connection failed: " . mysqli_connect_error());

}

mysqli_query($conn,"SET NAMES utf8");
mysqli_query($conn,"SET CHARACTER_SET utf8_unicode_ci");

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}


$nationalid = $_POST['nationalid'];
$sql = "SELECT  id,surname,nationalid FROM electorate WHERE nationalid = $nationalid ";

$result = $conn->query($sql);

//header('Location: pass_gen_view.php');

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
    echo $row["id"];
    echo $row["surname"];
    echo $row["nationalid"];
  }
}


 $conn->close();
?>