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 :)

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 mysql , 用自己创建的本地主机和用户名 登录不上
  • ¥15 关于#web项目#的问题,请各位专家解答!
  • ¥15 vmtools环境不正常
  • ¥15 请问如何在Ubuntu系统中安装使用microsoft R open?
  • ¥15 jupyter notebook
  • ¥30 informer时间序列预测
  • ¥20 SSR引物多态性分析
  • ¥15 大漠插件在Win11易语言注册调用和免注册灵异事件,VS上注册调用完全没问题
  • ¥15 Addressable缓存机制做热更新的问题
  • ¥15 微信开发者工具vant组件