php - 另一个手机号码正在更新，而不是输入的手机号码

Question

我正在使用邮递员。当我在邮递员中输入手机号码并在sql yog上检查时，那里会更新另一个号码。我不知道发生了什么事。其他列数据工作正常，只有移动字段有问题。请帮忙..提前谢谢。

这是我的数据库表

这是我执行代码后得到的

this is my controller file

function updt()
{
    $input = (array)json_decode(file_get_contents('php://input'));   
    $this->form_validation->set_rules('id','id','trim|is_natural_no_zero|required');
    $this->form_validation->set_rules('fname','fname','trim');
    $this->form_validation->set_rules('lname','lname','trim');
    $this->form_validation->set_rules('mobile','mobile','exact_length[10]');
    $this->form_validation->set_rules('email','email','trim|valid_email');
    $this->form_validation->set_rules('user','user','trim');
    $this->form_validation->set_rules('password','password','trim');
    $this->form_validation->set_data($input);


    if($this->form_validation->run() == FALSE)
    {
        $out =['status'=>403, 'msg' =>$this->form_validation->error_array()];
        $this->output->set_output(json_encode($out));
    }
    else 
    {
        $data = array();
        $data['id'] = $input['id']; 
        if(isset($input['fname']))     {$data['fname'] =$input['fname'];}
        if(isset($input['lname']))     {$data['lname'] = $input['lname'];}
        if(isset($input['mobile']))    {$data['mobile'] = $input['mobile'];}
        if(isset($input['email']))     {$data['email'] = $input['email'];}
        if(isset($input['user']))      {$data['user'] = $input['user'];}
        if(isset($input['password']))  {$data['password'] = md5($input['password']);}


        $up = $this->mym->updtdata($data);

        if($up['status'] ==1)
        {
            $out = ['status'=>200, 'msg'=>'records uppdated'];
            $this->output->set_output(json_encode($out));
        }
        else
        {
            $out = ['status'=>200, 'msg'=>'Records ont updated'];
            $this->output->set_output(json_encode($out));
        }

    }
}

这是我的模型功能

function updtdata($update)
  {         
        $this->db->where('id',$update['id']);
        $query  = $this->db->update('userdata',$update);
        if($query)
        {
            return array('status'=>1);
        }
        else
        {
            return array('status'=>0, 'msg'=>'Error occurd');
        }
   }

标签： phpcodeigniterpostmansqlyog