php - AJAX更新和删除错误但仍然成功错误

Question

** 更新删除时出现问题，输入列id错误，虽然数据库没有变化，但系统还是报成功**

$loai = trim($_POST['loai']);
 $id = trim($_POST['id']);
    $ten = trim($_POST['ten']);
    $idghichu = trim($_POST['idghichu']);
$sql;
$conn = new mysqli('localhost','root','12345678','chamcomvantay');
if($loai == "xoa") {
$sql = "DELETE FROM chamcomvantay.tb_bophan WHERE ID='$id' ";
 }
elseif ($loai == "sua") {
    $sql = "UPDATE chamcomvantay.tb_bophan SET TENBP='$ten', GHICHU='$idghichu' WHERE ID='$id'   ";
}
if(mysqli_query($conn, $sql)) {

echo "success";    // This is an error //

 } else {
  echo "Lỗi";
}

$conn->close();
?>

--my ajax code---- 

$idbophan  = $('#idbophan').val();   
$idten =  $('#idten').val();
$idghichu = $('#idghichu').val();
$loai = "sua";
if($idbophan.trim() != "" ){
$.post('thaotacbophan.php',{'id':$idbophan.trim(),'ten': $idten.trim(),'idghichu':$idghichu.trim(),'loai':$loai.trim()}, function(data){
alert(data); // error but still alert("success"); ///
  });
}
else{
  alert("Vui lòng điền đầy đủ thông tin");
}

标签： phpajax