Alternate colors by dates

sandeep_mur

Hi,

I am extracting results from a Mysql database and showing them in a table.

Everyday when my script runs, it extracts the current days results which could be 1 row or 4 or 5 rows.

What I want to be able to do is alternate the row color every other day or by date such that all rows for a given day have the same color and the rows for the next day have the alternate color.

thanks for any suggestions?
sg

johanafm

data setup

# original dates, used to instantiate DateTime objects
$ds = array(	DateTime::createFromFormat('Y-m-d', '2011-07-30'),
				DateTime::createFromFormat('Y-m-d', '2011-07-30'),
				DateTime::createFromFormat('Y-m-d', '2011-07-31'),
				DateTime::createFromFormat('Y-m-d', '2011-08-01')
);
# change dates into days, represented as "Mon", "Tue" etc
foreach($ds as &$d)
{
	$d = $d->format('D');
}

stylesheet

# create css style rules based on the above
.Mon { color: #FFF; }
.Tue { color: #F00; }
.WED { color: #0F0; }

output

# use the class attribute to make the css styles apply to each element as needed
foreach ($ds as $d)
{
	printf('<div class="%s">%s</div>', $d, $rowData);
}

tomhath

Another way is to use the MySQL to_days() function. It returns an integer, which you can test for even/odd with PHP's modulo operator %

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_to-days

Derokorian

You could also keep track of the last seen day/date (useful if some might be missing) and if it differs switch colors. See the snippet (not completed or tested)

function switchColor() {
   GLOBAL $colors
   if( $colors['current'] == $colors['b'] )
      $colors['current'] = $colors['a'];
   else
      $colors['current'] = $colors['b'];
}

$prevdate = '';
$colors = array(
           'current' => '',
           'a' => '#FFF',
           'b' => '#000'
      );
while( $row = $result->fetch_assoc() ) {
   if( $prevdate != $row['date'] )
     switchColor();

   echo '<span style="color:'. $colors['current'] .';">'. $row['date'] .' - '. $row['data'] .'</span><br />';

   $prevdate = $row['date'];
}