Import into table using SQL via Webpage

I have create a page with a ‘wpdadiehard’ shortcode.

I have create the project and page with “Bulk actions allowed” and “Import allowed”.

If , on my page, page_id=4749 , I cliked on import, I get the prompt for import, I chose the file, which is an SQL file, and press “import”.

It import no rows.

What I am trying to accoplish is to import participants for an event. But I would like to clear the table for all participants first for this event before importing the new participants.. The do an update of a value afterwards.

Is this possible from a Front_end WordPress Page without having to log into the Admin pages?

I nee a easy way to update participants of an event

Examle SQL:

DELETE from g_tour_entries where tour_id = ‘2024-01’;

INSERT INTO g_tour_entries( tour_entry_id,member_id, tour_id,tour_handicap, golf, meal, raffel, tour_tee,flight_pos,flight_nr,team_id,start_time,2_pot,game_id,reserved) Values (‘2024-01-395′,’395′,’2024-01′,(get_handicap(395)),’1′,’Kabeljauw’,”,’LT’,’2′,’Flight01′,”,’16:00′,”,”,’0′);
INSERT INTO g_tour_entries( tour_entry_id,member_id, tour_id,tour_handicap, golf, meal, raffel, tour_tee,flight_pos,flight_nr,team_id,start_time,2_pot,game_id,reserved) Values (‘2024-01-523′,’523′,’2024-01′,(get_handicap(523)),’1′,”,”,’M’,’3′,’Flight03′,”,’16:00′,”,”,’0′);

update g_tour_entries set tour_handcap = ‘1’ where tour_id = ‘2024-04’;

The page I need help with: [log in to see the link]