[login to view URL] checkbox select all passes table data via ajax to a php file and the php file do a change in the mysql datatable with dependent on the ajax data

In Corso Pubblicato 5 anni fa Pagato alla consegna
In Corso Pagato alla consegna

I delevoped a datatable and I am using [login to view URL] with this checkbox plugin: [login to view URL] and this file structure [login to view URL]

So what I need now are some tiny code snippets in a [login to view URL] file and in the [login to view URL] via jquery that perform some specific mysql actions FOR ALL SELECTRED ROWS OVER ALL PAGES after pressing different submit buttons.

When you press the main drop down menu („Mass Select Operations“) on my live example page [login to view URL] you will find all the specific submit buttons on the right, with the specific actions on the left.

So the first one should update the value of the mysql column „forsale“ in the mysql table to the value 1 after pressing it for all rows that have a selected checkbox.

I tried to do it with the following code in the [login to view URL] to test it with a single mysql change:

$(document).on('submit','#mass_putonsale2', function(e){

[login to view URL]();

show_loading_message();

var form = this;

var rows_selected = [login to view URL](0).[login to view URL]();

// Iterate over all selected checkboxes

$.each(rows_selected, function(index, rowId){

// Create a hidden element

$(form).append(

$('<input>')

.attr('type', 'hidden')

.attr('name', 'id[]')

.val(rowId)

);

}

);

var form_data_putonsale = $(form).serialize();

var request = $.ajax({

url: '[login to view URL]',

cache: false,

data: form_data_putonsale,

dataType: 'json',

contentType: 'application/json; charset=utf-8',

type: 'get'

});

hide_loading_message();

and with the following code in [login to view URL]

elseif ($job == 'mass_putonsale'){

$query = "UPDATE cards SET forsale = 1 WHERE id = '"; mysqli_real_escape_string($conn,$_GET['id'][0]) ."'";

$query = mysqli_query($conn, $query);

}

But it is not working at all … so this would be the first specific tiny job and many more would come after this one for sure ...

I can give you a view access to all live files, so you are able to get a quick overview before we do the job via [login to view URL] .

here is a part of the process that is working, but I am not able to edit it to my needs, so the whole process is working.

best greetings

AJAX JavaScript jQuery / Prototype MySQL PHP

Rif. progetto: #18122293

Info sul progetto

2 proposte Progetto a distanza Attivo 5 anni fa

2 freelance hanno fatto un'offerta media di €10 per questo lavoro

manishuser

I can fixed this problem I have experience in php,J's, database

€8 EUR in 2 giorni
(0 valutazioni)
0.0
starhadi

kindly ignore the bid amount & time-line, it's just a placeholder, as i still need to receive more detailed requirements for you to finalized it. ------ Dear sir, I have read you project description and understand the Altro

€12 EUR in 1 giorno
(0 valutazioni)
0.0