M temp

public function tambah($data)
    {
        $this->db->insert('routemap', $data);
        $getData = $this->makeTemp($data);
        return $getData;
    }

public function makeTemp($data)
    {
        $temp = " CREATE TEMPORARY TABLE temp_table_1 (
                    `nohp` varchar(20),
                    `nmsal` varchar(40),
                    `hari` varchar(10),
                    `nors` varchar(20),
                    `nmrs` varchar(40),
                    `lat` varchar(30),
                    `long` varchar(30),
                    `user` varchar(10)
                    );
                  ";

        $this->db->query($temp);
        $this->db->insert('temp_table_1',$data);
        $export = $this->db->get('temp_table_1')->result();
        return $export;
    }