Ryan Malesevich is back today with part two of his "iTunes Stats for Macintosh with PHP and MySQL" series, building on the groundwork laid in part one.

As promised I'm back again the second and should be the last part for the iTunes stats with PHP & MySQL. In the previous section I covered how to get your iTunes information from iTunes into a MySQL database. Since I didn't get any questions about it I can either assume that no one cares or no one had any troubles.

This part is not exclusive to a Mac, you can write your PHP scripts with any operating system that you want. So if you're not on a Mac but has a friend who does then you can send your friend your iTunes XML file and your friend can export the data for you. Let’s get stated shall we.

Since in the first part of the series, he showed how to put information into the database, he shows in this second part how to get things back out. There's code samples for connecting to the database, the SQL to grab all of the data out from the table and echo out the information inside. He also links to his stats as an example.

Ryan Malesevich is back today with part two of his "iTunes Stats for Macintosh with PHP and MySQL" series, building on the groundwork laid in part one.

As promised I'm back again the second and should be the last part for the iTunes stats with PHP & MySQL. In the previous section I covered how to get your iTunes information from iTunes into a MySQL database. Since I didn't get any questions about it I can either assume that no one cares or no one had any troubles.

This part is not exclusive to a Mac, you can write your PHP scripts with any operating system that you want. So if you're not on a Mac but has a friend who does then you can send your friend your iTunes XML file and your friend can export the data for you. Let’s get stated shall we.

Since in the first part of the series, he showed how to put information into the database, he shows in this second part how to get things back out. There's code samples for connecting to the database, the SQL to grab all of the data out from the table and echo out the information inside. He also links to his stats as an example.

In this first part of a new tutorial on Ryan Malesevich's blog today, he introduces you to a set of scripts that can help you get the play stats from Apple's iTunes software out to a MySQL database for report/display/whatever you want.

I'm back with the third and final way that I know how to get iTunes play stats. In case you missed it, the previous methods were Javascript in Windows and Applescript in Macintosh. This way is Mac-centric again, well just the exporting the iTunes data to a MySQL database is only for Mac, you can write the PHP scripts with whatever platform that makes you happy.

He starts off with the "hardest step" in the whole process - using SQLTunes to export the data from iTunes. He goes through the configuration of the software and the steps needed to actually get the stats out. With the data in the database, he wraps up part one. Keep an eye out for the second part, display those stats via PHP scripts to your anxiously waiting viewers.

In this first part of a new tutorial on Ryan Malesevich's blog today, he introduces you to a set of scripts that can help you get the play stats from Apple's iTunes software out to a MySQL database for report/display/whatever you want.

I'm back with the third and final way that I know how to get iTunes play stats. In case you missed it, the previous methods were Javascript in Windows and Applescript in Macintosh. This way is Mac-centric again, well just the exporting the iTunes data to a MySQL database is only for Mac, you can write the PHP scripts with whatever platform that makes you happy.

He starts off with the "hardest step" in the whole process - using SQLTunes to export the data from iTunes. He goes through the configuration of the software and the steps needed to actually get the stats out. With the data in the database, he wraps up part one. Keep an eye out for the second part, display those stats via PHP scripts to your anxiously waiting viewers.

From Engadget today, there's a look at how you can, using a PHP installation and some scripts, control iTunes from any web browser.

For today’s how-to we’re going to set up a simple web server in XP so that we can control iTunes remotely. Engadget reader Jordan Parker was tired of having to walk into the other room to change tracks so he put together the PHP script we’ll be using. The page it generates should be usable on any device with a web browser. Similar solutions exist for OS X. Click on to get the full skinny — it’s worth your time, promise!

They give you a zip file of all of the images and PHP scripts you'll need. They then walk you through the installation of PHP on WinXP, using something called BRS WebWeaver as the server. Then you start it all up, head over to the player.php script, and, if all went well, you'll have a working iTunes interface.

From Engadget today, there's a look at how you can, using a PHP installation and some scripts, control iTunes from any web browser.

For today’s how-to we’re going to set up a simple web server in XP so that we can control iTunes remotely. Engadget reader Jordan Parker was tired of having to walk into the other room to change tracks so he put together the PHP script we’ll be using. The page it generates should be usable on any device with a web browser. Similar solutions exist for OS X. Click on to get the full skinny — it’s worth your time, promise!

They give you a zip file of all of the images and PHP scripts you'll need. They then walk you through the installation of PHP on WinXP, using something called BRS WebWeaver as the server. Then you start it all up, head over to the player.php script, and, if all went well, you'll have a working iTunes interface.

On AllForces.com today, there's this new post with a pointer to some PHP scripts that can interact with the iTunes Music Store.

Check out these PHP scripts that access the iTunes Music Store to grab the Album Art in all it’s 600x600px glory. Also, Benjamin Morin has posted on his blog a set of scripts (script only not demo) to access the free videos like trailers and music videos from the iTunes Music store.

Included in the scripts on this page are:

• iTunes Album Art SEARCH
• iTunes Music Videos
• iTunes Movie Trailers

On AllForces.com today, there's this new post with a pointer to some PHP scripts that can interact with the iTunes Music Store.

Check out these PHP scripts that access the iTunes Music Store to grab the Album Art in all it’s 600x600px glory. Also, Benjamin Morin has posted on his blog a set of scripts (script only not demo) to access the free videos like trailers and music videos from the iTunes Music store.

Included in the scripts on this page are:

• iTunes Album Art SEARCH
• iTunes Music Videos
• iTunes Movie Trailers