defining <td> colors based on an ID.

Debar

First of all thanks for the help. Great forums and I learn so much every day.

Heres what Ive been working on the following, my first goal for this particular project was to make my table rows alternate colors. This was easy enough using examples found on the internet. I nailed it down in no time.

Now I wish to change the text color based on the status ID from my query. Lets start with my first bit of code for alternating the table colors.


 <?php   

  	echo '             <table width="100%" cellpadding="0" cellspacing="0" summary="">';

// Define my background colors
$row1 = '<tr class="row2">';
$row2 = '<tr class="row">';
$row_count = 0;

// do the query:

  $orders_contents = '';
  $orders_status = $db->Execute("select orders_status_name, orders_status_id from " . TABLE_ORDERS_STATUS . " where language_id = '" . $_SESSION['languages_id'] . "'");

  while (!$orders_status->EOF) {

$orders_pending = $db->Execute("select count(*) as count from " . TABLE_ORDERS . " where orders_status = '" . $orders_status->fields['orders_status_id'] . "'");

/* Now we do this small line which is basically going to tell PHP to alternate the colors between the two colors we defined above. */ 
$row_color = ($row_count % 2) ? $row1 : $row2; 

$orders_contents .=  $row_color . '<td class="rowLeft"><a href="' . zen_href_link(FILENAME_ORDERS, 'selected_box=customers&status=' . $orders_status->fields['orders_status_id'], 'NONSSL') . '">' . $orders_status->fields['orders_status_name'] . '</a>:</td><td class="rowRight"> ' . $orders_pending->fields['count'] . '</td><td class="rowRight">' . 'test'. '</td></tr>';
$orders_status->MoveNext();
$row_count++;
  }

  echo $orders_contents;
 echo '             </table>';
  ?>

Now I was thinking I can use the same concept to change my text color based on the orders_status_id. So that I can say if the order_status_id = 2 then my <td class="rowRightGreen"> or something similar to change the style of the text to whatever I want.

My question is in what way should/could i go about doing this. My initial thoughts would be to base it off my previous modifcation for row colors. Exept instead of defining a $row_color = ($row_count % 2) ? $row1 : $row2; make an additional variable that is defined by the order_status_id.

Any ideas how I can do this?

Thanks so much guys.

Debar

am I not explaining myself very well? no sarcasm here just want to make sure im not being confusing.

😃

bpat1434

Don't know if this will help, or if you've solved it yet...

How about linking out to an external file which defines the id colors. So you would include your external php file, then call the function.

I don't know how many IDs you have, so it may not be very feasible.

But something like this:

<?php
$orders_status_id = //mysql query, or GET/POST query
if($orders_status_id == 1){
     $col1 = <td class="rowrightGreen">;
}
if($orders_status_id == 2){
     $col2 = <td class="rowrightBlue">;
}
?>

I'm not 100% sure that would work. But something like that probably.

~Brett

Debar

hmmm, does look like that will work for me. Although its great for defining a variable and style to each status id. I think what I need is something like

$row_color = ($row_count % 2) ? $row1 : $row2;

that will tell which variable to use that we defined using your method, depending on the id. Thanks for the help man, were getting there, now all i need to figure out is how to

$status_color = ($statusGreen $statusBlue or however we can do that.

Kind of see what i mean mate?

stevesweetland

consider using a switch statment....

switch ($status_id){
  case 1:
    $td_color = "blue";
    break;

  case 2:
    $td_color = "red";
    break;

  case 3:
    $td_color = "green";
    break;
};

or you could show off a bit and just be less complex, but neater...

function statuscolor($status_id){
  if ($status_id == 1) return "blue";
  if ($status_id == 2) return "red";
  if ($status_id == 3) return "green";
};


/// then after uv done all ur code, you can just pick up ur color by doing this...
$color = statuscolor($status_id);

Debar

ooh i like that mate,

now all i would need to do there would be to define my $status_id

but im running into trouble here.


//this here pretty much grabs the info needed for each row of data.

$orders_status = $db->Execute("select orders_status_name, orders_status_id from " . TABLE_ORDERS_STATUS . " where language_id = '" . $_SESSION['languages_id'] . "'");   

// I also need to define my $status_id so i just copied removed order_status_name from above. is this the correct way to define this variable below?

$status_id = $db->Execute("select orders_status_id from " . TABLE_ORDERS_STATUS . " where language_id = '" . $_SESSION['languages_id'] . "'");

Thanks so much guys

Debar

well I think im just about there gang.

This is what I have completed

very top of page i inlcuded this which ill move to my functions.php later


function statuscolor($status_id){ 
  if ($status_id == 1) return "blue"; 
  if ($status_id == 2) return "red"; 
  if ($status_id == 3) return "green"; 
};

Then down in the depths of my content page, for this particular table report on current order status I have this.

Now all seems to work except the primary goal. my text test all has a background of blue with is $status_id == 1 so its not actully working. any thoughts how I can relate my status_id to the particular row that its in?


<?php   

  	echo '             <table width="100%" cellpadding="0" cellspacing="0" summary="">';

// Define my background colors
$row1 = '<tr class="row2">';
$row2 = '<tr class="row">';
$row_count = 0;

// Define my Status Colors


// do the query:

  $orders_contents = '';
  $orders_status = $db->Execute("select orders_status_name, orders_status_id from " . TABLE_ORDERS_STATUS . " where language_id = '" . $_SESSION['languages_id'] . "'");
  $status_id = $orders_status->fields['orders_status_id'] ;

  while (!$orders_status->EOF) {

$orders_pending = $db->Execute("select count(*) as count from " . TABLE_ORDERS . " where orders_status = '" . $orders_status->fields['orders_status_id'] . "'");

/* Now we do this small line which is basically going to tell PHP to alternate the colors between the two colors we defined above. */ 
$row_color = ($row_count % 2) ? $row1 : $row2; 
$color = statuscolor($status_id); 





$orders_contents .=  $row_color . '<td class="rowLeft"><a href="' . zen_href_link(FILENAME_ORDERS, 'selected_box=customers&status=' . $orders_status->fields['orders_status_id'], 'NONSSL') . '">' . $orders_status->fields['orders_status_name'] . '</a>:</td><td class="rowRight"> ' . $orders_pending->fields['count'] . '</td><td bgcolor="' . $color . '" class="rowRight"> test </td></tr>';
$orders_status->MoveNext();
$row_count++;
  }

  echo $orders_contents;
 echo '             </table>';
  ?>

Debar

i fixed it by moving

$status_id = $orders_status->fields['orders_status_id'] ;

after the while. don’t know if that’s the way about it but it seems to work, thanks so much to the following

stevesweetland
bpat1434

your input and thoughts have taught me allot. Thanks for mentoring