On Friday 29 Nov 2002 11:22 pm, Olaf Marzocchi wrote: > Could you suggest me a good MySQL and PHP tutorial available in the web?
www.devshed.com > Thank you > > Olaf > > At 23.22 29/11/2002, you wrote: > >On Sat, 2002-11-30 at 08:47, Guilherme Cirne wrote: > > > Hi, > > > > > > Does anybody know of good database applications for cataloging CD's > > > > under ML > > > > > 9.0? > > > >I've been using the cddb_get package with a MySQL database. > > > >http://armin.emx.at/cddb/CDDB_get-latest.tar.gz > > > >Works very well. > > > >Create the database with 'mysqladmin create CDs', then from the > >CDDB_get-2.11 directory, do 'mysql CDs <DATABASE'. > > > >You now have a MySQL database called CDs with 2 tables, cds and tracks. > > > >Then do 'perl Makefile.pl' then 'make' & 'make install' > > > >You'll have to edit the resulting cddb.pl with the correct login > >information for your MySQL server. localhost for the server, root as the > >user, and "" for the password works for a default installation. > > > >I also added the following line to cddb.pl so that the cd drawer ejects > >after writing to the database (on line 356): > > > > system ("eject /dev/scd0"); #or whatever your cd device is... > > > >So, while connected to the Internet, simply put in your cds one by one, > >run 'cddb.pl' and it will go off to the Internet, grab the cddb info, > >and populate your database. You may have to manually add any cds that > >don't exist in the cddb database, I suggest that you investigate > >phpMyAdmin for this. I'll leave that up to you :) > > > >Also, believe it or not, I wrote a couple of php pages to view my > >collection only yesterday... > > > >Put them under /var/www/html and view them with your browser. > > > >I hope that this solution fits the bill. > > > >Kind regards, > > > >John... > > <olaf@ kjws.com> for every kind of mail, except spam! :-) -- Jordan Elver http://www.jordanelver.co.uk "> How do I read MIME files??? Quietly, while pretending to be trapped in an invisible box. :)"
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
