Share My Creation [Web][SithasoDaisy5] Low Code Generated CRUD WebApp using MySQL as Back-End via REST API (PHP)

Hi Fam

Download Complete Deployable Project (Source Included)
  1. To run this WebApp, you will need a webserver running PHP. We use Laragon for development.
  2. You will also need BANano
  3. You will also need SithasoDaisy5, get it from this GitHub Repo
  4. This app has been developed using SithasoDaisy5 Low Code Generator
Import the attached addressbook.sql to your MySQL using phpMyAdmin
After opening the b4x project, double the api.php file and update your database connnection parameters, save the file and ensure you click Sync in your IDE Files Tab.

B4X:
$config = new Config([
        'driver' => 'mysql',
        'address' => 'localhost',
        'port' => '3306',
        'username' => 'root',
        'password' => 'root123!',
        'database' => 'addressbook',
        'debug' => true,
        'tables' => 'all',
        'middlewares' => 'apiKeyAuth,sanitation',
        'customControllers' => 'SecureQueryController',
        'apiKeyAuth.keys' => 'jNOEqK8xvAqWWRf7B4jlw2ppOCeBoHunex4ViA1txPrG7V9DW1dG737HhseS4E5Ca3xVaUtUwbDRIOrkwEZv7SEvUQP6jClRpDESkRUnshgyngNDd2epbJWjF48xAzKp',
        'apiKeyAuth.header' => 'X-API-Key',
    ]);

If you get here, you have successfully ran your app.

1761172620585.png


1761172659554.png

1761172712828.png

1761172742707.png


CRUD SCREENS

1761172795998.png


1761172830924.png


1761172860645.png



Exploring the SithasoDaisy5 Low Code Generator (AddressBook Project)

On the download, we have added the addressbook.json file, which is the SD5LCG project that reproduces this project. Import it to the SD5LCG

Check this YT for more context of what we are trying to achieve here.


Enjoy!

MySQL REST API Projects We Did Before






 
Top