Confirming deletion of record in mysql php

Question

I m trying to delete a row in php mysql. The row is deleted quiet ok but mysqli_affected_rows($conn) is not giving a response so I can confirm the deletion for the user.

 $sql="DELETE FROM `users` WHERE `memberID`='$id'";
 $res=mysqli_query($conn,$sql);
 if(mysqli_affected_rows($conn) == 1){
     echo 'success'
 } else {
     echo "The User could not be deleted due to some error";
     echo mysqli_affected_rows($conn);
 }

Answer 1

You don't need to check by boolean value 0 or 1. But if you want to do it that way, you will need to declare a flag before that and then change the flag value according to condition after that you can do it [as your way]

(mysqli_affected_rows($conn) == 1)

But as default a simple if() conditon will check and return true on pass and false on fail.

So, simply you can do:

if($res)
{
//your codes if query is done
} else
{
//your codes if query fails
}