1 Results found for "Active Record Codeigniter"

How To Write Subquery In Codeigniter Active Record

CodeIgniter Active Records do not currently support sub-queries, However I use the following approach: $this->db->select('id');$this->db->from('table');$where_clause = $this->db->_compile_select(false,true);$this->db->_reset_select();#Create main query$this->db->select('*');$this->db->from('table1');$this->db->where("`id` NOT IN ($where_clause)", NULL, FALSE);return $this->db->get('',null,null,true); _compile_select() and _reset_select() are two undocumented (AFAIK) methods which compile the query and return the sql (without running it) and reset the query.On the main query the FALSE in the where clause tells codeigniter not ... Continue