Laravel - Toggle value in database with checkbox and ajax

Question

I want to toggle a boolean value in my table with a checkbox through jquery and ajax.

So whenever a user ticks the the checkbox it should toggle the value in table.

So far i came up with this but i need help:

$(document).ready(function(){
        $("input:checkbox").change(function() { 
            var isChecked = $("input:checkbox").is(":checked") ? 1:0; 
            $.ajax({
                type:'POST',
                url:'/activation',
                headers: {'X-CSRF-TOKEN': '{{ csrf_token() }}' },
                data: $('.checkbox').serialize(),
                    success:function(data){

                    }
            });
        });
    });

What exactly is not working? So far you've only shown how you do an ajax... — Andrei
– Andrei, Commented Oct 24, 2016 at 8:13
true...it's not working at all, i don't know what to put in my controller method si if that checkbox was 0 it should change the value in DB table and vice versa — lewis4u
– lewis4u, Commented Oct 24, 2016 at 8:14
Welp, if it's a 0(or a 1 for that matter) then Table::where('someField', 'someValue')->update(['someField' => 'someValue']). Have a look at their docs, if you have specific questions, me and probably everybody else here, would be more than happy to help. — Andrei
– Andrei, Commented Oct 24, 2016 at 8:17
@Andrew i did it....maybe you could tell me if i can make it better — lewis4u
– lewis4u, Commented Oct 24, 2016 at 12:11

Bashar · Accepted Answer · 2021-01-30 08:44:24Z

10

@andre's answer is correct but

    if($user->active == 1){
        $user->active = 0;
    } else {
        $user->active = 1;
    }

this part can be done by a single line

$user->active = !$user->active;

edited Jan 30, 2021 at 8:44

answered Jul 20, 2019 at 8:45

Bashar

4735 silver badges14 bronze badges

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

Comments

Andrei · Accepted Answer · 2016-10-24 12:39:29Z

5

The only thing I'd modify would be returning an answer to the ajax call to let it know what's happening.

public function activation(Request $request)
{

    $user = User::findOrFail($request->user_id);

    if($user->active == 1){
        $user->active = 0;
    } else {
        $user->active = 1;
    }

    return response()->json([
      'data' => [
        'success' => $user->save(),
      ]
    ]);
}

And now in the front-end part:

$(document).ready(function(){
  $("input:checkbox").change(function() {
    var user_id = $(this).closest('tr').attr('id');

    $.ajax({
            type:'POST',
            url:'/activation',
            headers: {'X-CSRF-TOKEN': '{{ csrf_token() }}' },
            data: { "user_id" : user_id },
            success: function(data){
              if(data.data.success){
                //do something
              }
            }
        });
    });
});

jQuery Ajax documentation

edited Oct 24, 2016 at 12:39

answered Oct 24, 2016 at 12:34

Andrei

3,6485 gold badges23 silver badges50 bronze badges

8 Comments

lewis4u Over a year ago

I have a prepared success flash message so how can i use that....i have putted it in my answer

Andrei Over a year ago

I'm sorry, see what exactly?

lewis4u Over a year ago

this part is what i need in your answer if(data.success){ //do something }

Andrei Over a year ago

No, definitely not. That's the point of ajax, no reload. Do a console.log(data) to see what's in there. Learn to debug, it's a very good skill to have.

lewis4u Over a year ago

yes i understand now....but how to make some feedback for user...what to put here: if(data.success){ //do something }

|

dılo sürücü · Accepted Answer · 2020-01-12 16:09:13Z

-1

in model create a method

function toggleActive ()
{

  $this->active!=(int)$this->active;
  return $this;
}

in controller


$model->toggleActive()->save();

edited Jan 12, 2020 at 16:09

answered Aug 10, 2019 at 9:47

dılo sürücü

4,2692 gold badges31 silver badges32 bronze badges

Collectives™ on Stack Overflow

Laravel - Toggle value in database with checkbox and ajax

3 Answers 3

Comments

8 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related