一.转换二维数组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);