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

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

@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

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

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

Collectives™ on Stack Overflow

BOOTSTRAP Table in a PHP Foreach loop

3 Answers 3

1 Comment

Comments

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

2 Comments

Related