Jump to content

change row color

PetePenquin

By PetePenquin
in PHP Coding Help

Recommended Posts

PetePenquin Newbie

PetePenquin

Posted
Posted

Hi,

 

I'm having the following problem. I want to change the row color depending on the value of a record.

 

i made three different td class in the style.

 

Then i check the value of the record "TOEGEZEGD" and connect this to $NewClass,

 

The i try to change the color of the background.

 

$NewClass takes the value i want (check by display echo $NewClass)

 

But the background of the row doesn't change, i tried different methodes:

 

<td class = "$NewClass">'.$row['TOEGEZEGD'].'</td>
<td class = \"$New$Class\">'.$row['VORM'].'</td>
<td><DIV CLASS="$NewClass">'.$row['PAKKET'].'</DIV></td>

 

But non of them work

 

please help, it's driving my crazy

<?php

// checking for started session
function is_session_started()
{
    if ( php_sapi_name() !== 'cli' ) {
        if ( version_compare(phpversion(), '5.4.0', '>=') ) {
            return session_status() === PHP_SESSION_ACTIVE ? TRUE : FALSE;
        } else {
            return session_id() === '' ? FALSE : TRUE;
        }
    }
    return FALSE;
}

if ( is_session_started() === FALSE ) session_start();

if(isset($_SESSION ['ingelogd']) AND $_SESSION['ingelogd'] == 1)
{}
else
{
	header("location:index.php");
	exit;
}

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>**********</title>
<meta name="" content="">
</head>
<body>
	<style>
		textarea, input, button,
		a, td, span{
			font-family: "Trebuchet MS", Helvetica, sans-serif;
		}
		
		td{
			color: blue;
			width: 100px;
			background-color: #ceffce;
			height: 50px;
			text-align: center;
}

		td.JA{
            color: red;
            width: 100px;
            background-color: #00ee00;
            height: 50px;
            text-align: left;
        } 
		.JA{
            color: red;
            width: 100px;
            background-color: #00ee00;
            height: 50px;
            text-align: left;
        } 
		 td.NEE{
            color: green;
            width: 100px;
            background-color: #ff0000;
            height: 50px;
            text-align: left;
        }

        td.MISSCHIEN{
            color: orange;
            width: 100px;
            background-color: #f07700;
            height: 50px;
            text-align: left;
        } 
		
		td.op{
			color: black;
			width: 450px;
			background-color: #ceDDce!important;
			height: 50px;
			text-align: left; 
		}
		
		th{
			color: black;
			width: 40px;
			background-color: #cecece;
			height: 50px;
			text-align: center;
		}
		th.op{
			color: black;
			width: 450px;
			background-color: #cecece;
			height: 50px;
			text-align: center;
		}
		
		.a{
			height: 25%;
			cursor: pointer;
		}
		
		 
		button{
			width: 100%;
			height: 100%;
			margin: -5 auto -5 auto;
			
		}
		
		textarea {
			height: 100%;
			width: 100%;
		}
		
		.verwijder{
			width: 10px;
			height: auto;
			background-color: #ffa8a8;
		}
		
		.space{
			width: 20px;
			height: auto;
		}
		
		.invoegen{
			background-color: #6dbbdc;
			width: 1434px;
			padding: 5px;
			margin: 5px;
		}
		
		.content{
			background-color: #FFDD67;
			width: 1500px; ;
			padding: 0 5 0 5;
			margin: 0 5 0 5;
		}
			.content table{
				margin-bottom: 100px;
			}
		
		span{
			text-decoration: underline;
		}
		
		select{
			height: 90%;
		}
		
	</style>
		
		
	
	
<div class="content">
<?php

	
	mysql_connect("localhost", "************", "*********") or die(mysql_error());
mysql_select_db("*********");






$sql = "SELECT  ID, NAAM, CONTACT, TOEGEZEGD, bestuur1, bestuur2, bestuur3, bestuur4, bestuur5, VORM, PAKKET, KANGEFACTUREERD, GEFACTUREERD, AANTAL, POST, OPMERKING FROM `sponsoren` ORDER BY $field $sort";


$result = mysql_query($sql) or die(mysql_error());



echo'<table>';


while($row = mysql_fetch_array($result))
{
	$BESTUUR1 = $row['bestuur1'];
	$BESTUUR2 = $row['bestuur2'];
	$BESTUUR3 = $row['bestuur3'];
	$BESTUUR4 = $row['bestuur4'];
	$BESTUUR5 = $row['bestuur5'];
	
if ($row['TOEGEZEGD'] == 'ja') {
  $NewClass = "JA" ;
} elseif ($row['TOEGEZEGD'] == 'nee') {
  $NewClass = "NEE";
} elseif ($row['TOEGEZEGD'] == 'misschien') {
  $NewClass = "MISSCHIEN";
}

echo $NewClass;
echo'<tr>		
		<td><a href="full_table_row_results.php?ID='.$row['ID'].'">'.$row['ID'].'</a></td>
		<td>'.$row['NAAM'].'</td>
		<td>'.$row['CONTACT'].'</td>
		<td >';
			    if($BESTUUR1 == 1){
				echo "<div class='item'><label>Kk</label></div>";
			    };
				if($BESTUUR2 == 1){
				echo "<div class='item'><label>Rutger</label></div>";
			    }; 
			    if($BESTUUR3 == 1){
				echo "<div class='item'><label>Toby</label></div>";
			    }; 
				if($BESTUUR4 == 1){
				echo "<div class='item'><label>Meijke</label></div>";
			    }; 
			    if($BESTUUR5 == 1){
				echo "<div class='item'><label>Boele</label></div>";
			    }"</td>"; 	
echo'<td class = "$NewClass">'.$row['TOEGEZEGD'].'</td>
	 <td class = \"$New$Class\">'.$row['VORM'].'</td>
	 <td><DIV CLASS="$NewClass">'.$row['PAKKET'].'</DIV></td>
	 <td>'.$row['KANGEFACTUREERD'].'</td>
	 <td>'.$row['GEFACTUREERD'].'</td>
	 <td>'.$row['AANTAL'].'</td>
	 <td>'.$row['POST'].'</td>
	 <td class = "op">'.$row['OPMERKING'].'</td>';
echo'</tr>';
}
echo'</table>';

?>
    </div>
  </body>
</html>
Link to comment
https://forums.phpfreaks.com/topic/292159-change-row-color/
Share on other sites
Ch0cu3r Newbie

Ch0cu3r

Posted
Posted

You using a variable within a single quote string

echo'<td class = "$NewClass">'

Variables are not expanded within single quotes. Use double quotes or concatenate the variable

echo "<td class = \"$NewClass\">"  // double quote string

// OR

echo '<td class = "'.$NewClass.'">' // concatenate
Link to comment
https://forums.phpfreaks.com/topic/292159-change-row-color/#findComment-1495235
Share on other sites
ginerjm Prolific Member

ginerjm

Posted
Posted

This works the same and is easier to type:

 

 echo "<td class = '$NewClass'>";
 

 

as well as this:

 

echo "<td class='$newclass'>";

 

The unnecessary use of Caps will end up biting you in the a** one of these days.  Yes - JS (and perhaps other code) insists on this in its function names and vars but php doesn't.  It you do use Caps tho, you have to stick with them.  IMHO - stick to all lower.  Funny how php allows flexibility with function names but not with variable names.

Link to comment
https://forums.phpfreaks.com/topic/292159-change-row-color/#findComment-1495247
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.