Write some Software

Closed Posted 7 years ago Paid on delivery
Closed Paid on delivery

A client wishes to regularly and automatically submit information about their staff to our servers. You need to write a simple web service that will receive POST submissions of data, and update appropriate database tables.

The data will be sent as a tab-separated text string, with entries for successive people separated by newline characters (as though pasted from a spreadsheet). There will be a number of fields per person, namely:

1. First name

2. Surname

3. Email address

4. Gender (either the character “m” or the character “f”)

5. Department name

6. Department contact person name

7. Department contact person email address

*Note that the contact person is always the same person (with the same email address) for a given department. You need to provide:

• SQL CREATE TABLE commands for appropriate table(s) in which to store the data optimally.

• A brief description of the syntax (i.e., http query format) which clients of the web service system should use to provide the data to your script. This paragraph should be sufficient for well-qualified developers at the customer to be able to write the necessary code to use your web service system.

• Well-structured PHP file(s) to receive queries and submit the data to the database, free from security holes and using appropriate database access commands/libraries.

Your solution should include:

• SQL DELETE commands to remove all existing data when you receive a new set of people – no UPDATEs are required

• SQL INSERT commands to insert the relevant data into the SQL fields

• Basic acknowledgement to the client that the data has been submitted

Data validation is NOT required (beyond basic security) – you can assume that the input is of the correct form.

PHP Software Architecture

Project ID: #10229484

About the project

8 proposals Remote project Active 7 years ago

8 freelancers are bidding on average R1240 for this job

Baxter2008

Hi there. My name is Brent. I am a PHP and web developer. If my understanding is correct, you need a basic PHP script to receive the submitted data and insert into a database hosted on your server and not a full REST More

R1250 ZAR in 5 days
(23 Reviews)
4.0
PARITech

Hi There, I can do this job for you. Thanks

R555 ZAR in 1 day
(17 Reviews)
4.0
xcodegoing

Thank you for viewing my profile you can check have 5***/5*** also have 100% complete rate you can check happy customer. always trying to get customer satisfaction. I have gone through your project requirement More

R1088 ZAR in 8 days
(19 Reviews)
1.8