This PHP script doesn't work as expected. I want it to change the amount of the rounded values displayed on the page based on the database amounts, but it always shows the "1 round" code, even if the DB is 4,5 etc. How can I fix this?
Code:
<?php
$servername = "";
$username = "";
$password = "";
$dbname = "";
$con = new mysqli($servername, $username, $password, $dbname);
if ($con->connect_error) {
die("Connection failed: " . $con->connect_error);
}
else{
$sql = "SELECT rounds FROM vf_Discussion";
$result = $con->query($sql);
$allRounds = $result->fetch_row();
$rounds = $allRounds[0];
var_dump($rounds);
}
mysqli_close($con);
?>
<?php
$rounds1 = '<h2 class="CommentHeading">Round 1 (Pro)</h2> <br> <h2 class="CommentHeading">Round 1 (Con)</h2>';
$rounds2 = '<h2 class="CommentHeading">Round 2 (Pro)</h2> <br> <h2 class="CommentHeading">Round 2 (Con)</h2>';
$rounds3 = '<h2 class="CommentHeading">Round 3 (Pro)</h2> <br> <h2 class="CommentHeading">Round 3 (Con)</h2>';
$rounds4 = '<h2 class="CommentHeading">Round 4 (Pro)</h2> <br> <h2 class="CommentHeading">Round 4 (Con)</h2>';
$rounds5 = '<h2 class="CommentHeading">Round 5 (Pro)</h2> <br> <h2 class="CommentHeading">Round 5 (Con)</h2>';
?>
<?php
foreach($allRounds as $rounds) {
if ($rounds == 1) {
echo $rounds1;
foreach ($Sender->Data('Answers') as $Row) {
$Sender->EventArguments['Comment'] = $Row;
WriteComment($Row, $Sender, Gdn::Session(), 0);
}
}
if ($rounds == 2) {
echo $rounds1;
echo $rounds2;
foreach ($Sender->Data('Answers') as $Row) {
$Sender->EventArguments['Comment'] = $Row;
WriteComment($Row, $Sender, Gdn::Session(), 0);
}
}
if ($rounds == 3) {
echo $rounds1;
echo $rounds2;
echo $rounds3;
foreach ($Sender->Data('Answers') as $Row) {
$Sender->EventArguments['Comment'] = $Row;
WriteComment($Row, $Sender, Gdn::Session(), 0);
}
}
if ($rounds == 4) {
echo $rounds1;
echo $rounds2;
echo $rounds3;
echo $rounds4;
foreach ($Sender->Data('Answers') as $Row) {
$Sender->EventArguments['Comment'] = $Row;
WriteComment($Row, $Sender, Gdn::Session(), 0);
}
}
if ($rounds == 5) {
echo $rounds1;
echo $rounds2;
echo $rounds3;
echo $rounds4;
echo $rounds5;
foreach ($Sender->Data('Answers') as $Row) {
$Sender->EventArguments['Comment'] = $Row;
WriteComment($Row, $Sender, Gdn::Session(), 0);
}
}
}
?>
Aucun commentaire:
Enregistrer un commentaire