如何遍历数组,把数组循环插入另一个表

浏览:1417 发布日期:2015/10/28 分类:求助交流 关键字: 如何遍历数组,把数组循环插入另一个表
$obj2=D('Onewinlog');
$datas=D('Oneyuanjoins')->where('status=1 and paytime is not null')->order('paytime asc')->limit(100); 
foreach($datas as &$data){
                    $insert[] = array(
                    'join_id' => $data['id'], //付款单id
                    'seq' => $data['seq'], //期次
                    'seq_id'  => $data['seq_id'], //活动id
                    'shop_id' => $data['shop_id'], 
                    'prod_id' => $data['prod_id'],
                    'user_id' => $data['user_id'],
                    'paytime' => $data['paytime'],//年月日时分秒毫秒
                    'y_time'  => date('Y-m-d',substr($data['paytime'],0,strlen($data['paytime'])-3) ),//年月日2015-10-24
                    'h_time'  => date('H:i:s',substr($data['paytime'],0,strlen($data['paytime'])-3) ),//时分秒
                    'm_time' => date("His",substr($data['paytime'],0,strlen($data['paytime'])-3) ).substr($data['paytime'],0,3),//要计算的数据
                    'create_ip' => $data['create_ip'],
                    'address' => $data['address'],
                    'create_time' => $data['create_time'],
                    'is_mobile'=>$data['is_mobile'],
                    'status'=>$data['status'],
                    'win_seq' => $winseq,   //所属活动中奖的seqid
                    );
                    //
                    $obj2->add($insert);
                }
最佳答案
评论( 相关
后面还有条评论,点击查看>>