区分大小写的PHP PDO登录脚本

$stmt = $pdo->prepare("SELECT * FROM users WHERE username = :username AND password = :password");
$stmt->bindValue(':username', $username);
$stmt->bindValue(':password', $password);

$stmt->execute();
$user = $stmt->fetch(PDO::FETCH_ASSOC);

<?php
// 建立数据库连接
$dsn = "mysql:host=localhost;dbname=mydatabase";
$username = "myusername";
$password = "mypassword";
$pdo = new PDO($dsn, $username, $password);

// 获取用户提交的登录凭据
$username = $_POST['username'];
$password = $_POST['password'];

// 准备查询语句
$stmt = $pdo->prepare("SELECT * FROM users WHERE username = :username AND password = :password");
$stmt->bindValue(':username', $username);
$stmt->bindValue(':password', $password);

// 执行查询并获取结果
$stmt->execute();
$user = $stmt->fetch(PDO::FETCH_ASSOC);

// 判断登录是否成功
if ($user) {
    // 登录成功，执行相应操作
    echo "登录成功！";
    // 跳转到用户主页或其他操作
} else {
    // 登录失败，显示错误消息
    echo "用户名或密码错误！";
}
?>