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):
. 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.