php - PHP否则不起作用

Question

为什么我的最后一个 else$msg不起作用？即使我这样做是正确的。请帮助并解决我的问题。

代码：

 //Cancel button start
 if (isset($_POST['cncl'])) {
     $sql = "DELETE FROM users WHERE Email_ID='$email' AND token='$token' AND isEmailConfirmed='PENDING' AND isMobileConfirmed='PENDING'";
     ///     
     if ($con - > query($sql) === TRUE) {
         $msg = "<div class='alert-box success'><span>Registration cancelled. < /
         span > < /div > ";
     } else {
         $msg = "<div class='alert-box warning'><span>Registration cancelled! Please signup again if you create again!</span> < /
         div > ";
     }

     ///
 }
 //Cancel button end

标签： php

Answer 1

您可以检查，是否记录删除。

if (isset($_POST['cncl'])) {
     $result = $con->query("DELETE FROM users WHERE Email_ID='$email' AND token='$token' AND isEmailConfirmed='PENDING' AND isMobileConfirmed='PENDING'");
     ///     
     if ((mysql_affected_rows($con) > 0) ) {
         $msg = "<div class='alert-box success'><span>Registration cancelled. < /
         span > < /div > ";
     } else {
         $msg = "<div class='alert-box warning'><span>Registration cancelled! Please signup again if you create again!</span> < /
         div > ";
     }

如果返回值大于 0 则记录被删除，如果返回 0 则记录不被删除。