.tpl files and website problem

Posted by whitstone86 on Stack Overflow See other posts from Stack Overflow or by whitstone86
Published on 2010-06-09T15:49:41Z Indexed on 2010/06/09 15:52 UTC
Read the original article Hit count: 187

Filed under:
|
|
|

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.

© Stack Overflow or respective owner

Related posts about php

Related posts about sql