<?php
$servername = "localhost";
$username = "name";
$password = "password";
$dbname = "chat";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$us1 = $_GET["user"];
$pw1 = $_GET["pswd"];

// sql for compare record
$sql = "SELECT usr, pw FROM pwt EXISTS (SELECT usr, pw FROM pwt WHERE usr = '$us1' AND pw = '$pw1')";



if ($conn->query($sql) === TRUE) {
    header('Location: http://192.168.56.101/testat/source/admin.php');
} else {
    echo "Falsches Passwort " . $conn->error;
    echo "Passwort ist $pw1";
    echo "Name ist $us1";
}

$conn->close();
?>