Forum Moderators: coopster
on my page, every video has it's own html page.
i want to eliminate those individual pages and i want to use php so that everytime a link to one of the videos is clicked, the file (or reference to it) is called from the db.
somehow i can't seem to put together the logic or come to realize if it's even possible to do this.
PLEASE HELP! feel free to ask if more info is needed or if i didn't make myself too clear.
[edited by: ergophobe at 2:54 pm (utc) on Sep. 10, 2004]
[edit reason] URL deleted as per TOS [/edit]
2) you could probably do this in a pretty straightforward way using php and your db; the thing is, you'll need to read the manual at php.net for connecting to your database, and getting at your database info. None of this can really be explained in just a few short paragraphs, you really need to learn this part of php and your database sql, so I'm afraid the most honest answer is somewhat rtfm'ish.
3) you are probably a newbie indeed, since otherwise you wouldn't have posted quite in this fashion - so you'll probably want to read the tutorial at php.net, and read up on the various functions in detail, and do a lot of trial php code before you even really begin to think about writing this specific code for your site. If you don't have hours and hours to give to learning php and sql, you should probably try to find a good professional.
[edited by: jatar_k at 4:47 pm (utc) on Sep. 10, 2004]
Well one thought would be for all of your links to go to a single page/script that could deliver the video and construct the page according to what video is being requested.
Some thoughts about that though. Are the pages as you have them right now already spidered in search engines?
If so you may want to keep the individual pages and then just set a var and then include the page builder script. This will keep nice static urls.
Your link could be
<a href="/movies/movietitle.html">Movie Title</a>
this would require your html pages to be parsed for php as well. Then the page could be
<?php
$moviename = 'movietitle';
include $_SERVER['DOCUMENT_ROOT'] . '/templates/pagegenerator.php';
?>
If you really get organized all the titles could be the page names and you could just use parse the url to deliver the content.