【笔记(2)】批量将数据导入新建phpcms模型中去

本文记录了如何批量将原有CMS系统中的数据导入到新建的phpcms模型中,包括主表和附表数据的整合与插入,为数据建模更新提供示例。

最近,需要将原来的数据重新建模更新,在导数据的时候,需要用到cms的主表数据和附表数据,以及将所有数据整合插入新建的模型中去,示例代码记录如下:

//导数据
public function daoshuju()
{
	$chart_db = pc_base::load_model('chart_model');
	$chart_data_db = pc_base::load_model('chart_data_model');
	$gangqinpu_db = pc_base::load_model('gangqinpu_model');
	$gangqinpu_data_db = pc_base::load_model('gangqinpu_data_model');
	$where = "`status` = 99 and `id` <4241 and `catid` = 489";
	$info=array();
	$info=$chart_db->select($where, '*', '5000', "`id` desc");
	$count=0;
	foreach($info AS $k=>$v)
	{
		$cc=$chart_data_db->get_one(array('id'=>$v['id']));
		/*
		$arr=array2string($quputupian);
		$array = $temp = array();
		if(!empty($arr)) {
			foreach($arr as $key=>$val) {
				$temp['url'] = $val['url'];
				$temp['alt'] = $val['alt'];
				$array[$key] = $temp;
			}
		}
		$array = array2string($array);*/
		$data['catid']=622;
		$data['title'] = $v['title'];
		$data['keywords'] = $v['keywords'];
		$data['description'] = $v['description'];
		$data['bianzhuzhe'] = $v['bianzhuzhe'];
		$data['zimu'] = $v['zimu'];
		$data['dealpic'] = $v['dealpic'];
		$data['picnum'] = $v['picnum'];
		$data['pdf'] = $v['pdf'];
		$data['pdfpath'] = $v['pdfpath'];
		$data['language'] = $v['language'];
		$data['username'] = 'shihaijuan';
		$data['status'] = $v['status'];
		$data['listorder'] = $v['listorder'];
		$data['thumb'] = $v['thumb'];
		$data['dynamic_parameter'] = $v['dynamic_parameter'];
		$data['dealpj'] = $v['dealpj'];
		$data['puji'] = $v['puji'];
		$data['filesize'] = $v['filesize'];
		$data['pdfpage'] = $v['pdfpage'];
		$data['hqgq_url'] = $v['url'];
		$data['inputtime'] = SYS_TIME;
		$data['updatetime'] = SYS_TIME;	

		$resid = $gangqinpu_db->insert($data,true);
		if($resid){
			$data2['id'] = $resid;
			$data2['quputupian'] =addslashes($cc['quputupian']);
			$data2['content'] = $cc['content'];
			$data2['pdfs'] = addslashes($cc['pdfs']);
			$gangqinpu_data_db->insert($data2);
			$count++;
		}
	}
	echo '成功上传'.$count.'条数据!';	
}	


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值