PDO 是执行语句期间受影响的行
我找到了很多方法来使用 PDO 的 exec 语句，但我不确定它对我有帮助.我的理解是我必须对准备好的语句使用 execute() 函数.我正在使用来自用户输入的数据更新一行，因此我想使用准备好的语句而不是 query() 调用.
I have found many ways to use the exec statement for PDO, but I'm not sure it helps me. My understanding is that I have to use the execute() function for prepared statements. I am updating a row with data from user input, so I would like to use a prepared statement instead of the query() call.
我的代码如下:
$dbh = buildDBConnector();
$sql = "UPDATE tb_users
SET authState=1
WHERE id = ? AND authPass = ?";
$q = $dbh->prepare($sql);
$f = $q->execute(array($id,$authPass));
if($f){
echo '<br />Success<br />';
}else{
echo '<br />Failure<br />';
}
问题是查询本身没有错误并且执行得很好，所以没有存储在 $f 中的失败.但是，我需要知道它是否真的找到了要更新的行，然后成功更新了它.换句话说，我需要受影响的行.在谷歌搜索等时，它不断出现 exec 语句，但据我所知， exec 不是用于准备好的语句?有什么建议吗?
The issue is that the query itself is error free and executes fine, so there is no failure to store in $f. However, I need to know if it actually found the row to update, then successfully updated it. In other words, I need the affected rows. When googling and such, it keeps coming to the exec statement, but from my understanding, exec isn't for prepared statements? Any suggestions?
推荐答案
试试 $q->rowCount().准备好的语句将通过该方法返回受影响的行数.
Try $q->rowCount(). Prepared statements will return the number of affected rows via that method.
相关文章