accessing result array in codeigniter

Question

I have the following happening in my model:

public function load_user_menu($username)
    {
        $this->db->select('*');
        $this->db->from('menu');
        $this->db->where('username', $username);
        $query = $this->db->get();
        return $query->result();
    }

and the following in my controller:

public function index()
    {     
        /*If user previously logged in and not logged out, username remains in session.
            load username and load profile data. 
        */
        //check if user logged in or not
        if(($this->session->userdata('username')!=""))
        {
            //load data from model
            $profile = array();
            $username = $this->session->userdata('username');
            $result = $this->profileModel->user_profile($username);
             foreach($result as &$value)
              {
                  $profile['userdetails'] = $value;
              }
            $this->load->view('profile', $profile);
        }else{
            //redirect to login function
            $this->login();
        }
    }

but I am getting errors on profile view. I am sure I am accessing them wrong because I am doing this on view:

<? echo $userdetails['profilepic']; ?>

and nothing is showing but this error:

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/profile.php

Line Number: 60

which am certain because of the wrong accessing. How can I access the details based on the above?

Where is $userdetails['profilepic']; in your code? The error says there is nothing to get from that variable, defiantly there isn't anything fetched into $userdetails['profilepic'];. — MahanGM
– MahanGM, Commented Apr 12, 2013 at 9:57

bipen · Accepted Answer · 2013-04-12 09:57:21Z

3

assumming you have profilepic inside userdetails and seeing the error you are trying to get he property of nonobject that means

 <? echo $userdetails['profilepic']; ?>

should be

 <? echo $userdetails->profilepic; ?>

since you are taking you result as object and not array

return $query->result();

or you change this to

return $query->result_array();

answered Apr 12, 2013 at 9:57

bipen

36.6k9 gold badges51 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

bipen · Accepted Answer · 2013-04-12 09:59:22Z

1

$query->result(); produces an object; $query->result_array(); gives you an array

either is fine, depending on your needs

edited Apr 12, 2013 at 9:59

bipen

36.6k9 gold badges51 silver badges62 bronze badges

answered Apr 12, 2013 at 9:58

jmadsen

3,6552 gold badges37 silver badges49 bronze badges

1 Comment

jmadsen Over a year ago

I guess we don't need comments and edits when two people are typing at the same time; happens alot

Muhammad Sadiq · Accepted Answer · 2015-08-01 10:28:18Z

0

-There is no need of foreach loop in your controller as

$result = $this->profileModel->user_profile($username);
             foreach($result as &$value)
              {
                  $profile['userdetails'] = $value;
              }

-Try this instead.

$profile['userdetails'] = $this->profileModel->user_profile($username);

-To Access in View,use this as

echo $userdetails->profilepic;

answered Aug 1, 2015 at 10:28

Muhammad Sadiq

1,16511 silver badges14 bronze badges

Comments

Nilesh Mahajan · Accepted Answer · 2013-04-13 07:56:00Z

-1

just try this on your view page

<? echo $profilepic; ?>

answered Apr 13, 2013 at 7:56

Nilesh Mahajan

6175 silver badges17 bronze badges

Collectives™ on Stack Overflow

accessing result array in codeigniter

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related