query builder insert select

bisa seharusnya gan, sudah dicoba?

maksudnya saya mau pakai

 $this->db->select

gini gan

Bisa, Ada dua cara untuk melakukannya:

1. Dengan DB->query langsung

 $query = $this->db->query('INSERT california_authors (au_id, au_lname, au_fname)
                           SELECT au_id, au_lname, au_fname
                           FROM authors
                           WHERE State = \'CA\'');

2. Atau dengan cek select nya dulu, baru di DB->insert

 $select = $this->db->select('au_id, au_lname, au_fname')->where('state', 'CA')>get('california_authors');
if($select->num_rows())
{
    $insert = $this->db->insert('california_authors', $select->result_array());
}
else
{
/* there is nothing to insert *
}

Sumber: https://stackoverflow.com/questions/3360631/how-to-insert-records-using-select-in-codeigniter-active-record