How to sort json array relative to 2 fields

Question

Sort by database is not needed. The use of plug-ins has not led to anything good - the table has got a slant. Dan array. I form it in php .

 $row_section['cell'][$index] = array( 0, $tovar, $cnt, $productID, $arElement["PROPERTIES"]["CML2_ARTICLE"]["VALUE"], $arElement["PROPERTIES"]["BREND"]["VALUE"], $arElement["NAME"], $n, $arElement["PROPERTIES"]["CML2_DAYS_DELIVERY"]["VALUE"], $price ); $index=$index+1; $mas=json_encode($row_section,256);

I send to the server by clicking on the table header:

 <thead> <tr> <th class="def-table-code"> <a href="<?=$url?>&sort=property_CML2_ARTICLE&method=<?=$method?>">Код</a> </th> <th class="def-table-manufacturer"> <a href="<?=$url?>&sort=property_BREND&method=<?=$method?>">Производитель</a> </th> <th class="def-table-title"> <a href="<?=$url?>&sort=NAME&method=<?=$method?>">Название</a> </th> <!-- <th class="def-table-available"> <a href="<?=$url?>&sort=CATALOG_QUANTITY&method=<?=$method?>">Количество, шт.</a> </th> <th class="def-table-delivery"> <a href="<?=$url?>&sort=property_CML2_DAYS_DELIVERY&method=<?=$method?>">Срок поставки, дн. </th> <th class="def-table-price">Цена, руб.</th> <th class="def-table-buy">В корзину</th> --> <th class="def-table-available sort_id" id="CATALOG_QUANTITY" onclick="cat(5,1);">Количество, шт.</th> <th class="def-table-delivery sort_id" id="property_CML2_DAYS_DELIVERY" onclick="cat(6,1);">Срок поставки, дн.</th> <th class="def-table-price sort_id" id="CATALOG_PRICE" onclick="cat(7,1);">Цена, руб.</th> <th class="def-table-buy">В корзину</th> </tr> </thead>

I send ajax request to the server:

 function cat(sortby, method){ alert(sortby); alert(method); $.ajax({ url: '/unimann/ajax/sortfromcatalogajax.php?sortby='+sortby+'&method='+method type: 'POST', data: massiv, success: function(res) { $('#sort_tab').html(res); alert('Soxranenp!'); } }); }

On the server I plan:

 $data= json_decode($_POST['massiv'],true);

It will turn out an array (on the server it was not possible to check, I do not know whether it went). The idea is to get such an array

 Array ( [cell] => Array ( [0] => Array ( [0] => 1 [1] => 453852 [2] => TB215363 [3] => FENOX [4] => TB215363_диск тормозной передний!\ Audi 80/90/100 1.6-2.0D 86-91 [5] => 6 [6] => 1 [7] => 772.52 ) [1] => Array ( [0] => 1 [1] => 355471 [2] => 8DD 355 100-581 [3] => HELLA [4] => Диск тормозной AUDI 80 86>91/100 76>88 передний не вент. [5] => 2 [6] => 1 [7] => 1044.41 ) [2] => Array ( [0] => 1 [1] => 228617 [2] => 0986478016 [3] => BOSCH [4] => Диск тормозной передн AUDI: 100 1.6/1.9/2.0 D/2.1 76-82, 100 1.8/1.8 KAT/1.9 82-91, 100 Avant 1.6/1. [5] => 6 [6] => 1 [7] => 1126.23 ) [3] => Array ( [0] => 1 [1] => 440468 [2] => 0986478016 [3] => BOSCH [4] => Диск тормозной передн AUDI: 100 1.6/1.9/2.0 D/2.1 76-82, 100 1.8/1.8 KAT/1.9 82-91, 100 Avant 1.6/1. [5] => 2 [6] => 1 [7] => 1126.23 ) [4] => Array ( [0] => 1 [1] => 228618 [2] => 0986478016 [3] => BOSCH [4] => Диск тормозной передн AUDI: 100 1.6/1.9/2.0 D/2.1 76-82, 100 1.8/1.8 KAT/1.9 82-91, 100 Avant 1.6/1. [5] => 2 [6] => 1 [7] => 1126.23 ) [5] => Array ( [0] => 1 [1] => 140741 [2] => BG2215 [3] => DELPHI [4] => Диск тормозной AUDI 80 86>91/100 76>88 передний не вент. [5] => 2 [6] => 1 [7] => 876.12 ) [6] => Array ( [0] => 1 [1] => 128269 [2] => A1081P [3] => LPR [4] => Диск тормозной AUDI 80 86>91/100 76>88 передний не вент. [5] => 2 [6] => 1 [7] => 1046.65 ) [7] => Array ( [0] => 1 [1] => 184737 [2] => 24.0113-0160.1 [3] => ATE [4] => Диск тормозной передн, AUDI: 100 1.6/1.9/2.0/2.0 D/2.1 76-82, 100 1.8/1.8 KAT/1.9/2.0 D/2.0 D Turbo [5] => 4 [6] => 2 [7] => 1216.57 ) [8] => Array ( [0] => 1 [1] => 315459 [2] => 24.0113-0160.1 [3] => ATE [4] => Диск тормозной передн, AUDI: 100 1.6/1.9/2.0/2.0 D/2.1 76-82, 100 1.8/1.8 KAT/1.9/2.0 D/2.0 D Turbo [5] => 10 [6] => 1 [7] => 1216.57 ) ) )

Question: how to sort either cell[][5] , or cell[][6] , or cell[][7] with respect to cell[][0] and cell[][1] ? That is, we compare the elements for which cell[][1] same, and sort them in ascending or descending order.

It is necessary to sort within the union. In the plate:

Do you understand that your problem statement is too complicated and long?
Simplify your question, and as a result, even no one will read it to the end.

Alexey Shimansky 36.9k five 47 115 · Answer 1 · 2015-12-04T12:18:49

There is such a function - array_multisort .

 $babbie = Array ( "cell" => Array ( "0" => Array ( "0" => 1, "1" => 453852, "2" => "TB215363", "3" => "FENOX", "4" => "TB215363_диск тормозной передний!\ Audi 80/90/100 1.6-2.0D 86-91", "5" => 6, "6" => 1, "7" => 772.52), "1" => Array ( "0" => 1, "1" => 355471, "2" => "DD 355 100-581", "3" => "HELLA", "4" => "Диск тормозной AUDI 80 86>91/100 76>88 передний не вент.", "5" => 2, "6" => 1, "7" => 1044.41 ), "2" => Array ( "0" => 1, "1" => 228617, "2" => "0986478016", "3" => "BOSCH", "4" => "Диск тормозной передн AUDI: 100 1.6/1.9/2.0 D/2.1 76-82, 100 1.8/1.8 KAT/1.9 82-91, 100 Avant 1.6/1.", "5" => 6, "6" => 1, "7" => 1126.23 ), "3" => Array ( "0" => 1, "1" => 440468, "2" => "0986478016", "3" => "BOSCH", "4" => "Диск тормозной передн AUDI: 100 1.6/1.9/2.0 D/2.1 76-82, 100 1.8/1.8 KAT/1.9 82-91, 100 Avant 1.6/1.", "5" => 2, "6" => 1, "7" => 1126.23 ), "4" => Array ( "0" => 1, "1" => 228618, "2" => "0986478016", "3" => "BOSCH", "4" => "Диск тормозной передн AUDI: 100 1.6/1.9/2.0 D/2.1 76-82, 100 1.8/1.8 KAT/1.9 82-91, 100 Avant 1.6/1.", "5" => 2, "6" => 1, "7" => 1126.23 ), "5" => Array ( "0" => 1, "1" => 140741, "2" => "BG2215", "3" => "DELPHI", "4" => "Диск тормозной AUDI 80 86>91/100 76>88 передний не вент.", "5" => 2, "6" => 1, "7" => 876.12 ), "6" => Array ( "0" => 1, "1" => 128269, "2" => "A1081P", "3" => "LPR", "4" => "Диск тормозной AUDI 80 86>91/100 76>88 передний не вент.", "5" => 2, "6" => 1, "7" => 1046.65 ), "7" => Array ( "0" => 1, "1" => 184737, "2" => "24.0113-0160.1", "3" => "ATE", "4" => "Диск тормозной передн, AUDI: 100 1.6/1.9/2.0/2.0 D/2.1 76-82, 100 1.8/1.8 KAT/1.9/2.0 D/2.0 D Turbo", "5" => 4, "6" => 2, "7" => 1216.57 ), "8" => Array ( "0" => 1, "1" => 315459, "2" => "24.0113-0160.1", "3" => "ATE", "4" => "Диск тормозной передн, AUDI: 100 1.6/1.9/2.0/2.0 D/2.1 76-82, 100 1.8/1.8 KAT/1.9/2.0 D/2.0 D Turbo", "5" => 10, "6" => 1, "7" => 1216.57 ) ) ); print("<pre>"); print_r($babbie); print("</pre>"); // Получение списка столбцов массива $babie["cell"] foreach ($babbie["cell"] as $key => $row) { $col_0[$key] = $row[0]; $col_1[$key] = $row[1]; } // Сортируем данные по col_0 по col_1 по возрастанию // Добавляем $babbie["cell"] в качестве последнего параметра, для сортировки по общему ключу array_multisort($col_0, SORT_ASC, $col_1, SORT_ASC, $babbie["cell"]); print("<pre>"); print_r($babbie); print("</pre>");

Results:

And then read the documentation.

How to sort json array relative to 2 fields

1 answer 1

More articles: