Using PHP for a database to my DVD & CD Collection need
 

Hi Guys,

I am about to undertake the mammoth task of cataloguing all my music CD's and my DVD collection.

I was going to use M$ Acess to enter all the details for DVD's the catergories would be: Title, Genre, Rating, Running time and so on.

For music CD's: Title, Artists, Genre and so on.

What I wanted to know is could I then use the saved Access database file with MySQL or PHP so that I could make a web server database and access the info that is stored in that Access file?

For instance rather than be limited to having the stored database file on one pc and having to install access on every machine to access that database and share that folder where the database is stored. I thought it would be better to make a webpage with either PHP or MySQL and be able to access that database file from any PC I choose to use.

Can this be done or do I need to enter all these details in a PHP database program?

I would be extremely grateful for any help anyone can offer me on this subject.

Thanks in advance. :)

I don't know about your question, but, do you know "extreme movie manager" program?

It can export your database in html format and other several options.
It obtain movie info from internet and you only need to type a few information. I think is the better way to do a movie database.

For mp3 there are another database programs similar to extreme movie manager.

Hi Luis,

Thank you for your response, it sounds very interesting and is a start on the right road to what I want to achieve.

I shall check it out thanks again. :)

You can do what you want (Access -> web page) using VBscript or ASP (I don't know about PHP).

If you want to use PHP and MySQL you don't need MSAccess.

Another (freeware) database server that I like a lot is Firebird.

Hi Michael,

If you know a little SQL, you can use SQLite http://www.sqlite.org
The good thing about that, is that it will run on just about any platform, and then you can program your front end in PHP.
SQLite doesn't need a database backend, so you don't need to set up a dedicated server like MySQL, PostgreSQL, MSSQL, etc.
We use SQLite at work on mission critical applications ;)

-kwag

@GFR

Thanks for your suggestions. :D

@kwag

Hi Karl,

Thank you also for your help, this sounds like a good solution to my problem.

I will definately head over to sqlite and do some research, thanks again buddy. :)

@All

Thank you all for your help and various options you have offered me here I greatly appreciate them. :)

Your welcome.