Smarty Looping Hash

[Anon]

Hi,

I am using Smarty template engine for a project and I was wondering whether there is a way tos save one step of assigning values to variables to each variable we want to use in the template. That is, a way we can pass in a hash of a MySQL Result object and so, the only modification is on the template and the SQL query structure.

Any ideas whether Smarty can do this, and how.

$query = mysql_query("SELECT id, ip FROM table";
while ($row = mysql_fetch_assoc($query))
{
$smarty->assign("test",$row);
}

We were experimenting of passing this and in our template identify where we want the array placed. Any ideas?

[Anon]

Try something like this... (off the top of my head, will likely need tweaked to get it to work).

WHILE( list($key,$val)=each($mysql_fetch_array($query))
{
$obj->assign(array(STRTOUPPOER($key)=>$val));
}

This assumes that the field name in your table is the same as your template token.

[Anon]

I talked with Monte last Friday, and we figured a nice way to handle it:

pagination.php

$result = mysql_query("select * from ipaddress LIMIT 10);
while ($row = mysql_fetch_array($result))
{
$results[] = $row;
}

$smarty->assign("results",$results);
$smarty->display("page.html");

page.html

{section name=query loop=$results}
{$results[query].ipid}.) {$results[query].ipaddress}<HR>
{/section}