当一条商品通过审核后将该条数据转存到商品表中并在审核表中删除该条数据

实习期还有1个半月就结束了，最近做了一个电商项目，负责里的多商户及即时通讯的部分，项目做完就来分点总结下遇到的问题：

问题描述：

当一条商品通过审核后将该条数据转存到商品表中并在审核表中删除该条数据。

循环方式：

	
	$id = intval($this->segment(6));
	
	$check_shop = $this->db->GetOne("SELECT * FROM `@#_check_shoplist` WHERE id = '$id'");
	#转存拥有的数据字段
	$bind = array('sid','cateid', 'brandid', 'seller_id', 'seller_name', 'title', 'title_style', 'title2', 'keywords', 'description', 'money', 'direct_price', 'cost_price', 'yunjiage', 'zongrenshu', 'canyurenshu','shenyurenshu', 'qishu','maxqishu','thumb', 'picarr', 'content','pccontent', 'xsjx_time','renqi','pos', 'time','minNumber','xiangou','xg_number','paixu','status','shop_type','is_miaokai','card_money','card_number','dockcode','chengben','dhbb_type','lucky_number','is_jiqi_zj', 'stock', 'title2');

	//新建空的键名和键值
	
	$check_key = NULL;
	$check_value = NULL;
	foreach($check_shop as $key => $value){
  		 if(in_array($key, $bind)) {
     	 		$check_key .= "{$key},";
      			$check_value .= "'{$value}',";
   		}
	}
	#除去键名及键值右边的 逗号
	
	$check_key = rtrim($check_key,',');
	$check_value = rtrim($check_value,',');
	
	$insert_shoplist = $this->db->Query("INSERT INTO `@#_shoplist`({$check_key}) VALUES( {$check_value})");
	
	$del_checkshop = $this->db->Query("update @#_check_shoplist set check_status = 0 where id = $id");