How to process JSON generated by js-sortable?

Question

PHP

Sorting blocks with the js-sortable plugin. After dragging, an array of the type is formed. Now, as I guess, it needs to be processed somehow, each ID needs to be assigned something like a weight. And pass to the handler somehow so probably["Степан", "Оля", "Владимир", "Алина"]

$.get('saveSortable.php', {тут наверно будет обработанный json - как написать не знаю} );

But how is this done correctly, how to process and transfer this array for writing to the weight base according to the ID of each block?

Answer 1

In saveSortable.php something like:

$i = 0;
foreach ($_GET['array'] as $name) {
      $db->query(" UPDATE `table` SET `sort` = ?i WHERE `name` = '?s' ", $i, $name);
      $i++;
}