删除记录，如果它存在于php / PDO中[重复](Deleting record if it exists in php/PDO [duplicate])

 
 
 这个问题在这里已有答案： 
 
 
 
  
 检查行是否存在mysql 3答案 
 
 
 
 
 我有一些代码从MySQL数据库中删除记录，但即使记录不存在，我也会收到成功消息。 如果记录不存在但找不到符合我代码的记录，我已经搜索了生成消息的方法。 
 
 我的代码是： 
 
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.';
?>
 
 请注意Fred-ii-你提到的答案是正确的，但我问的问题中的术语是不同的。 我问如何确保我删除的RECORD存在。 我没有问如何检查一行是否存在，并且当我在寻找现有的RECORD时，我从未想过要搜索有关现有ROW的任何内容。 对于像你这样的专家来说，一行可能和唱片一样，但是我和其他像我这样不那么开明的人从来没有听过一个叫做行的记录。 祝福，Tog 

 
 
This question already has an answer here:
 
 
 
  
 check if row exists with mysql  3 answers  
 
 
 
 
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

原文：https://stackoverflow.com/questions/44305738