How to update data using session in codeigniter

Question

This my code in codeigniter but it doesn't update in database, I'm beginner ni codeigniter, how could I fix this error, or what is wrong in my code? THis is my Controller:

function edit() {
    $role = $this->session->userdata('role');
    $this->form_validation->set_rules('firstname', 'firstname', 'required|xss_clean');
    $this->form_validation->set_rules('lastname', 'lastname', 'required|xss_clean');
    if ($this->form_validation->run() == FALSE) {
        //set page data
        $data['title'] = 'Update Profile';
       if($role!=''){
       $data['admin'] = $this->M_user->get($this->session->userdata('user_id'));
      }else{
      $data['admin'] = $this->M_administrator->getAdmin($this->session->userdata('id_admin'));
      }
        $data['sitename'] = $this->M_website->getName();
        $data['content'] = 'admin/myaccount/edit';

        //parse template
        $this->parser->parse('admin/template', $data);
    } else {
       if($role!=''){
        if ($this->M_user->updateStatus($_POST['user_id'])) {
             //SAVE ADMIN ACTION LOG
            //save_admin_action(array('module' => Constant::AM_ACCOUNT, 'action' => Constant::AL_EDIT, 'title' => $this->form_validation['username'], 'object_id' => $id));

            //redirect page
            $this->session->set_flashdata('saved', TRUE);
            redirect('admin/myaccount');
        }
       }else{           
        if ($this->M_administrator->updateStatus($_POST['id_admin'])) {
             //SAVE ADMIN ACTION LOG
            //save_admin_action(array('module' => Constant::AM_ACCOUNT, 'action' => Constant::AL_EDIT, 'title' => $this->form_validation['username'], 'object_id' => $id));

            //redirect page
            $this->session->set_flashdata('saved', TRUE);
            redirect('admin/myaccount');
        }
      }
    }
}

This is my model administrator:

function updateStatus($post, $id){
    $data = array(
                'firstname' => $post['firstname'],
                'lastname' => $post['lastname']
        );
    $this->db->where('id_admin', $id);
    if($this->db->update('admin', $data)){
        return TRUE;
    }else{
        return FALSE;   
    }
}

user Model:

function updateStatus($post, $id){
    $data = array(
                'firstname' => $post['firstname'],
                'lastname' => $post['lastname']
        );
    $this->db->where('user_id', $id);
    if($this->db->update('user', $data)){
        return TRUE;
    }else{
        return FALSE;
    }
}

I think that you are passing only one parameter in your function i.e $this->M_user->updateStatus($_POST['user_id']) in model function updateStatus($post, $id) and you are using the second parameter i.e $id in where which will be blank — The developer
– The developer, Commented Jan 4, 2017 at 5:57
are you able to access the value of $post['firstname'] in model — The developer
– The developer, Commented Jan 4, 2017 at 9:37
yes i want to access firstname and lastname in model, i want to update firstname and lastname value, — Mark Anthony Naluz
– Mark Anthony Naluz, Commented Jan 4, 2017 at 9:50

Trushar Narodia · Accepted Answer · 2017-01-05 11:37:20Z

1

pass firstname and last name to your updatestatus model function if you are not getting that value in model so you are not able to change

print your query using $this->db->last_query(); to get query output and post your query here

answered Jan 5, 2017 at 11:37

Trushar Narodia

3664 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

The developer · Accepted Answer · 2017-01-04 06:00:45Z

0

Change your where clause to $this->db->where('id_admin', $post);

answered Jan 4, 2017 at 6:00

The developer

1941 gold badge3 silver badges15 bronze badges

1 Comment

Mark Anthony Naluz Over a year ago

When i replace $id to $post it store 2, and it never change,

Collectives™ on Stack Overflow

How to update data using session in codeigniter

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related