doukan6564 2019-08-07 10:17
浏览 61
已采纳

如果不更新图像codeigniter Php,则图像列为null

I am trying to update firstname,lastname,image in codeigniter,But whenever i update only first_name and last_name(not image) then image column become null in mysql,Where i am wrong Here is my code

Here is my model

$add_data['first_name'] = ($this->input->post('first_name') && !empty($this->input->post('first_name'))) ? $this->input->post('first_name') : NULL;     
$add_data['last_name'] = ($this->input->post('last_name') && !empty($this->input->post('last_name'))) ? $this->input->post('last_name') : NULL;     

$saveArr = [];
    if(!empty($this->input->post('first_name'))){
       $saveArr['first_name'] = $this->input->post('first_name');
    }
    if(!empty($this->input->post('last_name'))){
       $saveArr['last_name'] = $this->input->post('last_name');
    }   
if(!file_exists($_FILES['image']['tmp_name']) || !is_uploaded_file($_FILES['image']['tmp_name'])) 
    {
        $saveArr['image'] = $_FILES['image'];
    }
    else
    {
        $filename=time().uniqid(rand()).$_FILES['image']['name'];
        move_uploaded_file($_FILES["image"]["tmp_name"], "images/" . $filename);
        $saveArr['image']=$filename;
    }
$this->db->where('id',$add_data['user_id']);
$query=$this->db->update('users',  $saveArr);
  • 写回答

2条回答 默认 最新

  • douyu5775 2019-08-07 10:55
    关注

    In both condition you set $saveArr['image'], you just need to set $saveArr['image'] when upload new image. so just remove line $saveArr['image'] = $_FILES['image'];

    Use below updated code.

     $add_data['first_name'] = ($this->input->post('first_name') && !empty($this->input->post('first_name'))) ? $this->input->post('first_name') : NULL;     
        $add_data['last_name'] = ($this->input->post('last_name') && !empty($this->input->post('last_name'))) ? $this->input->post('last_name') : NULL;     
    
        $saveArr = [];
            if(!empty($this->input->post('first_name'))){
               $saveArr['first_name'] = $this->input->post('first_name');
            }
            if(!empty($this->input->post('last_name'))){
               $saveArr['last_name'] = $this->input->post('last_name');
            }   
        if(!file_exists($_FILES['image']['tmp_name']) || !is_uploaded_file($_FILES['image']['tmp_name'])) 
            {
    
            }
            else
            {
                $filename=time().uniqid(rand()).$_FILES['image']['name'];
                move_uploaded_file($_FILES["image"]["tmp_name"], "images/" . $filename);
                $saveArr['image']=$filename;
            }
        $this->db->where('id',$add_data['user_id']);
        $query=$this->db->update('users',  $saveArr);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 安卓adb backup备份应用数据失败
  • ¥15 eclipse运行项目时遇到的问题
  • ¥15 关于#c##的问题:最近需要用CAT工具Trados进行一些开发
  • ¥15 南大pa1 小游戏没有界面,并且报了如下错误,尝试过换显卡驱动,但是好像不行
  • ¥15 没有证书,nginx怎么反向代理到只能接受https的公网网站
  • ¥50 成都蓉城足球俱乐部小程序抢票
  • ¥15 yolov7训练自己的数据集
  • ¥15 esp8266与51单片机连接问题(标签-单片机|关键词-串口)(相关搜索:51单片机|单片机|测试代码)
  • ¥15 电力市场出清matlab yalmip kkt 双层优化问题
  • ¥30 ros小车路径规划实现不了,如何解决?(操作系统-ubuntu)