MySQL/PHP Music Charts

freeflow · 10-22-2010, 01:00 PM

Hi everyone. Can you help me find a solution for the following idea?

Is there a way to load (using PHP/MySQL) the top music chart titles and the band names from “somewhere” into my MySQL database? I would like to do this once a week using a cron job on the server.

**Eric** · 10-23-2010, 05:14 PM

You could either scrape (ehh) or use an RSS feed (if the place has one), and place the data into a MySQL db. The hardest part would be actually getting the data in the first place, where are you wanting to pull it from?

freeflow · 10-24-2010, 01:38 AM

Hi Eric,
Thanks for your reply. I knew this was going to be a bit complicated, but maybe there is a solution. I haven’t figured out yet from where to get the chart lists. There are many sites out there that offer this kind of service and I can’t imagine that they all upload the charts manually.

This is the data format I need:

song name - band name
song name - band name
...

What is “scrape (ehh)”?

What code do I need to do this using RSS feeds?

Obulus · 10-24-2010, 04:03 AM

The BBC Website may be able to provide you with the RSS feed you could use.

freeflow · 10-29-2010, 11:56 AM

Thanks for your replies! Looks like I might have to do this manually...

eagle12 · 10-29-2010, 04:54 PM

http://www.billboard.com/rss/charts/hot-100

I would just use this.

10-22-2010, 01:00 PM	THREAD STARTER #1 (permalink)
freeflow NamePros Regular Join Date: Dec 2006 Posts: 236	MySQL/PHP Music Charts Hi everyone. Can you help me find a solution for the following idea? Is there a way to load (using PHP/MySQL) the top music chart titles and the band names from “somewhere” into my MySQL database? I would like to do this once a week using a cron job on the server.

10-24-2010, 04:03 AM	#4 (permalink)
Obulus NamePros Regular Join Date: Aug 2009 Posts: 313	The BBC Website may be able to provide you with the RSS feed you could use. __________________ Available for hire.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
.Mobis up for auction-No Reserve RealMusicRingtone.com + plural	domainacrobat	.MOBI Marketplace	6	01-07-2007 02:28 PM
Working with Royalty Free Music	abacomedia	Webmaster Tutorials	2	08-18-2004 08:26 AM
Don't get caught by the Music Police - Advice for Webmasters	abacomedia	Website Development	9	07-05-2004 07:53 AM
MusicSharing.net	Domainut	Domains For Sale - Make Offer	13	01-30-2004 08:15 PM

10-23-2010, 05:14 PM	#2 (permalink)
Eric Tech Support Join Date: Mar 2005 Posts: 4,944	You could either scrape (ehh) or use an RSS feed (if the place has one), and place the data into a MySQL db. The hardest part would be actually getting the data in the first place, where are you wanting to pull it from?

10-24-2010, 01:38 AM	THREAD STARTER #3 (permalink)
freeflow NamePros Regular Join Date: Dec 2006 Posts: 236	Hi Eric, Thanks for your reply. I knew this was going to be a bit complicated, but maybe there is a solution. I haven’t figured out yet from where to get the chart lists. There are many sites out there that offer this kind of service and I can’t imagine that they all upload the charts manually. This is the data format I need: song name - band name song name - band name ... What is “scrape (ehh)”? What code do I need to do this using RSS feeds?

10-29-2010, 11:56 AM	THREAD STARTER #5 (permalink)
freeflow NamePros Regular Join Date: Dec 2006 Posts: 236	Thanks for your replies! Looks like I might have to do this manually...

10-29-2010, 04:54 PM	#6 (permalink)
eagle12 NamePros Member Join Date: Nov 2003 Location: Ontario, Canada Posts: 127	http://www.billboard.com/rss/charts/hot-100 I would just use this.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)