laravel checkbox inserting into mysql database 'Integrity constraint violation'

Question

I created a simple form that sends some data to a mysql database. When entering name or email everything workes fine. Except for the checkboxes. It runs perfekt when all checkboxes are checked, but if not -> i always get this error:

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'checkbox1' cannot be null

so i got this for creating the form:

{{Form::label('checkboxlabel', 'Agree')}}
{{Form::checkbox('checkbox1',1, true)}}

This is my migration file:

 Schema::create('users', function (Blueprint $table) {
        $table->increments('id');
        $table->string('email')->unique();
        $table->boolean('checkbox1')->nullable();

And this my Controller file:

    $user = new User;
    $user->email= $request->input('email');
    $user->checkbox1= $request->input('checkbox1');

Any help on this? Just want some true or false value for checked or not checked. Thx guys!

Can you paste the whole controller? This is just a snippet

Option
– Option

2017-11-09 15:56:31 +00:00
Commented Nov 9, 2017 at 15:56 — Option
– Option, Commented Nov 9, 2017 at 15:56

user1669496 · Accepted Answer · 2017-11-09 16:11:09Z

1

There is something weird going on but based on your question, I don't think it matters...

The way checkboxes work, if they aren't checked, then nothing gets sent to the server. As such, using your current code, the checkbox1 field will always either be true or null, it will never be false because false is never going to be sent to the server as a value.

What you likely need to do is apply a default when inserting...

$user->checkbox1= $request->input('checkbox1', 0);

This way if the checkbox isn't checked, your code will assume false and insert it into the database as such.

Now for the weird thing that's going on, your error message indicates you can't insert null into that column but you've very clearly set that field to nullable in your migration. Are these the same fields? Did you possibly update the migration without re-running it to update the schema in your database?

Can you run the statement show create table users and update your question with the contents of whatever is returned from that query?

answered Nov 9, 2017 at 16:11

user1669496

33.3k9 gold badges76 silver badges65 bronze badges

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

2 Comments

Stefan Over a year ago

You could use $request->has('checkbox1'); to get a bool.

A. Ka Over a year ago

Thx guys, this worked! Refreshed and started the migration again!

Leon Vismer · Accepted Answer · 2017-11-09 16:10:45Z

0

If you do not explicitly need a null value for a boolean you can do:

// Inside your migration
$table->boolean('checkbox1')->default(false);

// Inside the controller
$user->checkbox1 = $request->input('checkbox1');

Alternatively you can set a default if the value is not set in the request:

// Inside your migration
$table->boolean('checkbox1');

// Inside the controller
$user->checkbox1 = $request->input('checkbox1', 0);

answered Nov 9, 2017 at 16:10

Leon Vismer

5,1151 gold badge22 silver badges23 bronze badges

Collectives™ on Stack Overflow

laravel checkbox inserting into mysql database 'Integrity constraint violation'

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related