formatting query results

gafro

Posted: 13 October 2008 04:15 AM

[ Ignore ]

Summer Student

Total Posts: 14

Joined 03-16-2007

Hey Guys and Gals,

Looking for some info with the results received from a query.

overview example:

DB (table name = items)

id name
1 titleone
2 titletwo
3 titlethree
4 titlefour

Controller

$this->db-get(‘items’);

view

<li><?=$item->titleon?></li>
<?php endforeach;?>
</ul>

What I’d like to do is add a class to the li on every 3rd row.

<ul>
<li>itemone</li>
<li>itemtwo</li>
<li class=“classname”>itemthree</li>
<li>itemfour</li>
</ul>

I’m not sure how to get access to the keys from the array the active record has returned.

Can anyone shed some light or point me in the right direction.

Cheers all
Gafroninja

Profile

Steve Grant

Posted: 13 October 2008 05:05 AM

[ Ignore ] [ # 1 ]

Summer Student

Total Posts: 19

Joined 03-17-2008

gafro - 13 October 2008 04:15 AM
<?php foreach($items-result() as $item):?>

<li><?=$item->titleon?></li>
<?php endforeach;?>
</ul>

What I’d like to do is add a class to the li on every 3rd row.

<ul>
<li>itemone</li>
<li>itemtwo</li>
<li class=“classname”>itemthree</li>
<li>itemfour</li>
</ul>

I’m not sure how to get access to the keys from the array the active record has returned.

Can anyone shed some light or point me in the right direction.

Cheers all
Gafroninja

Your best bet is probably to use a for loop rather than foreach, as you then effectively create your own array indexing.

Something like…

<ul>
<?php for($i = 0; $i < count($items); $i++): ?>
  <?php $item = $items->result(); ?>
  <li<?php if(($i + 1) % 3 == 0): ?> class="classname"<?php endif; ?>><?php echo $item->name; ?>
<?php endfor; ?>
</ul> 

Profile

John_Betong

Posted: 13 October 2008 05:09 AM

[ Ignore ] [ # 2 ]

Research Assistant

Total Posts: 390

Joined 12-26-2006

Try:

<?php foreach($items-result() as $item):?>
    </php if ('itemthree' == $item) { ?>   
      <li class='classname'><?=$item->titleon?></li>
    <?php }else{ ?>     
      <li><?=$item->titleon?></li>
    <?php } ?>
  <?php endforeach;?>
  
OR this may work...

  <?php foreach($items-result() as $item): ?>

    <?php $class = ('itemthree' == $item) : "class='classname'" : '' ?>   

    <?= "<li $class" .'<'  .$item->titleon .'</li>' ?>

  <?php endforeach; ?> 

Signature

Real life ... (development site)
My Hippy Trail Source code
Latest Project

Profile

gafro

Posted: 13 October 2008 05:16 AM

[ Ignore ] [ # 3 ]

Summer Student

Total Posts: 14

Joined 03-16-2007

@Steve grant - Cheers I’ll give that a go.

@John Betong - That is a solution for that particular example. I would need to do a check for itemsix, itemnine and so on. Thanks for the help.

If there’s another way to actually access the array index let me know:D

Cheers everyone.

Gafro

Profile

John_Betong

Posted: 13 October 2008 07:44 AM

[ Ignore ] [ # 4 ]

Research Assistant

Total Posts: 390

Joined 12-26-2006

Hi Gafro,

Try this:

Controller:

//========================================================  
  function index($data=array())  {
    for($i2=0; $i2<10; $i2++) {
      $data['customers'][] = array(
                                    'Name',
                                    'Title: 1',
                                    'Title: 2',
                                    'Title: 3',
                                    'email',
                                    'address: 1',
                                    'address: 2',
                                    'address: 3',
                                    'address: 4',
                                    'City:',
                                    'Country:',
                                    'Zip code',
                                    'Tel:',
                                    'Fax:',
                                    'Source:'
                                  );
    }//endforeach
    
    $total_fields = count($data['customers'][0]);
    for($i2=0; $i2<$total_fields; $i2++) {
        switch($i2) {
              case 0: $style="font-size:14px; font-weight:bold";              break; // Name
              case 1:
              case 2:
              case 3: $style="font-size:12px; color:#00f'";   break; // Title
              case 4: $style="font-size:16px; color:#f00";    break; // Email
              case 5:
              case 6:
              case 7:
              case 8: $style="font-size:14px; color:#060";    break; //  Tel
              case 9: 
              case 10: $style="font-size:16px; color:#00f";    break; // City, Country
              case 11: $style="font-size:18px; color:#060";    break; // Zip code
              case 12:
              case 13: $style="font-size:12px; color:#009";    break; // Tel, Fax
              case 14: $style="font-size:22px; color:#009";    break; // Source
              break;   echo 'Should never get here';
        }//endswitch      
        $data['style'][$i2] = $style;
    }//endfornext loop  
      
      if (FALSE) {
        echo '<pre>';
          print_r($data);
        echo '</pre>';
      }  
    // }//endfornext14:44 10/10/2008;
    // die;
    $data['footer'] = $this->load->view('_footer',  $data, TRUE);
    $output         = $this->load->view('_ci_forums_viewthread_93697',    $data, TRUE);
    echo $output;
  }//endfunc 

View:

<div style='width:500px; margin:1em auto 14em; scroll:auto; border:solid 1px #ddd; text-align:left'>
      
      <div style='float:left; width:60%; margin:1em auto 0 1em; border:solid 1px #bbb'>
      
        <p style='width:90%; margin:2em auto''>
          <?php foreach($customers as $customer): ?>
            <?php for($i2=0; $i2<count($customer); $i2++) { ?>
              <?= "<span style='$style[$i2]'>" .$customer[$i2] .'</span><br />'?>
            <?php } ?>
            <?= br(3) ?>
          <?php endforeach    ?>
        </p>  
        
      </div>

    </div> 

You can see the results Here

Signature

Real life ... (development site)
My Hippy Trail Source code
Latest Project

Profile

xwero

Posted: 13 October 2008 07:55 AM

[ Ignore ] [ # 5 ]

Sr. Research Associate

Total Posts: 4830

Joined 07-14-2006

Steve Grant - 13 October 2008 05:05 AM
Your best bet is probably to use a for loop rather than foreach, as you then effectively create your own array indexing.

Something like…
<ul> <?php for($i = 0; $i < count($items); $i++): ?> <?php $item = $items->result(); ?> <li<?php if(($i + 1) % 3 == 0): ?> class="classname"<?php endif; ?>><?php echo $item->name; ?> <?php endfor; ?> </ul>

You can do it with a foreach loop by using the key.

<ul><?php foreach($items as $i=>$item): ?>
<li<?php if(($i+1) % 3 == 0) echo ' class="classname"' ?>><?php echo $item->name ?></li><?php endforeach ?>
</ul> 

Profile

gafro

Posted: 13 October 2008 08:24 AM

[ Ignore ] [ # 6 ]

Summer Student

Total Posts: 14

Joined 03-16-2007

Excellant. I think that’s what I was looking for.

Thanks for the help all

Profile

‹‹ Screen renders differently Question about multiple databases ››

Username		Remember Me?
Password		forgot password?

Post Marker Legend
	New posts	Hot Topic with new posts	New Poll	Moved Topic	Sticky topic
	No new posts	Hot Topic with no new posts	Old Poll	Closed Topic	Announcements

Visitor Statistics
The most visitors ever was 719, on June 06, 2008 10:16 AM
Total Registered Members:	77571	Total Logged-in Users:	20
Total Topics:	101561	Total Anonymous Users:	2
Total Replies:	544409	Total Guests:	182
Total Posts:	645970