PHP echoing the wrong number of columns in HTML table

vba_php · November 16, 2019, 5:52pm

hello everyone,

I have a PHP query:

$sql = mysqli_query($conn, "SELECT ip
                                 , host
                                 , page 
                                 , DATE_FORMAT(date, '%m/%d/%y') as date
                                 , TIME_FORMAT(time, '%T') as time
                            FROM tblTraffic 
                            ORDER BY date DESC, time DESC");

and I’m echoing out the results in this code:

    <?php
        // printing table rows
        while($row = mysqli_fetch_row($sql)) {
            echo '<tr>'; 
            foreach ($row as $key => $col) {
				echo "<td>$col</td>"; }
            echo '</tr>';
        }
        
    ?>
</table>

however, in the attached image you can see what I’m getting as an output. I don’t think my code is wrong. Can someone here maybe see something that is wrong with this?

VISITOR IP ADDRESS, ISP NAME	VISITOR DOMAIN ADDRESS		PAGE VISITED	DATE	TIME

whispers · November 16, 2019, 6:10pm

cant see the image (waaay too small to be worth anything)

how about trying to explain what we are looking at?

What is going on? (results)
vs
What you want? (expected results)

vba_php · November 16, 2019, 6:37pm

can’t you right click on the image and “save as”, download it to your machine and look at it there? I did and it is of proper size.

This is what I get:

6 columns when there’s only 5 being echoed. Columns headers are: “VISITOR IP ADDRESS, ISPNAME”, “VISITOR DOMAIN ADDRESS”, “BLANK”, “PAGE VISITED”, “DATE”, “TIME”.
the PAGE VISITED data appears in column 3 which has a BLANK header, the DATE data appears in column 4 which has a header saying 'PAGE VISITED", the TIME data appears in column 5 which has a header saying DATE and column 6 has no data but has a header that says TIME.

This is what I want:

The table output just like my code shows: 5 columns - “VISITOR IP ADDRESS, ISPNAME”, “VISITOR DOMAIN ADDRESS”, “PAGE VISITED”, “DATE”, “TIME”, with all column headers centered in the middle of their table cells and the appropriate data in the correct columns.

thanks.

phdr · November 16, 2019, 6:42pm

The html markup for your table heading section contains a mistake.

vba_php · November 16, 2019, 7:17pm

thank you so much for pointing that out! it works perfectly now. what a simple issue.