Why my data is not storing in database in laravel?

Question

my 3 inputs address, number and name_of_firm is showing null value but i fill the value in form. This is my form

<form id="myForm" method="post" action="{{ route('dealer.store') }}">
                        @csrf
                        <div class="user-box">
                            <input type="text" name="name" required="">
                            <label>Name</label>
                            @error('name')
                                <span class="invalid-feedback" role="alert">
                                    <strong>{{ $message }}</strong>
                                </span>
                            @enderror
                        </div>
                        <div class="user-box">
                            <input type="text" name="name_of_firm" required="">
                            <label>Name Of Firm</label>
                            @error('name_of_firm')
                                <span class="invalid-feedback" role="alert">
                                    <strong>{{ $message }}</strong>
                                </span>
                            @enderror
                        </div>
                        <div class="user-box">
                            <input type="text" name="number" required="">
                            <label>Number</label>
                            @error('number')
                                <span class="invalid-feedback" role="alert">
                                    <strong>{{ $message }}</strong>
                                </span>
                            @enderror
                        </div>
                        <div class="user-box">
                            <input type="text" name="address" required="">
                            <label>Address</label>
                            @error('address')
                                <span class="invalid-feedback" role="alert">
                                    <strong>{{ $message }}</strong>
                                </span>
                            @enderror
                        </div>
                        <div class="user-box">
                            <input type="email" name="email" required="">
                            <label>Email</label>
                            @error('email')
                                <span class="invalid-feedback" role="alert">
                                    <strong>{{ $message }}</strong>
                                </span>
                            @enderror
                        </div>
                        <div class="user-box">
                            <input type="password" name="password" required="">
                            <label>Password</label>
                            @error('password')
                                <span class="invalid-feedback" role="alert">
                                    <strong>{{ $message }}</strong>
                                </span>
                            @enderror
                        </div>

                        <button class="a" id="a" value="submit" name="submit">Submit</button>

                    </form>

This is my controller. the name of my controller is DealerController from where i storing data in users table

public function store(Request $request)
{
    $request->validate([
        'name' => 'required',
        'email' => 'required',
        'password' => 'required',
        'name_of_firm' => 'required',
        'address' => 'required',
        'number' => 'required',
    ]);

    $user = User::create([
        'name' => $request->input('name'),
        'email' => $request->input('email'),
        'password' => Hash::make($request->input('password')),
        'name_of_firm' => $request->input('name_of_firm'),
        'address' => $request->input('address'),
        'number' => $request->input('number'),
    ]);

    return redirect()->route('dealer.index')->withSuccess('done');
}

this is my User model. there are only 3 field that are fillable.

protected $fillable = [
    'name',
    'email',
    'password',
];

This is pic of database. enter image description here

Khalid Khan · Accepted Answer · 2021-06-30 11:28:47Z

2

That's because of Laravel mass-assignment and you should add every field you want to fill with input in $fillable array.

change your fillable array like below:

protected $fillable = [
        'name',
        'email',
        'password',
        'name_of_firm',
        'address',
        'number'
];

edited Jun 30, 2021 at 11:28

Khalid Khan

3,1951 gold badge13 silver badges30 bronze badges

answered May 26, 2021 at 9:11

reza khademi

4744 silver badges13 bronze badges

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

Comments

Khalid Khan · Accepted Answer · 2021-05-26 09:12:07Z

1

Replace your $fillable to this

protected $guarded = [
    'id',
];

It'll resolve the issue

answered May 26, 2021 at 9:12

Khalid Khan

3,1951 gold badge13 silver badges30 bronze badges

2 Comments

elchroy Over a year ago

This works, however, I tend to list the exact columns/attributes that are fillable

Khalid Khan Over a year ago

@elchroy Yes, but it depends upon your preference, I like it this way

Hedayatullah Sarwary · Accepted Answer · 2021-05-26 09:22:11Z

0

If you are using $fillable try to add the other fields also, but if you don't want to add other fields try to use $guarded:

$fillable

protected $fillabel = [
    'name',
    'email',
    'password',
    'name_of_firm',
    'address',
    'number'
];

$guarded

protected $guarded = [];

answered May 26, 2021 at 9:22

Hedayatullah Sarwary

2,8483 gold badges27 silver badges40 bronze badges

Collectives™ on Stack Overflow

Why my data is not storing in database in laravel?

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related