Question

如何知道代码符中删除的行没有行, 前提是 $this- gt; db- gt; db- gt; effect_ rows () 每次在成功或失败时返回 < code> 。

Answer 1

如何知道代码编辑器中删除的行没有删除的行, 前提是 $this- gt; db- gt; db- gt; effect_ rows () 每次在成功或失败时也返回 $this- gt; db- gt; effect_ rows () 。

我不使用 CodeIgniter, 但通常情况下, impacted_rows () 应该返回受影响的行数。这意味着, 如果查询成功, 它应该 ways 是一个整数。如果返回 0, 如果 & gt; 0, 则不删除行数。

Answer 2

$this->db->where($conditions)->delete( mytable );
return $this->db->affected_rows();

Answer 3

您是否测试过它, 根据代码编辑网站, 有一个黑客返回正确的行数, 默认打开。

http://codigniter.com/user_guide/database/ helps.html

Answer 4

根据Codigniter 用户guide ,它返回正确的行数:

"Note: In MySQL "DELETE FROM TABLE" returns 0 affected rows. The database class has a small hack that allows it to return the correct number of affected rows. By default this hack is enabled but it can be turned off in the database driver file."

因此,这项工作应:

 $this->db->delete( 1 ,  your_table );
 echo ($this->db->affected_rows()." rows were deleted");

如果它不起作用,那么就做做一个非理想的变通办法

$count = $this->db->count_all( your_table );
$this->db->delete( 1 ,  your_table );
$new_count = $this->db->count_all( your_table );
if ($new_count > $count)
{
    echo (($new_count-$count)." rows was deleted");
}
else
{
    echo "nothing deleted";
}

Answer 5

That would help if you were more specific, with example... But you can perform a SELECT COUNT(*) before deletion and after and compare the two results.

友情链接