how to assign different css values to info pulled from MySQL

[webguync]

I am trying to figure out the best way to do something if there is a way.

 

I am pulling values from a MySQL table and using a while loop to display the data, so it looks something like this.

 

while($row = mysql_fetch_array($result))
  {


  echo "<tr>";

  echo "<td>" . $row['last_name'] . "</td>\n";
  echo "<td>" . ucwords($row['first_name']) . "</td>\n";

  echo "<td>" . $row['Class_Date'] . "</td>\n";
  
  echo "</tr>";

 

for the class dates, I want the column background to be a different color depending on the date. For instance January would hvae a blue background, February a red one etc.

 

I was going to try and do that with CSS like

 

echo "<td class="blue">" . $row['Class_Date'] . "</td>\n";

 

in the CSS...

.blue{
background-color:#06c;
}

 

but not sure the best way to make the changing data values different colors with CSS.

 

any suggestions?

 

[JonnoTheDev]

How is the date formatted in $row['Class_Date']. Is it YYYY-MM-DD?

 

If so you could use a simple function:

 

<?php
function cssfromdate($date) {
$parts = explode('-',$date);
$month = $parts[1];
$class = array('01' => 'red',
			   '02' => 'green',
			   '03' => 'blue',
			   '04' => 'orange',
			   '05' => 'white',
			   '06' => 'black',
			   '07' => 'blue',
			   '08' => 'orange',
			   '09' => 'white',
			   '10' => 'black',
			   '11' => 'black',
			   '12' => 'black');
return $class[$month];						   
}

while($row = mysql_fetch_array($result)) {
echo "<tr>\n";
echo "<td>".$row['last_name']."</td>\n";
echo "<td>".ucwords($row['first_name'])."</td>\n";
echo "<td class=\"".cssfromdate($row['Class_Date'])."\">".$row['Class_Date']."</td>\n";
echo "</tr>\n";
}
?>

 

[webguync]

currently it is just text (January 2011), but I can change to any format it needs to be.

[JonnoTheDev]

OK, well you can see how I have done this. The date value that is passed into the function is in the format YYYY-MM-DD. It extracts the month and returns the class name for that month. You can either change the array keys in the function to the month name if you want to pass the likes of 'January' in or just reformat the date. It's really simple.

[webguync]

ok neat thanks. So if I wanted to change the array keys it would be...

$class = array('January' => 'red',
			   'February' => 'green',
			   'March' => 'blue',
			   'April' => 'orange',
etc...
			   ');
return $class[$month];						   
}

 

?

[webguync]

I am getting some notices with the code I am trying

Notice: Undefined offset: 1 in index.php on line 57

Notice: Undefined index: in index.php on line 62

 

I changed the database content to be either 'January' or 'March' just to try this out.

 

in my PHP

 

function cssfromdate($date) {
$parts = explode('-',$date);
$month = $parts[1];
$class = array('January' => 'January',
			   
			   'March' => 'March',
			  );
return $class[$month];						   
}

while($row = mysql_fetch_array($result))
  {


  echo "<tr>";

  echo "<td>" . $row['last_name'] . "</td>\n";
  echo "<td>" . ucwords($row['first_name']) . "</td>\n";

  echo "<td class=\"".cssfromdate($row['Class_Date'])."\">".$row['Class_Date']."</td>\n";
  
  echo "</tr>";



  }

 

it looks like the notices are for these two lines

$month = $parts[1];
return $class[$month];

 

please explain what I need to do to fix.

[JonnoTheDev]

function cssfromdate($date) {
$class = array('January' => 'red', 'March' => 'blue');
return $class[$date];
}

[webguync]

thanks, seems to be working as intended now. I am still getting this notice though.

 

 

Notice: Undefined index: in index.php on line 57

 

which is this line

[php
return $class[$date];
[/code]

 

how do I get rid of that notice?

[webguync]

never mind. I had error reporting set to ALL. I just took that out and no more notice so all is good. Thanks again!