Codeigniter :adding values to array using get_where

Question

i am getting values from datbase using get_where clause for my login like this

Controller:

public function  submit_login(){
            if($this->input->post('submit')){
                $email= $this->input->post('email');
                $password= $this->input->post('password');
                $this->load->model('user_model');
                $result= $this->user_model->login($email, $password);

              print_r($result);
            }
        }

Model

public function login($email, $password){
        $query=$this->db->get_where('user',array('email'=>$email,'password'=>$password));
             if($query->num_rows()>0){
                return $query->result();
            }
        return false ; 
    }

it returns followint array

Array ( [0] => stdClass Object ( [id] => 2 [name] => Sikander [email] => [email protected] [password] => password [mobile_number] => 1234 [role] => seller [points] => 0 ) )

Now i tried to loop this and assign id to sesion but foreach does not seem to work with this , dont know why pleas help

Tpojka · Accepted Answer · 2016-06-20 23:32:44Z

2

Application should work in matter model returns only one result. Which you have there. As you see you got an array with one element [0] that is an object. Following OOP approach you can reach those properties (values) by:

$result[0]->id;

Alternatively, as one row from database is expected, in model you can return:

return $query->row();

and check it by

$result->id

If array syntax is more convinient for you to iterate, you can use

$query->result_array()

or

$query->row_array()

methods. There is plenty of useful examples in docs.

answered Jun 20, 2016 at 23:32

Tpojka

7,0812 gold badges32 silver badges41 bronze badges

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

Comments

Mohit maru · Accepted Answer · 2016-06-28 08:36:04Z

0

public function login($email, $password){
    $query=$this->db->get_where('user',array('email'=>$email,'password'=>$password));
         if($query->num_rows()>0){
            return $query->result();
        }
    return false ; 
}

IN your code return $query->result(); give array with object so in

foreach ($users as $user) {
                  echo $user->email; // what ever your table fields          

                        }

If you want only single value form the query so you need to return $query->result(); replace with

return $query->row(); // this return as object  or 
return $query->row_array();// this return as single array

answered Jun 28, 2016 at 8:36

Mohit maru

8238 silver badges15 bronze badges

Collectives™ on Stack Overflow

Codeigniter :adding values to array using get_where

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