Home > Article > Backend Development > PHP method to implement two-dimensional array sorting by a certain column
The example in this article describes the method of sorting a two-dimensional array by a certain column in PHP. Share it with everyone for your reference, the details are as follows:
/* * 二维数组 按某列排序 * array_multisort($arr1,$arr2) * 手册 例子如下 * */ $data[] = array('volume' => 67, 'edition' => 2); $data[] = array('volume' => 86, 'edition' => 1); $data[] = array('volume' => 85, 'edition' => 6); $data[] = array('volume' => 98, 'edition' => 2); $data[] = array('volume' => 86, 'edition' => 6); $data[] = array('volume' => 67, 'edition' => 7); // 取得列的列表 foreach ($data as $key => $row) { $volume[$key] = $row['volume']; $edition[$key] = $row['edition']; } // 将数据根据 volume 降序排列,根据 edition 升序排列 // 把 $data 作为最后一个参数,以通用键排序 array_multisort($volume, SORT_DESC, $edition, SORT_ASC, $data); /*************************************/ /* 从上面的例子不难看出,array_multisort()函数 * 是将每一个二维数组的列作为 一个参数进行排序 * 来达到整个数组的排序 */ /*************************************/ function sigcol_arrsort($data,$col,$type=SORT_DESC){ if(is_array($data)){ $i=0; foreach($data as $k=>$v){ if(key_exists($col,$v)){ $arr[$i] = $v[$col]; $i++; }else{ continue; } } }else{ return false; } array_multisort($arr,$type,$data); return $data; } print_r(sigcol_arrsort($data,'edition',SORT_DESC)); /*说白了 原理就是: 新数组 原二维数组 2 array('volume' => 67, 'edition' => 2); 1 array('volume' => 86, 'edition' => 1); 6 array('volume' => 85, 'edition' => 6); 2 array('volume' => 98, 'edition' => 2); 6 array('volume' => 86, 'edition' => 6); 7 array('volume' => 67, 'edition' => 7); 这两个数组的每一行都锁在一起,新数组一旦变动顺序, 那么就会连带每一行的二维数组也跟着变换顺序 ,即新数组为参照物 相当于查询子句中的 order by */
Running results:
Array ( [0] => Array ( [volume] => 67 [edition] => 7 ) [1] => Array ( [volume] => 85 [edition] => 6 ) [2] => Array ( [volume] => 86 [edition] => 6 ) [3] => Array ( [volume] => 67 [edition] => 2 ) [4] => Array ( [volume] => 98 [edition] => 2 ) [5] => Array ( [volume] => 86 [edition] => 1 ) )