News Feed
Sections




News Archive
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


blog comments powered by Disqus

Similar Posts

PHPBuilder.com: Dynamic XML with PHP

Christopher Jones' Blog: Highly Scalable Connection Pooling in PHP

David Coallier's Blog: PEAR::DB is Deprecated, Got It?

Federico Cargnelutti's Blog: Database Replication Adapter for Zend Framework Applications

Gennady Feldman's Blog: Performance tips, APC vs Eaccelerator


Community Events





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


tool library laravel podcast community series opinion symfony list composer voicesoftheelephpant artisanfiles release security introduction language version conference framework interview

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