PHP/MySQL Web Service


I'm looking for someone to make a basic PHP-based web service for me and some well designed MySQL tables to hold and store the data.

There are 2 types of data to be stored:

Merchant Commission - commission available to affiliates from various affiliate networks - can be % or flat rate

User Commission Earned - commission earned by users from affiliate links they clicked and products they purchased

This project is only to build the web service (PHP) to store and retrieve the data and the mysql tables to contain that data.

I want the mysql scripts to create the table and index structures and the 2 PHP files for the web services.

There will be set and get on both merchant and user commission.

Here are the 4 web service calls:

setMerchantCommission - parameters (that i know of so far): affiliateid/name, merchantid, product type, commission currency, commission type, commission value

getMerchantCommission - parameters: affiliateid/name, merchantid/name

setUserCommission - parameters: userid, transactionid, affiliateid, merchantid, currency, commission value

getUserCommission - parameters: userid (returns JSON of entire history of user commission earned including dates earned etc)

I don't accept spammers, so in your application please provide the mysql you would use to create the usercommission table.

Good luck, and let's get cracking!

Skills: MySQL, PHP, Software Architecture

See more: mysql web service, web services php, types of data structures in c, types of data structures, types data structures, type of data structures, set data structures, json calls, get web services, data structures types, data structures set, currency table rate, currency rate table, basic data structures in c, application of data structures, software cracking , software architecture php mysql, service architecture, php web service, php json, mysql index, json php, json and mysql, basic php, web service php mysql

Project ID: #4777921