How To Extract Data From Database In Html

I’m new to CS-Cart but have built some site & apps in html & php.

I’m building a special Website/Content Page.

I need to extract data from the database to display in my html code.

Normally I would simple embed in the html to select the data but it’s not working here.

What should I do to grab the list of products in a specified category?

select product from cscart_products_categories, cscart_product_descriptions where cscart_products_categories.product_id = cscart_product_descriptions.product_id and cscart_products_categories.category_id=40


Product 1

Product 2

Product 3 …


I am afraid there is no ability to execute PHP code in default CMS pages.