Create a REST API in PHP to update / inquire tables

This project is to create REST API similar to the guidelines in this article posted here [url removed, login to view] to update, insert, and retrieve data from database tables as defined in the attached sql statement.

The authentication for the API should come from the tradesystems table (user will need to provide SYSTEMID and SYSTEMPASSWD)

There should be the following functions:

1. Update users - Update user data based on the info passed (such as update the password).

2. List all users - List all users linked to the system the user provided as credentials. (the usersystemx table is the cross-reference).

3. Add user - add a record into the tradeusers table and in the usersystemx table for the system the user provided as credentials. If the tradeusers record already exists (based on acnt_id and password), then only a usersystemx record should be added.

4. Delete user - delete the record in tradeusers and the associated usersystemx record. However, the delete of the tradeusers record should only occur if there is no other usersystemx record.

This shoul dbe written in PHP and use the ADODB library.

Evner: PHP

Se mere: create rest api php, rest php insert, php rest update, sql php rest api, php api rest, rest api php insert, php create rest api, www linked in com, www linked in, sql guidelines, rest api design, project list in php, php create table, linked in com, in php, create www, create table php, create a design, create a com, c linked list library

Om arbejdsgiveren:
( 149 bedømmelser ) Platte City, United States

Projekt ID: #612640

2 freelancere byder i gennemsnit $300 på dette job


Please check PM.

$300 USD in 7 dage
(87 bedømmelser)

I'm ready.

$300 USD in 5 dage
(1 bedømmelse)