This project is to create a simple PHP based API to create, get and update records in one table. Attached to this project is a MySQL dump of three tables. The main table is tradeusers where the data entry / retrieve is to occur, with the following caveats:
1. The API will require authentication based on SYSTEMID and SYSTEMPASSWD in the tradesystems table
2. When "creating" a record, an associated row needs to be inserted into the usersystemx table with the SYSTEMID (used for authentication) and the ACNT_ID
3. The retrieval portion should get all data from the tradeusers table
## Deliverables
The coder should follow the example listed on this page to build the API:
[login to view URL]
(or, if the coder is experienced enough, a better method if one is available).
The following libraries MUST be used:
1. PHP ADODB - [login to view URL] - for ALL database access
2. Inspekt - for Examing the incoming variables.
All code should be commented with basic PHPDoc style comments.