Codeigniter - Update database records based on selected checkbox

Question

I have a table that contains rows of user orders, I would like the user to be able to update multi orders rows in one click, so I am using a checkbox so the user can check the order that would like to update.

each checkbox represents the order id that has to be updated if checked, I tried to use loops, but the code else cause an error, or do nothing.

here is the my model code:

public function update_order(){
    $data = array(
      'status' => 'Pack'
    );
    $this->db->where('order_id', $this->input->post('checkbox'));
    return $this->db->update('user_orders', $data);
  }

Controller code (I placed the code without any loops just to make it more clear):

public function update_order()
{
   $this->user_model->update_order();
}

and finally here is the view:

<?php echo form_open('user/update_order'); ?>
    <?php foreach ($users as $user): ?>
    <input type="checkbox" class="custom-control-input" name="checkbox" value="<?php echo $user['order_id']; ?>">
      <?php endforeach; ?>
      <button type="submit" class="btn btn-sm btn-block btn-warning text-white">Update</button>
 </form>

Pradeep · Accepted Answer · 2018-06-23 19:02:32Z

2

Hope this will help you :

Make your checkbox an array like this : checkbox[]

Your view should be like this :

<?php echo form_open('user/update_order'); ?>
    <?php foreach ($users as $user): ?>
    <input type="checkbox" class="custom-control-input" name="checkbox[]" value="<?php echo $user['order_id']; ?>">
      <?php endforeach; ?>
      <button type="submit" class="btn btn-sm btn-block btn-warning text-white">Update</button>
 <?php echo form_close(); ?>

Your update_order method should be like this :

Use where_in to update the records

public function update_order()
{
    $data = array(
      'status' => 'Pack'
    );
    $order_ids = $this->input->post('checkbox');
    $this->db->where_in('order_id', $order_ids);
    return $this->db->update('user_orders', $data);
}

See more : https://www.codeigniter.com/user_guide/database/query_builder.html#looking-for-specific-data

answered Jun 23, 2018 at 19:02

Pradeep

9,70713 gold badges29 silver badges34 bronze badges

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

1 Comment

Ahmad Tahhan Over a year ago

Worked perfectly, I thought I would need to run some kind of loop in the controller to make work. Thank you so much

Collectives™ on Stack Overflow

Codeigniter - Update database records based on selected checkbox

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related