[dancer-users] How to data into webpage

[Alex Mestiashvili]

On 08/20/2015 04:17 AM, Richard Reina wrote:
> Have been learning Dancer2 over the last few weeks and really like it.
> Wondering if someone can tell me how I can load data from a MySQL
> database into a dancer rendered page. I am comfortable writing SQL in
> perl via perl->DBI just don't have any idea how to bring the data from
> a fetch into a webpage so that I can display it directly on the page
> or load it into a dropdown menu. Any help is greatly appreciated.
>
> Thanks

The page is generated from a template,
just pass your variables containing the data from sql to the template,
and the templating engine such as "simple" or "template_toolkit"  ( see
config.yaml )
will take care about displaying your data.

Dancer::Tutorial has pretty good example:
https://metacpan.org/pod/Dancer2::Tutorial
Also have a look on https://metacpan.org/pod/Dancer2::Plugin::Database