21,886
社区成员
发帖
与我相关
我的任务
分享如何用php实现二维数组,按照特定字段排列,实现mysql的order by field功能
这样的一个数组
[{"id":1,"num":5,"name":"jack"},{"id":2,"num":0,"name":"aaaa"},{"id":3,"num":5,"name":"bbbb"}]
按照数组["aaaa","jack","bbbb"]的顺序
这样的去排序,期望得到
[{"id":2,"num":0,"name":"aaaa"},{"id":3,"num":5,"name":"bbbb"},{"id":1,"num":5,"name":"jack"}]
这个数组.
如何写这个方法?
$targetArr是目标数组,$sortArr是$targetArr里某个键的值组成的数组,$key是键名
function testsort($targetArr, $sortArr, $key){
}
或者有大神用别的方法实现也行.
[{"id":1,"num":5,"name":"jack"},{"id":2,"num":0,"name":"aaaa"},{"id":3,"num":5,"name":"bbbb"}]
按照数组["aaaa","jack","bbbb"]的顺序
这样的去排序,期望得到
[{"id":2,"num":0,"name":"aaaa"},{"id":3,"num":5,"name":"bbbb"},{"id":1,"num":5,"name":"jack"}]
这个数组.
如何写这个方法?
$targetArr是目标数组,$sortArr是$targetArr里某个键的值组成的数组,$key是键名
function testsort($targetArr, $sortArr, $key){
}
或者有大神用别的方法实现也行.
...全文
请发表友善的回复…
发表回复
12ers_梦骑士 2018-01-26
- 打赏
- 举报
上一条回复错了...这个就是我想要的,十分感谢!!!
12ers_梦骑士 2018-01-26
- 打赏
- 举报
看楼上的回复,想要的是 name 列按指定顺序排序,还是谢谢你
很訾 2018-01-11
- 打赏
- 举报
或者
/**
* 二维数组排序
* @param Array $arr 需要排序的二维数组
* @param String $shortKey 需要排序的键名
* @param String $short 排序方式:SORT_DESC降序，SORT_ASC升序，
* @param String $shortType 排序方式具体参考array_multisort()
* @return Array
*/
function multi_array_sort(&$arr,$shortKey,$short=SORT_DESC,$shortType=SORT_REGULAR)
{
foreach ($arr as $key => $data){
$name[$key] = $data[$shortKey];
}
array_multisort($name,$shortType,$short,$arr);
}
很訾 2018-01-11
- 打赏
- 举报
比如有个多为数组：
代码如下:
$arr = array(
‘d' => array(‘id' => 5, ‘name' => 1, ‘age' => 7),
‘b' => array(‘id' => 2,'name' => 3,'age' => 4),
‘a' => array(‘id' => 8,'name' => 10,'age' => 5),
‘c' => array(‘id' => 1,'name' => 2,'age' => 2)
);
需要对二维数组中的 age 项排序。
代码如下:
function multi_array_sort($multi_array,$sort_key,$sort=SORT_ASC){
if(is_array($multi_array)){
foreach ($multi_array as $row_array){
if(is_array($row_array)){
$key_array[] = $row_array[$sort_key];
}else{
return false;
}
}
}else{
return false;
}
array_multisort($key_array,$sort,$multi_array);
return $multi_array;
}
//处理
echo “<pre/>”;
print_r(multi_array_sort($arr,'age'));exit;
//输出
Array
(
[c] => Array
(
[id] => 1
[name] => 2
[age] => 2
)
[b] => Array
(
[id] => 2
[name] => 3
[age] => 4
)
[a] => Array
(
[id] => 8
[name] => 10
[age] => 5
)
[d] => Array
(
[id] => 5
[name] => 1
[age] => 7
)
)
xuzuning 2018-01-08
- 打赏
- 举报
按 name 列排序
$s = '[{"id":1,"num":5,"name":"jack"},{"id":2,"num":0,"name":"aaaa"},{"id":3,"num":5,"name":"bbbb"}]';
$a = json_decode($s,1);
foreach($a as $i=>$v) $r[] = $v['name'];
array_multisort($r, $a);
echo json_encode($a), PHP_EOL;
[{"id":2,"num":0,"name":"aaaa"},{"id":3,"num":5,"name":"bbbb"},{"id":1,"num":5,"name":"jack"}]
$s = '[{"id":1,"num":5,"name":"jack"},{"id":2,"num":0,"name":"aaaa"},{"id":3,"num":5,"name":"bbbb"}]';
$a = json_decode($s,1);
$d = array("aaaa","jack","bbbb");
foreach($a as $i=>$v) $k[] = array_search($v['name'], $d);
array_multisort($k, $a);
echo json_encode($a), PHP_EOL;
[{"id":2,"num":0,"name":"aaaa"},{"id":1,"num":5,"name":"jack"},{"id":3,"num":5,"name":"bbbb"}]
