PHPRunner can generate secure REST API endpoints for SQL databases using HTTP Basic or API key authorization.

API endpoints provide authorized users access to specific data sets while obscuring the database's connection details.

For example, this URL will query and return a specific subset of data from the proprietary gem pricing database below.

https://valucalc.com/diamondpricesapi.php?apikey=ABC123&cut=ideal&clarity=VVS1&color=D&upper=1.5&lower=1