Web Scrap PHP Script

CLOSED
Bids
7
Avg Bid (GBP)
£55
Project Budget (GBP)
£20 - £70

Project Description:
I require a PHP CLI script that will do a product web scrap on www.wrdmusic.com

I am a reseller of their products but they do not have a way to share their products and tracks with their clients. I need a script that will update an existing MySQL database with their products (the script will be run by via cron at regular intervals so will need to add new products and make updates where required).

Please note when pricing up that as the supplier doesn't have a proper database themselves the data is in multiple formats - I suggest you check out a few of their CDs to see the format that the data is in before quoting for the work:

http://www.wrdmusic.com/product_info.php?products_id=1000147 <<< New entry with link to MP3 file for preview of track. Data points in their own TD tag

http://www.wrdmusic.com/product_info.php?manufacturers_id=14&products_id=1118 <<< Old entry where all data is within a P tag separated by a BR

The structure of the database I need populating is as follows:

tblManufacturers - full list found in "Search by Artist" SELECT on most pages
id {AI BI}
wrdid {BI} - taken from URL where possible

tblAlbums
id {AI BI}
wrdid {BI}
Title {VC}
RRP {D} - is price including VAT
DiscCount {I} - Number of CDs
Manufacturer {I} - FK to tblManufacturers.id

tblTracks
id {AI BI}
Album {BI} - FK to tblAlbums.id
Disc {I}
Track {I}
Title {VC}
Artist {VC}
BPM {I}
Length {T}
DStyle {BI} - FK tblDStyles.id
PrevMP3 {VC} - Filename of MP3 preview file

tblDStyles
id {BI AI}
Style {VC}

I am a PHP programmer but do not have time to put this together myself - all coding must be clean and well commented.

Skills required:
MySQL, PHP, Software Architecture
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire phpXpertbd
£ 63
in 3 days
£ 72
in 2 days
£ 62
in 4 days
£ 73
in 3 days
£ 49
in 3 days
£ 44
in 1 days