How to create Grid or Table Data in Templates module.

[brys]

In prestashop 1.7.5 I have an admin controler which extends FrameworkBundleAdminController.

Now I want to download data from my table in this controller and display it in the grid (table) in a similar way as customer data or their addresses are displayed. How do you do it in a twig based template?

Unless you can do it differently using a helper.

 

[ABCDino]

You can retrieve DataBase information via

$query = 'SELECT * FROM myTable';
$rowsList = Db::getInstance()->executeS($query);

You can use a helper to display your form, in the same way you would do in a module.

$helper = new HelperForm();
...
$fields_form = ...
...
return $helper->generateForm($fieldsForm);

 

[brys]

But i use controler which extends FrameworkBundleAdminController

I have error 500

 

[ABCDino]

You can try this tutorial https://devdocs.prestashop.com/1.7/modules/sample_modules/grid-and-identifiable-object-form-hooks-usage/