can't print a value from database in a view under codeigniter can't print a value from database in a view under codeigniter codeigniter codeigniter

can't print a value from database in a view under codeigniter


You need to update your code. You need to return first_name from the function get_name

function get_name() {        $this->db->select('first_name');        $this->db->where('email', $this->session->userdata('email'));        $query = $this->db->get('users');        if($query->num_rows() == 1) {            return $query->row()->first_name;        }    }

You also need to return the value from function show_name

function show_name() {    $this->load->model('users_model');    return $this->users_model->get_name();    }


Change your code like thisController

function profile(){    $this->load->model('users_model');    $name = $this->users_model->get_name();    if ($name){      $data['first_name'] = $name;      $this->load->view('members/template', $data);    }else{      ehco "No User Exist";      exit;    }}

Model

function get_name() {        $return =false;        $this->db->select('first_name');        $this->db->where('email', $this->session->userdata('email'));        $query = $this->db->get('users');        if($query->num_rows() == 1) {            $return = $query->row()->first_name;        }        return $return ;    }