Insert checked checkbox value in database and remove it when unchecked

Question

I am trying to apply this purpose in my project, I have a table that display checkbox values from a table. My goal is to insert checked value to another table and remove it when I unchecked it from this table.

I made an insertion like this :

1- table

 <table>

foreach($result as $row)
{
 <tr>
<td><?=$row->name?></td>
<td><input type='checkbox' class="check-lab" value="   
<?=$row->id?>"  /></td>
</tr>
<?php } ?>
</table>

2- JQUERY

$('.check-lab').change(function() {
if ($(this).is(':checked')) {
var labCheckded= $(this).val();
var deleteLab= 1;
}

else {
var deleteLab= 0;

}

$.ajax({
type:'POST',
url:'<?=base_url('admin_medico/SaveLab')?>',
data: {labCheckded:labCheckded,deleteLab:deleteLab},
success:function(data) {

},

});

})

3- CONTROLLER

public function SaveLab(){

$save = array(
  'laboratory'  => $this->input->post('labCheckded')
 );
$this->model_admin->SaveLab($save);

}

AFTER CHECKING, SOME VALUES INSERTIONS ARE MADE PROPERLY. HOW CAN I REMOVE (DELETE) IT IF I UNCHECKED THIS VALUE ?

I would refer you to the CodeIgniter docs but it seems their website seems to be offline at this moment, check my answer I hope it helps — 95faf8e76605e973
– 95faf8e76605e973, Commented Aug 21, 2018 at 15:06

95faf8e76605e973 · Accepted Answer · 2018-08-21 15:17:00Z

1

Your code is already fine you just need to create a new model and controller for deleting the item.
Example:

In your jQuery, do:

    $('.check-lab').change(function() {

    var labCheckded= $(this).val();

    if ($(this).is(':checked')) {
    var deleteLab= 1;
    $.ajax({
    type:'POST',
    url:'<?=base_url('admin_medico/SaveLab')?>',
    data: {labCheckded:labCheckded,deleteLab:deleteLab},
    success:function(data) {
    },
    });
    } 

    else {
    var deleteLab= 0;
    $.ajax({
    type:'POST',
    url:'<?=base_url('admin_medico/DeleteLab')?>',
    data: {labCheckded:labCheckded,deleteLab:deleteLab},
    success:function(data) {
    },
    });
    }

    });

In your controller you could have

public function DeleteLab(){
$delete = array(
  'laboratory'  => $this->input->post('labCheckded')
 );
$this->model_admin->DeleteLab($delete);
}

In your model you could have function

public function DeleteLab($delete){
    $this->db->where('column_name', $delete['laboratory']); //assuming $delete['laboratory'] is a proper key
    $this->db->delete('table_name');
}

edited Aug 21, 2018 at 15:17

answered Aug 21, 2018 at 15:04

95faf8e76605e973

14.3k4 gold badges30 silver badges56 bronze badges

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

3 Comments

Diasline Over a year ago

ok, you are right, I forgot the idea of using the condition like you do in the jquery codes. Thank man

Diasline Over a year ago

I have a question : When I unchecked how I will get the value to delete it since in the else condition there is not the value of labCheckded ?

95faf8e76605e973 Over a year ago

You could take labCheckded variable outside of the if statement. I edited my answer just now to reflect that. You could read more here about JavaScript scopes

Collectives™ on Stack Overflow

Insert checked checkbox value in database and remove it when unchecked

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related