<?include "conninfo.php";

$username=$_POST["username"];
$password=$_POST["password"];

$query="SELECT * FROM people WHERE username like '$username' AND password like '$password'";

$result=mysqli_query($link,$query);?>


<?$numrows=mysqli_num_rows($result);

if ($numrows>0){?>
<br><br><b>Thank you for logging in. Here are your details:<br><br>
<?

    while ($r=mysqli_fetch_array($result))
    {
    echo $r["id"]." ";
    echo $r["firstname"]." ";
    echo $r["surname"]." ";
    echo $r["address"]."<br>";
    }
}
else
{
echo "Sorry, no records found";
}

?>
