On 12 Oct 2006, at 07:27 , Peter Dominic Ryan - Subscriptions Account
wrote:
Each page is exactly the same, but for the content related to
the particular video. I have a list of all the vids, their
attributes and so on, ready to populate my template, but it
just seems silly having to do it by hand.
It seems silly doing this with 200 web pages.
This is a job for a very simple php page.
Yes, but not everyone knows PHP. Hence my question.
Yes, but this would be a very very simple php script and would
mean having one script page instead of hundreds of nearly
identical html files.
And, of course, this could be perl or python just as easily.
I don’t know much, if anything about PHP, but I assume I would need
to learn MySQL as well
ie. to create a database of all of the videos and their attributes?
Depends on exactly what you want. there are many ways to skin this
particular cat. A mysql databse is certainly one if you want to
store a lot of data about each video, especially if you want to be
able to modify that data easily and via the web.
But, if for example you only want to know the name, filesize, and
type, you can do that all within the script quite easily.
On the other hand, if you want to keep track of a lot of information,
like who shot the video using what equipment on what date and in what
conditions and what the licensing is for that video, the cost to use,
reboradcast rights, number of accesses, resolution, compression
scheme, and so on and so on, then a simple mysql database might be
worth doing.
Really, basic php is dead simple, and so is basic sql. I am no über-
programmer or anything, and my eyes glaze over at things like 'class'
and 'OOP', but basic php I picked up in a couple of lazy days worth
or work and the sql stuff just sort of hitched along for the ride.
But, as Patrick said, this should go to Web-Authoring. We're well
beyond the scope of BBEdit here.
--
"Let's get back to syntax of procmail and forget the syntax of
fools." - Don
--
------------------------------------------------------------------
Have a feature request? Not sure the software's working correctly?
If so, please send mail to <[EMAIL PROTECTED]>, not to the list.
List FAQ: <http://www.barebones.com/support/lists/bbedit_talk.shtml>
List archives: <http://www.listsearch.com/BBEditTalk.lasso>
To unsubscribe, send mail to: <[EMAIL PROTECTED]>
