MySQL Video Database Questions

Question

4.00/5 (1 vote)

See more:

, +

Hello,

I've got a few questions that I'd like to ask of you all in the know.

Before I outline what I'm trying to achieve, I'll state my experience level. I've done a little programming in the past, and was at some point fairly proficient in scripting html, javascript, vb and c, but I've not really touched it in a long while so am quite rusty.

What I'd like to achieve is a website which has the capability of storing and searching a video database (videos can either be stored independantly on my own server, or via youtube for example), and need to be searched by location and distance from location and by keyword.

I want it to look in terms of formatting like dailymotion. I've got my own logos and what have you already designed.

I also need a pretty basic login function with a favourite videos section. On each page of video I need to be able to add some sort of description.

I'd like to be able to support different quality of videos but as long as I can get 360p I'll be happy.

I've been looking at Visual Web Developer and MySQL databases. It seems I could manually organise videos into an SQL db, and use MySQL/VWD to recall the videos from the db into a video handler, connected to a player?

I've not got the ins and outs of how exactly I would do that but it seems theoretically this could work?

Amy ideas on where to start/ how to code something like this up? Any links to tutorials/good articles for a beginner would be awesome!

Thanks.

RMC

Posted 16-Feb-11 21:18pm

renegmc

Updated 17-Feb-11 3:28am

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Henry Minute · Accepted Answer · 2011-02-17T05:04:00

Solution 1

This[^] might help with some ideas, if nothing else.

As might this one[^] from Microsoft.

Posted 17-Feb-11 5:04am

Henry Minute

Comments

renegmc 17-Feb-11 19:19pm

Thanks for that, helpful articles.

As an aside, is there anyway of using a player, and rerouting the source to find and play a different video?

Not that I'm suggesting taking code from elsewhere... xD

Henry Minute 17-Feb-11 19:23pm

If you mean a player control, then all you have to do is give it a new uri and it will play whatever is there, assuming it is a valid media file.

Otherwise, I don't know.