Re: Two color rows in table inside while iteration
| From: | Juan Rodriguez Monti | Date: | Thu, 29 Apr 2010 14:01:05 +0000 |
| Subject: | Re: Two color rows in table inside while iteration | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-304752@lists.php.net to get a copy of this message | ||
2010/4/29 tedd <tedd.sperling@gmail.com>:
> At 8:29 AM -0300 4/28/10, 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
>
>
> Juan:
>
> Everyone has done this at one time or another -- this is my solution.
>
> http://webbytedd.com/b/color-rows/
>
> Plus, it validates and keeps things simple.
>
> Cheers,
>
> tedd
Tedd,
Thanks. I'm gonna check it. I finally solved it using:
if ( CONDITIONS )) {
$results = query( QUERY );
$colors = array('#97b7cd','#96bf8c');
$index= 0;
echo "<html>";
echo "<head>";
echo '<link rel="stylesheet" type="text/css" href="is.css"
/>';
echo "</head>";
echo "<body>";
echo '<div id="container">';
echo "<table border='1'>";
echo "<td><strong>a1</strong></td>
<td><strong>a2</strong></td>
<td><strong>a3</strong></td>
<td><strong>a4</strong></td>
<td><strong>a5</strong></td> ";
while ($row = CONDITIONS )) {
echo '<tr style="background-color: ' . $colors[$index ++ % 2] .
';">';
echo "<td>$row[0]</td><td>$row[1]</td> <td>$row[2]</td>
<td>$row[3]</td><td>$row[4]</td> ";
}
echo "</tr>";
echo "</table>";
echo "</div>";
echo '<p><a href="back.html">back</a></p>';
echo "</body>";
echo "</html>";
This solution was the best for me. It's solved with your help.
Thanks a lot!.
Juan