I have started to make some code, but I really do not know how to make my while loop, or if I am thinking right at all.
I have a formfield, where I can put in a number. That number is printed out in:
<div id="showsection">
<ul class="sectionnumbers" style="list-style:none; padding: 4px 0px 0px 0px ;">
<?php include('sections.php');?>
</ul>
</div>
Everytime I fx put in the number "0", it should get the background: "#81c77d", with a height on 20px; I have made the arrays for it, which I think is okay?
But how can I make my while loop for it?
<?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';
$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");
// '?' 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: */
while ($stmt->fetch()) {
echo "<li><div style='background-color: ".$voisins."</li>";
// loop through number and echo the background color of array
}
}
// luk statement
$stmt->close();
// luk connection
$mysqli->close();
echo "test";
?>