Posted by Benjamin Bolbach on 05/02/05 20:08

I don't think that kind of template design would be a good solution.
It may seem to be a bit easier, but why don't you write a simple
DB class with its own query function, that returns you a filled array
On a select statement. Because the next thing to do is the error handling
Inside smarty directly. So you give up the division of logic an output.

Ben

-----Ursprüngliche Nachricht-----
Von: Jörg Hermsdorf [mailto:funtasyspace@yahoo.com]
Gesendet: Montag, 2. Mai 2005 18:58
An: smarty-general@lists.php.net
Betreff: [SMARTY] direct way to handle mysql result sets (via resource id)
with smarty

Hello List,
I would like to know if there is an easier way to
handle MySQL result sets in smarty? Currently I only
know of the approach to prepare an array out of the
resource id returned by mysql_query() :

....
$result = mysql_query('SELECT * FROM ...');
while ($row = mysql_fetch_assoc($result))
{
$result_array[] = $row;
}
$smarty->assign('results', $result_array);

Then I can use the result set within the {foreach
item=result from=$result_array}{/foreach} function.

But I'm looking for another way, where I can directly
assign the resource like this:

$smarty->assign('results', mysql_query('SELECT * FROM
....'));

.... is there a foreach-like smarty-plugin-function
that can handle a "resource id" instead of an array?

Thanks, Jörg.






___________________________________________________________
Gesendet von Yahoo! Mail - Jetzt mit 250MB Speicher kostenlos - Hier
anmelden: http://mail.yahoo.de

--
Smarty General Mailing List (http://smarty.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.1 - Release Date: 02.05.2005


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.1 - Release Date: 02.05.2005

[Back to original message]