View Full Version : streaming video

07-28-2011, 01:06 PM
Greetings, I'm new to this forum and php and mysql and had a question about streaming video. I know I'm a little far away from doing that but I am one of those people that will not be able to sleep until it is figured out.

I was wondering if someone could help me understand the logic to how you would setup mysql and php to show video.

Like in what way would I store the users videos. Would I make separate databases for each user (dynamically), and it would display all the video files in that database for that user. Or should it all go into one database and users videos are separated by different tables instead of by different databases? ect,ect..

Any help would be great. Thank-you,

07-28-2011, 01:15 PM
all in one database and likely all the videos stored in a single table.

table one
userid, username

table two
videoid, description, link

table three
userid, videoid

a new row in this table for each video a user has.

General practice is to store the videos (or files such as PDFs etc.) outside of the database and store the path to the files in your database.