B4J Tutorial [Web] Dynamic Database Connectivity with Automatic CRUD REST API - API.PHP

Hi Fam

Original Project

I've been looking at ways to get the api.php file for CRUD REST to work in a dynamic fashion so that I can get it connect to any back-end database.

I found a way to do this by passing headers to the api.php file so that it can access any db. The GIF here is using the same api.php file but accesses a SQLite DB and also a MySQL file dynamically.

// --- Dynamic DB Configuration via Headers ---
    $headers = getallheaders();
    $host = $headers['X-Host'] ?? '';
    $user = $headers['X-User'] ?? '';
    $password = $headers['X-Password'] ?? '';
    $dbname = $headers['X-DBName'] ?? '';
    $driver = $headers['X-Driver'] ?? 'mysql';
    $port = $headers['X-Port'] ?? '';

So in your app, you add the needed headers

Dim fetch As SDUIFetch
    fetch.Initialize(baseURL)
    fetch.SetContentTypeApplicationJSON
    If UseApiKey Then fetch.AddHeader("X-API-Key", sApiKey)
    fetch.AddHeader("X-Host", sHost)
    fetch.AddHeader("X-User", sUser)
    fetch.AddHeader("X-Password", sPassword)
    fetch.AddHeader("X-DBName", sDbName)
    fetch.AddHeader("X-Driver", sDriver)
    fetch.AddHeader("X-Port", sPort)

These will be passed to the api.php library so that its dynamic and able to connect to any database back-end.

Enjoy!

 

[Mashiane]

For SQLite - you set the driver and the host header and the others should be blank.

For MySQL - you set the rest of the settings applicable.