make AMC db available over internet
Posted: 2010-07-06 19:22:38
Hi guys, first and for all, I'm not really sure where to start this topic. Mods, move it if necessary... And sorry about the long story 
I've been using AMC to catalog my movies from quite some time now. Got over 1000 items in the DB. That said, just wondering if I can make this data available over the internet somehow. It would be very handy when I'm in a shop looking through DVD's. Due to the large collection sometimes I'm not certain which one I already own and which ones I've simply seen somewhere else.
Buying the same disc twice is a bit stupid 
Currently I export the DB to HTML and put that file on my mobile every couple of weeks.
I do have a NAS at home that's always accessible, and it can be configured as webserver with MySQL/phpMyAdmin integrated.
So I thought I could regularly export the AMC db to a mySQL db, and code a very simple webinterface that shows some very basic info on all the items I have. This way I can have a semi-live view on my DB through my mobile (has internet).
As an intermediate step I'm now putting that HTML file I mentioned earlier on the NAS. But I think having the data in MySQL has also other advantages to explore.
However... MySQL/phpMyAdmin is totally new for me, and my knowledge about PHP is very very basic (I'm more of an ASP guy, but the NAS doesn't support it...). So I was wondering if I can fallback on an existing solution before spending the time of trying to figure this out on my own.
I've been using AMC to catalog my movies from quite some time now. Got over 1000 items in the DB. That said, just wondering if I can make this data available over the internet somehow. It would be very handy when I'm in a shop looking through DVD's. Due to the large collection sometimes I'm not certain which one I already own and which ones I've simply seen somewhere else.
Buying the same disc twice is a bit stupid Currently I export the DB to HTML and put that file on my mobile every couple of weeks.
I do have a NAS at home that's always accessible, and it can be configured as webserver with MySQL/phpMyAdmin integrated.
So I thought I could regularly export the AMC db to a mySQL db, and code a very simple webinterface that shows some very basic info on all the items I have. This way I can have a semi-live view on my DB through my mobile (has internet).
As an intermediate step I'm now putting that HTML file I mentioned earlier on the NAS. But I think having the data in MySQL has also other advantages to explore.
However... MySQL/phpMyAdmin is totally new for me, and my knowledge about PHP is very very basic (I'm more of an ASP guy, but the NAS doesn't support it...). So I was wondering if I can fallback on an existing solution before spending the time of trying to figure this out on my own.