Styling rows in table that uses CSV data through PHP

Question

I've been working on this simple code that puts a CSV file into a nice table. But because the data is imported, styling ODD rows is a pretty hard thing to do.

All I need would be a method to address certain rows, so I can make a "zebra" like background, and put specific data in another text style.

Does aynone have an idea? thanks a lot!

<?php
print("<TABLE>\n");
$row = 0;
$handle = fopen("test_file.csv", "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
   $num = count($data);
   for ($c=0; $c <= $row; $c++)
{
    print("<TR>");
    print("<TD>".$data[0]." </td>");
    print("<TD>".$data[1]." </td>");
    print("<TD>".$data[2]." </td>");
    print("<TD>".$data[3]." </td>");
    print("<TD>".$data[4]." </td>");
    print("</TR>"); 
}
}
fclose($handle);

?>

jathanism · Accepted Answer · 2009-11-18 15:15:18Z

There is a jQuery plugin called TableSorter that allows for the zebra-style coloring and also adds the ability to to click-to-sort rows. It is very easy to integrate.

This is not a pure PHP solution, but in the majority of cases you're going to end up having to code CSS and JavaScript anyways, so this ends up saving a lot of time and prevents you from hard-coding that stuff into your PHP logic.

First you link the scripts in the <head> of your document:

<script type="text/javascript" src="/path/to/jquery-latest.js"></script> 
<script type="text/javascript" src="/path/to/jquery.tablesorter.js"></script>

Then you make sure your table has <thead> and <tbody> elements:

<table id="myTable"> 
<thead> 
<tr> 
    <th>Last Name</th> 
    <th>First Name</th> 
    <th>Email</th> 
    <th>Due</th> 
    <th>Web Site</th> 
</tr> 
</thead> 
<tbody> 
<tr>
    <td>...
...
</tbody>
</table>

End then you enable it with jQuery:

$(document).ready(function() 
    { 
        $("#myTable").tablesorter({ widgets: ['zebra'] }); 
    } 
);

RageZ · Accepted Answer · 2009-11-18 04:24:47Z

1

what about

print("<TR class='" . ($c%2 == 0?'even':'odd')."'>");

after you can add the proper CSS

.even {
  background-color: #aaaaaa; 
}

.odd {
  background-color: #fffff; 
}

answered Nov 18, 2009 at 4:24

RageZ

27.3k12 gold badges72 silver badges76 bronze badges

Comments

cletus · Accepted Answer · 2009-11-18 04:56:49Z

1

Use something like:

<table>
<tbody>
<?php
$row = 0;
$handle = fopen('test_file.csv', 'r');
while ($data = fgetcsv($handle, 1000, ',')):
  $class = ++$row & 1 == 1 ? ' class="odd"' : '';
  $num = count($data);
?>
<tr<?php echo $class; ?>>
<?php for ($c=0; $c <= $num; $c++) {
  <td><?php echo $data[$c]; ?></td>
<?php endfor; ?>
</tr>
<?php endwhile; ?>
</tbody>
</table>
<?php fclose($handle); ?>

with:

tr.odd td { background: #CCC; }

Or with short tags (which I personally prefer):

<table>
<tbody>
<?
$row = 0;
$handle = fopen('test_file.csv', 'r');
while ($data = fgetcsv($handle, 1000, ',')):
  $class = ++$row & 1 == 1 ? ' class="odd"' : '';
  $num = count($data);
?>
<tr<?= $class ?>>
<? for ($c=0; $c <= $num; $c++) {
  <td><?= $data[$c]; ?></td>
<? endfor; ?>
</tr>
<? endwhile; ?>
</tbody>
</table>
<? fclose($handle); ?>

edited Nov 18, 2009 at 4:56

answered Nov 18, 2009 at 4:36

cletus

627k169 gold badges922 silver badges945 bronze badges

1 Comment

Justin Johnson Over a year ago

You've got for ($c=0; $c <= $num; $c++) { and endfor;

Collectives™ on Stack Overflow

Styling rows in table that uses CSV data through PHP

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related