codeigniter returning object

Question

I am selecting from database and data successfully coming back. I am just not sure how to access element of the array such as username or name or etc. This is the output:

Array ( [0] => stdClass Object ( [id] => 9 [fullname] => Ø®Ø§Ù„Ø¯ Ø§Ù„ØºØ§Ù…Ø¯ÙŠ [membership] => free [username] => kkkkk [password] => 16d7a4fca7442dda3ad93c9a726597e4 [email] => [email protected] [about] => [city] => riyadh [profilepic] => /home2/sdds/public_html/uploads/Red_velvet_cupcakes_with_roses.jpgRed_velvet_cupcakes_with_roses.jpg [mobile] => [telephone] => [address] => [gallery_link] => ) )

and this is the code in the model returning the above:

public function login()
{
    $this->db->select('*');
    $this->db->from('members');
    $this->db->where('username', $this->input->post('username'));
    $this->db->where('password', md5($this->input->post('password')));
    $query = $this->db->get();
    return $query->result();
}

So what to do here? thanks in advance

gave me this: Message: Object of class stdClass could not be converted to string — sys_debug
– sys_debug, Commented Apr 4, 2013 at 18:15
$query->result() returns an object, not an array. Use $query->result_array() instead if you want an array. It's a common mistake :) — user50049
– user50049, Commented Apr 4, 2013 at 18:29

Stack Programmer · Accepted Answer · 2019-03-27 15:41:22Z

1

please check this :

//model function in your model    
public function login()
    {
        $this->db->select('*');
        $this->db->from('members');
        $this->db->where('username', $this->input->post('username'));
        $this->db->where('password', md5($this->input->post('password')));
        $query = $this->db->get();
        return $query->row();
    }
   // in controller  
    $logindata = $this->YOUR_MODEL_NAME->login();
// access like this

    echo $logindata->fullname;

Ref: https://www.codeigniter.com/user_guide/database/results.html

edited Mar 27, 2019 at 15:41

Stack Programmer

6796 silver badges18 bronze badges

answered Apr 4, 2013 at 18:20

Syed Ahmed

1,6452 gold badges16 silver badges23 bronze badges

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

Comments

cartalot · Accepted Answer · 2013-04-05 00:04:35Z

0

piling on -- also be sure and check if you actually got anything in your model method

 // check how many records returned with num_rows()
 if ($query->num_rows() == 1) {

       // since there is just one record, use row()
       // when 2 or more records, use result() 
       return $query->row();
    }
    else
    { return false; }

that way in your controller you immediately know if anything came back and you can show the appropriate view.

  if(! $logindata = $this->login_model->login() ) { 
   // NO login data came back 
   //  show appropriate view

  else {
 // pass to data if you need it in the view 
  $data['logindata'] = $logindata ;
   // call and show the view  

 }

answered Apr 5, 2013 at 0:04

cartalot

3,1281 gold badge19 silver badges15 bronze badges

Collectives™ on Stack Overflow

codeigniter returning object

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related