Simple store rest API using MySQL

This is simple rest api for a store named Gorkhali.

• gorkhali_store/api/config contains database.php to change the database login credentials

Schema Design

This is our final database schema:

We came up with it by first listing all the necessary information, then normalizing it. Some changes such as variable size and switching foreign keys were done later as needed. Some improvements that could be made are allowing customers to have many phone numbers and emails but that wasn’t necessary for this database. Sale_price is how we track how much the item cost when it was purchased. If the website or whatever the database could be used for would like to show the cost reduction of the sale price there would need to be another variable.

Getting Data (Querying)

http://localhost/gorkhali_store/api/orders/read.php?status=completed&date_start=1990-01-01&date_end=2010-01-01 Where the parameters are status, date_start, and date_end. This retrieves all customers orders with dates between 1990 and 2010.

Posting Data

Example of creating a customer: http://localhost/gorkhali_store/api/customer/read.php?first_name=Jone&last_name=Cena&email=john@john.com&phone_number=1236987 Based off the schema, needs first_name, last_name, email, and a phone_number.

Shows POST was successful.

Putting Data

Example of updating existing data.
http://localhost/gorkhali_store/api/customer/read.php?first_name=Dywan&last_name=Johnson&email=rock@rock.com&phone_number=1236987&c_id=26

Same as POST

Deleting data

Example of deleting existing data. http://localhost/gorkhali_store/api/customer/read.php?c_id=26 Pass it the c_id.

Now that line is NULL.