PHP smarty database output

Question

How to output all rows in a database with smarty ?

David Conde · Accepted Answer · 2011-03-31 12:12:32Z

5

Basically, read the database data in a "controller" or something like that and send them to smarty using a variable, much like this:

$db = GetSomeDbObject();

$rows = $db->Query("Select * From aTable");
$smarty->assign("rows", $rows);
$smarty->display("index.tpl");

And, now in a smarty file (index.tpl)

<h2>Smarty Rows</h2>
{foreach $rows as $row}
  Row Name: {$row.FieldName}
{/foreach}

answered Mar 31, 2011 at 12:12

David Conde

4,6472 gold badges37 silver badges48 bronze badges

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

1 Answer 1