Fertiggestellt

Populate MySQL Table with Clickbank Data Feed

Populate MySQL Table with Clickbank Data Feed This isn't rocket science and should be a pretty quick job for someone who knows how to parse XML and put it into a database.

I need a PHP script that will run once a day (using cron) and download the Clickbank data feed, unzip it, parse the XML, and put the data into a mySQL Table.

The data feed can be found at this location:

[url removed, login to view]

Here's the SQL for the ClickBank table:

CREATE TABLE `clickbank` (

`cbid` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,

`id` VARCHAR( 128 ) NOT NULL ,

`popularityrank` INT NOT NULL ,

`title` VARCHAR( 128 ) NOT NULL ,

`description` VARCHAR( 255 ) NOT NULL ,

`recurring` BOOL NOT NULL ,

`gravity` FLOAT NOT NULL DEFAULT '0',

`earnedpersale` FLOAT NOT NULL DEFAULT '0',

`percentpersale` FLOAT NOT NULL DEFAULT '0',

`totalearningspersale` FLOAT NOT NULL DEFAULT '0',

`totalrebillamount` FLOAT NOT NULL DEFAULT '0',

`referred` FLOAT NOT NULL DEFAULT '0',

`commission` INT NOT NULL ,

`added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

) ENGINE = MYISAM ;.

When the script is run it needs to add events to a mySQL table called events -- the events should be posted at the appropriate times.

The events to add are:

* start download clickbank feed

* finish download clickbank feed

* start parse clickbank feed

* finish parse clickbank feed

* start update clickbank table

* finish update clickbank table

The event table:

CREATE TABLE `events` (

`eventid` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,

`site` VARCHAR( 50 ) NOT NULL DEFAULT 'Sonic Toolkit',

`tool` VARCHAR( 50 ) NOT NULL DEFAULT 'Sonic Article Bot',

`event` VARCHAR( 100 ) NOT NULL ,

`added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

) ENGINE = MYISAM ;

After the new feed has been saved, send an email showing the start and end times for the process (from downloading the new feed, to when the table was finished updating with the new data).

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

The PHP script must run on a Linux-based web server using the following: PHP version 4.4.4 MySQL version 4.1.22-standard I will be running the script with a cron job, but it must also be able to be fired off by hitting it with a browser.

Fähigkeiten: Amazon Web Services, Ingenieurwesen, MySQL, PHP, Softwarearchitektur, Testen von Software, Web Hosting, Website-Management, Testen von Webseiten, XML, XSLT

Mehr darüber mysql populate table, sonic for hire, sonic'com, rocket software, rocket hire, populate xml from database, php script null, php create table, mysql software download, i was referred by, how to null php script, how to null a script, how to null a php script, hitting the web, create table php, clickbank article, data science job, rocket engine, populate, php script create table

Über den Arbeitgeber:
( 78 Bewertungen ) Wasilla, United States

Projekt-ID: #3448032

Vergeben an:

vw1425800vw

See private message.

$34 USD in 4 Tagen
(29 Bewertungen)
3.6

5 Freelancer bieten im Durchschnitt $47 für diesen Job

aklcompany

See private message.

$76.5 USD in 4 Tagen
(60 Bewertungen)
5.7
srikantvishvw

See private message.

$76.5 USD in 4 Tagen
(14 Bewertungen)
4.0
tomsan

See private message.

$24.65 USD in 4 Tagen
(13 Bewertungen)
2.9
vw6548276vw

See private message.

$25.5 USD in 4 Tagen
(1 Bewertung)
0.0