CodeIgniter query returns an empty array

Question

I have a JOIN query in CodeIgniter which returns an empty array.

My Controller part:

if ($this->session->has_userdata('user')) {

    $id = $this->session->user['id'];

    $where = ["products.user_id =" => $id];

    $status = $this->insertModel->get_status($where);

    $this->load->view('profile', ["status" => $status]);
}

My model:

return $this->db
        ->from('photos')
        ->join('products', 'photos.prod_id = products.id', 'left')
        ->where($where)
        ->get()
        ->result_array();

ok.... and what are you wanting it to return? What is your question exactly? — C. Peck
– C. Peck, Commented Mar 30, 2019 at 19:05

Vickel · Accepted Answer · 2019-03-31 00:34:54Z

2

in your controller, just send $id instead of $where

$status = $this->insertModel->get_status($id);

and rebuild your where clause in your model the Codeigniter way:

->where('products.user_id', $id)

see the docs here

and about MVC (Model=database interaction, View=browser output and Controller=your application logic)

edited Mar 31, 2019 at 0:34

answered Mar 30, 2019 at 19:21

Vickel

7,9806 gold badges40 silver badges63 bronze badges

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

Comments

M.Hemant · Accepted Answer · 2019-03-31 05:38:33Z

0

Controller:
Your error is in $where, check my code

if ($this->session->has_userdata('user')) {

    $id = $this->session->user['id'];

    //$where = ["products.user_id =" => $id];//old line
    $where = array("products.user_id" => $id);//new line

    $status = $this->insertModel->get_status($where);

    $this->load->view('profile', ["status" => $status]);
}

answered Mar 31, 2019 at 5:38

M.Hemant

2,3551 gold badge11 silver badges14 bronze badges

Collectives™ on Stack Overflow

CodeIgniter query returns an empty array

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