Home > php教程 > php手册 > body text

PHP 二维数组按某列进行排序

WBOY
Release: 2016-06-06 19:42:05
Original
2242 people have browsed it

/* * 二维数组 按某列排序 * 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

/*
*  二维数组 按某列排序
*  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);
Copy after login

// 取得列的列表
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);
Copy after login

/*************************************/
/* 从上面的例子不难看出,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));
Copy after login

/*说白了 原理就是:
新数组    原二维数组
 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
*/

运行结果:

 7        array('volume' => 67, 'edition' => 7);

6        array('volume' => 86, 'edition' => 6);

6        array('volume' => 85, 'edition' => 6);

2        array('volume' => 98, 'edition' => 2);

2        array('volume' => 67, 'edition' => 2);

1        array('volume' => 86, 'edition' => 1);

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Recommendations
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!