Hey Don,
It sounds like you've got a long road ahead of you if you're not too familiar, but don't be discouraged!
So I'll run through this how I would set it up and hopefully it should give you a better idea. Although I'm still unsure on how to randomize your videos: 1. I'd either upload my videos to a web server or upload them to youtube(because there's nothing wrong with styling a youtube player to work how you want instead of using something less robust).
2. Then I'd create a database with a link to each of the videos in it, so since you're familiar with SQL I won't go into this too much but each link would have its own ID.
3. Then in your HTML code you'll need to pull one of the links in, you can do this by using PHP and MySqli. MySqli is much more secure than MySql so it's a must. So by using these codes you'll need to 'connect to your servers database', 'query the database' and then 'echo' out the link into the HTML. (http://www.codecademy.com/en/tracks/php might be a good place to start)
4. With the link pulling through from your database you can then utilize them with an embed tag(provided by Youtube) or insert it as the source of your chosen video players code.
If you then want to provide it as a package to customers then you'd be best to turn it into a widget. But you should definitely get the functionality down before you do anything else.
As for randomizing the videos, I'm sure there's a way you can query the database and ask it for a random result between ID number etc etc, but I'll leave that to you to find out :)
Hope this helps and feel free to check out our tutorials too!
http://www.meowplates.co.uk/web-tutorials
|