mercredi 7 juin 2017

PHP does not work correctly, doesn't display if statements correctly?

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