Share My Creation [Web][SithasoDaisy] Secure CRUD MySQL REST API Web App using Api Key on top of HTTPS

Hi Fam

• This is a fully functional webapp that showcases categories & products. One is able to toggle views between table listing and a grid listing.
• Both these have functionality to edit, clone, delete records from the database.
• When adding products, we load categories in a select/combo box for selection
• The complete application has been creating via code
• Validation has been added for required fields
• Each action to the REST API requires the API Key.
• The MySQL Webserver should run on HTTPS.

What do we mean by secure? By using an API Key for the MySQL REST API, one needs to feed a "header" key with a key to execute any call to the backend MySQL database when using the API. This should be deployed on HTTPS.

Related content

[Web] Creating Secure MySQL REST API based WebApps using Api Keys on top of HTTPS

Hi Fam. This tutorial is based on the api.php project, originally posted in the forum on September 9, 2022. See the Related Content section below. This time around we are looking at how we can use Api Keys for Authenticating our MySQL WebApps to make them secure when using REST API...

www.b4x.com

Source Code?

If you are subscribed to SithasoDaisy WebApps, get it from your download link.

or

Get it with a certificate of appreciation of $5, by sending it here.

Enjoy!