在PHP参数化查询中，tinyint类型的数据用啥代替，应该不用s代替吧？
最新回答
傲骨
2023-01-05 20:19:53
$pdo = new PDO("mysql:host=localhost;dbname=database", "dbusername", "dbpassword");
$username = "root";
$password = "123456";
$query = "SELECT * FROM users WHERE (name = :username) and (password = :password)";
$statement = $pdo->prepare($query, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));
$statement->bindParam(":username", $username, PDO::PARAM_STR, 10);
$statement->bindParam(":password", $password, PDO::PARAM_STR, 12);
$statement->execute();
热门标签
