Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2

Thread: streaming video

  1. #1
    New to the CF scene
    Join Date
    Jul 2011
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    streaming video

    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,

  • #2
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,634
    Thanks
    4
    Thanked 148 Times in 139 Posts
    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.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •