slashpine Posted December 27, 2008 Share Posted December 27, 2008 I am trying to add both column headings and alternating color rows to this script...can a php coder please code in an example of both in this script? Thanks <?php $filename = "file.csv"; function viewlog($filename) { $fp = fopen($filename,"r"); $file = fread($fp,65535); $replaced = eregi_replace(",", "<td>", $file); $replaced2 = eregi_replace("\n", "<tr><td>", $replaced); $replaced3 = eregi_replace("\r", "<tr><td>", $replaced2); fclose($fp); return $replaced3; } echo "<html><head><title></title></head><body bgcolor=silver>"; echo "<table border=1 bordercolor=black cellspacing=0 cellpadding=5 width=100% style='font-size:10pt'>"; echo viewlog($filename); echo "</table></body></html>"; exit; ?> Quote Link to comment Share on other sites More sharing options...
revraz Posted December 27, 2008 Share Posted December 27, 2008 Here is one way to do alternate row colors, not specific to your code, but easy to integrate. $color = "#ffffff"; $color1 = "#ffffff"; $color2 = "#99ffff"; while ($row = mysql_fetch_row($result)) { if ($color == $color1){ $color = $color2; }ELSE{ $color = $color1; } $id=$row[0]; echo "<tr bgcolor=$color>"; Quote Link to comment Share on other sites More sharing options...
genericnumber1 Posted December 27, 2008 Share Posted December 27, 2008 Or... <?php $colors = array('#ffffff', '#99ffff'); $count = count($colors); $iter = 0; while($row = mysql_fetch_array($result)) { echo '<tr style="background-color:' . $colors[$iter % $count] . '">'; ++$iter; } allows for a variable amount of colors beyond 2, all you need to do is add it to the array. Quote Link to comment Share on other sites More sharing options...
ToonMariner Posted December 27, 2008 Share Posted December 27, 2008 OR... WTH aren't you breaking out of php to html out and using css properly to control your presentational layer???????? Quote Link to comment Share on other sites More sharing options...
slashpine Posted December 27, 2008 Author Share Posted December 27, 2008 there is no mysql database...this parses a flat text file (CSV) Quote Link to comment Share on other sites More sharing options...
revraz Posted December 27, 2008 Share Posted December 27, 2008 Doesn't really matter, you can still do a while loop till you get to EOF. there is no mysql database...this parses a flat text file (CSV) Quote Link to comment Share on other sites More sharing options...
slashpine Posted December 27, 2008 Author Share Posted December 27, 2008 would it be any more difficult for you to apply it to the script I posted? I'm not a php coder and I was seeking some free syntax... I was hoping it wouldn't be too much trouble... Quote Link to comment Share on other sites More sharing options...
slashpine Posted December 27, 2008 Author Share Posted December 27, 2008 I am trying to add both column headings and alternating color rows to this script...can a php coder please code in an example of both in this script? Thanks <?php $filename = "file.csv"; function viewlog($filename) { $fp = fopen($filename,"r"); $file = fread($fp,65535); $replaced = eregi_replace(",", "<td>", $file); $replaced2 = eregi_replace("\n", "<tr><td>", $replaced); $replaced3 = eregi_replace("\r", "<tr><td>", $replaced2); fclose($fp); return $replaced3; } echo "<html><head><title></title></head><body bgcolor=silver>"; echo "<table border=1 bordercolor=black cellspacing=0 cellpadding=5 width=100% style='font-size:10pt'>"; echo viewlog($filename); echo "</table></body></html>"; exit; ?> I have been able to add column headings but I am still unable to get the alternating row color to work ...can someone please show me hos this can be down witht the existing code? Also...(more of a php question) how would I remove a couple of the records in the CSV file NOT to display? Thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.