getting the value of the single field output using the codeigniter active record

Use row() like,

return $this->db->get()->row()->name;

Use row() for a single row, and result() for multiple rows.