BOOTSTRAP Table in a PHP Foreach loop

Question

I have som trouble finding out what i am doing wrong. I am using Bootstrap Table in a foreach loop

 Foreach($fetchSite as $rows)
  {
      $sname = $rows['name'];
      echo "<div class='well'>"
      . "<h4>$sname</h4>";


      foreach ($fetchDep as $rowd)
      {  
          $depn = $rowd['dep'];
          echo "<h5>$depn:</h5>";

  foreach($fetchUserdata as $row)
  {
      $uname = $row['username'];
      $team = $row['team'];
      $stime = $row['sttime'];
      $depna = $row['dep'];
      $siten = $row['name'];

      if($sname == $siten)
      {




        if($depn == $depna)
        {
             echo "<div class='row'>"

        . "<div class='table-responsive'>"
        . "<table class = 'table table-striped' style='width: 500px;'>"
        . "<thead><tr><th>Bruger:</th><th>Team:</th><th>startet:</th></tr></thead>"; 

          echo "<tr><td>".$uname."</td><td>".$team."</td><td>".$stime."</td></tr>";
            echo "<tbody>"
        . "</tbody>"
        . "</table>"
        . "</div>"


        . "</div>";  
        }


      }


  }//end Foreach FetchUSerdata

  }// end Foreach Depfetch  
  echo "</div>";

  } // End Foreach FetchSite

The problem is that there are to many Bruger:, Team: and startet

i only want 1 line of Bruger, Team: and startet and then the users listed below. I know where the problem is:

 if($depn == $depna)
        {
             echo "<div class='row'>"

        . "<div class='table-responsive'>"
        . "<table class = 'table table-striped' style='width: 500px;'>"
        . "<thead><tr><th>Bruger:</th><th>Team:</th><th>startet:</th></tr></thead>"; 

          echo "<tr><td>".$uname."</td><td>".$team."</td><td>".$stime."</td></tr>";
            echo "<tbody>"
        . "</tbody>"
        . "</table>"
        . "</div>"


        . "</div>";  
        }

But i dont no how to solve it. Sorry for my bad english and stupid question. Merry Christmas

put table tag and th tags out of your loop and it will be clear — Alaa M. Jaddou
– Alaa M. Jaddou, Commented Dec 23, 2015 at 23:05

Mr Lister · Accepted Answer · 2015-12-29 11:34:17Z

1

The only thing you would want to leave inside the foreach is the <tr> and <td> sections. Leave the <table..> and <th> (table headers outside) the foreach that way it will generate a table.

Example

echo "<div class='row'>"
     . "<div class='table-responsive'>"
     . "<table class = 'table table-striped' style='width: 500px;'>"
     . "<thead><tr><th>Bruger:</th><th>Team:</th><th>startet:</th></tr></thead>";

foreach($fetchUserdata as $row)
  {
      $uname = $row['username'];
      $team = $row['team'];
      $stime = $row['sttime'];
      $depna = $row['dep'];
      $siten = $row['name'];

      if($sname == $siten)
      { 
        if($depn == $depna)
        {   
          echo "<tbody>"
               ."<tr><td>".$uname."</td><td>".$team."</td><td>".$stime."</td></tr>";
               . "</tbody>"
        }
      }
  }
          echo "</table>"
               . "</div>"
               . "</div>";  
//end Foreach FetchUSerdata

edited Dec 29, 2015 at 11:34

Mr Lister

46.8k15 gold badges118 silver badges156 bronze badges

answered Dec 23, 2015 at 23:14

Og Ramos

461 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Og Ramos Over a year ago

@MrLister Thank you for the edit! I'm quite new to answering :)

Alaa M. Jaddou · Accepted Answer · 2015-12-23 23:13:02Z

Foreach($fetchSite as $rows)
{
  $sname = $rows['name'];
  echo "<div class='well'>"
  . "<h4>$sname</h4>";


  foreach ($fetchDep as $rowd)
  {  
      $depn = $rowd['dep'];
      echo "<h5>$depn:</h5>";
     echo "<div class='row'>"
    . "<div class='table-responsive'>"
    . "<table class = 'table table-striped' style='width: 500px;'>"
    . "<thead><tr><th>Bruger:</th><th>Team:</th><th>startet:</th></tr></thead>"; 

 echo "<tbody>";
foreach($fetchUserdata as $row)
{
  $uname = $row['username'];
  $team = $row['team'];
  $stime = $row['sttime'];
  $depna = $row['dep'];
  $siten = $row['name'];

  if($sname == $siten)
  {
    if($depn == $depna)
    {
      echo "<tr><td>".$uname."</td><td>".$team."</td><td>".$stime."</td></tr>"; 
    }
  }
}//end Foreach FetchUSerdata
    echo "</tbody>"
    . "</table>"
    . "</div>"
    . "</div>";
}// end Foreach Depfetch  
  echo "</div>";

} // End Foreach FetchSite

Tyler Sebastian · Accepted Answer · 2015-12-23 23:10:50Z

0

It's really difficult to understand what you're asking, but I think I got the gist. The following code example takes an array

$fetchSite = [
    [
        'something' => 'a',
        'something_else' => 'b'
    ],
    ...
]

and turns it into a table

something | something_else
----------+---------------
    a     |        b

code:

<table>
    <thead>
        <tr>
            <?php foreach(array_keys($fetchSite[0]) as $column) { ?>
                <th><?=$column?></th>
            <?php } ?>
        </tr>
    </thead>
    <tbody>
        <?php foreach($fetchSite as $row) { 
            foreach($row as $column) { ?>
                <td><?=$column?></td>
        <?php } 
        } ?>
    </tbody>
</table>

perhaps that will help you

answered Dec 23, 2015 at 23:10

Tyler Sebastian

9,5887 gold badges42 silver badges64 bronze badges

2 Comments

Alaa M. Jaddou Over a year ago

he just need to make the th not appear at every row it fetch.

Tyler Sebastian Over a year ago

@AlaaM.Jaddou ah I see

Collectives™ on Stack Overflow

BOOTSTRAP Table in a PHP Foreach loop

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related