duangan6636
2019-08-06 07:43
浏览 91
已采纳

在Codeigniter PHP中更新查询使记录为空

I am trying to update records(first_name,last_name) from MySQL using Codeigniter but if I do not update first_name OR last_name then record become empty from MySQL, I want existing record should not be removed/deleted,how can I do this? here is my code

$add_data['user_id'] = ($this->input->post('user_id') && !empty($this->input->post('user_id'))) ? $this->input->post('user_id') : NULL;     
$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;     
$data = array(
        'first_name'=>$add_data['first_name'],
        'last_name'=>$add_data['last_name'],
        );  
$this->db->where('id',$add_data['user_id']);
$query=$this->db->update('users', $data);
  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • douma5954 2019-08-06 07:53
    已采纳

    Here is snippet:

      $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');
      }
      $this->db->where('id',$add_data['user_id']);
      $query=$this->db->update('users',  $saveArr);
    

    Hope this will help you :)

    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题