News Feed
Sections




News Archive
feed this:

Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Ryan Malesevich's Blog:
iTunes Stats for Macintosh with PHP & MySQL Part 2
August 14, 2006 @ 10:55:41

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.

1 comment voice your opinion now!
itunes stats part2 macintosh display database play count itunes stats part2 macintosh display database play count


Ryan Malesevich's Blog:
iTunes Stats for Macintosh with PHP & MySQL Part 1
August 10, 2006 @ 13:06:27

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.

0 comments voice your opinion now!
part1 itunes stats play count sqltunes mysql export part1 itunes stats play count sqltunes mysql export


Nexen.net:
April 2006 PHP Usage Stats
May 09, 2006 @ 14:00:50

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.

0 comments voice your opinion now!
usage stats april2006 graph version php5 php4 usage stats april2006 graph version php5 php4



Community Events





Don't see your event here?
Let us know!


symfony interview threedevsandamaybe language community podcast development introduction laravel api list code deployment conference release series zendserver tips bugfix framework

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework