Forum PHP.pl

<table>
{section name=id loop=$titles}
<tr>
<td>Tytuł: {$titles[id]}<br/>
Cena: {$prices[id]}<br/>
Autor: {$authors[id]}</td>
</tr>
{/section}

<?php
include ("Smarty.class.php");
$smarty = new Smarty();
$conn = pg_connect('dbname=xxxx user=xxxxx password=xxxxxx');
if(! is_resource($conn)) {
throw new Exception('Nie można połączyć się z bazą danych.');
}


$result = "SELECT title, price, author from books";
$rs = pg_query($conn, $result);
while ($row = pg_fetch_assoc($rs))
{
$titles[] = $row['title'];
$prices[] = $row['price'];
$authors[] = $row['author'];
}
$smarty->assign("titles",$titles);
$smarty->assign("prices",$prices);
$smarty->assign("authors",$authors);

$smarty->display("sample_section2.tpl");

?>