public function addImage() { $this->db->trans_start(); //transaction starts $query = "insert into image_info(user_id,image_type,id) values('" . $this->user_id . "','" . $this->image_type . "','" . $this->id . "')"; $this->db->query($query); $insert_id = $this->db->insert_id(); $this->db->trans_complete(); //transaction ends $query = "select * from image_info where image_id='" . $insert_id . "'"; $records = $this->db->query($query); return Image_info::instantiateSingle($records); }