I need someone to create a keyword generation script written in PHP that will combine the keywords phrases pulled from the Wordtracker API and Overture Keyword suggestion tool (using cURL or whatever other method you know. I have a Wordtracerk API account).
It should be written in PHP to where I can upload the files to any PHP 4+ web server and pull up the config/interface and start using it.
I would like an admin/interface page where I can input the MySQL database name, table name, username and password, keyword phrase, wordtracker api account, ect..
After I enter the main keyword and hit submit, the script will go out and pull from both sources and combine the two lists, removing all duplicates and enter them into the MySQL database I specified in the interface panel.
Each database entry should have 3 fields, the unique index key, the keyword phrase and "the parent". "The parent" is any term that I specify on the interface page when generating the keyword list so I can create a heiarchy. I'll be pulling the keywords from the database into an array based on "the parent". So you could make the default parent 'index' or something like that.
Also, I would like to be able to run an update that will go out and pull from both sources again at a later date, compare them to what is in the database now and update with any new phrases that are found.
I'm open to any other ideas/suggestions you have as well.
## 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
PHP