ansaurus

Question

Answer 1

+1 A:

With CodeIgniter, one way to loop through query results is like so:

//if your doing your queries in a controller
$data['query']=$this->db->query('SELECT * FROM purchases WHERE clientID=5');

//or if using models
$data['query']=$this->pmnt_model->getPmnts();

//view
foreach($query result() as $row){
    echo $row->date;
}

the $query variable is the result array returned from the mysql query. The objects can be accessed via the -> operator.

See http://codeigniter.com/user_guide/database/results.html for more info.

You also might want to check out the active record class.

HTH

stormdrain 2010-07-16 13:40:34

Answer 2

A:

There are two possibilities that i can see see to accomplish what you need. Here is one; send two arrays to your view, one containing just the dates and the other containing the purchase information:

In the controller

$page_data['purchase_dates'] = $this->yourmodel->get_purchase_dates($record_id);
$page_data['purchases'] = $this->yourmodel->get_purchases($record_id);

Note Make sure you use GROUP BY in your database query for the purchase dates.

In the View

<!-- Start Outer Tree Loop -->
<?php if($purchase_dates != FALSE){?>
<?php foreach($purchase_dates as $id=>$outer_value) { ?>
<!-- Output the date here -->
  <!-- Start Purchase table -->
  <table>
  <tr>
  <th>Param One</th>
  <th>Param Two</th>
  <th>Etcetera</th>
  <th></th>
  </tr>

  <!-- Start inner loop -->
  <?php foreach($purchases as $id=>$inner_value) { ?>
   <?php if($inner_value['purchase_date'] == $outer_value['purchase_date']) { ?>
    <tr>
    <td><?php echo $inner_value['Param One'] ?> </td>
    <td><?php echo $inner_value['Param Two'] ?></td>
    <td><?php echo $inner_value['Etcetera'] ?> </td>
   </tr>
   <?php  } ?>
  <?php  } ?>
  <!-- End inner loop -->

  </table>
  <!-- End Purchase table -->

<?php } ?>
<?php }?>
<!-- End Outer Tree Loop -->

I have added comments to illustrate the code (this may be the best option for you as the array you posted is two dimensional).

The second: is to send a three dimensional array to the view and loop through it in a very similar fashion as above.

<?php if($purchases != FALSE){?>
<?php foreach($purchases as $id=>$purchase_day) { ?>

<?php foreach($purchase_day as $purchase) { ?>

<!-- Output here -->

<?php } ?>

<?php } ?>
<?php }?>

Hope this helps.

DRL 2010-07-16 18:01:34

ansaurus

tags:

views:

answers:

php loops and grouping mysql

related questions