Create a simple text input/api that reads relational information in a database.

Job ID: 36349123

Budget: $10 – $30 USD

I need a PHP program made with these tables and columns, as well as one text input and a submit button.

Author - id, firstName, lastName, books
Book - isbn, author, title, summary, price
Purchase - id, customer, book, purchase
Customer - id, firstName, lastName, purchases

I need to be able to enter any information about an Author to get books they've written.
Also to be able to look up a Customer to get info about their Purchases.
As well as be able to look up a Purchase to get the Customer of that purchase and the Books they've bought.

It needs to use GraphQL to do the queries. I don't need any mutations, only to read a database for the relation between these tables.

It should use Symfony framework, Doctrine ORM, and API platform from api-platform.com

If you're able to do it, please include the amount you can do it for in your bid and include the word "book" in your bid so I know you've read the requirements.
Related categories: PHP Symfony PHP