Associating Images, Video, Audio to Records in Table

Collapse
This topic is closed.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
  • shms
    Private

    • Nov 2019
    • 3

    Associating Images, Video, Audio to Records in Table

    Dear Support,

    Greetings!

    I'm registered with Bluevoda and my website is: www.seetharamhospital.com

    I'm creating database and tables - just wondering is it possible to associate (or store) media like Images, Audio, Video with records.

    What should be the field type for the same.

    Any insight will be very helpful.

    Thanks much.

    Regards,
    Ram
  • VodaHost
    General & Forum Administrator

    • Mar 2005
    • 12356

    #2
    Re: Associating Images, Video, Audio to Records in Table

    Hi,

    It is possible but it is not recommended to store images or video into a database. Usually you would store these in a folder on your account and then make a link from the database to the folder for loading. This cuts down on database size and makes loading faster.

    The field type should be LONGBLOB for all.

    VodaHost

    Your Website People!
    1-302-283-3777 North America / International
    02036089024 / United Kingdom
    291916438 / Australia

    ------------------------

    Top 3 Best Sellers

    Web Hosting - Unlimited disk space & bandwidth.

    Reseller Hosting - Start your own web hosting business.

    Search Engine & Directory Submission - 300 directories + (Google,Yahoo,Bing)


    Comment

    • shms
      Private

      • Nov 2019
      • 3

      #3
      Re: Associating Images, Video, Audio to Records in Table

      Great.
      Thanks much for the advice..
      As suggested, I will upload the media in the folder and provide a link where ever needed.

      Comment

      • VodaHost
        General & Forum Administrator

        • Mar 2005
        • 12356

        #4
        Re: Associating Images, Video, Audio to Records in Table

        Hi,

        You're welcome!

        VodaHost

        Your Website People!
        1-302-283-3777 North America / International
        02036089024 / United Kingdom
        291916438 / Australia

        ------------------------

        Top 3 Best Sellers

        Web Hosting - Unlimited disk space & bandwidth.

        Reseller Hosting - Start your own web hosting business.

        Search Engine & Directory Submission - 300 directories + (Google,Yahoo,Bing)


        Comment

        Working...
        X