如果主键被命名为“id”，那么如何使用CodeIgniter和Datamapper删除记录？

Question

I have a table named usuario, an entity with the same name, and the primary key is named idusuario. I can't delete it since the primary key isn't named "id". Is it possible to circumvent this limitation somehow?

Answer 1

This should work:

$this->db->delete('usuario', array('idusuario' => $value)); 

According to CodeIgniter's Active Record documentation:

The first parameter is the table name, the second is the where clause. You can also use the where() or or_where() functions instead of passing the data to the second parameter of the function: