重构-旧表导入新表数据
// 对应字段 key-新，value-旧$fields = array('user_id'=>'user_id','user_name'=>'name','password'=>'password','salt'=>'salt','email'=>'email','grade'=>'type','head_photo'=>'head','last_login_time'=>'last_time','last_login_ip'=>'last_ip');// 原数据$user = new maUser();$data = $user->getAll( implode(',', $fields) );// 需要处理的字段foreach( $data as $f){$f['head'] = json_decode($f['head']);$f['head'] = str_replace('.jpg', '', $f['head'][0]->n);$fieldStr = array();foreach( $fields as $name ){$fieldStr[] = "'".$f[$name]."'";}$fieldStr = implode(',', $fieldStr);$sql[] = "($fieldStr)";}// 写入新表$newFields = array_keys($fields);$newFields = implode(',', $newFields);$sql = "insert into user_account({$newFields}) values" . implode(',', $sql);pr($sql,1);