CODEWITHSUNDEEP
phpcodeigniter
Aruna Chakraborty
Aruna Chakraborty

Reputation: 45

Fetching data using where clause

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. enter image description here

I am trying like this.But it is not working.Can you please anyone help me to solve this problem?I am using 3 tables for this situation. 1.categoriesenter image description herecategories table

2.products enter image description here 3.product_cat

enter image description here

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>

Upvotes: 1

Views: 56

Answers (1)

Sanjuktha
Sanjuktha

Reputation: 1085

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

Upvotes: 1

Related Questions