如何用php实现二维数组,按照特定字段排列,实现mysql的order by field功能

12ers_梦骑士 2018-01-08 05:50:19
这样的一个数组
[{"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){
}
或者有大神用别的方法实现也行.
...全文
666 5 打赏 收藏 转发到动态 举报
写回复
用AI写文章
5 条回复
切换为时间正序
请发表友善的回复…
发表回复
12ers_梦骑士 2018-01-26
  • 打赏
  • 举报
回复
引用 1 楼 xuzuning 的回复:
按 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"}]
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);
$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"}]
上一条回复错了...这个就是我想要的,十分感谢!!!
12ers_梦骑士 2018-01-26
  • 打赏
  • 举报
回复
引用 1 楼 xuzuning 的回复:
按 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"}]
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);
$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"}]
看楼上的回复,想要的是 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"}]
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);
$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"}]

21,881

社区成员

发帖
与我相关
我的任务
社区描述
从PHP安装配置,PHP入门,PHP基础到PHP应用
社区管理员
  • 基础编程社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧