Help: Store video/image files in database
furious_gamer
Excessive happiness
^^ Storing images in DB is not good idea unless it's the photo of employee or anything similar to that. get the image using normal File input and use BLOB. Otherwise store images under a folder and name it with your primary_key . filename. very easy to pick the file instead of retrieve it from DB and way easy to store.
furious_gamer
Excessive happiness
^^ See if video files, i would not suggest you to store it in DB and no way you can store it in DB. Yes, create a folder in server and create folders according to whatever criteria you need to store them.
Ex. If facebook like app, i would store images like server_path/user_images/user_id/
under this folder three subfolder named profie_pic, gallery(again sub-folders) and video.
Under this video folder i'll store whatever video he uploaded.
This is the fastest and correct way to do. In the meanwhile, refer the video name in some tables, so that user can search for the video name and play it. This way, you can fetch the video names from DB and when user click on link, retrieve the video from folder.
Ex. If facebook like app, i would store images like server_path/user_images/user_id/
under this folder three subfolder named profie_pic, gallery(again sub-folders) and video.
Under this video folder i'll store whatever video he uploaded.
This is the fastest and correct way to do. In the meanwhile, refer the video name in some tables, so that user can search for the video name and play it. This way, you can fetch the video names from DB and when user click on link, retrieve the video from folder.
furious_gamer
Excessive happiness
^^
Write the code in such a way that if that folder doesn't exists, create one. In this way no need to export things.
Write the code in such a way that if that folder doesn't exists, create one. In this way no need to export things.