Quantcast Programming: Using PHP for a Database to my DVD & CD Collection Need - digitalFAQ.com Forums [Archives]
  #1  
08-01-2005, 04:06 PM
Zyphon Zyphon is offline
Free Member
 
Join Date: Oct 2003
Location: London, England (UK)
Posts: 1,035
Thanks: 0
Thanked 0 Times in 0 Posts
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.
__________________
Regards.

Michael.
Reply With Quote
Someday, 12:01 PM
admin's Avatar
Site Staff / Ad Manager
 
Join Date: Dec 2002
Posts: 42
Thanks: ∞
Thanked 42 Times in 42 Posts
  #2  
08-01-2005, 04:16 PM
Prodater64 Prodater64 is offline
Free Member
 
Join Date: Mar 2003
Location: Palma de Mallorca - España
Posts: 2,925
Thanks: 0
Thanked 0 Times in 0 Posts
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.
Reply With Quote
  #3  
08-01-2005, 04:45 PM
Zyphon Zyphon is offline
Free Member
 
Join Date: Oct 2003
Location: London, England (UK)
Posts: 1,035
Thanks: 0
Thanked 0 Times in 0 Posts
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.
__________________
Regards.

Michael.
Reply With Quote
  #4  
08-02-2005, 06:12 AM
GFR GFR is offline
Free Member
 
Join Date: May 2002
Posts: 438
Thanks: 0
Thanked 0 Times in 0 Posts
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.
Reply With Quote
  #5  
08-02-2005, 07:01 AM
kwag kwag is offline
Free Member
 
Join Date: Apr 2002
Location: Puerto Rico, USA
Posts: 13,537
Thanks: 0
Thanked 0 Times in 0 Posts
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
Reply With Quote
  #6  
08-02-2005, 11:23 AM
Zyphon Zyphon is offline
Free Member
 
Join Date: Oct 2003
Location: London, England (UK)
Posts: 1,035
Thanks: 0
Thanked 0 Times in 0 Posts
@GFR

Thanks for your suggestions.

@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.
__________________
Regards.

Michael.
Reply With Quote
  #7  
08-02-2005, 12:05 PM
Prodater64 Prodater64 is offline
Free Member
 
Join Date: Mar 2003
Location: Palma de Mallorca - España
Posts: 2,925
Thanks: 0
Thanked 0 Times in 0 Posts
Your welcome.
Reply With Quote
Reply




Similar Threads
Thread Thread Starter Forum Replies Last Post
Python: iPod shuffle Database Builder kwag Avisynth Scripting 0 06-29-2005 12:48 AM
How to fix corrupt codec database? rs008f Video Encoding and Conversion 5 08-23-2004 07:34 PM
Great database for your movies : Ant Movie Catalog Graal_CPM Off-topic Lounge 1 04-06-2003 09:07 AM
Any recommendations for an MP3 Cataloguer/Database app? el_mero_zooter Audio Conversion 4 09-24-2002 08:11 PM
KVCD: Suggestion - some kind of database? Pike Players, DVRs, Media Centers 1 08-09-2002 10:15 AM

Thread Tools



 
All times are GMT -5. The time now is 01:18 AM  —  vBulletin © Jelsoft Enterprises Ltd