JSON API config file

[skylardarkfox]

This could be an easy way to define an API structure, including a full path tree and database connection details. Such a file might be structured something like the following:

{
   "connections":{
      "Conn1":{
         "host":"server1.com",
         "db":"someDatabase",
         "uid":"dbUser",
         "pwd":"dbPass",
         "server":"MySQL",
         "connection_type":"PDO",
         "options":[
            
         ]
      },
      "Conn2":{
         "file":"connectionFile.php",
         "name":"thisConnection"
      }
   },
   "endpoints":{
      "level1":{
         "__connection":"Conn2",
         "level1a":{
            "select":{
               "query":"SELECT ...",
               "connection":"Conn1",
               "procedure":"PreparedStatement"
            },
            "insert":{
               "query":"INSERT INTO ...",
               "connection":"Conn1",
               "procedure":"StatementSet"
            },
            "update":{
               "query":"UPDATE ...",
               "connection":"Conn1",
               "procedure":"StatementSet"
            },
            "delete":{
               "query":"DELETE FROM ...",
               "connection":"Conn1",
               "procedure":"PreparedStatement"
            }
         },
         "level1b":{
            "request":"path/to/file.php"
         }
      }
   }
}

[skylardarkfox]

Any request would check this file first to determine the correct query to be run based on the path by which the API is accessed. These queries could either be defined directly in the JSON as shown, or a separate PHP include could be provided in which the query procedure is defined.