How to create a normal HTML Table filled in with Database Data using php?

Question

Hi im new to frontend world and i made a small sql database filled with some data , i could get the data from database to my php code as Associative Array but the problem is that i cant fill them inside my table , they appear upper and outside the table. with any help i'll be thankful.

<?php
include("page.html");
include("databaseConnection.php");

$sth = $conn->prepare("SELECT ID, userName from passwords");
$sth->execute();

$result[] = $sth->fetchAll();

if(isset($_POST["showData"])){

echo "<table style='border: 2px solid black'>
<tr>
<th style='border: 1px solid red'>ID</th>
<th style='border: 1px solid black'>User Name</th>
</tr> <tbody>";

foreach ($result as $key => $value) {
    foreach ($value as $key1 => $value1) {
        echo "<tr>
        <td>".print_r($value1['ID'])."</td>
        <td>".print_r($value1['userName'])."</td>
        </tr>";
    }

}
echo "</tbody></table>";


}
?>

enter image description of the result here

clem · Accepted Answer · 2017-09-28 10:29:54Z

1

You are using print_r inside a string concatenation.

foreach ($value as $key1 => $value1) {
    echo "<tr>
    <td>".print_r($value1['ID'])."</td>
    <td>".print_r($value1['userName'])."</td>
    </tr>";
}

Remove the print_r statements and the values will show up inside the table.

answered Sep 28, 2017 at 10:29

clem

3,3661 gold badge24 silver badges33 bronze badges

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

1 Comment

Sam Bo Hamdan Over a year ago

thx alot i removed one foreach aswell and the print_r it Works! , have a nice day Sir!.

Liogate · Accepted Answer · 2017-09-28 09:49:56Z

0

Your tbody tag should be parent of all your tr elements and your header in thead. Check this struct bellow:

<table>
 <thead>
  <tr>
     <th>Month</th>
     <th>Savings</th>
  </tr>
 </thead>
 <tbody>
  <tr>
     <td>January</td>
     <td>$100</td>
  </tr>
  <tr>
     <td>February</td>
     <td>$80</td>
  </tr>
 </tbody>
 <tfoot>
  <tr>
     <td>Sum</td>
     <td>$180</td>
  </tr>
 </tfoot>
</table>

answered Sep 28, 2017 at 9:49

Liogate

1651 gold badge1 silver badge7 bronze badges

1 Comment

Sam Bo Hamdan Over a year ago

thx for answer i've tryed this but also didnt work the result always appears outside the table

Krysan · Accepted Answer · 2017-09-28 10:04:27Z

0

A quick&dirty solution,not tested :-




<?php
include("page.html");
include("databaseConnection.php");

$sth = $conn->prepare("SELECT ID, userName from passwords");
$sth->execute();

$result[] = $sth->fetchAll();

if(isset($_POST["showData"])){

echo "<table style='border: 2px solid black'>
<tr>
<th style='border: 1px solid red'>ID</th>
<th style='border: 1px solid black'>User Name</th>
</tr> <tbody>";
foreach ($result as $key => $value) {
    foreach ($value as $key1 => $value1) {
?>
<tr>
<td><? echo $value1['ID']; ?></td>
<td><? echo $value1['userName']; ?></td>
</tr>
<?php
    }

}
echo "</tbody></table>";
}
?>

edited Sep 28, 2017 at 10:04

answered Sep 28, 2017 at 9:43

Krysan

116 bronze badges

9 Comments

Dwhitz Over a year ago

This does not provide an answer to a question, should be a comment. Please see When should I comment?. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker.

Krysan Over a year ago

sorry...but i am new to stackoverflow community...ok i will delete this answer (comment)

Sam Bo Hamdan Over a year ago

@Krysan sure i'll :)

Krysan Over a year ago

@SamBoHamdan well I am also a beginner in PHP,but I had solved this problem when I was learning PHP...

Sam Bo Hamdan Over a year ago

nice i hope that u can help me 2 @Krysan , u can find the pic in the Question

|

Collectives™ on Stack Overflow

How to create a normal HTML Table filled in with Database Data using php?

3 Answers 3

1 Comment

1 Comment

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related