How to display data from database in select?

Question

MODX

There is a database of goods with characteristics. When loading the page it is necessary to load all the products of the category to load in the select. Let me show you how to do it.
When choosing a characteristic with an ajax request, you need to change the price (the length of the product changes, and accordingly the product is already different).
Please tell me the logic of this functionality.
I'm planning to write a snippet to generate a list of features on the page when it loads. As well as another snippet that processes an ajax request that makes a request to the database. He will update the price.
Nothing else comes to mind.

Answer 1

It is not necessary to make requests for every sneeze. You can pre-select the necessary data and push it into a js variable and already work with it (this is, of course, if prices do not change often)