Template select menu query

[jbeauviala]

Hi, I have a template that will contain a rather large form, where many of the form fields are select menus consisting of many items. We used to do this with database queries, and I would prefer not to hard code values into the template.

Is there a way to either query a csv file to build the menu values ? Or if not, to query MySQL/SQLite.

Thanks,

j.

[pixelijn]

@jbeauviala

Is there a way to either query a csv file to build the menu values ? Or if not, to query MySQL/SQLite.

Yes, of course.

You can find a simple .csv reader function in the Virtual pages guide. As regards database handling, Kirby has the Database class that makes database handling rather easy.