Skip navigation.

Harold's Home

   Home
  
XML version of this site

PHP Scripts

Index
CLI fun
Mail on 404
HB-NS (NewsScript)

Downloads

Applescripts
APOD to Desktop
Dreamweaver Extensions

Stuff

Writings
Other stuff
Central Grinder

OOOk Default:

VJ stuff
VJ Tools
Bananas
Strippers
Sample Movies

News

iTunes database to MySQL pt. II
Last week I linked to phptunest which can import an iTunes library XML file to a MySQL database.

Well, here is the search script I promised which is pretty nifty:
see the source or download a zipfile which includes the stylesheet.

Change a few values at the top of the script and you're good to go.

I encountered a few problems with the import which had to do with the XML parser of the importfunction choking on special entities with ampersands (like &) but I figured out a workaround which I've submitted to the author of phptunest.

You can also see a live version of the script running on my homemachine (which may or may not be running):
http://oook.xs4all.nl/metal/intune.php?field=artist&words=My%20Dying%20Bride. Note that clicking on a trackname will bring up a password dialog as my music is in a protected area. Don't bother asking for the password.

Show all items | Read all items

About, copyright, privacy and accessibility | Mail