PHP color table from mysql database

Question

i am having some problems with my echo '<tr style="background-color: . $color . '">'; it keeps giving me Parse error: syntax error, unexpected 'background' (T_STRING) in C:\xampp\htdocs\test.php line 146 and i am pretty new to php so i have no clue what i can do.

My purpes with this code is to get some information from a colum in mysql database and then show it as a table in a website(that i have allready fixed, but i need the colors to work) and then it is going to color some of the table rows after some of their value in the database.

P.S: This is not my whole code.

hope someone can help, Thanks.

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


if ( ($row['Flyttet'] == "NEI") && ($row['Slettet'] != "JA") && ($row['Delt'] != "NEI") ) {
    $red ='#ff0000';    
}
else {
    $red = false;
}

if ( (($row['Flyttet'] == "NEI") && ($row['Slettet'] != "NEI") && ($row['Delt'] != "JA")) || (($row['Flyttet'] == "JA") && ($row['Slettet'] != "NEI") && ($row['Delt'] != "JA"))  ) {
    $gul ='#FFFF00';    
}
else {
    $gul = false;
}

if ( ($row['Flyttet'] == "JA") && ($row['Slettet'] != "NEI") && ($row['Delt'] != "NEI") ) {
    $blue ='#1E90FF';    
}
else {
    $blue = false;
}

if ( ($row['Flyttet'] == "NEI") && ($row['Slettet'] != "NEI") && ($row['Delt'] != "JA") ) {
    $green ='#3CB371';    
}
else {
    $green = false;
}


$color = ";
if(!$red && !$gul && !$blue) $color = $green;
if(!$red && !$gul && !$green) $color = $blue;
if(!$red && !$green && !$blue) $color = $gul;
if(!$green && !$gul && !$blue) $color = $red;

    //Første kolone som skal vises
    echo '<tr style="background-color: . $color . '">';
    echo "<td>" . utf8_encode($row['ID']) . "</td>";
    echo "<td>" . utf8_encode($row['Vsite']) . "</td>";
    echo "<td>" . utf8_encode($row['Registrar']) . "</td>";
    echo "<td>" . utf8_encode($row['Eier']) . "</td>";
    echo "<td>" . utf8_encode($row['NS']) . "</td>";
    echo "<td>" . utf8_encode($row['A']) . "</td>";
    echo "<td>" . utf8_encode($row['MX']) . "</td>";
    echo "<td>" . utf8_encode($row['Flyttet']) . "</td>";
    echo "<td>" . utf8_encode($row['Slettet']) . "</td>";
    echo "<td>" . utf8_encode($row['Delt']) . "</td>";
    echo "<td>" . utf8_encode($row['Behkd']) . "</td>";
    echo "<td>" . utf8_encode($row['Varenr']) . "</td>";
    echo "<td>" . utf8_encode($row['Server']) . "</td>";
    echo "<td>" . utf8_encode($row['Sistoppdatert']) . "</td>";
    echo "</tr>";

    }

Possible duplicate of [Reference - What does this error mean in PHP?](http://stackoverflow.com/questions/12769982/reference-what-does-this-error-mean-in-php) — swidmann, Nov 23 '15 at 09:10

score 1 · Answer 1 · answered Nov 23 '15 at 09:13

You initialize your variable color wrong. It must be $color = "";.

$color = "";
    if(!$red && !$gul && !$blue) $color = $green;
    if(!$red && !$gul && !$green) $color = $blue;
    if(!$red && !$green && !$blue) $color = $gul;
    if(!$green && !$gul && !$blue) $color = $red;

    //Første kolone som skal vises
    echo '<tr style="background-color:' . $color . '">';
    echo "<td>" . utf8_encode($row['ID']) . "</td>";
    echo "<td>" . utf8_encode($row['Vsite']) . "</td>";
    echo "<td>" . utf8_encode($row['Registrar']) . "</td>";
    echo "<td>" . utf8_encode($row['Eier']) . "</td>";
    echo "<td>" . utf8_encode($row['NS']) . "</td>";
    echo "<td>" . utf8_encode($row['A']) . "</td>";
    echo "<td>" . utf8_encode($row['MX']) . "</td>";
    echo "<td>" . utf8_encode($row['Flyttet']) . "</td>";
    echo "<td>" . utf8_encode($row['Slettet']) . "</td>";
    echo "<td>" . utf8_encode($row['Delt']) . "</td>";
    echo "<td>" . utf8_encode($row['Behkd']) . "</td>";
    echo "<td>" . utf8_encode($row['Varenr']) . "</td>";
    echo "<td>" . utf8_encode($row['Server']) . "</td>";
    echo "<td>" . utf8_encode($row['Sistoppdatert']) . "</td>";
    echo "</tr>";

    }

score 0 · Answer 2 · answered Nov 23 '15 at 09:11

0

One single quote was missing. It should be like this:

echo '<tr style="background-color:' . $color . '">';

answered Nov 23 '15 at 09:11

Sanjay Kumar N S

4,653
4
23
38

score 0 · Accepted Answer · answered Nov 26 '15 at 08:07

I ended up using something like this

$color = '';

if ( ($row['Flyttet'] == "NEI") && ($row['Slettet'] == "JA") && ($row['Delt'] == "NEI") ) $color ='#ff0000';
if ( (($row['Flyttet'] == "NEI") && ($row['Slettet'] == "NEI") && ($row['Delt'] == "JA"))|| (($row['Flyttet'] == "JA") && ($row['Slettet'] == "NEI") && ($row['Delt'] == "JA")) ) $color ='#FFFF00';
if ( ($row['Flyttet'] == "JA") && ($row['Slettet'] == "NEI") && ($row['Delt'] == "NEI") ) $color ='#1E90FF';
if ( (($row['Flyttet'] == "NEI") && ($row['Slettet'] == "NEI") && ($row['Delt'] == "JA")) || (($row['Flyttet'] == "NEI") && ($row['Slettet'] == "NEI") && ($row['Delt'] == "NEI")) ) $color ='#3CB371';

score -1 · Answer 4 · answered Nov 23 '15 at 09:12

-1

Your background-color needs double quotes:

echo '<tr style="background-color:"' . $color . '"">';

answered Nov 23 '15 at 09:12

KiwiJuicer

1,952
14
28

this is wrong, because the tr would then look in html like this `` – Lino Nov 23 '15 at 09:22

PHP color table from mysql database

4 Answers4