How to create table in foreach

Question

This is my php code

    <?php
include_once 'conectDB.php';
$sql ='SELECT CHECKLISTS.USER_ID, CHECKLISTS.ADMIN_ID, PROGRAMS.PROGRAM_NAME
FROM CHECKLISTS
LEFT JOIN COMPUTERS
ON CHECKLISTS.USER_ID = COMPUTERS.COMPUTER_NAME
LEFT JOIN ADMINS
ON CHECKLISTS.ADMIN_ID = ADMINS.USER_ID
LEFT JOIN CHECKLIST_PROGRAMS
ON CHECKLISTS.ID = CHECKLIST_PROGRAMS.CHECKLIST_ID
LEFT JOIN PROGRAMS
ON PROGRAMS.ID = CHECKLIST_PROGRAMS.PROGRAM_ID
';

$result = $connection->query($sql);
$checklists = array();
if ($result->num_rows > 0){

  while($row = $result->fetch_assoc()) {

    $checklists [] = $row;
  }

} else {
  echo '0 results';
}
$connection->close();
?>

And this is HTML CODE in this foreach I don't know how to query and create table :(

<html>
<head>
  <link rel="stylesheet" type="text/css" href="bootstrap/css/bootstrap.min.css">
  <title>C.I.G. Check List</title></head>
  <body>
    <div class="container">
      <div class="row" style="margin-top:10px;">
        <div class="col-md-offset-2 col-md-8">
          <div class="row" style="margin-top:20px;">
          <div class="col-md-4"><h3>C.I.Gruop Checklist</h3></div>
          <div class="col-md-6" style="margin-top:19px; font-size:20px;"><a href="Addchecklist.php">New Item</a></div>
        </div></div>
      </div>
      <div class="col-md-2"></div>
      <div class="row" style="margin-top:20px;">
        <div class="col-md-offset-1 col-md-9">
          <!-- ส่วนแสดงผล -->
          <?php
          foreach ($checklists as $checklist) {
            print_r($checklist);
          }
          ?>
        </div>

      </div>

</div
  </body>
  </html>

pretty sure this is a duplicate: http://stackoverflow.com/questions/10057671/how-does-foreach-actually-work — SnakeFoot, Mar 31 '16 at 07:49

score 1 · Answer 1 · answered Mar 31 '16 at 07:47

1

You need to do like this:-

<table>
<?php
    foreach ($checklists as $checklist) {
        echo '<tr><td>'.$checklist.'</td></tr>';            
    }
?>
</table>

answered Mar 31 '16 at 07:47

D.k

442
4
13

score 0 · Answer 2 · answered Mar 31 '16 at 07:49

Creating table in foreach is simple. Try this:

<table>
    <thead>
        <tr>
            <th>Check List</th>
        </tr>
    </thead>
    <tbody>
        <?php
        foreach ($checklists as $checklist) {
            ?>
            <tr>
                <?php


                echo "<td>" . $checklist . "</td>";
                ?>

            </tr>
            <?php
        }
        ?>
    </tbody>
</table>

score 0 · Answer 3 · answered Mar 31 '16 at 07:49

0

One option can be:

<table>
  <? foreach ($checklists as $checklist) { ?>
  <tr>
    <td>
      <? echo $checklist; ?>
    </td>
  </tr>
  <? } ?>
</table>

Within the loop, everything you write is repeated as many times as the checklist items

answered Mar 31 '16 at 07:49

Miguel Jiménez

484
2
12

How to create table in foreach

3 Answers3