Getting database data into a html table

Question

I need to get the data of the database to an HTML table.

There were similar questions asked before but none of them were similar to my requirement.

I need to get the first row of the database to the first row of the table.

So I did this.

echo "<table id='main-table' border='1px solid'> <thead> ";
echo "<tr>";
                echo "<th>Board No</th>";
                 echo "<th>Number</th>";
 echo "</tr></thead><tbody>";

           while($query->fetch()){
                 echo "<form action='' class='' method='post'><tr>";
                   line 55 --> echo "<td>" . Board Code:".$row["board_code"] . Number:".$row["status"]  . "</td>";

                  echo "</tr> </form>";   
        }//End of While
  echo "</tbody></table>";

There is a syntax error in line 55 as mentioned above in the code.

String Concatination issue in same line 55.

Wit Wikky
– Wit Wikky

2018-11-23 04:42:21 +00:00
Commented Nov 23, 2018 at 4:42 — Wit Wikky
– Wit Wikky, Commented Nov 23, 2018 at 4:42

Bhoomi Patel · Accepted Answer · 2018-11-23 04:52:22Z

3

Check this code:

echo "<table id='main-table' border='1px solid'> <thead> ";
echo "<tr>";
              echo "<th>Board No</th>";
               echo "<th>Number</th>";
echo "</tr></thead><tbody>";

         while($query->fetch()){
               echo "<form action='' class='' method='post'><tr>";
               echo "<td> Board Code:".$row["board_code"]. "</td>";
                echo "<td>Number:".$row["status"]. "</td>";
                echo "</tr> </form>";
      }
echo "</tbody></table>";

answered Nov 23, 2018 at 4:52

Bhoomi Patel

77510 silver badges32 bronze badges

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

Comments

Asad · Accepted Answer · 2018-11-23 04:38:44Z

0

 "<td>" . Board Code:".$row["board_code"] ." Number:".$row["status"]  . "</td>";

edit your code like if it does not work please share your whole code will help you for sure

answered Nov 23, 2018 at 4:38

Asad

1241 silver badge9 bronze badges

Comments

Vaibhav Shettar · Accepted Answer · 2018-11-23 04:40:14Z

0

Check with this code

echo "<form action='' class='' method='post'><tr>";
                   line 55 --> echo "<td>" . Board Code:".$row["board_code"] ." Number:".$row["status"]  . "</td>";

                  echo "</tr> </form>";

answered Nov 23, 2018 at 4:40

Vaibhav Shettar

8202 gold badges10 silver badges22 bronze badges

Collectives™ on Stack Overflow

Getting database data into a html table

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related