Two color rows in table inside while iteration
in [General]
|
From: Juan Rodriguez Monti on 28 Apr 2010 07:29 Hello Guys, I would like to implement a two color row table for some queries that I'm doing. I use PHP to query a DB, then I use while to print all its results. I have a code pretty similar to this one : $results = Here the QUERY; echo "<html>"; echo "<head>"; echo '<link rel="stylesheet" type="text/css" href="style.css" />'; echo "</head>"; echo "<body>"; echo '<div id="container">'; echo "<center><h2>Results</h2></center><br />"; echo ("<table border='1'>"); echo "<td><strong>At1</strong></td> <td><strong>At2</strong></td> <td><strong>At3</strong></td> $ while ($row = while condition )) { echo ("<tr>"); echo "<td>$row[0]</td><td>$row[1]</td> <td>$row[2]</td> <td>$row[3]</td><td>$row[4]</td> "; echo "</div>"; echo "</body>"; echo "</html>"; I just want to show you how I write the table. What I would like to know is what do you suggest to do a two color row format. Thanks!, Juan
From: Ashley Sheridan on 28 Apr 2010 07:27 On Wed, 2010-04-28 at 08:29 -0300, Juan Rodriguez Monti wrote: > Hello Guys, > I would like to implement a two color row table for some queries that I'm doing. > > I use PHP to query a DB, then I use while to print all its results. I > have a code pretty similar to this one : > > $results = Here the QUERY; > echo "<html>"; > echo "<head>"; > echo '<link rel="stylesheet" type="text/css" href="style.css" />'; > echo "</head>"; > echo "<body>"; > echo '<div id="container">'; > > echo "<center><h2>Results</h2></center><br />"; > echo ("<table border='1'>"); > echo "<td><strong>At1</strong></td> > <td><strong>At2</strong></td> <td><strong>At3</strong></td> $ > > while ($row = while condition )) { > echo ("<tr>"); > echo "<td>$row[0]</td><td>$row[1]</td> <td>$row[2]</td> > <td>$row[3]</td><td>$row[4]</td> "; > echo "</div>"; > echo "</body>"; > echo "</html>"; > > I just want to show you how I write the table. What I would like to > know is what do you suggest to do a two color row format. > > Thanks!, > Juan > You look to be converting the database rows into table columns there, so which do you want to style, the rows or the columns? Basically, I'd do something like this that I wrote a while back: http://www.ashleysheridan.co.uk/coding_php_alternate_rows.php Thanks, Ash http://www.ashleysheridan.co.uk
From: "Jay Blanchard" on 28 Apr 2010 07:37 [snip] I just want to show you how I write the table. What I would like to know is what do you suggest to do a two color row format. [/snip] Before your table; $trColor = 0; Then during the loop; while(foo){ $tr = (0 == $trColor % 2)? "#E8E8E8" : "#FFFFFF"; echo "<tr style=\"background-color:".$tr."\">"; .... Replace the hex values with the colors you desire.
From: "Gary ." on 28 Apr 2010 07:38 On 4/28/10, Juan Rodriguez Monti wrote: > I would like to implement a two color row table for some queries that I'm > doing. .... > what do you suggest to do a two color row format. Well, I wouldn't mix the presentation and querying of the db in one place, but assuming that's just a simplified example... I'd just set each <tr> style name to something relevant declared in your CSS. Alternating rows getting style names like "odd", and "even", which are declared in CSS to display in different colours, or whatever.
From: Ali Asghar Toraby Parizy on 28 Apr 2010 07:46
It isn't good idea to use php to visualize your table. You can fetch you data by php and style them by java script. On Wed, Apr 28, 2010 at 3:59 PM, Juan Rodriguez Monti <juan(a)rodriguezmonti.com.ar> wrote: > Hello Guys, > I would like to implement a two color row table for some queries that I'm doing. > > I use PHP to query a DB, then I use while to print all its results. I > have a code pretty similar to this one : > > $results = Here the QUERY; > echo "<html>"; > echo "<head>"; > echo '<link rel="stylesheet" type="text/css" href="style.css" />'; > echo "</head>"; > echo "<body>"; > echo '<div id="container">'; > > echo "<center><h2>Results</h2></center><br />"; > echo ("<table border='1'>"); > echo "<td><strong>At1</strong></td> > <td><strong>At2</strong></td> <td><strong>At3</strong></td> $ > > while ($row = while condition )) { > echo ("<tr>"); > echo "<td>$row[0]</td><td>$row[1]</td> <td>$row[2]</td> > <td>$row[3]</td><td>$row[4]</td> "; > echo "</div>"; > echo "</body>"; > echo "</html>"; > > I just want to show you how I write the table. What I would like to > know is what do you suggest to do a two color row format. > > Thanks!, > Juan > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > |