I'm trying to get 12 variables set depending on the data pulled from my database. At the moment I have it setting them into an array and then into a variable from there. However, for some reason the 12th value from my db isn't being entered into my array and then when I attempt an echo of each variable I get miss matched dates. Can anyone see where I'm going wrong here?
Example DB
date1 = 01/01/2018
date2 = 02/01/2018
date3 = 03/01/2018
date4 = 04/01/2018
date5 = 05/01/2018
date6 = 06/01/2018
date7 = 07/01/2018
date8 = 08/01/2018
date9 = 09/01/2018
date10 = 10/01/2018
date11 = 11/01/2018
date12 = 12/01/2018
Example Array
Array
(
[0] =>; 01/01/2018
[1] =>; 02/01/2018
[2] =>; 03/01/2018
[3] =>; 04/01/2018
[4] =>; 05/01/2018
[5] =>; 06/01/2018
[6] =>; 07/01/2018
[8] =>; 08/01/2018
[9] =>; 09/01/2018
[9] =>; 10/01/2018
[10] =>; 11/01/2018
[11] =>; 12/01/2018 //-----This isn't being added-----
)
Example Echo
$var1 = 01/01/2018 //-----Should be 01/01/2018-----
$var2 = 02/01/2018 //-----Should be 02/01/2018-----
$var3 = 01/01/2018 //-----Should be 03/01/2018-----
$var4 = 02/01/2018 //-----Should be 04/01/2018-----
$var5 = 03/01/2018 //-----Should be 05/01/2018-----
$var6 = 01/01/2018 //-----Should be 06/01/2018-----
$var7 = 02/01/2018 //-----Should be 07/01/2018-----
$var8 = 03/01/2018 //-----Should be 08/01/2018-----
$var9 = 04/01/2018 //-----Should be 09/01/2018-----
$var10 = 01/01/2018 //-----Should be 10/01/2018-----
$var11 = 02/01/2018 //-----Should be 11/01/2018-----
$var12 = 03/01/2018 //-----Should be 12/01/2018-----
<?php
include 'db.php';
if (isset($_GET['id'])) {
$id = $_GET['id'];
$sql = "SELECT * FROM system WHERE `id` = '$id' AND `status` = 'Not Set'";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
if ($result->num_rows > 0) {
$arrayResults = array();
$i = 0;
while($row = $result->fetch_assoc()) {
array_push($arrayResults, $row['date']);
foreach($arrayResults as $value){
${'var'.$i} = $value;
$i++;
}
}
print_r($arrayResults);
echo '<br><br>';
echo $var1.'<br>';
echo $var2.'<br>';
echo $var3.'<br>';
echo $var4.'<br>';
echo $var5.'<br>';
echo $var6.'<br>';
echo $var7.'<br>';
echo $var8.'<br>';
echo $var9.'<br>';
echo $var10.'<br>';
echo $var11.'<br>';
echo $var12.'<br>';
}
}
?>
UPDATE
The echo dates are now echoing in the correct order only issue now is it's still missing the first entry from the database so it's only creating 11 variables not 12. The array data prints all dates but the first, so the array entries are from [0] to [10] when it needs to be [0] to [11].
<?php
include 'db.php';
if (isset($_GET['id'])) {
$id = $_GET['id'];
$sql = "SELECT * FROM system WHERE `id` = '$id' AND `status` = 'No Set'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
$row = $result->fetch_assoc();
$arrayResults = array();
$i = 0;
while($row = $result->fetch_assoc()) {
array_push($arrayResults, $row['date']);
${'var'.$i} = $row['date'];
$i++;
}
print_r($arrayResults);
echo '<br><br>';
echo $var0.'<br>';
echo $var1.'<br>';
echo $var2.'<br>';
echo $var3.'<br>';
echo $var4.'<br>';
echo $var5.'<br>';
echo $var6.'<br>';
echo $var7.'<br>';
echo $var8.'<br>';
echo $var9.'<br>';
echo $var10.'<br>';
echo $var11.'<br>';
}
}
?>
You should put the "foreach" outside of the "while"
while($row = $result->fetch_assoc()) {
array_push($arrayResults, $row['date']);
}
foreach($arrayResults as $value){
${'var'.$i} = $value;
$i++;
}
Please note that this make loop twice over the results. You could instantiate the "$varx" directly inside the while. And if you have no other use for $arrayResults you can skip it.
while($row = $result->fetch_assoc()) {
array_push($arrayResults, $row['date']);//this line is not compulsory. Depends if you need $arrayResults later.
${'var'.$i} = $row['date'];
$i++;
}
You echo from $var1, but your loop starts from $i = 0;
Try setting $i = 1, or start echoing $var0 and ending on $var11