thomasderuel / api-project

Api

How it works ?

1. Step one : git clone into a folder.

2. Step two(on command line) : import the database mysql -u username -p database_name < db.sql

3. Step three : on the same folder, run php -S localhost:YOUR_PORT or ./server.sh

Read your api (ex for YOUR_PORT = 8000):

* GET http://localhost:8000/api/v1/songs (all music)
* GET http://localhost:8000/api/v1/songs?id
* GET http://localhost:8000/api/v1/instruments (v0.3)
* GET http://localhost:8000/api/v1/instruments?id (v0.3)

Config

[x] check the database connection

[x] check if your data is empty

[ ] check url

api-project's Issues

Check url

Check if url exist; else return error.

exemple:
http://localhost:8080/api/v1/artists return true
but
http://localhost:8080/api/v1/azerty return false

add GET api/v1/artists?id=my_id

• Get the params
• compare with database:
  • if the params exist; return database
  • else return error

add /instruments?id

Modified Database

Create 2 tables: songs & tracks:

1. in songs : ID/ Artist/ title/ track(array)
2. in tracks: melody/chords/bass/drums
3. Make a JOIN between them