php - 如何使用 mysqli dbdriver 知道行是否被删除

Question

我正在使用 codeigniter 2.1.0 和 mysqli dbdriver。我有以下查询，想知道何时成功

$query = $this->db->query("delete FROM abc WHERE id IN (" . $IdList . ")");

如何知道相关行是否被删除？

Answer 1

$this->db->affected_rows() 就是您要查找的内容。您应该能够将该结果与预期的已删除行数进行比较。

同时引用USER GUIDE

Displays the number of affected rows, when doing "write" type queries (insert, update, etc.).

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.