php - My table is not populating correctly -
i trying grab mysql table throw table. reason, it's throwing 1 row instead of creating new rows more data.
i have code here:
<?php //display current users asc on view $q="select * users order id asc"; $r=mysqli_query($dbc,$q); ?> <div class="panel panel-default"> <!-- default panel contents --> <div class="panel-heading">user manager</div> <div class="panel-body"> <p>some default panel content here. nulla vitae elit libero, pharetra augue. aenean lacinia bibendum nulla sed consectetur. aenean eu leo quam. pellentesque ornare sem lacinia quam venenatis vestibulum. nullam id dolor id nibh ultricies vehicula ut id elit.</p> </div> <!-- table --> <div class="table-responsive"> <table class="table table-striped"> <thead> <tr> <th>userid</th> <th>first name</th> <th>last name</th> <th>email</th> <th>status</th> <th>role</th> </tr> </thead> <tbody> <?php echo "<tr>"; // display users onto table while (($list= mysqli_fetch_assoc($r))){ echo"<td>".$list['id']."</td>"; echo"<td>".$list['fname']."</td>"; echo"<td>".$list['lname']."</td>"; echo"<td>".$list['email']."</td>"; echo"<td>".$list['status']."</td>"; echo"<td>".$list['role']."</td>"; } echo"</tr>";?> </tbody> </table> </div> </div>
all tr
tags out of loop.
Comments
Post a Comment