Answers for "codeigniter query in model"

get result count codeigniter

public function record_count() {
   return $this->db->count_all("tablename");
}

codeigniter where_not_in

$names = array('Frank', 'Todd', 'James');
$this->db->where_not_in('username', $names);
// Produces: WHERE username NOT IN ('Frank', 'Todd', 'James')