Pull row from database corressponding to url route

[Rareform]

I know I probably butchered the wording of the title, but what I want is to get a row from my database that corresponds with the url routing thing that slim does, ex: ‘www.mysite.com/pages/1’ i want to return row one of the table - ‘www.mysite.com/pages/57’ would return row 57 of the table. I know practically no slim so the more detail and dumb talk you can provide the better. Thanks.

If this is possible, how would I use the output to fill a page? I was told that I could use twig templates to do this, but don’t really know how.

If this is too much info and no one want to spend the effort typing out how all this stuff works, just a point in the right direction tutorial/learning wise would be much appreciated, ive been trying to google this stuff on my own for some 20 hours this weekend and keep failing. thank you.

[odan]

Welcome @Rareform

For the beginning I would like to recommend you some Slim Framework resources and tutorials:

Please read the Slim Documentation first:

• http://www.slimframework.com/docs/
• http://www.slimframework.com/docs/v3/start/installation.html

Also learn the basics about PSR-7, Routing and DI.

• http://www.slimframework.com/docs/v3/concepts/value-objects.html
• http://www.slimframework.com/docs/v3/concepts/middleware.html
• http://www.slimframework.com/docs/v3/concepts/di.html

Then try to create the first Slim application:

• https://github.com/odan/slim-hello-world (Hello World)
• http://www.slimframework.com/docs/v3/tutorial/first-app.html (Slim with Nginx & PHP templates)
• https://odan.github.io/2017/11/30/creating-your-first-slim-framework-application.html (Slim with Apache and Twig)

Good luck

[Rareform]

Ok ill take a look at the links thanks so much!