难倒桌子格式

Question

If you remember me from asking the 20+ questions yesterday, I'm still awake and still at it. I'd like to inform anyone who cares I've made GREAT progress.

What I'm trying to figure out now is how to create a minimum about of rows for a table to have. The reason being is if the Table on my page doesn't have exactly 12 rows, it looks bad. The problem is there won't always be 12 rows worth of data in the SQL Database, so I need to find a way to make it so if there's not 12 results it fills in the table with a character of choice, probably "--"

Also, I'm trying to figure out how to create pages for the table. I haven't done any research on that one yet and it's not what this questions about, but if you know how and want to drop it here, that'd be cool.

Answer 1

There are a few different ways you could go about this, but the basic idea is to know how many rows you printed, and if it's less than 12, print empty rows until you have the 12 you need. Here's one example:

Assuming you have your query results in an array called $data:

<table>
<?php
    foreach ($data as $row) {
        echo "<tr><td>{$row['col1']}</td><td>{$row['col2']}</td><td>{$row['col3']}</td></tr>";
    }
    if (count($data) < 12) {
        for ($i=0; $i < 12-count($data); $i++) {                        
            echo "<tr><td colspan='3'>EMPTY ROW</td></tr>";
        }
    }
?>
</table>