[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

進行中 投稿 5年前 着払い
進行中 着払い

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/プロトタイプ MySQL PHP

プロジェクトID: #18122293

プロジェクトについて

2個の提案 リモートプロジェクト アクティブ 5年前

2人のフリーランサーが、平均€10 で、この仕事に入札しています。

manishuser

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

€8 EUR 2日以内
(0件のレビュー)
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 もっと

€12 EUR 1日以内
(0件のレビュー)
0.0