Smarty

[jaxyeh]

Hello Guys,

I am starting to develop some huge php project along with smarty templates... However, I came up with one problem using {html_options} along with array that depends on DATABASE... Which means, array are not defined through by regular assigned method, but array retrieved through DATABASE. so I use SECTION LOOP to define array variables, but how can I define them without loop or using {html_options}??

I decided to do those follow method, using {section loop} above the {html_options}. It works fine. But I wasn't sure if its logical correction, so I am asking you guys who're expert with Smarty templates to observe and give me feedback on this method...

here 's PHP code:
[php:1:01a2a09dbf]
$query = "SELECT * FROM groups ORDER BY groupid ASC";
if ($groups = $db->array_query($query)) {
$smarty->assign('groups', $groups);
$smarty->assign('group_id', '2');
}
[/php:1:01a2a09dbf]

here's TPL code using {section}:

[messju]

hmm, htmloptions already takes *arrays* as parameters for values and output. i would suggest tweaking your db-result, so that smarty can handle them easily:

[php:1:6b2e921f4f]
if ($groups = $db->array_query($query)) {
$groups_opts = array();
foreach ($groups as $group) {
$groups_opts[$group['groupid']]=$group['name'];
}
$smarty->assign('groups_opts', $groups_opts);
$smarty->assign('group_id', '2');
}
[/php:1:6b2e921f4f]

after that you have a hash-array in your template mapping id->name.
that fits perfectly for {html_options}'s options-attribute:

[jaxyeh]

That's the perfect answer I am looking for!!! THANKS!!

your an angel!

-jax

[mikeken]

are you guys using ezsql or whatever its called?