Data fetch logic from database via buttons and partial shortcode update

Hi all,

I am working on a personal project that fetches data from the database and puts it on my front end.

i have created a php file that pulls data from my table hosted on phpmyadmin (i use easywp from namecheap) and gives me the data pull on the basis of a shortcode.

I need to build a logic that updates the parameters of my shortcode partially.

example – [Shortcode var 1 = update from button var 2 = update from button var 3 = static fixed on website] how to go about building this logic?

Any help would be appreciated.

Thank you in advance.

PS – I have tried AJAX and custom fetch API, but the data never gets updated on the website, nothing happening.