CodeIgniter Forums
How to store video paths in mysql - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: How to store video paths in mysql (/showthread.php?tid=13959)



How to store video paths in mysql - El Forum - 12-13-2008

[eluser]phpserver[/eluser]
I am involved in a small project that will enable my users watch videos.I want to save paths in a mysql database that will enable me do the following.

Delete a video
View all my videos in a list
Watch a video

Any help is welcome.


How to store video paths in mysql - El Forum - 12-13-2008

[eluser]m4rw3r[/eluser]
It would probably be the same way you store images which users have uploaded.

Store them in a certain directory (maybe also subdirectories for each user) and then store the filename (and subdir name) in the database.
Then you also need a user_id column, to fetch the owning user / find all videos for a certain user.