一个组合数据的问题
$order = array(array('cooperator_id' => 1001, 'app_id' => 100, 'amount' => 4800),
array('cooperator_id' => 1001, 'app_id' => 'qn_100', 'amount' => 9000)
);
$pay = array(
array('cooperator_id' => 1001, 'app_id' => 100, 'amount' => 3600),
array('cooperator_id' => 1001, 'app_id' => 'qn_100', 'amount' => 8400)
);
$trade = array(
array('cooperator_id' => 1001, 'app_id' => 100, 'amount' => 3600),
array('cooperator_id' => 1001, 'app_id' => 'qn_100', 'amount' => 6400)
);
这是三个数据要生成下面的结果请问要怎么做?我觉得sql语句好写,但要的是,提前先把数据遍历一下,做$data = array();把数据在$data中把数据组好,请问要怎么组?
结果:
report_date cooperator_id app_id order_amount pay_amount trade_amount
2016-12-05 1001 100 4800 3600 3600
2016-12-05 1001 100 9000 8400 6400
for循环两次,每次循环分别取出三个数组中需要的数据,同时赋值给一个新的数组就可以了。
页:
[1]