php 巧用 array_column

最新推荐文章于 2021-03-11 17:18:57 发布

weixin_34384557

最新推荐文章于 2021-03-11 17:18:57 发布

阅读量78

点赞数

文章标签： php python

原文链接：https://my.oschina.net/osgrace/blog/1975945

版权

一.转换二维数组key

源数组$order_list

Array
(
[0] => Array
(
[order_sn] => or2018080155554856
[order_name] => 测试联票退票
[created_at] => 1533103751
)

[1] => Array
(
[order_sn] => or2018080155554854
[order_name] => 测试联票退票
[created_at] => 1533103751
)

[2] => Array
(
[order_sn] => or2018080155554852
[order_name] => 测试联票退票
[created_at] => 1533103751
)

[3] => Array
(
[order_sn] => or2018080148565657
[order_name] => 各类型门票景区单个实名制
[created_at] => 1533085200
)

[4] => Array
(
[order_sn] => or2018080110249505
[order_name] => 各类型门票景区单个实名制
[created_at] => 1533084879
)

)

//转换数组,用order_sn 值作为一维数组key,
$order_sn_key_info = array_column($order_info,NULL,'order_sn');
print_r($order_sn_key_info);
die;

目标数组

Array
(
[or2018080155554856] => Array
(
[order_sn] => or2018080155554856
[order_name] => 测试联票退票
[created_at] => 1533103751
)

[or2018080155554854] => Array
(
[order_sn] => or2018080155554854
[order_name] => 测试联票退票
[created_at] => 1533103751
)

[or2018080155554852] => Array
(
[order_sn] => or2018080155554852
[order_name] => 测试联票退票
[created_at] => 1533103751
)

[or2018080148565657] => Array
(
[order_sn] => or2018080148565657
[order_name] => 各类型门票景区单个实名制
[created_at] => 1533085200
)

[or2018080110249505] => Array
(
[order_sn] => or2018080110249505
[order_name] => 各类型门票景区单个实名制
[created_at] => 1533084879
)

)
二,获取二维数组某列值

源数组$order_list(上面),获取该数组中所有order_sn值

$arr_order_sns= array_column($order_info,'order_sn');
print_r($arr_order_sns);
die;

目标数组

Array
(
[0] => or2018080155554856
[1] => or2018080155554854
[2] => or2018080155554852
[3] => or2018080148565657
[4] => or2018080110249505
)

所有order_sn作为一维数组

后期可用该一维数组,进行sql where in 查询,where order_sn in implode(",",$array);

转载于:https://my.oschina.net/osgrace/blog/1975945

关注