MySQL Database with API Service

I need to create a MySQL database with a PHP handling service to make API calls to the database. The calls will be identified by tables in the database and based on the access level and query the write to the database will occur and database will return a JSON or XML response. I have the database created and some code we may be able to use. Example query will be: [login to view URL](variable)?user=(varaible)... etc We will create the database and create 15 different database procedures to add entries, modify entries, etc. Simple project especially with the example code I already have. There will be one more portion which we will put a call to call other external APIs that can be inserted in some of the procedures. The calls will also be http calls.