mysql - Codeigniter更新数据库列中的新镜像，而不替换旧镜像

Question

我正在更新映像文件，但是当我更新新文件时，它将替换旧文件。我想保留所有文件而不进行替换。

例如



如果我删除其中之一并添加新的，它将更新其中一个的列值并删除旧的..我需要所有它们。

这里是我的上传代码：

$picture=array();
$cpt = count($_FILES['my_image_upload']['name']);
$config['upload_path'] = APPPATH.'uploads/';
$config['allowed_types'] = '*';
$files = $_FILES;
for($i=0; $i<$cpt; $i++)
{       
 if($_FILES['my_image_upload']['name'][$i]!='')
    {   
    $_FILES['my_image_upload']['name']= $files['my_image_upload']['name'][$i]; 
    $_FILES['my_image_upload']['type']= $files['my_image_upload']['type'][$i];
    $_FILES['my_image_upload']['tmp_name']= $files['my_image_upload']['tmp_name'][$i];
    $_FILES['my_image_upload']['error']= $files['my_image_upload']['error'][$i];
    $_FILES['my_image_upload']['size']= $files['my_image_upload']['size'][$i];
    $this->load->library('upload', $config);
    $this->upload->initialize($config);
    $upload= $this->upload->do_upload('my_image_upload');
    if($upload)
        {
           $this->upload->data();
           $picture[] =$_FILES['my_image_upload']['name'];
        }
     }
 }
$fileName = implode('|',$picture);

提前致谢..

Answer 1

我建议像这样创建新表并插入数据...

id   user_id    image_name  
1       2       abc.jpg 
2       2       bbb.jpg 
3       2       ccc.jpg 
.........

并根据需要以简单的方式插入，更新和删除