php column not found,Uncaught PDOException: SQLSTATE[42S22]: Column not found in PHP code

I get this message:

Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Password' in 'field list' in C:\xampp\htdocs\eCommerce\admin\index.php:26 Stack trace: #0 C:\xampp\htdocs\eCommerce\admin\index.php(26): PDOStatement->execute(Array) #1 {main} thrown in C:\xampp\htdocs\eCommerce\admin\index.php on line 26

It says that the error comes from this line:

$stmt->execute(array($username, $hashedPass));

session_start();

$noNvabar = '';

if(isset($_SESSION['Username'])){

header('Location: dashboard.php');//Redirect to dashboard page

}

include 'init.php';

// Check if the user coming from an http post request

if ($_SERVER['REQUEST_METHOD'] == 'POST'){

$username = $_POST['user'];

$password = $_POST['pass'];

$hashedPass = sha1($password);

// Check if the user exist in the database

$stmt = $con->prepare("SELECT Username, Password FROM users WHERE Username = ? AND Password = ?");

$stmt->execute(array($username, $hashedPass));

$count = $stmt->rowCount();

// If count > 0 this means the database contains record about this username

if ($count > 0) {

echo 'welcome' . $username;

$_SESSION['Username'] = $username; // Register Session Nmae

header('Location: dashboard.php'); // Redirect to dashboard page

exit();

}

}

?>

Admin Login

include $tbl . 'footer.php';

?>

# Answer 1

Please read the message:

Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Password' in 'field list' in C:\xampp\htdocs\eCommerce\admin\index.php:26

==>

$stmt = $con->prepare("SELECT Username, Password FROM users WHERE Username = ? AND Password = ?");

Password is not found in the users table.