how to loop this output in codeigniter view

Question

I am returning 2 result query from model to view. so, in controller i am just printing the this array by print_r($data) function. i dont know how to loop this result in my view

this is the result i am getting in the controller from the model. so how can i loop through the data.

Array ( [value] => Grocery 
[products] => Array ( [0] => Array ( [query1] => Array ( [0] => stdClass Object ( [parent_category] => Beverages ) [1] => stdClass Object ( [parent_category] => Household ) ) [query2] => Array ( [0] => stdClass Object ( [product_name] => Britannia Cake - Fruity Fun ) [1] => stdClass Object ( [product_name] => Tetley Green Tea - Long Leaf ) [2] => stdClass Object ( [product_name] => Tetley Green Tea - Lemon ) [3] => stdClass Object ( [product_name] => AVT Gold Cup Premium Dust Tea ) [4] => stdClass Object ( [product_name] => Brooke Bond Red Label Tea ) [5] => stdClass Object ( [product_name] => sd sdsds s ) [6] => stdClass Object ( [product_name] => sds dfcs ) [7] => stdClass Object ( [product_name] => fhgg ) [8] => stdClass Object ( [product_name] => hearts ) [9] => stdClass Object ( [product_name] => banana ) [10] => stdClass Object ( [product_name] => hearts ) ) ) ) )

Model

 $query3=$this->db->select('product_name')
                      ->from('materials')
                      ->where('category',$value)
                      ->get();
                      $data=array();
                      if($query3->num_rows() > 0)
                      {
                          //$data['category'] = $this->test($value,$location);
                            $query4=$this->db->select('parent_category')
                          ->distinct()
                          ->from('materials')
                         ->where('category',$value)
                         ->where('warehouse_id',$location)
                         ->group_by('parent_category')
                                               ->get();
                          if($query4->num_rows() > 0)
                          {

                            $data['query1']= $query4->result();

                          }
                            $data['query2']=$query3->result();
                          //print_r($data);

                          return $data=array($data);
                      }

Controller

$data['value'] = $this->input->post('newparam');
$data['products']=$this->Search_model->getItems($data['value'],$location);
print_r(  $data);

View

<?php foreach ($query2 as $product){ ?>


        <tr>
                <td><?php echo $product->product_name?></td>

        </tr>


<?php } ?></table>

Bryan Lee · Accepted Answer · 2017-10-24 10:15:29Z

Assuming your $products variable has the following data structure :

[products] => Array ( 
            [0] => Array ( 
                    [query1] => Array ( 
                            [0] => stdClass Object ( [parent_category] => Beverages ) 
                            [1] => stdClass Object ( [parent_category] => Household ) ) 
                    [query2] => Array ( 
                            [0] => stdClass Object ( [product_name] => Britannia Cake - Fruity Fun ) 
                            [1] => stdClass Object ( [product_name] => Tetley Green Tea - Long Leaf ) 
                            [2] => stdClass Object ( [product_name] => Tetley Green Tea - Lemon ) 
                            [3] => stdClass Object ( [product_name] => AVT Gold Cup Premium Dust Tea ) 
                            [4] => stdClass Object ( [product_name] => Brooke Bond Red Label Tea ) 
                            [5] => stdClass Object ( [product_name] => sd sdsds s ) 
                            [6] => stdClass Object ( [product_name] => sds dfcs ) 
                            [7] => stdClass Object ( [product_name] => fhgg ) 
                            [8] => stdClass Object ( [product_name] => hearts ) 
                            [9] => stdClass Object ( [product_name] => banana ) 
                            [10] => stdClass Object ( [product_name] => hearts ) 
                    ) 
            ) 
        )

Then to loop through the data in the query2 array, you could do :

<?php foreach($products[0]['query2'] as $product) { ?>
    <tr>
        <td><?php echo $product->product_name;?></td>
    </tr>
<?php } ?>

romal tandel · Accepted Answer · 2017-10-24 10:07:44Z

1

pass data in controller like this

$this->load->view('myview', $data);

try this in view

<?php
foreach ($products as $prod){
    $query1 = $prod['query1'];
    $query2 = $prod['query2'];
}
foreach($query2 as $product){?>
    <tr>
                <td><?php echo $product->product_name?></td>

        </tr>
<?php
}
?>

answered Oct 24, 2017 at 10:07

romal tandel

50113 silver badges22 bronze badges

Comments

Akshay Hegde · Accepted Answer · 2017-10-24 10:09:14Z

1

You have to pass data to your view, like below

/* This is in your controller */
$data['value'] = $this->input->post('newparam');
$data['products']=$this->Search_model->getItems($data['value'],$location);

/* say your view file is myview.php then */
$this->load->view('myview', $data);

in you view (myview.php), you get two variables

<?php print_r($products);?>
<?php print_r($value);?>

and iterate like below

<table>
<?php foreach ($products[0]['query2'] as $product): ?>
        <tr>
                <td><?php echo $product->product_name?></td>
        </tr>
<?php endforeach;?>
</table>

edited Oct 24, 2017 at 10:09

answered Oct 24, 2017 at 9:57

Akshay Hegde

17.1k2 gold badges25 silver badges39 bronze badges

2 Comments

noushad mohammed Over a year ago

i am able print the data but i just want to loop through it

Akshay Hegde Over a year ago

see added how to loop also for $products[0]['query2'], since you got return $data=array($data); in your model, otherwise you can just use $products['query2']

ivanavitdev · Accepted Answer · 2017-10-24 09:56:53Z

0

Pass the data from controller to view then loop it inside the view

CONTROLLER

  function index(){
    $data['value'] = $this->input->post('newparam');
    $data['products']=$this->Search_model->getItems($data['value'],$location);
    $this->load->view("pages/extras/php/content", $data);
  }

VIEW

<?php

  echo $value;

  foreach ($products as $key => $value) {
    //do whatever you want
  }
?>

See https://www.codeigniter.com/user_guide/general/views.html for more examples

answered Oct 24, 2017 at 9:56

ivanavitdev

2,9583 gold badges14 silver badges24 bronze badges

2 Comments

noushad mohammed Over a year ago

how to loop throght inside associative array

noushad mohammed Over a year ago

<?php echo $products[$key]["product_name"]; ?> this is wnot working

Collectives™ on Stack Overflow

how to loop this output in codeigniter view

4 Answers 4

Comments

Comments

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related