How to add custom php page?

[Aurox]

I want to add a php page that has some code that will tweak the sql.

 

If I just add it, I get page404 not found when I run it in the browser.

 

It contains variables like website.com/page.php?id=345

 

What to do?

[Daresh]

Build a module with a controller, like in this tutorial: http://doc.prestashop.com/display/PS16/Creating+a+first+module

[endriu107]

Do like Daresh said, or you can create only one page without module http://stackoverflow.com/questions/27385742/custom-page-in-prestashop-1-6-without-cms I think creating module is better option.