Color coding html table cell based on SQL flag value

Question

So I finally have a SQL query working to take 3 conditions from my DB table and set a flag based on them.

Here is the Statement:

UPDATE staging 
SET  `miuFlag` =1 
WHERE  `lowSideMIUNumArriv` =    `lowSideMIUNumDepart` 
AND  `miu` =  "No"

Now my database table has a column called 'miuFlag' with either ones or zeroes. Based on this value, I want one of my html table values to be red or green (0=red, 1=green).

Here is the affected html table row:

        <td><? echo $row['miu'];?>&nbsp;</td>

I know I can color this row's font by using style inside of the td element, but how exactly would I create the condition to style one color for miuFlag = 0 and another for miuFlag = 1?

Are you opposed to javascript? because with the JQuery Library it should be possible and fairly easy. — Jeanze
– Jeanze, Commented Jun 8, 2017 at 20:08
I'm actually using some on this page because it's all being displayed in a datatable — Geoff_S
– Geoff_S, Commented Jun 8, 2017 at 20:10

Bookin · Accepted Answer · 2017-06-08 20:08:48Z

1

HTML:

<td class="<?php echo (int)$row['miu']?'red':''?>"><? echo $row['miu'];?>&nbsp;</td>

CSS

.red{
    color:red;
}

answered Jun 8, 2017 at 20:08

Bookin

2822 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Geoff_S Over a year ago

I think this makes sense, except for the value of miuFlag. So I need the value of miuFlag (0 or 1) to dictate the color of the $row[miu]. If that makes sense

Bookin Over a year ago

(int)$row['miu']?'red':'' - if 1 it will be red, if 0 it will be empty

Geoff_S Over a year ago

Thank you so much, it's perfect!

Farhad Hossen · Accepted Answer · 2017-06-08 20:14:59Z

1

You can try this code:

<td styel="<?php $row[miuFlag] == 1 ? 'color:green' : 'color:red' ?>"><?= $row['miu'];?>&nbsp;<td>

edited Jun 8, 2017 at 20:14

answered Jun 8, 2017 at 20:13

Farhad Hossen

2731 silver badge6 bronze badges

2 Comments

Geoff_S Over a year ago

So does that mean, if miuFlag is 1 use green, else use red?

Farhad Hossen Over a year ago

<td styel="<?php $row[miuFlag] == 1 ? 'color:green' : $row[miuFlag] == 0 ? 'color:red' : ''?>"><?= $row['miu'];?> <td> try this @TomN.

m i c h a e l · Accepted Answer · 2017-06-08 20:18:18Z

1

I think it would be something like this:

<td class="<? echo ($row['miu'] == 0) ? "redstyle" : "greenstyle"); ?>">&nbsp;</td>

edited Jun 8, 2017 at 20:18

answered Jun 8, 2017 at 20:08

m i c h a e l

851 silver badge7 bronze badges

3 Comments

Geoff_S Over a year ago

But if I'm not mistaken, that only applies to 0 and not the 1. Also, I need to check the value (0 and 1) of miuFlag in my database and then color the miu row.

m i c h a e l Over a year ago

That would work for both, assuming that you only have two values. The first part after the question mark is what happens if the value is 0, and the part after the colon is for any other value.

Bookin Over a year ago

you lose one bracket

Collectives™ on Stack Overflow

Color coding html table cell based on SQL flag value

3 Answers 3

3 Comments

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related