php - display a table row by row

Question

I print my table like that:

print $tableHeader . $dataRow . $tableFooter;

the $dataRow is the result of a loop (getting data from DB and building the row, nothing unusual), it's something like:

while ($obj = mysql_fetch_object($res)) { 
  $dataRow .= ' <td width="210" style="...">' . $obj->title . ' <br /> '. $obj->screenName .' </td>';
  ...
  ...
}

The problem is when there is a huge amount of information to handle => huge amount of rows to build before displaying the final table.

How could I tell Apache to display it row by row ?

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. — Kermit
– Kermit, Commented Mar 28, 2013 at 14:03
apache has nothing to do with this. All you need is a proper pagination system. — Sebas
– Sebas, Commented Mar 28, 2013 at 14:06
If php assigns its variables, Apache can't help because it does not see variables. Use echo instead, if you can. — Voitcus
– Voitcus, Commented Mar 28, 2013 at 14:09

user2219905 · Accepted Answer · 2013-03-28 14:10:47Z

1

You could do it with Ajax.

You can make a pagination. When you click on a page, you load only the x results.
You can trigger the user's scroll and load more results.

I personnally use DataTables which can do the two things : http://www.datatables.net/

Hope that helps !

answered Mar 28, 2013 at 14:10

user2219905

382 bronze badges

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

Comments

Dvid Silva · Accepted Answer · 2013-03-28 14:09:05Z

0

Can't you paginate?

the way to go is to tell php to display piece by piece, but you will have to change your code a bit to something like.

print $tableHeader 
while ($obj = mysql_fetch_object($res)) { 
   print ' <td width="210" style="...">' . $obj->title . ' <br /> '. $obj->screenName .' </td>';
  flush();
}
print $tableFooter;

answered Mar 28, 2013 at 14:09

Dvid Silva

1,17213 silver badges25 bronze badges

Collectives™ on Stack Overflow

php - display a table row by row

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related