forskellige baggrundsfarver i en while lykke

<?php
// kommer fra sql
$numbers_=array(9=>2, 8=>0, 15=>5);



$property=array(
    "orp_2"=>array(
        "numbers"=>array(1,9,14,20,31), "padding"=>5, "color"=>"#ffffff"),    
    "voisins"=>array(
        "numbers"=>array(0, 2, 3, 4 , 7, 18 , 19 , 21, 22, 25, 26, 28, 29, 32, 35), "padding"=>15, "color"=>"#81c77d"
    ),    
    "jeu"=>array(
        "numbers"=>array(3, 12, 15, 26, 32, 35), "padding"=>7, "color"=>"#81e87c"
    ),    
    "orp_1"=>array(
        "numbers"=>array(6,17,34), "padding"=>12, "color"=>"#ffffff"
    ),
    "tiers"=>array(
        "numbers"=>array(5,8,10,11,13,16,23,24,27,30,33,36), "padding"=>42, "color"=>"#dfb07b"
    )
);



$str="";
foreach ($numbers_ as $numbers_key => $numbers_value){
    
    // løber de 5 array igennem
    foreach ($property as $key => $value){
        // $key = array navnet (orp_2,voisins... )        
        // $value = numbers, padding, color
        
        // sørger for at 8 ikke bliver udskrevet da værdien er 0
        if($numbers_value>0){
            // finder tallet i et af de 5 array, og udskriver det, samt antallet af tal, og padding og farve
            if(in_array($numbers_key, $value['numbers']) ){
                $str .= "tal " . $numbers_key . " er der " . $numbers_value . " af padding = " . $value['padding'] . " farve = " . $value['color']. "<br>";
            }            
        }        
    }
}
echo $str;
?>

<?php
// kommer fra sql
$numbers_=array(9=>2, 8=>0, 15=>5);

$property=array(
    "voisins"     => array(0 => "#81c77d", 2 => "#81c77d", 3 => "#81c77d", 4 => "#81c77d", 7 => "#81c77d", 12 => "#81c77d", 15 => "#81c77d", 18 => "#81c77d", 19 => "#81c77d", 21 => "#81c77d", 22 => "#81c77d", 25 => "#81c77d", 26 => "#81c77d", 28 => "#81c77d", 29 => "#81c77d", 32 => "#81c77d", 35 => "#81c77d"),
    "jeu"         => array(0 => "#81e87c", 3 => "#81e87c", 12 => "#81e87c", 15 => "#81e87c", 26 => "#81e87c", 32 => "#81e87c", 35 => "#81e87c"),
    "orp_1"     => array(6 => "#ffffff", 17 => "#ffffff", 34 => "#ffffff"),
    "tiers"     => array(5 => "#dfb07b", 8 => "#dfb07b", 10 => "#dfb07b", 11 => "#dfb07b", 13 => "#dfb07b", 16 => "#dfb07b", 23 => "#dfb07b", 24 => "#dfb07b", 27 => "#dfb07b", 30 => "#dfb07b", 33 => "#dfb07b", 36 => "#dfb07b"),
    "orp_2"     => array(1 => "#ffffff", 9 => "#ffffff", 14 => "#ffffff", 20 => "#ffffff", 31 => "#ffffff")
);


$str="";
foreach ($numbers_ as $numbers_key => $numbers_value){    
    foreach ($property as $key => $value){        
        foreach($value as $k => $v){            
            if($k==$numbers_key){                
                $str.="<br>tal " . $numbers_key . " " . " er der " .$numbers_value . " af med farve coden " . $v;
            }
        }
    }
}
echo $str;


/*
udskriver 
tal 9 er der 2 af med farve coden #ffffff
tal 8 er der 0 af med farve coden #dfb07b
tal 15 er der 5 af med farve coden #81c77d
tal 15 er der 5 af med farve coden #81e87c

ja 15 indgår i 2 array's
*/
?>

 
// kommer fra sql
$numbers_=array(9=>2, 8=>0, 15=>5);

foreach($value as $k => $v){            
    if($k==$numbers_key){                
        $str.="<br>tal " . $numbers_key . " " . " er der " .$numbers_value . " af med farve coden " . $v;
    }
}

 
CREATE TABLE `numbertable` (
  `num_id` int(11) NOT NULL,
  `numbers` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `numbertable` (`num_id`, `numbers`) VALUES
(337, 1),
(338, 7),
(339, 35),
(340, 13),
(341, 0),
(342, 21),
(343, 2),
(344, 10),
(345, 28),
(346, 36);

ALTER TABLE `numbertable`
  ADD PRIMARY KEY (`num_id`);
ALTER TABLE `numbertable`
  MODIFY `num_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=347;

 
<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
//include('session.php');
// Selecting Database
// include 'dbconfic.inc.php';
$mysqli = mysqli_connect("localhost", "root", "", "test");



$property = array(
    "orp_2" => array(
        "numbers" => array(345, 337, 338), "padding" => 5, "color" => "#ffffff"),
    "voisins" => array(
        "numbers" => array(344, 346), "padding" => 15, "color" => "#81c77d"
    ),
    "jeu" => array(
        "numbers" => array(343, 339), "padding" => 7, "color" => "#81e87c"
    ),
    "orp_1" => array(
        "numbers" => array(340, 342), "padding" => 12, "color" => "#ffffff"
    ),
    "tiers" => array(
        "numbers" => array(341, 350), "padding" => 42, "color" => "#dfb07b"
    )
);
// '?' er placeholders for variabler
$stmt = $mysqli->prepare("SELECT * FROM numbertable ORDER BY num_id DESC LIMIT 27;");

// execute prepared statement
$stmt->execute();

// gør variabler klar:
$number = null;
$n_id = null;

/* bind result variabler */
$stmt->bind_result($n_id, $number);
/* fetch values for hver row, her kun 1 row dog: */
$str = "";
while ($stmt->fetch()) {
    // echo $n_id . " " .   $number . "<br>";
    // løber de 5 array igennem
    foreach ($property as $key => $value) {
        // $key = array navnet (orp_2,voisins... )
        // $value = numbers, padding, color

        if ($number > 0) {
            // finder tallet i et af de 5 array, og udskriver det, samt antallet af tal, og padding og farve
            if (in_array($n_id, $value['numbers'])) {
                $str .= "tal " . $n_id . " er der " . $number . " af padding = " . $value['padding'] . " farve = " . $value['color'] . "<br>";
            }
        }
    }
}
echo $str;

// luk statement
$stmt->close();

// luk connection
$mysqli->close();
?>

 
tal 346 er der 36 af padding = 15 farve = #81c77d
tal 345 er der 28 af padding = 5 farve = #ffffff
tal 344 er der 10 af padding = 15 farve = #81c77d
tal 343 er der 2 af padding = 7 farve = #81e87c
tal 342 er der 21 af padding = 12 farve = #ffffff
tal 340 er der 13 af padding = 12 farve = #ffffff
tal 339 er der 35 af padding = 7 farve = #81e87c
tal 338 er der 7 af padding = 5 farve = #ffffff
tal 337 er der 1 af padding = 5 farve = #ffffff

 
$str .= "tal " . $n_id . " er der " . $number . " af padding = " . $value['padding'] . " farve = " . $value['color'] . "<br>";

 
$str .= "<li><div style='background-color: ".$value['color']."'>".$number."</div></li>";

 
In PHP, there are three types of arrays:
Indexed arrays - Arrays with a numeric index
Associative arrays - Arrays with named keys
Multidimensional arrays - Arrays containing one or more arrays

 
<?php
/*
CREATE TABLE numbertable (
  `num_id` int(11) NOT NULL,
  `numbers` int(11) NOT NULL,
  `color` varchar(10) CHARACTER SET utf8 COLLATE utf8_danish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



INSERT INTO numbertable (num_id, numbers, color) VALUES
(337, 1, '81e87c'),
(338, 7, '81e87c'),
(339, 35, 'ffffff'),
(340, 13, '81e87c'),
(341, 0, 'ffffff'),
(342, 21, '81e87c'),
(343, 2, 'dfb07b'),
(344, 10, 'ffffff'),
(345, 28, 'ffffff'),
(346, 36, 'dfb07b');


ALTER TABLE numbertable
  ADD PRIMARY KEY (`num_id`);


ALTER TABLE numbertable
  MODIFY `num_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=347;
*/

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
//include('session.php');
// Selecting Database
// include 'dbconfic.inc.php';
$mysqli = mysqli_connect("localhost", "root", "", "test");



$stmt = $mysqli->prepare("SELECT * FROM numbertable ORDER BY num_id DESC LIMIT 27;");

// execute prepared statement
$stmt->execute();


/* bind result variabler */
$stmt->bind_result($n_id, $number, $color);
/* fetch values for hver row, her kun 1 row dog: */
$str = "";
while ($stmt->fetch()) {
    if ($number > 0) {        
        $str .= "\n<li><div style='background-color: #".$color."'>".$number."</div></li>";        
    }    
}
echo $str;

// luk statement
$stmt->close();

// luk connection
$mysqli->close();
?>

"orp_2" => array(
    "numbers" => array(1 => "#ffffff"
),

 

"orp_2" => array(
    "numbers" => array(1), "color" => "#ffffff"
),