How to work on custom page?

[venkatesh]

Hi

I created custom page like this way

1.comment.php -> inside prestashop root folder

2.CommentController.php -> /prestashop/controllers/

3.Comment.php -> /prestashop/classes/

4.comment.tpl -> /prestashop/themes/MyTheme/

 

now i want to retrieve data from database. where to write code and how to pass it to .tpl file