iTunes Stats

5 Replies

1. Tim adds this Comment:

   I was wondering about creating actual queries, similar to iTunes for my database. I have very little mySQL experience, so it’s probably a easy solution. What is needed to do a sql search, and display the results? Don’t worry, I’m hoping to by an O’reilly mySQL book soon.

   January 3rd, 2007 at 11:05 pm

2. Shayne adds this Comment:

   I would love to see you just insert every xml key into the song table. I don’t really see why you stopped where you did, having more data would allow for things like summing up sizes, times, are they compilations, even linking for shared across a network.

   An Update to this would be simply awesome.

   January 22nd, 2007 at 2:52 pm

3. sherwin adds this Comment:

   thanks for making this, it saves me from creating one myself

   i had to modify the truncate query in the index.php file. it didn’t include the $database_table_prefix so it wasn’t emptying the tables whenever the xml file is loaded into the database.

   line 40-42 i changed it to the following
   $result = mysql_query(”TRUNCATE TABLE `”.$database_table_prefix.”artist`”);
   $result = mysql_query(”TRUNCATE TABLE `”.$database_table_prefix.”album`”);
   $result = mysql_query(”TRUNCATE TABLE `”.$database_table_prefix.”song`”);

   if you can incorporate this into wordpress as a plugin w/ an upload page, it would be great

   August 24th, 2007 at 3:37 pm

4. Constantinos Neophytou adds this Comment:

   re: your note starting at line 69 in index.php. A better way to do that would be simply:

   $song->$next = (string) $property;

   though I’m not sure if this would work in php4.

   Also, did anyone have any problems with unicode characters in the library.xml file? they show up as gibberish in mysql. I’ve started by modifying install.php to include:

   ENGINE=MyISAM DEFAULT CHARSET=utf8

   after all the tables, but it’s still messed up and i can trace it back to the simplexml_load_file function. Any ideas?

   August 26th, 2007 at 12:50 pm

5. dfbills adds this Comment:

   I’d like to use this code to track changes in the iTunes database by processing the xml nightly and recording differences.

   Anyone done work in this area?

   October 11th, 2007 at 7:39 am

Add a Comment

Please note: Use of a non-personal web site or blog in the field below and/or comments that are off-topic, personal attacks, or support requests will likely be removed at my discretion.