CodeIgniter query builder script using session value in WHERE clause returns an empty result [closed]

Question

Closed. This question needs debugging details. It is not currently accepting answers.

Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question.

Closed yesterday.

Improve this 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();

In my local environment running CI3.1.11, your model script is valid and runs as expected. We don't know your version. We dont know if this is a code problem or a data problem. Is the session value definitely populated and accessible or are you getting a null value? Have you tried $this->session->userdata('id');? It is true that you don't need to explicitly mention the = but it is also harmless. This question Needs Debugging Details. — mickmackusa
– mickmackusa ♦, Commented yesterday

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 builder script using session value in WHERE clause returns an empty result [closed]

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related