Как обновить базу данных с помощью данных формы [дублировать] ⇐ Php

[Anonymous]

Я новичок в кодировании, и я пытаюсь обновить пользовательские данные из формы. Вставка, отображение и удаление данных работает нормально, но я не могу заставить функцию обновления работать.function getuser($id) {
$this->db->join('users_info','users.user_id = users_info.user');

$query = $this->db->get_where('users', array('user_id'=> $id));

return $query->result_array();
}

function edituser($id) {

$update_user = array(
'username' => $this->input->post('username'),
'password' => md5($this->input->post('password')),
'email' => $this->input->post('email'),
'level' => $this->input->post('role')
);

$this->db->where('user_id', $id);
$this->db->join('users_info','users.user_id = users_info.user' );
$this->db->update('users', $update_user);

$affected_rows1 = $this->db->affected_rows() ? TRUE : FALSE;

$update_info = array(
'name' => $this->input->post('first_name'),
'surname' => $this->input->post('surname'),
'address' => $this->input->post('address'),
'city' => $this->input->post('city'),
'phone' => $this->input->post('phone'),
'mobile' => $this->input->post('mobile'),
'am' => $this->input->post('am'),
'vat' => $this->input->post('vat')
);

$this->db->where('user', $id);
$this->db->update('users_info', $update_info);
$affected_rows2 = $this->db->affected_rows() ? TRUE : FALSE;

return ($affected_rows1 && $affected_rows2) ? TRUE : FALSE;

}
< /code>

мой контроллер: < /strong> < /p>

function edituser() {
if ($this->session->userdata('is_logged_in')) {
$this->load->helper('form');
$this->load->helper('html');
$this->load->model('users_model');
$id=$this->uri->segment(3);
$this->users_model->edituser($id);

if ((int)$id > 0) {

$query = $this->users_model->getuser($id);

$data['fid']['value'] = $id;
$data['fusername']['value'] = $query['username'];
$data['fpassword']['value'] = $query['password'];
$data['femail']['value'] = $query['email'];
$data['frole']['value'] = $query['role'];
$data['ffirst_name']['value'] = $query['first_name'];
$data['fsurname']['value'] = $query['surname'];
$data['faddress']['value'] = $query['address'];
$data['fcity']['value'] = $query['city'];
$data['fphone']['value'] = $query['phone'];
$data['fmobile']['value'] = $query['mobile'];
$data['fam']['value'] = $query['am'];
$data['fvat']['value'] = $query['vat'];
}

$data['main_content'] = 'pages/edit_user';
$this->load->view('templates/template', $data);

} else {
redirect('login/index');
}
}
< /code>

my view < /strong> < /p>

• Name*
  
  
  
  
  
  Подробнее здесь: https://stackoverflow.com/questions/124 ... -form-data