codeigniter db-> delete（）总是返回true？ [英] codeigniter db->delete() returns true always?

问题描述

我已经显示带记录的表格和删除图像。对删除图像点击我使用ajax删除记录。 supose有三个记录，id为40,41,42
如果我删除ID = 40的记录，responce返回1和记录被删除，
下次如果我再次点击删除图像返回1。

codeigniters db-> delete（）方法总是返回1
我需要手动检查如果记录存在，然后继续删除？
下面是我的代码iin ajax.php

  $ res = $ this-> db-> delete tbl_user_groups，array（'owner_id'=> $ admin，'user_group_id'=> $ gid））; 
 
 if（$ res）echo json_encode（array（success=>true））; 
 else echo json_encode（array（success=>false））; 
  
 
 
解决方案
  db-> delete / strong>如果删除操作成功，返回 TRUE 。如果它不能删除该行，它只会返回 FALSE 。我想你应该检查像：
  $ this-> db-> affected_rows 
 
返回数字，而不是布尔值，您可以使用If条件检查。
 
i have displayed table with record and "Delete" image. on delete image click i am deleting the record using ajax. supose there are three records with id 40,41,42
if i delete record with ID = 40, responce returns "1" and record gets deleted,
next time if i again click on delete image it again returns "1".

codeigniters db->delete() method returns "1" always ?
do i need to check manually if record exists and then proceed to delete ?
below is my code iin ajax.php
$res = $this->db->delete(tbl_user_groups, array('owner_id' => $admin,'user_group_id'=>$gid)); 

if($res) echo json_encode (array("success"=>"true"));
else     echo json_encode (array("success"=>"false"));

解决方案
The db->delete() returns TRUE, if delete operation is successful. It would only return FALSE if it COULDN’T delete the row. I think you should be checking something like: 
$this->db->affected_rows();
which returns number and not a Boolean, which you can check with your If conditions.

                        
这篇关于codeigniter db-> delete（）总是返回true？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！