CodeIgniter query builder SELECT query with JOIN clause [duplicate]

Question

This is my categories. If I click on a category then it goes to its view page, and show all products related with this selected category.

I am trying like this, but it is not working. I am using 3 tables for this situation.

1.categories

2.products 3.product_cat

Controller:

<?php 
class Clothing extends Controller{
    
    function product_details(){
        $id=$this->uri->segment(3);
        
        $this->load->model('Products_model');
        $data['products']=$this->Products_model->product_details($id);
        
        //$this->load->view('clothe',$data);
    }
}

?>

Model:

<?php
class Products_model extends Model {
    function product_details($id){
                    $query=$this->db->select("*")
                    ->from("product_cat")
                    ->where("categories_id",$id);
                    return $query;
        }
    }

View:

<html>
    <head></head>
    <body>
        
        <?php  foreach ($products as $v_menu) { ?>
                    <?php echo $v_menu; ?>
        <?php } ?>
    </body>
</html>

In model modify your query as $query=$this->db->select("*") ->from("product_cat") ->where("categories_id",$id)->get()->result(); — Gopal Sharma
– Gopal Sharma, Commented Sep 20, 2015 at 16:32
Version of CodeIgniter you are using is old at least more than 6 years now and it is not considered as secure one. Port your code to v 3.0.x — Tpojka
– Tpojka, Commented Sep 20, 2015 at 17:42
can you please, i got the product id's related with category id? and now how can i fetch the product details using this product id from the table products given above in the image? — Aruna Chakraborty
– Aruna Chakraborty, Commented Sep 20, 2015 at 18:22
I tried like this: $results= $this->db->select("*") ->from("products") ->where("id",$key)->get()->result(); — Aruna Chakraborty
– Aruna Chakraborty, Commented Sep 20, 2015 at 18:58

Sanjuktha · Accepted Answer · 2015-09-21 02:31:10Z

1

You can join the two tables products and product_cat as below so that you can get the product details too-

return $query=$this->db->select('*')
        ->from('product a')
        ->from('product_cat p')
        ->where("p.product_id = a.id")
        ->where('p.categories_id =', $id)
        ->get()->result();

answered Sep 21, 2015 at 2:31

Sanjuktha

1,0813 gold badges13 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

CodeIgniter query builder SELECT query with JOIN clause [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related