Jump to content

change row color

PetePenquin

By PetePenquin
in PHP Coding Help

 Share
Go to solution Solved by Ch0cu3r,

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
  • Solution
Ch0cu3r Newbie

Ch0cu3r

Posted
  • Solution
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
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
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.