php数组操作,内容相同,键值不同,互换
$title = array("A"=>"创建时间","C"=>"商品信息","D"=>"商品ID","F"=>"所属店铺","G"=>"商品数","I"=>"订单状态","J"=>"订单类型","M"=>"付款金额","S"=>"效果预估","Y"=>"订单编号","AD"=>"广告位名称"); $fild = array('creatTime'=>'创建时间','orderNumber'=>'订单编号','goodsTitle'=>'商品信息','shopName'=>'所属店铺','goodsNums'=>'商品数','paymentAmount'=>'付款金额','orderStatus'=>'订单状态','orderType'=>'订单类型','groupName'=>'广告位名称','commissionAmount'=>'佣金金额','goodsId'=>'商品ID');//数据库中对应的字段 foreach ($title as $k=>$v) { if($key = array_search($v,$fild)){//要获取excel的列值 $dataFild ["$key"]=$v; } } var_dump($dataFild); //结果
array(10) { ["creatTime"]=> string(1) "A" ["goodsTitle"]=> string(1) "C" ["goodsId"]=> string(1) "D" ["shopName"]=> string(1) "F" ["goodsNums"]=> string(1) "G" ["orderStatus"]=> string(1) "I" ["orderType"]=> string(1) "J" ["paymentAmount"]=> string(1) "M" ["orderNumber"]=> string(1) "Y" ["groupName"]=> string(2) "AD" }
//其实可以通过php内置函数来做,(下面两个函数搭配估计差不多)
//•array_combine — 创建一个数组,用一个数组的值作为其键名,另一个数组的值作为其值
//•array_flip — 交换数组中的键和值