NETGEAR is aware of a growing number of phone and online scams. To learn how to stay safe click here.
Forum Discussion
Movie database project
Hey guys. I need some help with a project. I have tons of movies stored on my NAS and also tons of physical DVD's & BD's. I'm looking for a way to create a database stored on my NAS where I can ...
Hi,
I've actually done exactly what you are looking for here. But it's pretty hardcoded as it started out by just listing out my movie directory pretty plain, and then I started patching on it. It was back in the days, when my programming skills were pretty basic. So I won't release it or something, but I can give you an idea of how I did it.
I'm using PHP, mySQL, JavaScript and jQuery, and an Android application (I've moved to the Apple-world now, so I better make an iOS-version also, or a mobile web app).
All my movie and series information is stored in mySQL. I have a cron job that is executed every night, looking for new files in my series and movie folders. I am specific about how I name my files. This is because I check my episode against thetvdb.com that provides a nice API. Here I also download posters and stuff, that I store on my NAS web server and use to show the information. The movies are checked agaist Imdb. They don't provide an open API, so here I use a PHP-wrapper.
To fetch information from the DB I have created a REST-ish API with some PHP-scripts that delivers JSON. This way I can easily get the information using AJAX to my web site, and to my Android application. Both these apps allows me to browse my episodes and movies, as well as marking what I've seen and not. I've also made a script that checks if there are new episode of the series i already got. This info is show in a widget i my Android app, which is pretty sweet :)
Hope this was to any help and inspiration. You can come pretty far with the stack supported on the ReadyNAS.
I've actually done exactly what you are looking for here. But it's pretty hardcoded as it started out by just listing out my movie directory pretty plain, and then I started patching on it. It was back in the days, when my programming skills were pretty basic. So I won't release it or something, but I can give you an idea of how I did it.
I'm using PHP, mySQL, JavaScript and jQuery, and an Android application (I've moved to the Apple-world now, so I better make an iOS-version also, or a mobile web app).
All my movie and series information is stored in mySQL. I have a cron job that is executed every night, looking for new files in my series and movie folders. I am specific about how I name my files. This is because I check my episode against thetvdb.com that provides a nice API. Here I also download posters and stuff, that I store on my NAS web server and use to show the information. The movies are checked agaist Imdb. They don't provide an open API, so here I use a PHP-wrapper.
To fetch information from the DB I have created a REST-ish API with some PHP-scripts that delivers JSON. This way I can easily get the information using AJAX to my web site, and to my Android application. Both these apps allows me to browse my episodes and movies, as well as marking what I've seen and not. I've also made a script that checks if there are new episode of the series i already got. This info is show in a widget i my Android app, which is pretty sweet :)
Hope this was to any help and inspiration. You can come pretty far with the stack supported on the ReadyNAS.
NETGEAR Academy
Boost your skills with the Netgear Academy - Get trained, certified and stay ahead with the latest Netgear technology!
Join Us!
