PHPDeveloper.org

Ryan Malesevich's Blog: iTunes Stats for Macintosh with PHP & MySQL Part 2

Mon, 14 Aug 2006 10:55:41 -0500

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's Blog: iTunes Stats for Macintosh with PHP & MySQL Part 1

Thu, 10 Aug 2006 13:06:27 -0500

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.

Nexen.net: April 2006 PHP Usage Stats

Tue, 09 May 2006 14:00:50 -0500

Damien Seguy of Nexen.net has submitted the latest PHP stats for the month of April 2006, including some evidence that PHP5 is gaining ground.

According to this latest information, PHP5 usage is gaining ground, and is now being used in about 7.2 percent of PHP installations. On the PHP 4 series front, PHP 4.4.2 is almost to the point of overtaking 4.3.10 as the largest insall base of any PHP version so far.

Damien has also included some new graphs in this edition, including one that shows Apache adotpion by country, one showing PHP's usage on large systems architecture, and a cumulative version graph of the usage of several of the more popular PHP versions.

You can check out the complete graphs for April here and get to the general PHP useage graphs here.