dscpg80066 2017-06-01 10:59
浏览 33
已采纳

删除记录,如果它存在于php / PDO中[重复]

This question already has an answer here:

I have some code that deletes a record from a MySQL database, but I get the success message even if the record does not exist. I have searched for ways of producing a message if the record does not exist but cannot find one that works with my code.

My code is:

try {
    $dbh = new PDO("mysql:host=$hostname;dbname=$dbname", $username, $password);
    /*** echo a message saying we have connected ***/
    //echo 'Connected to database<br />';
    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $sql = "DELETE FROM ukgh WHERE telephone = :telephone";
    $stmt = $dbh->prepare($sql);
    $stmt->bindParam(':telephone', $telephone, PDO::PARAM_STR);   
    $stmt->execute(); 

    /*** close the database connection ***/
    $dbh = null;
}
catch(PDOException $e) {
    echo $e->getMessage();
}
// once processing is complete
// show success message
echo 'Success - The record for ' . $telephone . ' has been deleted.';
?>

Note to Fred-ii- The answer you referred to is correct, but the terminology in the question I asked was different. I asked how to ensure the RECORD I was deleting existed. I did not ask how to check if a row exists, and would never have thought to search for anything about an existing ROW when I was looking for an existing RECORD. To some experts like yourself a row may be the same as a record, but I and possibly other less enlightened people like me have never heard a record called a row. Best wishes, Tog

</div>
  • 写回答

1条回答 默认 最新

  • dsgk0386 2017-06-01 11:05
    关注

    Use rowCount(); inside try to check number of affected rows by your sql statement

    try {
        $dbh = new PDO("mysql:host=$hostname;dbname=$dbname", $username, $password);
        /*     * * echo a message saying we have connected ** */
    //echo 'Connected to database<br />';
        $sql = "DELETE FROM ukgh WHERE telephone = :telephone";
        $stmt = $dbh->prepare($sql);
        $stmt->bindParam(':telephone', $telephone, PDO::PARAM_STR);
        $stmt->execute();
        $count = $stmt->rowCount();// check affected rows using rowCount
        if ($count > 0) {
            echo 'Success - The record for ' . $telephone . ' has been deleted.';
        } else {
            echo "Your error message";
        }
    } catch (PDOException $e) {
        echo $e->getMessage();
    }
    

    Read http://php.net/manual/en/pdostatement.rowcount.php

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 limma多组间分析最终p值只有一个
  • ¥15 nopCommerce开发问题
  • ¥15 torch.multiprocessing.spawn.ProcessExitedException: process 1 terminated with signal SIGKILL
  • ¥15 QuartusⅡ15.0编译项目后,output_files中的.jdi、.sld、.sof不更新怎么解决
  • ¥15 pycharm输出和导师的一样,但是标红
  • ¥15 想问问富文本拿到的html怎么转成docx的
  • ¥15 我看了您的文章,遇到了个问题。
  • ¥15 GitHubssh虚拟机连接不上
  • ¥15 装完kali之后下载Google输入法 重启电脑后出现以下状况 且退不出去 桌面消失 反复重启没用
  • ¥15 ESP-IDP-BLE配网连接wifi