Apologies if the title is in lowercase but it's describing an extension format.
I've started using Dwoo as my template engine for PHP, and am not sure how to convert my PHP files into .tpl templates.
My site is similar to, but not the same as, http://library.digiguide.com/lib/programme/Medium-319648/Drama/ with its design (except colour scheme and site name are different, plus it's in PHP - so copyright issues are avoided here, the design arguably could be seen as parody even though the content is different.
The database is called tvguide, and it has these tables:
Programmes
House M.D.
Medium
Police Stop!
American Dad!
The tablenames of the above programmes are:
housemdonair
mediumonair
policestopair
americandad1
Episodes
The tablenames for the above programmes' episode guides are:
housemdepidata
mediumepidata
policestopepidata
americandad1epidata
All of them have the following rows:
id (not an auto-increment, since I wish to dynamically generate a page from this)
episodename
seriesnumber
episodenumber
episodesynopsis
(the above four after id do exactly as stated)
I have a pagination script that works, it displays 20 records per page as I want it to.
This is called pmcPagination.php - but I won't post it in full since it would take up too much space.
However, I'm trying to get it so that variables are filled in like this:
(ok, so the examples below are ASP.NET, but if there's a PHP/MySQL equivalent I would gratefully appreciate this!!):
http://library.digiguide.com/lib/episode/741168
http://library.digiguide.com/lib/episode/714829
with the episode detail and data.
My site works, but it's fairly basic, and it's not online yet until my bugs are fixed.
Mod_rewrite is enabled so my site reads as http://mytvguide.com/episode/123456
or
http://mytvguide.com/programme/123456
http://mytvguide.com/WorldInAction/123456/Documentary/
I've tried looking on Google, but am not sure how to get this TV guide script to work at its best - but I think .tpl, and .php/MySQL is the way to go.
Any advice anyone has on making this project into a fully workable, ready to use site would be much appreciated, I've spent months refining this project!
P.S. Apologies for the length of this, hope it describes my project well.