MYSQL Output - HTML Table

Question

I have a query to output data within my MYSQL database and would like it to display in a table. With "Name" and "UserID" as the headings... currently the code I have developed, does output the results but instead creates multiple instances of the table and doesn't create new rows.

Please could someone help me achieve my goal?

echo"
<table width='400' border='1'>               
<tr>
    <td>Name</td>
    <td>SystemID</td>
  </tr>
  <tr>
    <td> ".$row['FullName']." </td>
    <td> ".$row['UserID']." </td>
  </tr>
</table>";

Yes, but I know how to output tables, I just couldn't find why multiple instances were being created, until it was pointed out that I had it in my loop — Rsmithy
– Rsmithy, Commented Aug 30, 2012 at 14:54

insomiac · Accepted Answer · 2012-08-30 15:03:03Z

2

The Table should be defined outside of the loop of the data, you just loop through the data and add a row on every loop :

echo "<table width='400' border='1'> ";
echo "<tr>
    <td>Name</td>
    <td>SystemID</td>
  </tr>";

// Example of while loop :
   while ($row = mysql_fetch_array($results)) {
     echo"      <tr>
        <td> ".$row['FullName']." </td>
        <td> ".$row['UserID']." </td>
      </tr>";
   }

echo "</table>";

edited Aug 30, 2012 at 15:03

answered Aug 30, 2012 at 14:41

insomiac

5,6848 gold badges47 silver badges73 bronze badges

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

Comments

Mike Brant · Accepted Answer · 2012-08-30 14:41:30Z

2

If the code you have shown is within some kind of while loop that loops through the database results, it should be clearly evident why you get a bunch of one row tables. Your entire table output would happen with each loop execution. What you should be doing is outputting your table opening tag and header row before you start the data retrieval loop. Output only the row with each loop execution, and then output the table closing tag after you exit the loop.

answered Aug 30, 2012 at 14:41

Mike Brant

71.4k10 gold badges102 silver badges104 bronze badges

Comments

CKKiller · Accepted Answer · 2012-08-30 14:41:49Z

2

echo"
<table width='400' border='1'>               
<tr>
    <td>Name</td>
    <td>SystemID</td>
  </tr>";

while ($row = $result->fetch_assoc()) { // or whatever your retrieval code is
  echo "<tr>
    <td> ".$row['FullName']." </td>
    <td> ".$row['UserID']." </td>
  </tr>";
}

echo "</table>";

You need to echo the table open tag and headers then loop through the database results, then echo the table closing tag.

answered Aug 30, 2012 at 14:41

CKKiller

1,4321 gold badge16 silver badges20 bronze badges

1 Comment

Rsmithy Over a year ago

I see where I went wrong now, makes sense, a rookie mistake :)

user1317647 · Accepted Answer · 2012-08-30 14:44:11Z

2

You should put <table width='400' border='1'> <tr> <td>Name</td> <td>SystemID</td> </tr> before loop ( <HERE> while() { ... } AND </table> you should put after cycle...

it should look like this:

echo "
<table width='400' border='1'>
<tr>
    <td>Name</td>
    <td>SystemID</td>
  </tr>";

while(....) {
echo "               
 <tr>
    <td> ".$row['FullName']." </td>
    <td> ".$row['UserID']." </td>
  </tr>
";
}

echo "</table>";

answered Aug 30, 2012 at 14:44

user1317647

Comments

Saurabh Kumar · Accepted Answer · 2012-08-30 14:42:26Z

1

http://www.siteground.com/tutorials/php-mysql/display_table_data.htm

answered Aug 30, 2012 at 14:42

Saurabh Kumar

5,9554 gold badges23 silver badges30 bronze badges

Comments

Chris Bier · Accepted Answer · 2012-08-30 14:41:12Z

0

Use this inside the loop instead

echo"
  <tr>
    <td> ".$row['FullName']." </td>
    <td> ".$row['UserID']." </td>
  </tr>";

and put the rest of the table wrapping around the loop.

answered Aug 30, 2012 at 14:41

Chris Bier

14.5k19 gold badges69 silver badges107 bronze badges

Comments

Abdennour TOUMI · Accepted Answer · 2013-07-30 13:15:10Z

0

Don't complicate the mission ; you don't need to do loop ; mysql provides option whichi is --html , just use it :

mysql --html -uroot -e "USE mydb;select * from mytable"

if you want to display only : FullName and UserID :

mysql --html -uroot -e "USE mydb;select FullName,UserID from mytable"

answered Jul 30, 2013 at 13:15

Abdennour TOUMI

94.6k42 gold badges271 silver badges274 bronze badges

Collectives™ on Stack Overflow

MYSQL Output - HTML Table

7 Answers 7

Comments

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related