bootstrap display data from mysql in table

Question

I am trying to display my mysql rows to html bootstrap table. Database connection is working, displaying data is working, but it is not fancy as i want. I'd like to maybe save in arrayData maybe and then print this arrayData in html tag. Please any suggestions much appreciated. I want to do this easiest way and most convenient for editing later on. php code to display data :

    if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "id: " . $row["id"]. " - Name: " . $row["name"]. " " . $row["lastName"]. "<br>"; /* and so on..*/
    }
} else {
    echo "0 results";
}

and this is my html code for bootstrap

    <table class="table table-striped">                     
<div class="table responsive">

  <thead>
    <tr>
      <th>#</th>
      <th>Name</th>
      <th>Last Name</th>
      <th>Number</th>
       <th>Info</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th scope="row">1</th>
      <td>ales</td>
      <td>king</td>
      <td></td>
        <td></td>
    </tr>
    <tr>
      <th scope="row">2</th>
      <td>love</td>
      <td>2</td>
      <td>code</td>
        <td></td>
    </tr>

  </tbody>
        </div>
   </table>

EDIT: i want this, but loaded from database not manually typed :)!

what is the expected result supposed to look like? You didn't say much in your question regarding this. — Funk Forty Niner
– Funk Forty Niner, Commented May 1, 2016 at 14:52
no. i want mysql data to display in this table. pagination is next! — swipeales
– swipeales, Commented May 1, 2016 at 15:00
oh, I see. Well it's not that hard really. Just place your <table></table> tags outside the loop and use the <tr></tr> and <td>$var</td> tags. HTML 101 stuff ;-) You can further your research by looking for "mysql html formatted table". — Funk Forty Niner
– Funk Forty Niner, Commented May 1, 2016 at 15:02

ScaisEdge · Accepted Answer · 2016-05-01 15:15:42Z

3

You can use a php loop this way

<table class="table table-striped">                     
    <div class="table responsive">
        <thead>
            <tr>
              <th>#</th>
              <th>Name</th>
              <th>Last Name</th>
              <th>Number</th>
               <th>Info</th>
            </tr>
        </thead>
        <tbody>
<?php 

....

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {


        echo '<tr>
                  <td scope="row">' . $row["id"]. '</td>
                  <td>' . $row["name"] .'</td>
                  <td> '.$row["lastName"] .'</td>
                </tr>';





    }
} else {
    echo "0 results";
} 
?>
       </tbody>
    </div>
</table>

answered May 1, 2016 at 15:15

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

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

3 Comments

swipeales Over a year ago

thanks works, i have one more question, if i have link in database how could i use <a href to it and add name LINK to display in table thank you!

swipeales Over a year ago

<td> <a href='".$row['info']."'>Link</a></td> it doesn't work with <a href?

swipeales Over a year ago

i fixed it a href without " "

Neko · Accepted Answer · 2016-05-01 15:22:11Z

1

I would do something like this: ( but you should really read some basic PHP )

<?php

echo "<table>";

// table header
echo "<tr><th>id</th><th>Name</th><th>Lastname</th></tr>";

// output data of each row
while($row = $result->fetch_assoc()) {

    echo "<tr><td>".$row["id"]."</td><td>".$row["name"]."</td><td>".$row["lastName"]."</td></tr>";
}

// table footer

echo "</table>";

?>

answered May 1, 2016 at 15:22

Neko

416 bronze badges

4 Comments

swipeales Over a year ago

thanks works, i have one more question, if i have link in database how could i use <a href to it and add name LINK to display in table thank you!

Neko Over a year ago

Same as before: echo "<a href='".$row['linkfromdb']."'>Link</a>";

swipeales Over a year ago

i copied your code and i get error 500 <td> <a href='".$row['info']."'>Link</a></td>

swipeales Over a year ago

i fixed it a href without " "

Collectives™ on Stack Overflow

bootstrap display data from mysql in table

2 Answers 2

3 Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related