How to output a loop in smarty?

Question

css

hello, please tell me an example of outputting a loop in smart along with a php request to the database.
I searched the Internet almost everything does not work and an error occurs.
I just need a query to a row in the database, for example, the ads table and the name column for this column, there are several thousand records, I want to display all of them in one array in the template in a loop, no matter how much I tried, nothing happens, maybe someone saw a 100% working example or knows

Answer 1

Like this? https://jsfiddle.net/madeas/cgga14pr/

Answer 2

https://vestride.github.io/Shuffle/

Answer 3

https://github.com/topics/filter

Answer 4

https://isotope.metafizzy.co/v2/

Answer 5

Smarty does not provide database queries; it's basically none of his business. He needs to serve a ready-made array and iterate over it in a loop - for example, foreach.

Answer 6

<?php
$arr = array(1000, 1001, 1002);
$smarty->assign('myArray', $arr);
?>

<ul>
{foreach from=$myArray item=foo}
    <li>{$foo}</li>
{/foreach}
</ul>