Laravel: Setting a Default Value for Blank/Null Input

Question

This is the code in the migration:

$table->string('role')->default('Standard');

When I leave the input box blank, it gives me an error:

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

How do we set the default value to "Standard" if the input box is left blank?

Code for Controller

 public function store(Request $request)
    {
        //return ['message' => 'I have your data'];
        $request->validate([
            'firstname' => 'required|string|max:191',
            'lastname' => 'required|string|max:191',
            'email' => 'required|string|email|max:191|unique:users',
            'password' => 'required|string|min:6',
        ]);
        return User::create([
        'firstname' => $request['firstname'],
        'lastname' => $request['lastname'],
        'email' => $request['email'],
        'phone' => $request['phone'],
        'role' => $request['role'],
        'usernotes' => $request['usernotes'],
        'password' => Hash::make($request['password']), //make sure to import Hash: use Illuminate\Support\Facades\Hash;
        'created_by' => $request['created_by'],
        'updated_by' => $request['updated_by'],
    ]);
    }

'role' => request()->get('role') ?? 'Standard' should ffix it, but I will not be able to help you without some more details. — Akshay Khale
– Akshay Khale, Commented Apr 9, 2020 at 6:02

Akshay Khale · Accepted Answer · 2020-04-09 08:28:19Z

2

In your code $request['role'] should be null which is causing the problem since the role field is not Nullable.

What you can do is, add the dwfault value if the role is null, just made following changes in your code and it should work.

public function store(Request $request)
{
    //return ['message' => 'I have your data'];
    $request->validate([
        'firstname' => 'required|string|max:191',
        'lastname' => 'required|string|max:191',
        'email' => 'required|string|email|max:191|unique:users',
        'password' => 'required|string|min:6',
    ]);
    return User::create([
    'firstname' => $request['firstname'],
    'lastname' => $request['lastname'],
    'email' => $request['email'],
    'phone' => $request['phone'],
    'role' => $request['role'] ?? 'Standard',
    'usernotes' => $request['usernotes'],
    'password' => Hash::make($request['password']), //make sure to import Hash: use Illuminate\Support\Facades\Hash;
    'created_by' => $request['created_by'],
    'updated_by' => $request['updated_by'],
]);
}

That should fix the issue.

Explanation: I am using Null coalescing (??) operator of PHP which will replace the null value with 'Standard'. It works only is PHP 7+, if you have a lower version of PHP then you can consider using the Ternary operator(?:).

Reference: https://www.php.net/manual/en/migration70.new-features.php

answered Apr 9, 2020 at 8:28

Akshay Khale

8,3918 gold badges52 silver badges60 bronze badges

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

1 Comment

sdeav Over a year ago

So, what is the point of writing the default value in the migration file? If you going to write it by yourself when you create?

PHP Geek · Accepted Answer · 2020-04-09 05:30:57Z

1

use nullable();

$table->string('role')->default('Standard')->nullable();

answered Apr 9, 2020 at 5:30

PHP Geek

4,0632 gold badges19 silver badges32 bronze badges

1 Comment

No One Over a year ago

Thanks a bunch for responding. I tried nullable but it leaves the field empty when it is saved.

Collectives™ on Stack Overflow

Laravel: Setting a Default Value for Blank/Null Input

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related