Hi there,

i have a short question. Is there a way how to add custom JS when the user clicks on a URL Button of a table? I had no success how to correctly identify the id of that row.

It would be great if you could provide me a short example/idea how it could work. 

My aim is to trigger a simple alert when the user clicks the url button.

Many regards,

Michael

Hi there,

well, i figured out how it can work, so maybe you are wrong. There is quite a simple solution for that imo.

If you just create a simple concat in the sql query like this

CONCAT('<button type="button", class="anmeldung_ablehnen", id=', turnier_id, '>Click Me!</button>') AS test

you are able to address the button with jquery by the class selector

jQuery(document).on( 'click', '.anmeldung_ablehnen', function (e) {

and you can get the id by

var turnier_id = this.id;

I still havent tried further yet, but that means that i can now write custom JS code with e.g. an ajax request to do whatever i want with the row and its id.

Many regards,

Michael

Hi Michiiee,

I am really interested how you solved this, is it possible to give more of an explanation, what type of code did you use? where you issued the sql statement?

I am trying to add data to a cell in a row from another input, ie if cell one is "Apple" cell 2 should be filled with an integer of 1 but hidden using javascript, I cant seem to use an integer as a foreign key ???

Sorry to intrude on your post but seemed very interesting how you accomplished this. many thanks Neil

Hi Neil,

well all tables i use are generated by the sql query option. So my sql query looks something like this:

SELECT anmeldung_id, turnier_id, ...,
CONCAT('<button type="button", class="anmeldung_annehmen", id=', turnier_id, '_', anmeldung_id ,'_', status_id , '>Anmeldung annehmen</button>') AS anmeldung_annehmen,
CONCAT('<button type="button", class="anmeldung_ablehnen", id=', turnier_id, '_', anmeldung_id ,'_', status_id , '>Anmeldung ablehnen</button>') AS anmeldung_ablehnen
FROM ... WHERE ....

I have set the columns for the concat statetments just to the data type string. A simple button is displayed in the frontend then.

In the custom JS section of my theme i added something like this:

jQuery(document).on( 'click', '.anmeldung_annehmen', function (e) {
var id = this.id;
var split = id.split("_");
var turnier_id = split[0]; 
var anmeldung_id = split[1];
var status = split[2];

With this code i can trigger some JS when the button with class anmeldung_annehmen is clicked.

With the split function i can read all the ids (or whatever you have used for the id of the button) into a variable.