Build table with php and sql

Question

I want to use prepared statement which works fine if it's just one row, but when I want to build a table it only shows the first row. I'm missing something simple somewhere, but I've tried all sorts of things which just broke.

<?php 
        $dbh = dbh_get();
        $sql = 'SELECT * FROM products
            WHERE prod_id >6
            ORDER BY prod_id';
        $stmt = $dbh->prepare($sql);
        $stmt->execute();
        $r = $stmt->fetch();

print '
    <tr>
        <td>' . $r['login_id'] . '</td>
        <td>' . $r['outlet_code'] . '</td>
        <td>' . $r['user_name'] . '</td>
        <td>' . $r['user_role'] . '</td>
        <td>' . $r['last_login'] . '</td>
        <td>' . $r['user_id'] . '</td>
    </tr>' . "\n";
dbh_free($dbh);
?>

Unsure if it's the php or the sql which is the problem

Nick · Accepted Answer · 2018-10-28 11:36:39Z

1

You need to loop on the results of $stmt->fetch() as it will return one row per call:

while ($r = $stmt->fetch()) {
    print '
    <tr>
        <td>' . $r['login_id'] . '</td>
        <td>' . $r['outlet_code'] . '</td>
        <td>' . $r['user_name'] . '</td>
        <td>' . $r['user_role'] . '</td>
        <td>' . $r['last_login'] . '</td>
        <td>' . $r['user_id'] . '</td>
    </tr>' . "\n";
}

answered Oct 28, 2018 at 11:36

Nick

147k23 gold badges67 silver badges106 bronze badges

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

Collectives™ on Stack Overflow

Build table with php and sql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related